mx_recipe_viewed
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(12) | No | ||||
| ipaddress | varchar(32) | No | ||||
| sessionid | varchar(128) | No | ||||
| recipeid | varchar(8) | No | ||||
| recipename | varchar(64) | No | ||||
| source | varchar(16) | No | ||||
| timestamp | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 23911 | A | No |
product_flavor
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| prod_flavor_id | varchar(6) | No | ||||
| orderlist | int(3) | Yes | NULL | |||
| item_code | varchar(6) | Yes | NULL | |||
| prod_flavor_name | varchar(60) | No | ||||
| short_name | varchar(12) | No | ||||
| start_date | date | Yes | NULL | |||
| display | tinyint(2) | No | 1 | 1- live, 2- staging |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 292 | A | No |
product_mex
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(3) | No | ||||
| item_code | varchar(6) | No | ||||
| item_order | tinyint(2) | No | ||||
| main_cat | varchar(6) | No | ||||
| m_cat_ename | varchar(32) | No | ||||
| m_cat_sname | varchar(32) | No | ||||
| prod_desc | varchar(120) | No | ||||
| prod_name | varchar(120) | No | ||||
| description | text | No | ||||
| created_user | varchar(30) | Yes | NULL | |||
| created_date | date | Yes | NULL | |||
| mod_user | varchar(30) | Yes | NULL | |||
| mod_date | date | Yes | NULL | |||
| remarks | text | No | ||||
| status | tinyint(1) | No | 2 | 2=live 3=stage |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 41 | A | No |
product_mex_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(3) | No | ||||
| item_code | varchar(6) | No | ||||
| item_order | tinyint(2) | No | ||||
| main_cat | varchar(6) | No | ||||
| m_cat_ename | varchar(32) | No | ||||
| m_cat_sname | varchar(32) | No | ||||
| prod_desc | varchar(120) | No | ||||
| prod_name | varchar(120) | No | ||||
| description | text | No | ||||
| created_user | varchar(30) | Yes | NULL | |||
| created_date | date | Yes | NULL | |||
| mod_user | varchar(30) | Yes | NULL | |||
| mod_date | date | Yes | NULL | |||
| remarks | text | No | ||||
| status | tinyint(1) | No | 2 | 2=live 3=stage |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 41 | A | No |
recipe_mex
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| recipe_id (Primary) | int(6) | No | ||||
| author | varchar(64) | No | ||||
| attribution | text | No | ||||
| main_ing_id | varchar(6) | Yes | NULL | |||
| menu_cat_id | varchar(6) | Yes | NULL | |||
| methods_id | varchar(38) | Yes | NULL | |||
| collections_id | varchar(6) | Yes | NULL | |||
| prod_fam_used | varchar(90) | No | ||||
| item_code_used | varchar(90) | Yes | NULL | |||
| name | varchar(90) | No | ||||
| name_mex | varchar(90) | No | ||||
| preptime | varchar(255) | No | ||||
| marinatetime | varchar(64) | No | ||||
| inactivetime | varchar(64) | No | ||||
| cooktime | varchar(64) | No | ||||
| totaltime | varchar(64) | No | ||||
| yield | varchar(90) | No | ||||
| ingredients | text | No | ||||
| instructions | text | No | ||||
| recipe_image | varchar(128) | Yes | NULL | |||
| small_recipe_image | varchar(128) | No | ||||
| created_date | date | No | 0009-01-01 | |||
| mod_date | date | No | 0001-01-01 | |||
| expire_date | date | Yes | NULL | |||
| status | tinyint(4) | No | 2 | |||
| recipe_usage | text | Yes | NULL | |||
| created_by | varchar(40) | No | ||||
| influencer | varchar(64) | No | ||||
| thumb_head | varchar(32) | Yes | ||||
| featured | varchar(256) | No | ||||
| short_desc | text | No | ||||
| long_desc | text | No | ||||
| vc_id | int(6) | Yes | NULL | |||
| coupon | varchar(1) | Yes | ||||
| viewcount | int(8) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | recipe_id | 18 | A | No | |
| prod_fam_used | BTREE | No | No | prod_fam_used | 18 | A | No | |
| item_code_used | BTREE | No | No | item_code_used | 18 | A | Yes | |
| main_ing_id | BTREE | No | No | main_ing_id | 18 | A | Yes |