branch
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| br_code | varchar(16) | No | ||||
| branch | varchar(64) | No | ||||
| tel | varchar(64) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 8 | A | No |
broker
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| CUSTOMERCODE (Primary) | varchar(6) | No | 0 | |||
| CUSTOMERNAME | varchar(80) | No | ||||
| BROKERCODE | varchar(6) | No | ||||
| BROKERNAME | varchar(80) | No | ||||
| LOADDATE | timestamp | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | CUSTOMERCODE | 3611 | A | No |
broker_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| CUSTOMERCODE (Primary) | varchar(6) | No | 0 | |||
| CUSTOMERNAME | varchar(80) | No | ||||
| BROKERCODE | varchar(6) | No | ||||
| BROKERNAME | varchar(80) | No | ||||
| LOADDATE | timestamp | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | CUSTOMERCODE | 3611 | A | No |
carrier
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| list | varchar(2) | No | ||||
| carrier | varchar(50) | No | ||||
| create_user | varchar(30) | No | ||||
| create_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 | 4 | 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(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 | current_timestamp() | |||
| mod_user | varchar(30) | Yes | NULL | |||
| mod_date | timestamp | No | current_timestamp() | |||
| load_date | timestamp | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | customer_code | 7608 | A | No |
default_email
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| email_id (Primary) | int(6) | No | ||||
| branch | varchar(8) | 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 | 11 | A | No |
default_email_test
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| email_id (Primary) | int(6) | No | ||||
| branch | varchar(8) | 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 | 1 | A | No |
job_no
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| no_id (Primary) | int(6) | No | ||||
| jobno | varchar(16) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | no_id | 1 | A | No |
newcustomers
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| company | varchar(50) | Yes | NULL | |||
| first_name | varchar(50) | Yes | NULL | |||
| last_name | varchar(50) | Yes | NULL | |||
| email_address | varchar(50) | Yes | NULL | |||
| job_title | varchar(50) | Yes | NULL | |||
| business_phone | varchar(25) | Yes | NULL | |||
| mobile_phone | varchar(25) | Yes | NULL | |||
| fax_number | varchar(25) | Yes | NULL | |||
| customer_addr1 | varchar(80) | No | ||||
| customer_addr2 | varchar(80) | No | ||||
| city | varchar(50) | Yes | NULL | |||
| state_province | varchar(50) | Yes | NULL | |||
| zip_postal_code | varchar(15) | Yes | NULL | |||
| country_region | varchar(50) | Yes | NULL | |||
| create_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 | 0 | A | No |
post_comments
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(5) | No | ||||
| req_id | int(4) | No | ||||
| job_id | varchar(32) | 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1601 | 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 | current_timestamp() | |||
| 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 | 3289 | A | No |
product_samples
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(7) | No | ||||
| job_id | varchar(16) | No | ||||
| qty | varchar(3) | Yes | ||||
| item_code | varchar(6) | No | 0 | |||
| item_type | varchar(16) | Yes | NULL | |||
| item_desc | varchar(70) | No | ||||
| s_code | varchar(7) | Yes | NULL | |||
| conv | varchar(16) | Yes | ||||
| size | varchar(16) | Yes | NULL | |||
| uom | varchar(16) | Yes | NULL | |||
| shipdate | datetime | Yes | NULL | |||
| tracking_no | varchar(128) | Yes | ||||
| varchar(8) | Yes | |||||
| branch | varchar(80) | Yes | ||||
| created_user | varchar(30) | No | ||||
| created_date | datetime | Yes | NULL | |||
| processed_date | datetime | Yes | NULL | |||
| status | varchar(16) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 6612 | A | No |
product_samples_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(7) | No | ||||
| job_id | varchar(16) | No | ||||
| qty | varchar(3) | Yes | ||||
| item_code | varchar(6) | No | 0 | |||
| item_type | varchar(16) | Yes | NULL | |||
| item_desc | varchar(70) | No | ||||
| s_code | varchar(7) | Yes | NULL | |||
| conv | varchar(16) | Yes | ||||
| size | varchar(16) | Yes | NULL | |||
| uom | varchar(16) | Yes | NULL | |||
| shipdate | datetime | Yes | NULL | |||
| tracking_no | varchar(128) | Yes | ||||
| varchar(8) | Yes | |||||
| branch | varchar(80) | Yes | ||||
| created_user | varchar(30) | No | ||||
| created_date | timestamp | No | 0000-00-00 00:00:00 | |||
| processed_date | timestamp | No | 0000-00-00 00:00:00 | |||
| status | varchar(16) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2255 | A | No |
pso_req
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| req_id (Primary) | int(4) | No | ||||
| job_id | varchar(16) | 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(7) | No | ||||
| customer_zip | varchar(10) | No | ||||
| customer_country | varchar(30) | Yes | NULL | |||
| customer_phone | varchar(15) | No | ||||
| attn | varchar(80) | Yes | NULL | |||
| varchar(128) | No | |||||
| broker | varchar(128) | No | ||||
| spec_sht | varchar(16) | No | ||||
| tracking_no | varchar(128) | No | ||||
| purpose | varchar(256) | No | ||||
| rd_desc | varchar(64) | No | ||||
| other_desc | varchar(64) | No | ||||
| shipvia | varchar(80) | No | ||||
| shipdate | datetime | Yes | NULL | |||
| due_date | date | Yes | NULL | |||
| user | varchar(30) | No | ||||
| user_level | tinyint(2) | No | ||||
| branch | varchar(80) | No | ||||
| approvedby | varchar(60) | No | ||||
| approvedate | datetime | Yes | NULL | |||
| create_date | datetime | Yes | NULL | |||
| comp_date | datetime | Yes | NULL | |||
| status | varchar(30) | No | OPEN | 1=OPN, 2=SHP | ||
| active | tinyint(2) | Yes | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | req_id | 3681 | A | No |
pso_req_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| req_id (Primary) | int(4) | No | ||||
| job_id | varchar(16) | 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(7) | No | ||||
| customer_zip | varchar(10) | No | ||||
| customer_country | varchar(30) | Yes | NULL | |||
| customer_phone | varchar(15) | No | ||||
| attn | varchar(80) | Yes | NULL | |||
| varchar(128) | No | |||||
| broker | varchar(128) | No | ||||
| spec_sht | varchar(16) | No | ||||
| tracking_no | varchar(128) | No | ||||
| purpose | varchar(256) | No | ||||
| rd_desc | varchar(64) | No | ||||
| other_desc | varchar(64) | No | ||||
| shipvia | varchar(80) | No | ||||
| shipdate | datetime | Yes | NULL | |||
| due_date | date | Yes | NULL | |||
| user | varchar(30) | No | ||||
| user_level | tinyint(2) | No | ||||
| branch | varchar(80) | No | ||||
| approvedby | varchar(60) | No | ||||
| approvedate | datetime | Yes | NULL | |||
| create_date | datetime | Yes | NULL | |||
| comp_date | datetime | Yes | NULL | |||
| status | varchar(30) | No | OPEN | 1=OPN, 2=SHP | ||
| active | tinyint(2) | Yes | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | req_id | 3665 | A | No |
req_type
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| list | varchar(2) | No | ||||
| purpose_type | varchar(50) | No | ||||
| create_user | varchar(30) | No | ||||
| create_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 | 7 | A | No |
sample_items
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| item_code (Primary) | varchar(6) | No | 0 | |||
| max_qty | tinyint(2) | No | ||||
| type | varchar(16) | No | ||||
| item_desc | varchar(70) | No | ||||
| s_code | varchar(7) | No | ||||
| conv | varchar(16) | No | ||||
| size | varchar(16) | No | ||||
| uom | varchar(16) | No | ||||
| created_user | varchar(30) | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| mod_user | varchar(30) | Yes | NULL | |||
| mod_date | timestamp | Yes | NULL | |||
| status | tinyint(2) | No | 1 | 0=inactive, 1=active |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | item_code | 78 | A | No |
sample_items_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| item_code (Primary) | varchar(6) | No | 0 | |||
| max_qty | tinyint(2) | No | ||||
| type | varchar(16) | No | ||||
| item_desc | varchar(70) | No | ||||
| s_code | varchar(7) | No | ||||
| conv | varchar(16) | No | ||||
| size | varchar(16) | No | ||||
| uom | varchar(16) | No | ||||
| created_user | varchar(30) | No | ||||
| created_date | timestamp | No | current_timestamp() | |||
| mod_user | varchar(30) | Yes | NULL | |||
| mod_date | timestamp | Yes | NULL | |||
| status | tinyint(2) | No | 1 | 0=inactive, 1=active |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | item_code | 68 | A | No |
ship_method
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| list | varchar(2) | No | ||||
| ship_type | varchar(50) | No | ||||
| create_user | varchar(30) | No | ||||
| create_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 | 7 | A | No |
status
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| list | varchar(2) | No | ||||
| abbr | varchar(8) | No | ||||
| sts_desc | varchar(32) | No | ||||
| create_user | varchar(30) | No | ||||
| create_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 | 7 | A | No |
users
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| branch (Primary) | varchar(32) | No | ||||
| fname | varchar(32) | No | ||||
| lname | varchar(32) | No | ||||
| email (Primary) | varchar(60) | No | ||||
| user | varchar(16) | No | ||||
| pwd | varchar(16) | No | ||||
| user_level | tinyint(2) | No | 1 | 1=admin, 2=hq, 3=br | ||
| status | tinyint(2) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 58 | A | No | |
| 58 | A | No | ||||||
| branch | 58 | A | No |
users_bk
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(6) | No | ||||
| branch (Primary) | varchar(32) | No | ||||
| fname | varchar(32) | No | ||||
| lname | varchar(32) | No | ||||
| email (Primary) | varchar(60) | No | ||||
| user_level | tinyint(2) | No | 1 | 1=admin, 2=hq, 3=br | ||
| status | tinyint(2) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 38 | A | No | |
| 38 | A | No | ||||||
| branch | 38 | 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 | 7 | A | No |