activity
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| activity_id (Primary) | int(10) | No | ||||
| kcc | varchar(6) | No | ||||
| user_name | varchar(96) | No | ||||
| login_count | int(6) | Yes | NULL | |||
| print_log | varchar(100) | Yes | NULL | |||
| download_log | varchar(100) | Yes | NULL | |||
| time_log | timestamp | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | activity_id | 71308 | A | No |
activity_v2
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| activity_id (Primary) | int(10) | No | ||||
| kcc | varchar(6) | No | ||||
| doc_id | varchar(128) | No | ||||
| productcode | varchar(64) | No | ||||
| doc_desc | varchar(512) | No | ||||
| download_log | varchar(100) | No | ||||
| gmaj | varchar(32) | No | ||||
| dept | varchar(100) | No | ||||
| page_path | varchar(64) | No | ||||
| library | varchar(32) | No | ||||
| clickcount | int(6) | No | ||||
| user_name | varchar(96) | No | ||||
| datetime_log | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | activity_id | 31242 | A | No |
adminuser
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| adminuser_id (Primary) | int(3) | No | ||||
| admin_email | varchar(96) | Yes | NULL | |||
| user_name | varchar(96) | No | ||||
| user_password | varchar(40) | No | ||||
| user_level | int(1) | No | 0 | |||
| login_date | date | Yes | 0000-00-00 | |||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | adminuser_id | 8 | A | No |
broker
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| kikko_id | int(3) | No | ||||
| brk_id | varchar(16) | No | ||||
| user_name (Primary) | varchar(96) | No | ||||
| user_firstname | varchar(64) | No | ||||
| user_lastname | varchar(64) | No | ||||
| user_company | varchar(200) | No | ||||
| user_email_address | varchar(160) | No | ||||
| ksu_sales_person | varchar(32) | No | ||||
| business_manager | varchar(32) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | user_name | 35 | A | No |
citrix_broker
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| brokerid (Primary) | char(3) | No | PK, fill 0 like 001 | |||
| brokername | varchar(40) | No | ||||
| active_flag | char(1) | No | 1=active, 0=inactive | |||
| lastupdated | datetime | No | PST |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | brokerid | 500 | A | No |
citrix_customer
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| customerid (Primary) | char(8) | No | PK | |||
| customername | varchar(80) | No | ||||
| active_flag | char(1) | No | 1=active, 0=inactive | |||
| primarybrokerid | char(3) | No | fill 0 | |||
| lastupdated | datetime | No | PST |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | customerid | 8863 | A | No |
contacts
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| contact_id (Primary) | int(2) | No | ||||
| kcc | varchar(6) | No | ||||
| order | varchar(2) | Yes | NULL | |||
| department | varchar(50) | Yes | NULL | |||
| contact_name | varchar(64) | No | ||||
| contact_email | varchar(96) | Yes | NULL | |||
| contact_phone | varchar(15) | Yes | NULL | |||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | contact_id | 14 | A | No |
document_table
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| doc_table_id (Primary) | int(8) | No | ||||
| user_level | int(11) | Yes | NULL | |||
| mktg_mat | varchar(16) | No | ||||
| kcc | varchar(64) | No | ||||
| ref_kcc | varchar(16) | Yes | ||||
| productcode | varchar(128) | Yes | NULL | |||
| doc_name | varchar(160) | No | ||||
| doc_description | text | Yes | NULL | |||
| doc_keyword | varchar(255) | Yes | NULL | |||
| created_user | varchar(30) | Yes | NULL | |||
| created_date | date | Yes | 0001-01-01 | |||
| expire_date | date | Yes | 0001-01-01 | |||
| mod_user | varchar(30) | Yes | NULL | |||
| mod_date | date | Yes | 0001-01-01 | |||
| doc_file_name | varchar(100) | Yes | NULL | |||
| upload_date | date | Yes | 0001-01-01 | |||
| status | int(1) | No | 1 | 2=pending |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | doc_table_id | 3432 | A | No |
document_table_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| doc_table_id (Primary) | int(8) | No | ||||
| user_level | int(11) | Yes | NULL | |||
| mktg_mat | varchar(16) | No | ||||
| kcc | varchar(64) | No | ||||
| ref_kcc | varchar(16) | Yes | ||||
| productcode | varchar(128) | Yes | NULL | |||
| doc_name | varchar(160) | No | ||||
| doc_description | text | Yes | NULL | |||
| doc_keyword | varchar(255) | Yes | NULL | |||
| created_user | varchar(30) | Yes | NULL | |||
| created_date | date | Yes | 0001-01-01 | |||
| expire_date | date | Yes | 0001-01-01 | |||
| mod_user | varchar(30) | Yes | NULL | |||
| mod_date | date | Yes | 0001-01-01 | |||
| doc_file_name | varchar(100) | Yes | NULL | |||
| upload_date | date | Yes | 0001-01-01 | |||
| status | int(1) | No | 1 | 2=pending |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | doc_table_id | 3420 | A | No |
ghk_removal
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| productcode (Primary) | varchar(7) | No | ||||
| upc | varchar(12) | No | ||||
| prod_desc | varchar(256) | No | ||||
| file_name (Primary) | varchar(64) | No | ||||
| created_date | date | No | ||||
| mod_date | datetime | Yes | NULL | |||
| status | tinyint(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | productcode | 293 | A | No | |
| file_name | 293 | A | No |
item_gmajor
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| majorcode (Primary) | char(2) | No | ||||
| majordesc | varchar(30) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | majorcode | 13 | A | No |
kcc_ref
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| product (Primary) | varchar(32) | No | ||||
| marketing | varchar(32) | No | ||||
| kcc_desc | varchar(256) | No | ||||
| cat_id | varchar(32) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | product | 37 | A | No |
kcc_references
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| kcc (Primary) | varchar(32) | No | ||||
| ref_kcc | varchar(32) | No | ||||
| kcc_desc | varchar(256) | No | ||||
| cat_id | varchar(32) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | kcc | 103 | A | No |
kosher
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| kcc | varchar(6) | No | ||||
| ref_kcc | varchar(124) | Yes | NULL | |||
| productcode | varchar(124) | Yes | NULL | |||
| doc_code | varchar(128) | Yes | NULL | |||
| doc_name | varchar(100) | No | ||||
| doc_description | text | Yes | NULL | |||
| doc_keyword | varchar(255) | No | ||||
| created_date | date | Yes | 0001-01-01 | |||
| expire_date | date | Yes | 0001-01-01 | |||
| mod_date | date | Yes | 0001-01-01 | |||
| upload_date | date | Yes | 0001-01-01 | |||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 55 | A | No |
kosher_ukd
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| ukd_id | varchar(128) | No | ||||
| Item_Description | varchar(255) | No | ||||
| productcode | text | No | ||||
| kcc | text | No | ||||
| doc_name | varchar(256) | No | ||||
| doc_description | varchar(256) | No | ||||
| doc_keyword | varchar(255) | No | ||||
| created_date | date | Yes | 0001-01-01 | |||
| expire_date | date | Yes | 0001-01-01 | |||
| mod_date | date | Yes | 0001-01-01 | |||
| upload_date | date | Yes | 0001-01-01 | |||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 164 | A | No |
kosher_ukd_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| ukd_id | varchar(128) | No | ||||
| Item_Description | varchar(255) | No | ||||
| productcode | text | No | ||||
| kcc | text | No | ||||
| doc_name | varchar(256) | No | ||||
| doc_description | varchar(256) | No | ||||
| doc_keyword | varchar(255) | No | ||||
| created_date | date | Yes | 0001-01-01 | |||
| expire_date | date | Yes | 0001-01-01 | |||
| mod_date | date | Yes | 0001-01-01 | |||
| upload_date | date | Yes | 0001-01-01 | |||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 163 | A | No |
ksu_new_account
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(4) | No | ||||
| UserName | varchar(20) | No | ||||
| AccountName | varchar(50) | No | ||||
| BuyerName | varchar(30) | No | ||||
| BuyerTitle | varchar(30) | No | ||||
| CellPhone | varchar(20) | No | ||||
| OfficePhone | varchar(20) | No | ||||
| varchar(50) | No | |||||
| rm_id | int(4) | No | ||||
| source | varchar(16) | No | ||||
| CreatedDate | datetime | No | PST |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 795 | A | No |
kwikee
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| no | int(11) | No | ||||
| gtin | varchar(16) | No | ||||
| uniformResourceIdentifier | varchar(256) | No | ||||
| typeOfInformation | varchar(32) | No | ||||
| fileFormatName | varchar(32) | No | ||||
| fileName (Primary) | varchar(32) | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| status | tinyint(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | fileName | 312 | A | No |
level_1
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| lv1_id (Primary) | int(1) | No | ||||
| kcc | varchar(6) | No | ||||
| kcc_name | varchar(100) | No | ||||
| kcc_menu | varchar(21) | No | ||||
| kcc_link | varchar(255) | No | ||||
| user_level | int(1) | No | ||||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | lv1_id | 7 | A | No |
level_2
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| lv2_id (Primary) | int(2) | No | ||||
| kcc | varchar(6) | No | 0 | |||
| orderlist | varchar(3) | Yes | NULL | |||
| kcc_name | varchar(100) | No | ||||
| kcc_menu | varchar(25) | No | ||||
| kcc_link | varchar(255) | No | ||||
| user_level | int(1) | No | 2 | |||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | lv2_id | 38 | A | No |
level_3
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| lv3_id (Primary) | int(2) | No | ||||
| kcc | varchar(6) | No | 0 | |||
| orderlist | int(3) | Yes | NULL | |||
| kcc_name | varchar(100) | No | ||||
| kcc_menu | varchar(32) | No | ||||
| kcc_link | varchar(255) | No | ||||
| majorcode | varchar(2) | No | ||||
| user_level | int(1) | No | 2 | |||
| status | int(1) | No | 1 | 2=retail mkg |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | lv3_id | 196 | A | No |
level_3_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| lv3_id (Primary) | int(2) | No | ||||
| kcc | varchar(6) | No | 0 | |||
| orderlist | int(3) | Yes | NULL | |||
| kcc_name | varchar(100) | No | ||||
| kcc_menu | varchar(32) | No | ||||
| kcc_link | varchar(255) | No | ||||
| majorcode | varchar(2) | No | ||||
| user_level | int(1) | No | 2 | |||
| status | int(1) | No | 1 | 2=retail mkg |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | lv3_id | 195 | A | No |
level_4
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| lv4_id (Primary) | int(2) | No | ||||
| kcc | varchar(6) | No | 0 | |||
| orderlist | tinyint(2) | No | ||||
| kcc_name | varchar(100) | No | ||||
| kcc_menu | varchar(25) | No | ||||
| kcc_link | varchar(255) | No | ||||
| user_level | int(1) | No | 3 | |||
| orderby | varchar(32) | No | doc_table_id DESC | |||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | lv4_id | 589 | A | No |
message
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| message_id (Primary) | int(6) | No | ||||
| created_by | varchar(20) | No | ||||
| message_title | varchar(255) | Yes | NULL | |||
| message | text | No | ||||
| expire_date | date | No | 0001-01-01 | |||
| created_date | date | Yes | NULL | |||
| status | tinyint(2) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | message_id | 1 | A | No |
new_products
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| kcc | varchar(6) | No | ||||
| productcode | varchar(30) | Yes | NULL | |||
| description | text | Yes | NULL | |||
| dept | varchar(128) | Yes | NULL | |||
| start_date | date | Yes | 0001-01-01 | |||
| end_date | date | Yes | 0001-01-01 | |||
| upload_date | date | Yes | 0001-01-01 | |||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 28 | A | No |
page_description
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| pg_desc_id (Primary) | int(2) | No | ||||
| kcc | varchar(6) | No | ||||
| index_desc | text | Yes | NULL | |||
| pg_desc | text | Yes | NULL | |||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | pg_desc_id | 56 | A | No |
product_images
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(7) | No | ||||
| GTIN | varchar(14) | No | ||||
| productcode | varchar(6) | No | ||||
| orderlist | tinyint(2) | Yes | NULL | |||
| prod_desc | varchar(256) | No | ||||
| catgdesc | varchar(30) | No | ||||
| gmaj | varchar(30) | No | ||||
| URL | varchar(512) | No | ||||
| file_name | varchar(128) | No | ||||
| height | varchar(16) | No | ||||
| width | varchar(16) | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| status | tinyint(1) | No | 1 | 0=del, 1=live |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 5585 | A | No |
product_images_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(7) | No | ||||
| GTIN | varchar(14) | No | ||||
| productcode | varchar(6) | No | ||||
| orderlist | tinyint(2) | Yes | NULL | |||
| prod_desc | varchar(256) | No | ||||
| catgdesc | varchar(30) | No | ||||
| gmaj | varchar(30) | No | ||||
| URL | varchar(512) | No | ||||
| file_name | varchar(128) | No | ||||
| height | varchar(16) | No | ||||
| width | varchar(16) | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| status | tinyint(1) | No | 1 | 0=del, 1=live |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 5808 | A | No |
product_images_conversion
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| productcode (Primary) | varchar(6) | No | ||||
| GTIN | varchar(14) | No | ||||
| GTIN_conversion | varchar(14) | Yes | NULL | |||
| proddesc | varchar(256) | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| status | tinyint(1) | No | 1 | 0=del, 1=live |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | productcode | 31 | A | No |
product_images_ws
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(7) | No | ||||
| GTIN | varchar(14) | No | ||||
| productcode | varchar(6) | No | ||||
| orderlist | tinyint(2) | Yes | NULL | |||
| prod_desc | varchar(256) | No | ||||
| catgdesc | varchar(30) | No | ||||
| gmaj | varchar(30) | No | ||||
| URL | varchar(512) | No | ||||
| file_name | varchar(128) | No | ||||
| height | varchar(16) | No | ||||
| width | varchar(16) | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| status | tinyint(1) | No | 1 | 0=del, 1=live |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 8456 | A | No |
product_items
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| product_items_id | int(3) | No | ||||
| productcode (Primary) | 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(135) | No | ||||
| container_dimensions | varchar(100) | No | ||||
| ingredients | varchar(2048) | No | ||||
| certification | varchar(1640) | No | ||||
| remarks | varchar(1640) | No | ||||
| gmaj | char(2) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | productcode | 487 | A | No |
product_kimages
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| productcode | varchar(12) | No | ||||
| Asset_ID (Primary) | int(12) | No | ||||
| GTIN | varchar(14) | No | ||||
| orderlist | tinyint(2) | Yes | NULL | |||
| kcc | varchar(16) | No | ||||
| prod_desc | varchar(256) | No | ||||
| catgdesc | varchar(30) | Yes | ||||
| country | varchar(30) | Yes | ||||
| prod_link | varchar(512) | No | ||||
| type_info | varchar(128) | No | ||||
| file_format | varchar(16) | No | ||||
| file_name | varchar(128) | No | ||||
| created_date | date | No | ||||
| status | tinyint(1) | No | 1 | 0=del, 1=live, 2=disabled,3=POGK, 4=PVK, 5=BWK, 9=nb, 10=no img |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | Asset_ID | 2124 | 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 |
roadmap
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| rm_id (Primary) | int(8) | No | ||||
| ksu_sales | varchar(32) | No | ||||
| broker | varchar(32) | No | ||||
| busmanager | varchar(32) | No | ||||
| account | varchar(32) | No | ||||
| products | varchar(128) | No | ||||
| pp_execution | varchar(64) | Yes | ||||
| ps_count | varchar(16) | Yes | ||||
| initial_target | varchar(16) | Yes | ||||
| final_target | varchar(16) | Yes | ||||
| presen_date | date | Yes | NULL | |||
| sample_req_date | date | Yes | NULL | |||
| sample_item | varchar(128) | No | ||||
| new_account | varchar(3) | Yes | NULL | |||
| result | text | No | ||||
| result_status | tinyint(2) | No | 0=inprogress, 1=pending, 2=lost, 3=won | |||
| result_date | datetime | Yes | NULL | |||
| approved_items | varchar(256) | No | ||||
| store_count | varchar(32) | No | ||||
| dept | varchar(16) | Yes | NULL | |||
| created_user | varchar(32) | Yes | NULL | |||
| created_date | datetime | Yes | NULL | |||
| mod_user | varchar(32) | No | ||||
| mod_date | datetime | Yes | NULL | |||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | rm_id | 753 | A | No |
roadmap_note
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(8) | No | ||||
| rm_id | int(8) | Yes | NULL | |||
| note | text | No | ||||
| created_user | varchar(32) | Yes | NULL | |||
| created_date | datetime | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 579 | A | No |
selections
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| sid (Primary) | int(8) | No | ||||
| sess_id | varchar(128) | No | ||||
| doc_id | varchar(16) | Yes | NULL | |||
| productcode | text | No | ||||
| doc_desc | varchar(128) | No | ||||
| filelink | varchar(128) | No | ||||
| user_email | varchar(160) | Yes | NULL | |||
| created_date | date | Yes | NULL | |||
| exp_date | date | Yes | NULL | |||
| receiver_email | varchar(160) | No | ||||
| download_date | datetime | Yes | NULL | |||
| status | int(1) | No | 1 | 1=selected, 3=downloaded |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | sid | 772 | A | No |
spec_kcc
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| kcc (Primary) | varchar(32) | No | ||||
| rf_kcc | varchar(32) | No | ||||
| kcc_desc | varchar(256) | No | ||||
| cat_id | varchar(32) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | kcc | 31 | A | No |
spec_sheets
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| productcode (Primary) | varchar(30) | No | ||||
| kcc | varchar(32) | No | ||||
| cat_id (Primary) | varchar(32) | No | ||||
| prod_type | varchar(32) | No | ||||
| prod_desc | varchar(256) | No | ||||
| prod_name | varchar(256) | No | ||||
| file_name | varchar(256) | No | ||||
| created_user | varchar(32) | No | ||||
| created_date | date | Yes | NULL | |||
| upload_date | timestamp | Yes | NULL | |||
| user_level | tinyint(2) | No | 3 | |||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | productcode | A | No | ||
| cat_id | 180 | A | No |
spec_sheets_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| productcode (Primary) | varchar(30) | No | ||||
| kcc | varchar(32) | No | ||||
| cat_id (Primary) | varchar(32) | No | ||||
| prod_type | varchar(32) | No | ||||
| prod_desc | varchar(256) | No | ||||
| prod_name | varchar(256) | No | ||||
| file_name | varchar(256) | No | ||||
| created_user | varchar(32) | No | ||||
| created_date | date | Yes | NULL | |||
| upload_date | timestamp | Yes | NULL | |||
| user_level | tinyint(2) | No | 3 | |||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | productcode | A | No | ||
| cat_id | 181 | A | No |
user
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user_id (Primary) | int(3) | No | ||||
| user_company | varchar(200) | No | ||||
| user_firstname | varchar(64) | No | ||||
| user_lastname | varchar(64) | No | ||||
| user_address | varchar(200) | No | ||||
| user_email_address | varchar(160) | No | ||||
| user_telephone | varchar(32) | No | ||||
| brk_id | varchar(256) | Yes | NULL | |||
| brk_name | varchar(200) | Yes | NULL | |||
| user_name | varchar(96) | No | ||||
| user_password | varchar(40) | No | ||||
| user_level | int(1) | No | 3 | -1=admin, 1=mgr, 2=ksu, 3=bkr, 4=keuro, 5=jpn, 8=dms | ||
| login_count | int(6) | Yes | 0 | |||
| agreed_date | datetime | Yes | NULL | |||
| last_login | datetime | Yes | NULL | |||
| timestamp | timestamp | No | current_timestamp() | |||
| server_id | varchar(2) | Yes | 0 | |||
| note | text | No | ||||
| status | int(1) | No | 1 | 0=inactive, 1=active, 3=deactivate |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | user_id | 1126 | A | No |
user_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user_id (Primary) | int(3) | No | ||||
| user_company | varchar(200) | No | ||||
| user_firstname | varchar(64) | No | ||||
| user_lastname | varchar(64) | No | ||||
| user_address | varchar(200) | No | ||||
| user_email_address | varchar(160) | No | ||||
| user_telephone | varchar(32) | No | ||||
| brk_id | varchar(256) | Yes | NULL | |||
| brk_name | varchar(200) | Yes | NULL | |||
| user_name | varchar(96) | No | ||||
| user_password | varchar(40) | No | ||||
| user_level | int(1) | No | 3 | -1=admin, 1=mgr, 2=ksu, 3=bkr, 4=keuro, 5=jpn, 8=dms | ||
| login_count | int(6) | Yes | 0 | |||
| agreed_date | datetime | Yes | NULL | |||
| last_login | datetime | Yes | NULL | |||
| timestamp | timestamp | No | current_timestamp() | |||
| server_id | varchar(2) | Yes | 0 | |||
| note | text | No | ||||
| status | int(1) | No | 1 | 0=inactive, 1=active, 3=deactivate |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | user_id | 961 | A | No |
user_login_log
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(10) | No | ||||
| ip_no | varchar(64) | No | ||||
| user_id | int(3) | No | ||||
| user_company | varchar(200) | No | ||||
| varchar(128) | No | |||||
| user | varchar(32) | Yes | ||||
| user_level | int(1) | No | ||||
| loc | varchar(16) | Yes | ||||
| login_date | datetime | Yes | NULL | |||
| status | tinyint(2) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 61884 | A | No |
user_onetime_pwd
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(10) | No | ||||
| ip_no | varchar(64) | No | ||||
| sess_id | varchar(128) | No | ||||
| user_id | int(3) | No | ||||
| user_email | varchar(96) | No | ||||
| user | varchar(32) | Yes | ||||
| user_level | int(1) | No | ||||
| login_date | datetime | Yes | NULL | |||
| user_password | varchar(40) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 40928 | A | No |
user_validation
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user_valid_id (Primary) | int(3) | No | ||||
| user_email_address | varchar(96) | No | ||||
| user_level | int(1) | No | 0 | |||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | user_valid_id | 1 | A | No |
_secured_ip
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(4) | No | ||||
| start_ip | varchar(64) | No | ||||
| end_ip | varchar(64) | No | ||||
| ip_desc | varchar(128) | Yes | NULL | |||
| group | tinyint(4) | No | 3 | 3=KSU, 2=KMS, 1=DEV | ||
| 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 | 26 | A | No |