activity
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(8) | No | ||||
| req_id | int(4) | No | ||||
| req_type | varchar(80) | No | ||||
| status | varchar(30) | No | ||||
| doc_link | varchar(80) | Yes | NULL | |||
| email_sent | varchar(128) | Yes | NULL | |||
| email_date | timestamp | Yes | 0000-00-00 00:00:00 | |||
| customer | varchar(80) | No | ||||
| itemcode | varchar(16) | No | ||||
| approver | varchar(16) | No | ||||
| approved_date | timestamp | No | 0000-00-00 00:00:00 | |||
| user | varchar(30) | No | ||||
| create_date | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1820 | 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 | 237 | A | No |
attribute_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| temp_id (Primary) | int(4) | No | ||||
| temp_list | int(11) | No | ||||
| temp_code | varchar(16) | No | ||||
| temp_name | varchar(128) | No | ||||
| temp_desc | varchar(128) | No | ||||
| temp_cat | varchar(32) | Yes | NULL | |||
| temp_header | text | No | ||||
| temp_address | text | No | ||||
| temp_body | text | Yes | NULL | |||
| temp_sig | text | No | ||||
| temp_footer | text | No | ||||
| create_user | varchar(30) | No | ||||
| create_date | date | No | 0000-00-00 | |||
| mod_user | varchar(30) | No | ||||
| mod_date | date | No | 0000-00-00 | |||
| dc_cat | varchar(32) | No | 0 | |||
| active | tinyint(2) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | temp_id | 100 | A | No |
branches
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| br_id (Primary) | int(2) | No | ||||
| branch | varchar(32) | No | ||||
| orderlist | int(2) | No | ||||
| address | varchar(64) | No | ||||
| tel | varchar(16) | No | ||||
| fax | varchar(16) | No | ||||
| name | varchar(64) | Yes | ||||
| title | varchar(256) | Yes | NULL | |||
| signature | varchar(128) | Yes | NULL | |||
| status | tinyint(2) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | br_id | 20 | A | No |
branches_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| br_id (Primary) | int(2) | No | ||||
| branch | varchar(32) | No | ||||
| orderlist | int(2) | No | ||||
| address | varchar(64) | No | ||||
| tel | varchar(16) | No | ||||
| fax | varchar(16) | No | ||||
| name | varchar(64) | Yes | ||||
| title | varchar(256) | Yes | NULL | |||
| signature | varchar(128) | Yes | NULL | |||
| status | tinyint(2) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | br_id | 21 | A | No |
brewery_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| br_id (Primary) | int(2) | No | ||||
| branch | varchar(32) | No | ||||
| orderlist | int(2) | No | ||||
| address | varchar(64) | No | ||||
| tel | varchar(16) | No | ||||
| fax | varchar(16) | No | ||||
| name | varchar(64) | Yes | ||||
| title | varchar(256) | Yes | NULL | |||
| signature | varchar(128) | Yes | NULL | |||
| status | tinyint(2) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | br_id | 16 | A | No |
contacts_reqa
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(5) | No | ||||
| list_order | tinyint(2) | Yes | NULL | |||
| branch | varchar(16) | No | ||||
| name | varchar(128) | No | ||||
| company | varchar(128) | No | ||||
| address1 | varchar(64) | No | ||||
| address2 | varchar(64) | No | ||||
| phone_bhrs | varchar(64) | No | ||||
| phone_ahrs | varchar(64) | No | ||||
| contact_for | varchar(64) | No | ||||
| nametoinsert | varchar(32) | No | ||||
| title | varchar(256) | No | ||||
| created_user | varchar(32) | No | ||||
| created_date | datetime | Yes | NULL | |||
| mod_user | varchar(32) | No | ||||
| mod_date | datetime | Yes | NULL | |||
| remarks | text | No | ||||
| status | tinyint(2) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 49 | A | No |
contacts_reqa_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(5) | No | ||||
| list_order | tinyint(2) | Yes | NULL | |||
| branch | varchar(16) | No | ||||
| name | varchar(128) | No | ||||
| company | varchar(128) | No | ||||
| address1 | varchar(64) | No | ||||
| address2 | varchar(64) | No | ||||
| phone_bhrs | varchar(64) | No | ||||
| phone_ahrs | varchar(64) | No | ||||
| contact_for | varchar(64) | No | ||||
| nametoinsert | varchar(32) | No | ||||
| title | varchar(256) | No | ||||
| created_user | varchar(32) | No | ||||
| created_date | datetime | Yes | NULL | |||
| mod_user | varchar(32) | No | ||||
| mod_date | datetime | Yes | NULL | |||
| remarks | text | No | ||||
| status | tinyint(2) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 47 | A | No |
correspondence
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(5) | No | ||||
| cor_id | int(4) | No | ||||
| cor_desc | text | No | ||||
| sender_email | varchar(128) | No | ||||
| sender_name | varchar(64) | No | ||||
| cor_email | varchar(256) | No | ||||
| customer_name | varchar(80) | No | ||||
| customer_code | varchar(80) | No | ||||
| subject | varchar(128) | No | ||||
| content | text | No | ||||
| create_user | varchar(30) | No | ||||
| create_date | timestamp | No | current_timestamp() | |||
| mod_user | varchar(30) | No | ||||
| mod_date | date | No | 0000-00-00 | |||
| user_level | tinyint(2) | No | ||||
| branch | varchar(32) | No | ||||
| status | varchar(30) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 7 | A | No |
customer
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| customer_code (Primary) | varchar(6) | No | 0 | |||
| customer_type | varchar(2) | No | ||||
| customer_name | varchar(120) | No | ||||
| customer_addr1 | varchar(80) | No | ||||
| customer_addr2 | varchar(80) | No | ||||
| customer_city | varchar(80) | Yes | ||||
| customer_state | varchar(2) | Yes | ||||
| customer_zip | varchar(10) | Yes | ||||
| customer_country | varchar(30) | Yes | NULL | |||
| customer_phone | varchar(30) | No | ||||
| customer_fax | varchar(30) | Yes | NULL | |||
| customer_email | varchar(50) | Yes | NULL | |||
| create_user | varchar(30) | No | ||||
| create_date | timestamp | No | 0000-00-00 00:00:00 | |||
| mod_user | varchar(30) | Yes | NULL | |||
| mod_date | timestamp | No | current_timestamp() | |||
| load_date | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | customer_code | 9174 | A | No |
customer_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| customer_code (Primary) | varchar(6) | No | 0 | |||
| customer_type | varchar(2) | No | ||||
| customer_name | varchar(80) | No | ||||
| customer_addr1 | varchar(80) | No | ||||
| customer_addr2 | varchar(80) | No | ||||
| customer_city | varchar(80) | No | ||||
| customer_state | varchar(2) | No | ||||
| customer_zip | varchar(10) | No | ||||
| customer_country | varchar(30) | Yes | NULL | |||
| customer_phone | varchar(15) | No | ||||
| customer_fax | varchar(15) | Yes | NULL | |||
| customer_email | varchar(50) | Yes | NULL | |||
| create_user | varchar(30) | No | ||||
| create_date | timestamp | No | 0000-00-00 00:00:00 | |||
| mod_user | varchar(30) | Yes | NULL | |||
| mod_date | timestamp | No | current_timestamp() | |||
| load_date | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | customer_code | 6392 | A | No |
dc_allergen
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| code (Primary) | varchar(8) | No | ||||
| item_desc | varchar(128) | No | ||||
| cat | varchar(8) | No | ||||
| allergen (Primary) | varchar(32) | No | ||||
| ord | tinyint(2) | Yes | 1 | |||
| status | tinyint(1) | Yes | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | code | 104 | A | No | |
| allergen | 104 | A | No |
dc_allergen_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| code (Primary) | varchar(8) | No | ||||
| item_desc | varchar(128) | No | ||||
| cat | varchar(8) | No | ||||
| allergen (Primary) | varchar(32) | No | ||||
| ord | tinyint(2) | Yes | 1 | |||
| status | tinyint(1) | Yes | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | code | 95 | A | No | |
| allergen | 95 | A | No |
dc_code
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| item_code (Primary) | varchar(6) | No | ||||
| desc | varchar(128) | No | ||||
| item_desc | varchar(128) | No | ||||
| code | varchar(8) | No | ||||
| cat | varchar(8) | No | ||||
| non_gmo | varchar(16) | Yes | NULL | |||
| mfg_loc | varchar(64) | Yes | NULL | |||
| status | tinyint(1) | Yes | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | item_code | 226 | A | No |
dc_code_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| item_code (Primary) | varchar(6) | No | ||||
| desc | varchar(128) | No | ||||
| item_desc | varchar(128) | No | ||||
| code | varchar(8) | No | ||||
| cat | varchar(8) | No | ||||
| non_gmo | varchar(16) | Yes | NULL | |||
| mfg_loc | varchar(64) | Yes | NULL | |||
| status | tinyint(1) | Yes | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | item_code | 191 | A | No |
dc_ing
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| code (Primary) | varchar(8) | No | ||||
| item_desc | varchar(128) | No | ||||
| cat | varchar(8) | No | ||||
| ing (Primary) | varchar(128) | No | ||||
| ratio | varchar(32) | No | ||||
| origin | varchar(32) | No | ||||
| ord | tinyint(2) | Yes | 1 | |||
| status | tinyint(1) | Yes | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | code | 89 | A | No | |
| ing | 178 | A | No |
dc_ing_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| code (Primary) | varchar(8) | No | ||||
| item_desc | varchar(128) | No | ||||
| cat | varchar(8) | No | ||||
| ing (Primary) | varchar(128) | No | ||||
| ratio | varchar(32) | No | ||||
| origin | varchar(32) | No | ||||
| ord | tinyint(2) | Yes | 1 | |||
| status | tinyint(1) | Yes | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | code | 91 | A | No | |
| ing | 182 | 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 | 27 | A | No |
default_email_bk
| 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 | 22 | A | No |
documents
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| doc_id (Primary) | int(8) | No | ||||
| req_id | int(8) | No | ||||
| temp_code | varchar(16) | No | ||||
| doc_name | varchar(128) | No | ||||
| customer_name | varchar(80) | No | ||||
| customer_code | varchar(80) | No | ||||
| item_code | varchar(6) | No | ||||
| item_desc | varchar(70) | No | ||||
| assi | varchar(30) | No | ||||
| temp_header | text | Yes | NULL | |||
| temp_address | text | No | ||||
| temp_body | text | No | ||||
| temp_sig | text | Yes | NULL | |||
| temp_footer | text | No | ||||
| temp_link | varchar(128) | No | ||||
| create_user | varchar(30) | No | ||||
| create_date | timestamp | No | current_timestamp() | |||
| mod_user | varchar(30) | No | ||||
| mod_date | date | No | 0000-00-00 | |||
| user_level | tinyint(2) | No | ||||
| branch | varchar(32) | No | ||||
| status | varchar(30) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | doc_id | 8156 | A | No |
documents_manual
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| mdoc_id (Primary) | int(10) | No | ||||
| req_id | int(8) | No | ||||
| doc_code | varchar(16) | No | ||||
| doc_desc | varchar(128) | No | ||||
| comments | text | Yes | NULL | |||
| customer_name | varchar(80) | No | ||||
| customer_code | varchar(80) | No | ||||
| item_code | varchar(6) | No | ||||
| item_desc | varchar(70) | No | ||||
| assi | varchar(30) | No | ||||
| file_link | varchar(256) | No | ||||
| create_user | varchar(30) | No | ||||
| create_date | timestamp | No | current_timestamp() | |||
| mod_user | varchar(30) | No | ||||
| mod_date | timestamp | No | current_timestamp() | |||
| approver | varchar(30) | No | ||||
| approved_date | timestamp | Yes | NULL | |||
| branch | varchar(32) | No | ||||
| status | varchar(30) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | mdoc_id | 55171 | A | No |
documents_manual_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| mdoc_id (Primary) | int(10) | No | ||||
| req_id | int(8) | No | ||||
| doc_code | varchar(16) | No | ||||
| doc_desc | varchar(128) | No | ||||
| comments | text | Yes | NULL | |||
| customer_name | varchar(80) | No | ||||
| customer_code | varchar(80) | No | ||||
| item_code | varchar(6) | No | ||||
| item_desc | varchar(70) | No | ||||
| assi | varchar(30) | No | ||||
| file_link | varchar(256) | No | ||||
| create_user | varchar(30) | No | ||||
| create_date | timestamp | No | current_timestamp() | |||
| mod_user | varchar(30) | No | ||||
| mod_date | timestamp | No | current_timestamp() | |||
| approver | varchar(30) | No | ||||
| approved_date | timestamp | No | current_timestamp() | |||
| branch | varchar(32) | No | ||||
| status | varchar(30) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | mdoc_id | 52705 | A | No |
google_users
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| google_id | varchar(35) | No | ||||
| branch | varchar(32) | No | ||||
| google_name | varchar(60) | No | ||||
| google_email | varchar(60) | No | ||||
| google_link | varchar(60) | No | ||||
| google_picture_link | varchar(256) | No | ||||
| user | varchar(32) | Yes | ||||
| pswd | varchar(32) | Yes | ||||
| mod_date | varchar(128) | No | ||||
| user_level | tinyint(2) | No | 0 | 0=inactive, 1=admin, 2=hq, 3=br | ||
| note | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 82 | A | No |
google_users_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| google_id | varchar(35) | No | ||||
| branch | varchar(32) | No | ||||
| google_name | varchar(60) | No | ||||
| google_email | varchar(60) | No | ||||
| google_link | varchar(60) | No | ||||
| google_picture_link | varchar(256) | No | ||||
| user | varchar(32) | Yes | ||||
| pswd | varchar(32) | Yes | ||||
| mod_date | varchar(128) | No | ||||
| user_level | tinyint(2) | No | 0 | 0=inactive, 1=admin, 2=hq, 3=br | ||
| note | text | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 86 | A | No |
non_gmo_items
| 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 | 8 | A | No |
post_comments
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(10) | No | ||||
| req_id | int(8) | No | ||||
| sender_email | varchar(128) | No | ||||
| sender_name | varchar(64) | No | ||||
| receiver_email | varchar(128) | No | ||||
| customer_name | varchar(80) | No | ||||
| customer_code | varchar(80) | No | ||||
| comments | text | No | ||||
| create_user | varchar(30) | No | ||||
| create_date | timestamp | No | current_timestamp() | |||
| branch | varchar(32) | No | ||||
| status | varchar(4) | No | 2=admin |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 33229 | A | No |
post_comments_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(10) | No | ||||
| req_id | int(8) | No | ||||
| sender_email | varchar(128) | No | ||||
| sender_name | varchar(64) | No | ||||
| receiver_email | varchar(128) | No | ||||
| customer_name | varchar(80) | No | ||||
| customer_code | varchar(80) | No | ||||
| comments | text | No | ||||
| create_user | varchar(30) | No | ||||
| create_date | timestamp | No | current_timestamp() | |||
| branch | varchar(32) | No | ||||
| status | varchar(4) | No | 2=admin |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 20998 | A | No |
post_notes
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(5) | No | ||||
| req_id | int(4) | No | ||||
| notes | text | No | ||||
| create_user | varchar(30) | No | ||||
| create_date | timestamp | No | current_timestamp() | |||
| status | varchar(4) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3 | 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 | 5548 | A | No |
product_items
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| product_items_id (Primary) | int(3) | No | ||||
| productcode | varchar(6) | No | ||||
| proddesc | varchar(90) | No | ||||
| uomid | varchar(2) | No | ||||
| prodacctcd | varchar(2) | No | ||||
| skuwght | decimal(8,3) | No | 0.000 | |||
| skuvolume | decimal(9,4) | No | 0.0000 | |||
| csperpallet | varchar(3) | No | ||||
| palletwght | decimal(11,2) | No | 0.00 | |||
| upc1cd3 | varchar(5) | No | ||||
| upc1cksum | varchar(2) | No | ||||
| height | decimal(5,3) | No | 0.000 | |||
| width | decimal(5,3) | No | 0.000 | |||
| depth | decimal(5,3) | No | 0.000 | |||
| createdate | datetime | No | 0000-00-00 00:00:00 | |||
| moddate | datetime | No | 0000-00-00 00:00:00 | |||
| csperlayer | varchar(2) | No | ||||
| layerperpal | varchar(2) | No | ||||
| netwght | decimal(8,3) | No | 0.000 | |||
| catgdesc | varchar(30) | No | ||||
| numstore | varchar(2) | No | ||||
| numtransport | varchar(2) | No | ||||
| packheight | decimal(5,3) | No | 0.000 | |||
| packsize | varchar(30) | No | ||||
| labeltype | varchar(60) | No | ||||
| manufname | varchar(40) | No | ||||
| containername | varchar(30) | No | ||||
| datecdrdg | varchar(80) | No | ||||
| datecdloc | varchar(80) | No | ||||
| trailer | varchar(2) | No | ||||
| datecdrdg2 | varchar(80) | No | ||||
| packnetw | decimal(6,3) | No | 0.000 | |||
| packgrwt | decimal(6,3) | No | 0.000 | |||
| packgrunit | varchar(5) | Yes | NULL | |||
| packnetunit | varchar(5) | Yes | NULL | |||
| prodclsdesc | varchar(30) | No | ||||
| upu | varchar(15) | No | ||||
| pkg | varchar(15) | No | ||||
| case | varchar(15) | No | ||||
| container_dimensions | varchar(100) | No | ||||
| ingredients | varchar(2048) | No | ||||
| certification | varchar(256) | No | ||||
| remarks | varchar(1024) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | product_items_id | 3749 | A | No |
product_item_bk
| 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 | 4110 | A | No |
readme
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| Message | text | Yes | NULL | |||
| Bitcoin_Address | text | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No |
requests
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| req_id (Primary) | int(8) | No | ||||
| req_type | varchar(80) | No | ||||
| customer_code | varchar(80) | Yes | NULL | |||
| customer_name | varchar(80) | No | ||||
| customer_addr1 | varchar(80) | No | ||||
| customer_addr2 | varchar(80) | No | ||||
| customer_city | varchar(80) | No | ||||
| customer_state | varchar(2) | No | ||||
| customer_zip | varchar(10) | No | ||||
| customer_country | varchar(30) | Yes | NULL | |||
| customer_phone | varchar(15) | No | ||||
| customer_fax | varchar(15) | Yes | NULL | |||
| attn | varchar(80) | Yes | NULL | |||
| title | varchar(80) | Yes | NULL | |||
| varchar(128) | No | |||||
| email_subject | varchar(128) | No | ||||
| doc_type | varchar(30) | No | ||||
| user | varchar(30) | No | ||||
| user_level | tinyint(2) | No | ||||
| assi | varchar(30) | Yes | NULL | |||
| assi_email | varchar(128) | Yes | NULL | |||
| ksu_sales | varchar(128) | No | ||||
| due_date | varchar(16) | Yes | ||||
| duedate | date | Yes | NULL | |||
| create_date | timestamp | No | 0000-00-00 00:00:00 | |||
| comp_date | timestamp | No | 0000-00-00 00:00:00 | |||
| appr_date | timestamp | No | 0000-00-00 00:00:00 | |||
| sent_date | timestamp | No | 0000-00-00 00:00:00 | |||
| status | varchar(30) | No | OPEN | |||
| stscde | tinyint(2) | No | ||||
| branch | varchar(32) | No | ||||
| active | tinyint(2) | Yes | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | req_id | 16590 | A | No |
requests_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| req_id (Primary) | int(8) | No | ||||
| req_type | varchar(80) | No | ||||
| customer_code | varchar(80) | Yes | NULL | |||
| customer_name | varchar(80) | No | ||||
| customer_addr1 | varchar(80) | No | ||||
| customer_addr2 | varchar(80) | No | ||||
| customer_city | varchar(80) | No | ||||
| customer_state | varchar(2) | No | ||||
| customer_zip | varchar(10) | No | ||||
| customer_country | varchar(30) | Yes | NULL | |||
| customer_phone | varchar(15) | No | ||||
| customer_fax | varchar(15) | Yes | NULL | |||
| attn | varchar(80) | Yes | NULL | |||
| title | varchar(80) | Yes | NULL | |||
| varchar(128) | No | |||||
| email_subject | varchar(128) | No | ||||
| doc_type | varchar(30) | No | ||||
| user | varchar(30) | No | ||||
| user_level | tinyint(2) | No | ||||
| assi | varchar(30) | Yes | NULL | |||
| assi_email | varchar(128) | Yes | NULL | |||
| due_date | varchar(16) | Yes | ||||
| duedate | date | Yes | NULL | |||
| create_date | timestamp | No | 0000-00-00 00:00:00 | |||
| comp_date | timestamp | No | 0000-00-00 00:00:00 | |||
| appr_date | timestamp | No | 0000-00-00 00:00:00 | |||
| sent_date | timestamp | No | 0000-00-00 00:00:00 | |||
| status | varchar(30) | No | OPEN | |||
| stscde | tinyint(2) | No | ||||
| branch | varchar(32) | No | ||||
| active | tinyint(2) | Yes | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | req_id | 9125 | 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 | ||||
| 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 | |||
| 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 | 162 | A | No |
template
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| temp_id (Primary) | int(4) | No | ||||
| temp_list | int(11) | No | ||||
| temp_code | varchar(16) | No | ||||
| temp_name | varchar(128) | No | ||||
| temp_desc | varchar(128) | No | ||||
| temp_cat | varchar(32) | Yes | NULL | |||
| temp_header | text | No | ||||
| temp_address | text | No | ||||
| temp_body | text | Yes | NULL | |||
| temp_sig | text | No | ||||
| temp_footer | text | No | ||||
| create_user | varchar(30) | No | ||||
| create_date | date | No | 0000-00-00 | |||
| mod_user | varchar(30) | No | ||||
| mod_date | date | No | 0000-00-00 | |||
| dc_cat | varchar(32) | No | 0 | |||
| active | tinyint(2) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | temp_id | 236 | A | No |
template_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| temp_id (Primary) | int(4) | No | ||||
| temp_list | int(11) | No | ||||
| temp_code | varchar(16) | No | ||||
| temp_name | varchar(128) | No | ||||
| temp_desc | varchar(128) | No | ||||
| temp_cat | varchar(32) | Yes | NULL | |||
| temp_header | text | No | ||||
| temp_address | text | No | ||||
| temp_body | text | Yes | NULL | |||
| temp_sig | text | No | ||||
| temp_footer | text | No | ||||
| create_user | varchar(30) | No | ||||
| create_date | date | No | 0000-00-00 | |||
| mod_user | varchar(30) | No | ||||
| mod_date | date | No | 0000-00-00 | |||
| dc_cat | varchar(32) | No | 0 | |||
| active | tinyint(2) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | temp_id | 187 | A | No |
template_serif
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| temp_id (Primary) | int(4) | No | ||||
| temp_list | int(11) | No | ||||
| temp_code | varchar(16) | No | ||||
| temp_name | varchar(128) | No | ||||
| temp_desc | varchar(128) | No | ||||
| temp_cat | varchar(32) | Yes | NULL | |||
| temp_header | text | No | ||||
| temp_address | text | No | ||||
| temp_body | text | Yes | NULL | |||
| temp_sig | text | No | ||||
| temp_footer | text | No | ||||
| create_user | varchar(30) | No | ||||
| create_date | date | No | 0000-00-00 | |||
| mod_user | varchar(30) | No | ||||
| mod_date | date | No | 0000-00-00 | |||
| dc_cat | varchar(32) | No | 0 | |||
| active | tinyint(2) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | temp_id | 74 | A | No |
user_timestamp
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(12) | No | ||||
| timestamp | datetime | No | ||||
| user | varchar(64) | No | ||||
| page | varchar(128) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 121779 | 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(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 | ||||
| SLF001 | varchar(32) | Yes | ||||
| storage_condition | varchar(16) | No | ||||
| date_code | varchar(16) | 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 | 314 | A | No |
v_mfg_loc
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(3) | No | ||||
| ProductionLoc | varchar(64) | No | ||||
| mfg_state | varchar(64) | Yes | ||||
| mfg_country | varchar(64) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 18 | 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 | 16 | A | No |