annotation
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| spec_id (Primary) | int(8) | No | ||||
| itemcode | varchar(7) | No | ||||
| itemname | varchar(128) | No | ||||
| ver | varchar(3) | No | ||||
| analysis_sup | text | Yes | NULL | |||
| certification_sup | varchar(256) | Yes | NULL | |||
| nutrition_sup | varchar(256) | Yes | NULL | |||
| origin_sup | varchar(128) | Yes | NULL | |||
| customer_sup | varchar(128) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | spec_id | 107 | A | No |
attribute
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| attributecode (Primary) | varchar(16) | No | ||||
| attributegroup | varchar(64) | Yes | NULL | |||
| attributedesc | varchar(64) | Yes | NULL | |||
| attributeunit | varchar(32) | Yes | NULL | |||
| type | varchar(64) | No | ||||
| value | varchar(64) | Yes | NULL | |||
| list | int(3) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | attributecode | 243 | A | No |
default_email
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| email_id (Primary) | int(6) | No | ||||
| name | varchar(128) | Yes | NULL | |||
| varchar(128) | No | |||||
| status | tinyint(3) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | email_id | 7 | A | No |
log_allergen
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| saucecode | varchar(16) | No | ||||
| saucecodedesc | varchar(64) | No | ||||
| ver | int(4) | No | 1 | |||
| ALG001 | varchar(32) | Yes | NULL | |||
| ALG002 | varchar(32) | Yes | NULL | |||
| ALG003 | varchar(32) | Yes | NULL | |||
| ALG004 | varchar(32) | Yes | NULL | |||
| ALG005 | varchar(32) | Yes | NULL | |||
| ALG006 | varchar(32) | Yes | NULL | |||
| ALG007 | varchar(32) | Yes | NULL | |||
| ALG008 | varchar(32) | Yes | NULL | |||
| ALG009 | varchar(32) | Yes | NULL | |||
| ALG010 | varchar(32) | Yes | NULL | |||
| ALG011 | varchar(32) | Yes | NULL | |||
| ALG012 | varchar(32) | Yes | NULL | |||
| user | varchar(16) | No | ||||
| created_date | timestamp | Yes | NULL | |||
| status | tinyint(2) | No | 3 | 1=disapprove, 2 approve, 3 active |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 262 | A | No |
log_chem1
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| saucecode | varchar(16) | No | ||||
| saucecodedesc | varchar(64) | No | ||||
| ver | int(4) | No | 1 | |||
| CHM001 | varchar(32) | Yes | NULL | |||
| CHM002 | varchar(32) | Yes | NULL | |||
| CHM003 | varchar(32) | Yes | NULL | |||
| CHM004 | varchar(32) | Yes | NULL | |||
| CHM005 | varchar(32) | Yes | NULL | |||
| CHM006 | varchar(32) | Yes | NULL | |||
| CHM007T | varchar(32) | Yes | ||||
| CHM007 | varchar(32) | Yes | NULL | |||
| CHM008 | varchar(32) | Yes | NULL | |||
| CHM009 | varchar(32) | Yes | NULL | |||
| CHM010T | varchar(32) | Yes | ||||
| CHM010 | varchar(32) | Yes | NULL | |||
| CHM011 | varchar(32) | Yes | NULL | |||
| CHM012 | varchar(32) | Yes | NULL | |||
| CHM013T | varchar(32) | Yes | ||||
| CHM013 | varchar(32) | Yes | NULL | |||
| CHM014 | varchar(32) | Yes | NULL | |||
| CHM015 | varchar(32) | Yes | NULL | |||
| CHM016 | varchar(32) | Yes | NULL | |||
| CHM017 | varchar(32) | Yes | NULL | |||
| CHM018 | varchar(32) | Yes | NULL | |||
| CHM019 | varchar(32) | Yes | NULL | |||
| CHM020 | varchar(32) | Yes | NULL | |||
| CHM021 | varchar(32) | Yes | NULL | |||
| CHM022 | varchar(32) | Yes | NULL | |||
| CHM023 | varchar(32) | Yes | NULL | |||
| CHM024 | varchar(32) | Yes | NULL | |||
| CHM025 | varchar(32) | Yes | NULL | |||
| CHM026 | varchar(32) | Yes | NULL | |||
| CHM027 | varchar(32) | Yes | NULL | |||
| CHM028 | varchar(32) | Yes | NULL | |||
| CHM029 | varchar(32) | Yes | NULL | |||
| user | varchar(16) | No | ||||
| created_date | timestamp | Yes | NULL | |||
| status | tinyint(2) | No | 3 | 1=disapprove, 2 approve, 3 active |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 596 | A | No |
log_chem2
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| saucecode | varchar(16) | No | ||||
| saucecodedesc | varchar(64) | No | ||||
| ver | int(4) | No | 1 | |||
| CHM030 | varchar(32) | Yes | NULL | |||
| CHM031 | varchar(32) | Yes | NULL | |||
| CHM032 | varchar(32) | Yes | NULL | |||
| CHM033 | varchar(32) | Yes | NULL | |||
| CHM034 | varchar(32) | Yes | NULL | |||
| CHM035 | varchar(32) | Yes | NULL | |||
| CHM036 | varchar(32) | Yes | NULL | |||
| CHM037 | varchar(32) | Yes | NULL | |||
| CHM038 | varchar(32) | Yes | NULL | |||
| CHM039 | varchar(32) | Yes | NULL | |||
| CHM040 | varchar(32) | Yes | NULL | |||
| CHM041 | varchar(32) | Yes | NULL | |||
| CHM042 | varchar(32) | Yes | NULL | |||
| CHM043 | varchar(32) | Yes | NULL | |||
| CHM044 | varchar(32) | Yes | NULL | |||
| CHM045 | varchar(32) | Yes | NULL | |||
| CHM046 | varchar(32) | Yes | NULL | |||
| CHM047 | varchar(32) | Yes | NULL | |||
| CHM048 | varchar(32) | Yes | NULL | |||
| CHM049 | varchar(32) | Yes | NULL | |||
| CHM050 | varchar(32) | Yes | NULL | |||
| CHM051 | varchar(32) | Yes | NULL | |||
| CHM052 | varchar(32) | Yes | NULL | |||
| CHM053 | varchar(32) | Yes | NULL | |||
| CHM054 | varchar(32) | Yes | NULL | |||
| CHM055 | varchar(32) | Yes | NULL | |||
| CHM056 | varchar(32) | Yes | NULL | |||
| CHM057 | varchar(32) | Yes | NULL | |||
| CHM058 | varchar(32) | Yes | NULL | |||
| CHM059 | varchar(32) | Yes | NULL | |||
| user | varchar(16) | No | ||||
| created_date | timestamp | Yes | NULL | |||
| status | tinyint(2) | No | 3 | 1=disapprove, 2 approve, 3 active |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 404 | A | No |
log_chem3
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| saucecode | varchar(16) | No | ||||
| saucecodedesc | varchar(64) | No | ||||
| ver | int(4) | No | 1 | |||
| CHM060 | varchar(32) | Yes | NULL | |||
| CHM061 | varchar(32) | Yes | NULL | |||
| CHM062 | varchar(32) | Yes | NULL | |||
| CHM063 | varchar(32) | Yes | NULL | |||
| CHM064 | varchar(32) | Yes | NULL | |||
| CHM065 | varchar(32) | Yes | NULL | |||
| CHM066 | varchar(32) | Yes | NULL | |||
| CHM067 | varchar(32) | Yes | NULL | |||
| CHM068 | varchar(32) | Yes | NULL | |||
| CHM069 | varchar(32) | Yes | NULL | |||
| CHM070 | varchar(32) | Yes | NULL | |||
| CHM071 | varchar(32) | Yes | NULL | |||
| CHM072 | varchar(32) | Yes | NULL | |||
| CHM073 | varchar(32) | Yes | NULL | |||
| CHM074 | varchar(32) | Yes | NULL | |||
| CHM075 | varchar(32) | Yes | NULL | |||
| CHM076 | varchar(32) | Yes | NULL | |||
| CHM077 | varchar(32) | Yes | NULL | |||
| CHM078 | varchar(32) | Yes | NULL | |||
| CHM079 | varchar(32) | Yes | NULL | |||
| CHM080 | varchar(32) | Yes | NULL | |||
| CHM081 | varchar(32) | Yes | NULL | |||
| CHM082 | varchar(32) | Yes | NULL | |||
| CHM083 | varchar(32) | Yes | NULL | |||
| CHM084 | varchar(32) | Yes | NULL | |||
| CHM085 | varchar(32) | Yes | NULL | |||
| CHM086 | varchar(32) | Yes | NULL | |||
| CHM087 | varchar(32) | Yes | NULL | |||
| CHM088 | varchar(32) | Yes | NULL | |||
| CHM089 | varchar(32) | Yes | NULL | |||
| CHM112 | varchar(32) | Yes | ||||
| CHM113 | varchar(32) | Yes | ||||
| user | varchar(16) | No | ||||
| created_date | timestamp | Yes | NULL | |||
| status | tinyint(2) | No | 3 | 1=disapprove, 2 approve, 3 active |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 238 | A | No |
log_ingredients
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| saucecode | varchar(16) | No | ||||
| saucecodedesc | varchar(64) | No | ||||
| ver | int(4) | No | 1 | |||
| ING001 | varchar(512) | Yes | NULL | |||
| ING002 | varchar(512) | Yes | NULL | |||
| ING003 | varchar(512) | Yes | NULL | |||
| ING004 | varchar(512) | Yes | NULL | |||
| ING005 | varchar(512) | Yes | NULL | |||
| ING006 | varchar(512) | Yes | NULL | |||
| ING007 | varchar(512) | Yes | NULL | |||
| ING008 | varchar(512) | Yes | NULL | |||
| ING009 | varchar(512) | Yes | NULL | |||
| ING010 | varchar(512) | Yes | NULL | |||
| ING011 | varchar(512) | Yes | NULL | |||
| ING012 | varchar(512) | Yes | NULL | |||
| ING013 | varchar(512) | Yes | NULL | |||
| ING014 | varchar(512) | Yes | NULL | |||
| ING015 | varchar(512) | Yes | NULL | |||
| ING016 | varchar(512) | Yes | NULL | |||
| ING017 | varchar(512) | Yes | NULL | |||
| ING018 | varchar(512) | Yes | NULL | |||
| ING019 | varchar(512) | Yes | NULL | |||
| ING020 | varchar(512) | Yes | ||||
| ING021 | varchar(512) | Yes | ||||
| ING022 | varchar(512) | Yes | ||||
| ING023 | varchar(512) | Yes | ||||
| ING024 | varchar(512) | Yes | ||||
| ING025 | varchar(512) | Yes | ||||
| COO001 | varchar(64) | Yes | NULL | |||
| COO002 | varchar(64) | Yes | NULL | |||
| COO003 | varchar(64) | Yes | NULL | |||
| COO004 | varchar(64) | Yes | NULL | |||
| COO005 | varchar(64) | Yes | NULL | |||
| COO006 | varchar(64) | Yes | NULL | |||
| COO007 | varchar(64) | Yes | NULL | |||
| COO008 | varchar(64) | Yes | NULL | |||
| COO009 | varchar(64) | Yes | NULL | |||
| COO010 | varchar(64) | Yes | NULL | |||
| COO011 | varchar(64) | Yes | NULL | |||
| COO012 | varchar(64) | Yes | NULL | |||
| COO013 | varchar(64) | Yes | NULL | |||
| COO014 | varchar(64) | Yes | NULL | |||
| COO015 | varchar(64) | Yes | NULL | |||
| COO016 | varchar(64) | Yes | NULL | |||
| COO017 | varchar(64) | Yes | NULL | |||
| COO018 | varchar(64) | Yes | NULL | |||
| COO019 | varchar(64) | Yes | NULL | |||
| COO020 | varchar(64) | Yes | ||||
| COO021 | varchar(64) | Yes | ||||
| COO022 | varchar(64) | Yes | ||||
| COO023 | varchar(64) | Yes | ||||
| COO024 | varchar(64) | Yes | ||||
| COO025 | varchar(64) | Yes | ||||
| IBD001 | varchar(32) | Yes | NULL | |||
| IBD002 | varchar(32) | Yes | NULL | |||
| IBD003 | varchar(32) | Yes | NULL | |||
| IBD004 | varchar(32) | Yes | NULL | |||
| IBD005 | varchar(32) | Yes | NULL | |||
| IBD006 | varchar(32) | Yes | NULL | |||
| IBD007 | varchar(32) | Yes | NULL | |||
| IBD008 | varchar(32) | Yes | NULL | |||
| IBD009 | varchar(32) | Yes | NULL | |||
| IBD010 | varchar(32) | Yes | NULL | |||
| IBD011 | varchar(32) | Yes | NULL | |||
| IBD012 | varchar(32) | Yes | NULL | |||
| IBD013 | varchar(32) | Yes | NULL | |||
| IBD014 | varchar(32) | Yes | NULL | |||
| IBD015 | varchar(32) | Yes | NULL | |||
| IBD016 | varchar(32) | Yes | NULL | |||
| IBD017 | varchar(32) | Yes | NULL | |||
| IBD018 | varchar(32) | Yes | NULL | |||
| IBD019 | varchar(32) | Yes | NULL | |||
| IBD020 | varchar(32) | Yes | ||||
| IBD021 | varchar(32) | Yes | ||||
| IBD022 | varchar(32) | Yes | ||||
| IBD023 | varchar(32) | Yes | ||||
| IBD024 | varchar(32) | Yes | ||||
| IBD025 | varchar(32) | Yes | ||||
| user | varchar(16) | No | ||||
| created_date | timestamp | Yes | NULL | |||
| status | tinyint(2) | No | 3 | 1=disapprove, 2 approve, 3 active |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 772 | A | No |
log_itemformat
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| ver | int(4) | No | 1 | |||
| item_code | varchar(7) | No | ||||
| item_desc | varchar(128) | No | ||||
| category_id | varchar(32) | No | ||||
| product_account_code | varchar(32) | No | ||||
| p_or_e | varchar(32) | No | ||||
| description | varchar(64) | No | ||||
| sauce_code | varchar(32) | No | ||||
| production_loc | varchar(32) | No | ||||
| CER001 | varchar(32) | Yes | ||||
| CER002 | varchar(32) | Yes | ||||
| CER003 | varchar(32) | Yes | ||||
| CER004 | varchar(32) | Yes | ||||
| CER005 | varchar(32) | Yes | ||||
| CER006 | varchar(32) | Yes | ||||
| SLF001 | varchar(32) | Yes | ||||
| storage_condition | varchar(16) | No | ||||
| storage_cond_name | varchar(32) | No | ||||
| date_code | varchar(16) | No | ||||
| date_code_loc | varchar(128) | No | ||||
| created_user | varchar(32) | No | ||||
| created_date | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2697 | A | No |
log_micro
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| saucecode | varchar(16) | No | ||||
| saucecodedesc | varchar(64) | No | ||||
| ver | int(4) | No | 1 | |||
| CHM090 | varchar(32) | Yes | NULL | |||
| CHM091 | varchar(32) | Yes | NULL | |||
| CHM092 | varchar(32) | Yes | NULL | |||
| CHM093 | varchar(32) | Yes | NULL | |||
| CHM094 | varchar(32) | Yes | NULL | |||
| CHM095 | varchar(32) | Yes | NULL | |||
| CHM096 | varchar(32) | Yes | NULL | |||
| CHM097 | varchar(32) | Yes | NULL | |||
| CHM098 | varchar(32) | Yes | NULL | |||
| CHM099 | varchar(32) | Yes | NULL | |||
| CHM100 | varchar(32) | Yes | NULL | |||
| CHM101 | varchar(32) | Yes | NULL | |||
| CHM102 | varchar(32) | Yes | NULL | |||
| CHM103 | varchar(32) | Yes | NULL | |||
| CHM104 | varchar(32) | Yes | NULL | |||
| CHM105 | varchar(32) | Yes | NULL | |||
| CHM106 | varchar(32) | Yes | NULL | |||
| CHM107 | varchar(32) | Yes | NULL | |||
| CHM108 | varchar(32) | Yes | NULL | |||
| CHM109 | varchar(32) | Yes | NULL | |||
| CHM110 | varchar(32) | Yes | NULL | |||
| CHM111 | varchar(32) | Yes | NULL | |||
| CHM112 | varchar(32) | Yes | NULL | |||
| CHM113 | varchar(32) | Yes | NULL | |||
| CHM114 | varchar(32) | Yes | NULL | |||
| CHM115 | varchar(32) | Yes | NULL | |||
| CHM116 | varchar(32) | Yes | NULL | |||
| CHM118 | varchar(32) | Yes | NULL | |||
| user | varchar(16) | No | ||||
| created_date | timestamp | Yes | NULL | |||
| status | tinyint(2) | No | 3 | 1=disapprove, 2 approve, 3 active |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 507 | A | No |
log_nutrition
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| saucecode | varchar(16) | No | ||||
| saucecodedesc | varchar(64) | No | ||||
| ver | int(4) | No | 1 | |||
| NUT001 | varchar(32) | Yes | NULL | |||
| NUT002 | varchar(32) | Yes | NULL | |||
| NUT003 | varchar(32) | Yes | NULL | |||
| NUT004 | varchar(32) | Yes | NULL | |||
| NUT005 | varchar(32) | Yes | NULL | |||
| NUT006 | varchar(32) | Yes | NULL | |||
| NUT007 | varchar(32) | Yes | NULL | |||
| NUT008 | varchar(32) | Yes | NULL | |||
| NUT009 | varchar(32) | Yes | NULL | |||
| NUT010 | varchar(32) | Yes | NULL | |||
| NUT011 | varchar(32) | Yes | NULL | |||
| NUT012 | varchar(32) | Yes | NULL | |||
| NUT013 | varchar(32) | Yes | NULL | |||
| NUT014 | varchar(32) | Yes | NULL | |||
| NUT015 | varchar(32) | Yes | NULL | |||
| NUT016 | varchar(32) | Yes | NULL | |||
| NUT017 | varchar(32) | Yes | NULL | |||
| NUT018 | varchar(32) | Yes | NULL | |||
| NUT019 | varchar(32) | Yes | NULL | |||
| NUT020 | varchar(32) | Yes | NULL | |||
| NUT021 | varchar(32) | Yes | NULL | |||
| NUT022 | varchar(32) | Yes | NULL | |||
| user | varchar(16) | No | ||||
| created_date | timestamp | Yes | NULL | |||
| status | tinyint(2) | No | 3 | 1=disapprove, 2 approve, 3 active |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 926 | A | No |
log_physchar
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| saucecode | varchar(16) | No | ||||
| saucecodedesc | varchar(64) | No | ||||
| ver | int(4) | No | 1 | |||
| PHY001 | varchar(255) | Yes | NULL | |||
| PHY002 | varchar(255) | Yes | NULL | |||
| PHY003 | varchar(255) | Yes | NULL | |||
| user | varchar(16) | No | ||||
| created_date | timestamp | Yes | NULL | |||
| status | tinyint(2) | No | 3 | 1=disapprove, 2 approve, 3 active |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 457 | A | No |
log_sauceitems
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| saucecode | varchar(16) | No | ||||
| saucecodedesc | varchar(64) | No | ||||
| ver | int(4) | No | 1 | |||
| saucetype | varchar(16) | Yes | NULL | |||
| ProductionLoc | varchar(64) | Yes | NULL | |||
| PLANT | varchar(32) | Yes | NULL | |||
| user | varchar(16) | No | ||||
| created_date | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1215 | A | No |
post_comments
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(5) | No | ||||
| spec_id | int(4) | No | ||||
| sender_email | varchar(128) | No | ||||
| sender_name | varchar(64) | No | ||||
| receiver_email | varchar(128) | No | ||||
| itemcode | varchar(7) | No | ||||
| itemname | varchar(128) | No | ||||
| comments | text | No | ||||
| create_user | varchar(30) | No | ||||
| create_date | timestamp | No | current_timestamp() | |||
| sauce_code | varchar(32) | No | ||||
| status | varchar(4) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 246 | A | No |
product_item
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| item_code (Primary) | varchar(6) | No | 0 | |||
| item_desc | varchar(70) | No | ||||
| created_user | varchar(30) | No | ||||
| created_date | timestamp | No | 0000-00-00 00:00:00 | |||
| mod_user | varchar(30) | Yes | NULL | |||
| mod_date | timestamp | Yes | NULL | |||
| load_date | timestamp | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | item_code | 3362 | A | No |
saucecode
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| saucecode (Primary) | varchar(16) | No | ||||
| saucecodedesc | varchar(64) | Yes | NULL | |||
| category_code | varchar(16) | No | ||||
| sales_category | varchar(32) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | saucecode | 522 | A | No |
sauceitem
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| saucecode (Primary) | varchar(16) | No | ||||
| saucetype | varchar(16) | Yes | NULL | |||
| ProductionLoc | varchar(64) | Yes | NULL | |||
| PHY001 | varchar(255) | Yes | NULL | |||
| PHY002 | varchar(255) | Yes | NULL | |||
| PHY003 | varchar(255) | Yes | NULL | |||
| CHM001 | varchar(32) | Yes | NULL | |||
| CHM002 | varchar(32) | Yes | NULL | |||
| CHM003 | varchar(32) | Yes | NULL | |||
| CHM004 | varchar(32) | Yes | NULL | |||
| CHM005 | varchar(32) | Yes | NULL | |||
| CHM006 | varchar(32) | Yes | NULL | |||
| CHM007T | varchar(32) | Yes | ||||
| CHM007 | varchar(32) | Yes | NULL | |||
| CHM008 | varchar(32) | Yes | NULL | |||
| CHM009 | varchar(32) | Yes | NULL | |||
| CHM010T | varchar(32) | Yes | ||||
| CHM010 | varchar(32) | Yes | NULL | |||
| CHM011 | varchar(32) | Yes | NULL | |||
| CHM012 | varchar(32) | Yes | NULL | |||
| CHM013T | varchar(32) | Yes | ||||
| CHM013 | varchar(32) | Yes | NULL | |||
| CHM014 | varchar(32) | Yes | NULL | |||
| CHM015 | varchar(32) | Yes | NULL | |||
| CHM016 | varchar(32) | Yes | NULL | |||
| CHM017 | varchar(32) | Yes | NULL | |||
| CHM018 | varchar(32) | Yes | NULL | |||
| CHM019 | varchar(32) | Yes | NULL | |||
| CHM020 | varchar(32) | Yes | NULL | |||
| CHM021 | varchar(32) | Yes | NULL | |||
| CHM022 | varchar(32) | Yes | NULL | |||
| CHM023 | varchar(32) | Yes | NULL | |||
| CHM024 | varchar(32) | Yes | NULL | |||
| CHM025 | varchar(32) | Yes | NULL | |||
| CHM026 | varchar(32) | Yes | NULL | |||
| CHM027 | varchar(32) | Yes | NULL | |||
| CHM028 | varchar(32) | Yes | NULL | |||
| CHM029 | varchar(32) | Yes | NULL | |||
| CHM030 | varchar(32) | Yes | NULL | |||
| CHM031 | varchar(32) | Yes | NULL | |||
| CHM032 | varchar(32) | Yes | NULL | |||
| CHM033 | varchar(32) | Yes | NULL | |||
| CHM034 | varchar(32) | Yes | NULL | |||
| CHM035 | varchar(32) | Yes | NULL | |||
| CHM036 | varchar(32) | Yes | NULL | |||
| CHM037 | varchar(32) | Yes | NULL | |||
| CHM038 | varchar(32) | Yes | NULL | |||
| CHM039 | varchar(32) | Yes | NULL | |||
| CHM040 | varchar(32) | Yes | NULL | |||
| CHM041 | varchar(32) | Yes | NULL | |||
| CHM042 | varchar(32) | Yes | NULL | |||
| CHM043 | varchar(32) | Yes | NULL | |||
| CHM044 | varchar(32) | Yes | NULL | |||
| CHM045 | varchar(32) | Yes | NULL | |||
| CHM046 | varchar(32) | Yes | NULL | |||
| CHM047 | varchar(32) | Yes | NULL | |||
| CHM048 | varchar(32) | Yes | NULL | |||
| CHM049 | varchar(32) | Yes | NULL | |||
| CHM050 | varchar(32) | Yes | NULL | |||
| CHM051 | varchar(32) | Yes | NULL | |||
| CHM052 | varchar(32) | Yes | NULL | |||
| CHM053 | varchar(32) | Yes | NULL | |||
| CHM054 | varchar(32) | Yes | NULL | |||
| CHM055 | varchar(32) | Yes | NULL | |||
| CHM056 | varchar(32) | Yes | NULL | |||
| CHM057 | varchar(32) | Yes | NULL | |||
| CHM058 | varchar(32) | Yes | NULL | |||
| CHM059 | varchar(32) | Yes | NULL | |||
| CHM060 | varchar(32) | Yes | NULL | |||
| CHM061 | varchar(32) | Yes | NULL | |||
| CHM062 | varchar(32) | Yes | NULL | |||
| CHM063 | varchar(32) | Yes | NULL | |||
| CHM064 | varchar(32) | Yes | NULL | |||
| CHM065 | varchar(32) | Yes | NULL | |||
| CHM066 | varchar(32) | Yes | NULL | |||
| CHM067 | varchar(32) | Yes | NULL | |||
| CHM068 | varchar(32) | Yes | NULL | |||
| CHM069 | varchar(32) | Yes | NULL | |||
| CHM070 | varchar(32) | Yes | NULL | |||
| CHM071 | varchar(32) | Yes | NULL | |||
| CHM072 | varchar(32) | Yes | NULL | |||
| CHM073 | varchar(32) | Yes | NULL | |||
| CHM074 | varchar(32) | Yes | NULL | |||
| CHM075 | varchar(32) | Yes | NULL | |||
| CHM076 | varchar(32) | Yes | NULL | |||
| CHM077 | varchar(32) | Yes | NULL | |||
| CHM078 | varchar(32) | Yes | NULL | |||
| CHM079 | varchar(32) | Yes | NULL | |||
| CHM080 | varchar(32) | Yes | NULL | |||
| CHM081 | varchar(32) | Yes | NULL | |||
| CHM082 | varchar(32) | Yes | NULL | |||
| CHM083 | varchar(32) | Yes | NULL | |||
| CHM084 | varchar(32) | Yes | NULL | |||
| CHM085 | varchar(32) | Yes | NULL | |||
| CHM086 | varchar(32) | Yes | NULL | |||
| CHM087 | varchar(32) | Yes | NULL | |||
| CHM088 | varchar(32) | Yes | NULL | |||
| CHM089 | varchar(32) | Yes | NULL | |||
| CHM090 | varchar(32) | Yes | NULL | |||
| CHM091 | varchar(32) | Yes | NULL | |||
| CHM092 | varchar(32) | Yes | NULL | |||
| CHM093 | varchar(32) | Yes | NULL | |||
| CHM094 | varchar(32) | Yes | NULL | |||
| CHM095 | varchar(32) | Yes | NULL | |||
| CHM096 | varchar(32) | Yes | NULL | |||
| CHM097 | varchar(32) | Yes | NULL | |||
| CHM098 | varchar(32) | Yes | NULL | |||
| CHM099 | varchar(32) | Yes | NULL | |||
| CHM100 | varchar(32) | Yes | NULL | |||
| CHM101 | varchar(32) | Yes | NULL | |||
| CHM102 | varchar(32) | Yes | NULL | |||
| CHM103 | varchar(32) | Yes | NULL | |||
| CHM104 | varchar(32) | Yes | NULL | |||
| CHM105 | varchar(32) | Yes | NULL | |||
| CHM106 | varchar(32) | Yes | NULL | |||
| CHM107 | varchar(32) | Yes | NULL | |||
| CHM108 | varchar(32) | Yes | NULL | |||
| CHM109 | varchar(32) | Yes | NULL | |||
| CHM110 | varchar(32) | Yes | NULL | |||
| CHM111 | varchar(32) | Yes | NULL | |||
| CHM112 | varchar(32) | Yes | NULL | |||
| CHM113 | varchar(32) | Yes | NULL | |||
| CHM114 | varchar(32) | Yes | NULL | |||
| CHM115 | varchar(32) | Yes | NULL | |||
| CHM116 | varchar(32) | Yes | NULL | |||
| CHM118 | varchar(32) | Yes | ||||
| CHM119 | varchar(32) | Yes | NULL | |||
| CHM120 | varchar(32) | Yes | NULL | |||
| CHM121 | varchar(32) | Yes | NULL | |||
| NUT001 | varchar(32) | Yes | NULL | |||
| NUT002 | varchar(32) | Yes | NULL | |||
| NUT003 | varchar(32) | Yes | NULL | |||
| NUT004 | varchar(32) | Yes | NULL | |||
| NUT005 | varchar(32) | Yes | NULL | |||
| NUT006 | varchar(32) | Yes | NULL | |||
| NUT007 | varchar(32) | Yes | NULL | |||
| NUT008 | varchar(32) | Yes | NULL | |||
| NUT009 | varchar(32) | Yes | NULL | |||
| NUT010 | varchar(32) | Yes | NULL | |||
| NUT011 | varchar(32) | Yes | NULL | |||
| NUT012 | varchar(32) | Yes | NULL | |||
| NUT013 | varchar(32) | Yes | NULL | |||
| NUT014 | varchar(32) | Yes | NULL | |||
| NUT015 | varchar(32) | Yes | NULL | |||
| NUT016 | varchar(32) | Yes | NULL | |||
| NUT017 | varchar(32) | Yes | NULL | |||
| NUT018 | varchar(32) | Yes | NULL | |||
| NUT019 | varchar(32) | Yes | NULL | |||
| NUT020 | varchar(32) | Yes | NULL | |||
| NUT021 | varchar(32) | Yes | NULL | |||
| NUT022 | varchar(32) | Yes | NULL | |||
| ING001 | varchar(512) | Yes | NULL | |||
| ING002 | varchar(512) | Yes | NULL | |||
| ING003 | varchar(512) | Yes | NULL | |||
| ING004 | varchar(512) | Yes | NULL | |||
| ING005 | varchar(512) | Yes | NULL | |||
| ING006 | varchar(512) | Yes | NULL | |||
| ING007 | varchar(512) | Yes | NULL | |||
| ING008 | varchar(512) | Yes | NULL | |||
| ING009 | varchar(512) | Yes | NULL | |||
| ING010 | varchar(512) | Yes | NULL | |||
| ING011 | varchar(512) | Yes | NULL | |||
| ING012 | varchar(512) | Yes | NULL | |||
| ING013 | varchar(512) | Yes | NULL | |||
| ING014 | varchar(512) | Yes | NULL | |||
| ING015 | varchar(512) | Yes | NULL | |||
| ING016 | varchar(512) | Yes | NULL | |||
| ING017 | varchar(512) | Yes | NULL | |||
| ING018 | varchar(512) | Yes | NULL | |||
| ING019 | varchar(512) | Yes | NULL | |||
| ING020 | varchar(512) | Yes | ||||
| ING021 | varchar(512) | Yes | ||||
| ING022 | varchar(512) | Yes | ||||
| ING023 | varchar(512) | Yes | ||||
| ING024 | varchar(512) | Yes | ||||
| ING025 | varchar(512) | Yes | ||||
| COO001 | varchar(64) | Yes | NULL | |||
| COO002 | varchar(64) | Yes | NULL | |||
| COO003 | varchar(64) | Yes | NULL | |||
| COO004 | varchar(64) | Yes | NULL | |||
| COO005 | varchar(64) | Yes | NULL | |||
| COO006 | varchar(64) | Yes | NULL | |||
| COO007 | varchar(64) | Yes | NULL | |||
| COO008 | varchar(64) | Yes | NULL | |||
| COO009 | varchar(64) | Yes | NULL | |||
| COO010 | varchar(64) | Yes | NULL | |||
| COO011 | varchar(64) | Yes | NULL | |||
| COO012 | varchar(64) | Yes | NULL | |||
| COO013 | varchar(64) | Yes | NULL | |||
| COO014 | varchar(64) | Yes | NULL | |||
| COO015 | varchar(64) | Yes | NULL | |||
| COO016 | varchar(64) | Yes | NULL | |||
| COO017 | varchar(64) | Yes | NULL | |||
| COO018 | varchar(64) | Yes | NULL | |||
| COO019 | varchar(64) | Yes | NULL | |||
| COO020 | varchar(64) | Yes | ||||
| COO021 | varchar(64) | Yes | ||||
| COO022 | varchar(64) | Yes | ||||
| COO023 | varchar(64) | Yes | ||||
| COO024 | varchar(64) | Yes | ||||
| COO025 | varchar(64) | Yes | ||||
| IBD001 | varchar(32) | Yes | NULL | |||
| IBD002 | varchar(32) | Yes | NULL | |||
| IBD003 | varchar(32) | Yes | NULL | |||
| IBD004 | varchar(32) | Yes | NULL | |||
| IBD005 | varchar(32) | Yes | NULL | |||
| IBD006 | varchar(32) | Yes | NULL | |||
| IBD007 | varchar(32) | Yes | NULL | |||
| IBD008 | varchar(32) | Yes | NULL | |||
| IBD009 | varchar(32) | Yes | NULL | |||
| IBD010 | varchar(32) | Yes | NULL | |||
| IBD011 | varchar(32) | Yes | NULL | |||
| IBD012 | varchar(32) | Yes | NULL | |||
| IBD013 | varchar(32) | Yes | NULL | |||
| IBD014 | varchar(32) | Yes | NULL | |||
| IBD015 | varchar(32) | Yes | NULL | |||
| IBD016 | varchar(32) | Yes | NULL | |||
| IBD017 | varchar(32) | Yes | NULL | |||
| IBD018 | varchar(32) | Yes | NULL | |||
| IBD019 | varchar(32) | Yes | NULL | |||
| IBD020 | varchar(32) | Yes | ||||
| IBD021 | varchar(32) | Yes | ||||
| IBD022 | varchar(32) | Yes | ||||
| IBD023 | varchar(32) | Yes | ||||
| IBD024 | varchar(32) | Yes | ||||
| IBD025 | varchar(32) | Yes | ||||
| ALG001 | varchar(32) | Yes | NULL | |||
| ALG002 | varchar(32) | Yes | NULL | |||
| ALG003 | varchar(32) | Yes | NULL | |||
| ALG004 | varchar(32) | Yes | NULL | |||
| ALG005 | varchar(32) | Yes | NULL | |||
| ALG006 | varchar(32) | Yes | NULL | |||
| ALG007 | varchar(32) | Yes | NULL | |||
| ALG008 | varchar(32) | Yes | NULL | |||
| ALG009 | varchar(32) | Yes | NULL | |||
| ALG010 | varchar(32) | Yes | NULL | |||
| ALG011 | varchar(32) | Yes | NULL | |||
| ALG012 | varchar(32) | Yes | NULL | |||
| ALG013 | varchar(32) | Yes | NULL | |||
| PLANT | varchar(32) | Yes | NULL | |||
| created_date | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | saucecode | 382 | A | No |
saucetype
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| saucetype (Primary) | varchar(5) | No | ||||
| saucetypedesc | varchar(64) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | saucetype | 7 | A | No |
specifications
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| spec_id (Primary) | int(8) | No | ||||
| saucecode | varchar(16) | No | ||||
| itemcode | varchar(7) | No | ||||
| itemname | varchar(128) | No | ||||
| ver | varchar(3) | No | ||||
| line_count | varchar(4) | No | ||||
| packing | varchar(256) | No | ||||
| storage | text | No | ||||
| date_code | text | No | ||||
| label | text | No | ||||
| ProductionLoc | varchar(64) | No | ||||
| PackLoc | varchar(64) | No | ||||
| spec_date | varchar(64) | No | ||||
| spec_file | varchar(128) | No | ||||
| created_user | varchar(64) | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| mod_user | varchar(64) | No | ||||
| mod_date | timestamp | No | 0000-00-00 00:00:00 | |||
| status | varchar(2) | Yes | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | spec_id | 2508 | A | No |
spec_user
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user_id (Primary) | int(6) | No | ||||
| ip_address | varchar(64) | No | ||||
| user_group | varchar(30) | No | ||||
| user_email | varchar(96) | No | ||||
| user_name | varchar(40) | No | ||||
| user | varchar(16) | No | ||||
| user_pwd | varchar(16) | No | ||||
| user_level | tinyint(1) | Yes | NULL | 1=ksu, 2=kmp, 3=kfi, 4=rdo | ||
| created_date | date | Yes | NULL | |||
| mod_date | date | Yes | NULL | |||
| last_logindate | timestamp | Yes | NULL | |||
| status | tinyint(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | user_id | 46 | A | No |
sp_allergen
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| itemcode (Primary) | varchar(6) | No | ||||
| itemname | varchar(128) | No | ||||
| spec_id (Primary) | int(8) | No | ||||
| allergen | varchar(256) | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| mod_user | varchar(64) | No | ||||
| mod_date | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | itemcode | 392 | A | No | |
| spec_id | 785 | A | No |
sp_analysis
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(8) | No | ||||
| itemcode | varchar(7) | No | ||||
| itemname | varchar(64) | No | ||||
| spec_id | int(8) | No | ||||
| orderlist | int(3) | No | ||||
| attrcode | varchar(16) | No | ||||
| name | varchar(64) | No | ||||
| value | varchar(64) | No | ||||
| type | varchar(64) | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| mod_user | varchar(64) | No | ||||
| mod_date | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 14711 | A | No |
sp_certifications
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| itemcode (Primary) | varchar(6) | No | ||||
| itemname | varchar(128) | No | ||||
| spec_id (Primary) | int(8) | No | ||||
| certifications | varchar(256) | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| mod_user | varchar(64) | No | ||||
| mod_date | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | itemcode | 837 | A | No | |
| spec_id | 2512 | A | No |
sp_ingredients
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| ing_id (Primary) | int(8) | No | ||||
| itemcode | varchar(7) | No | ||||
| itemname | varchar(128) | No | ||||
| spec_id | int(8) | No | ||||
| ingredients | text | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| mod_user | varchar(64) | No | ||||
| mod_date | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | ing_id | 2507 | A | No |
sp_nutritions
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| itemcode | varchar(7) | No | ||||
| itemname | varchar(128) | No | ||||
| spec_id | int(8) | No | ||||
| orderlist | int(3) | No | ||||
| attrcode | varchar(16) | No | ||||
| name | varchar(128) | No | ||||
| value | varchar(32) | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| mod_user | varchar(64) | No | ||||
| mod_date | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 43837 | A | No |
sp_physchar
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| itemcode | varchar(7) | No | ||||
| itemname | varchar(128) | No | ||||
| spec_id | int(8) | No | ||||
| orderlist | int(2) | No | ||||
| attrcode | varchar(16) | No | ||||
| name | varchar(128) | No | ||||
| value | text | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| mod_date | timestamp | No | 0000-00-00 00:00:00 | |||
| status | varchar(2) | Yes | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 7200 | A | No |
v_date_code
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(3) | No | ||||
| orderlist | tinyint(2) | No | ||||
| contents | mediumtext | No | ||||
| category | varchar(32) | No | ||||
| mfg_location | varchar(32) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 42 | A | No |
v_item_format
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| item_code (Primary) | varchar(7) | No | ||||
| item_desc | varchar(128) | No | ||||
| category_id | varchar(32) | No | ||||
| product_account_code | varchar(32) | No | ||||
| p_or_e | varchar(32) | No | ||||
| description | varchar(128) | No | ||||
| sauce_code | varchar(32) | No | ||||
| production_loc | varchar(32) | No | ||||
| CER001 | varchar(32) | Yes | ||||
| CER002 | varchar(32) | Yes | ||||
| CER003 | varchar(32) | Yes | ||||
| CER004 | varchar(32) | Yes | ||||
| CER005 | varchar(32) | Yes | ||||
| CER006 | varchar(32) | Yes | ||||
| SLF001 | varchar(32) | Yes | ||||
| storage_condition | varchar(16) | No | ||||
| storage_cond_name | varchar(32) | No | ||||
| date_code | varchar(16) | No | ||||
| date_code_loc | varchar(128) | No | ||||
| created_user | varchar(32) | No | ||||
| created_date | timestamp | No | 0000-00-00 00:00:00 | |||
| modified_user | varchar(32) | No | ||||
| modified_date | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | item_code | 847 | A | No |
v_mfg_loc
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(3) | No | ||||
| ProductionLoc | varchar(64) | No | ||||
| mfg_country | varchar(64) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 27 | A | No |
v_pack_type
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| itemcode (Primary) | varchar(6) | No | ||||
| itemdesc | varchar(80) | No | ||||
| packsize | varchar(30) | No | ||||
| containername | varchar(60) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | itemcode | 1559 | A | No |
v_storage_cond
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(3) | No | ||||
| name | varchar(32) | No | ||||
| contents | mediumtext | No | ||||
| category | varchar(32) | No | ||||
| type | varchar(32) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 15 | A | No |
_secured_ip
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(4) | No | ||||
| ip_no | varchar(64) | No | ||||
| ip_desc | varchar(128) | Yes | NULL | |||
| created_date | datetime | Yes | NULL | |||
| modified_date | timestamp | No | current_timestamp() | |||
| status | tinyint(2) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 10 | A | No |