broker
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| brk_id (Primary) | varchar(64) | No | ||||
| ded_brokerid (Primary) | varchar(256) | No | ||||
| status | int(1) | No | 1 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | brk_id | A | No | ||
| ded_brokerid | 436 | A | No |
deduction
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| dedid (Primary) | char(15) | No | ||||
| ded_status | char(1) | Yes | NULL | |||
| ded_date | date | Yes | NULL | |||
| ded_amount | decimal(12,2) | Yes | NULL | |||
| corpcustnum | char(8) | Yes | NULL | |||
| corpcustname | varchar(40) | Yes | NULL | |||
| ded_customer | char(8) | Yes | NULL | |||
| ded_cust_name | varchar(40) | Yes | NULL | |||
| ded_brokerid | int(4) | Yes | NULL | |||
| bkr_name | varchar(40) | Yes | NULL | |||
| slsmnid | char(4) | Yes | NULL | |||
| slsmnname | varchar(40) | Yes | NULL | |||
| ded_location | char(3) | Yes | NULL | |||
| ded_code | varchar(8) | Yes | ||||
| dc_desc | varchar(32) | Yes | ||||
| ded_reference | varchar(120) | Yes | NULL | |||
| ded_checkno | varchar(20) | Yes | ||||
| ded_user | char(12) | Yes | NULL | |||
| brk_id | char(12) | Yes | NULL | |||
| brk_apprv_flag | char(1) | Yes | NULL | |||
| brk_apprv_date | date | Yes | NULL | |||
| slsmgr | char(12) | Yes | NULL | |||
| mgr_apprv_flag | char(1) | Yes | NULL | |||
| mgr_apprv_date | date | Yes | NULL | |||
| correspondent | char(12) | Yes | NULL | |||
| comments_flag | date | Yes | NULL | |||
| create_date | date | Yes | NULL | |||
| create_user | char(12) | Yes | NULL | |||
| retrieved_flag | char(1) | Yes | NULL | |||
| retrieved_date | date | Yes | NULL | |||
| retrieved_user | char(12) | Yes | NULL | |||
| removed_date | date | Yes | NULL | |||
| removed_user | char(12) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | dedid | 173234 | A | No |
ded_code
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id | tinyint(2) | No | ||||
| code | varchar(8) | No | ||||
| dc_desc | varchar(32) | No | ||||
| status | tinyint(1) | No | 1 | 0=inactive, 1=active |
ded_comment
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| dedid (Primary) | char(15) | No | ||||
| linenum (Primary) | int(2) | No | 0 | |||
| cmnt | text | Yes | NULL | |||
| create_date | date | Yes | NULL | |||
| create_user | char(12) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | dedid | A | No | ||
| linenum | 99764 | A | No |
ded_doc
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| dedid (Primary) | char(15) | No | ||||
| brk_doc1 | varchar(150) | Yes | NULL | |||
| brk_doc2 | varchar(150) | Yes | NULL | |||
| brk_doc3 | varchar(150) | Yes | NULL | |||
| brk_doc_date | date | Yes | NULL | |||
| corr_doc1 | varchar(150) | Yes | NULL | |||
| corr_doc2 | varchar(150) | Yes | NULL | |||
| corr_doc3 | varchar(150) | Yes | NULL | |||
| corr_doc_date | date | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | dedid | 146402 | A | No |
email_activity
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(12) | No | ||||
| dedid | char(15) | No | ||||
| sent_to | varchar(128) | No | ||||
| document | varchar(128) | Yes | NULL | |||
| message | text | No | ||||
| sent_date | timestamp | Yes | NULL | |||
| create_user | char(12) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4366 | 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_email_address | varchar(160) | No | ||||
| kikko_id | varchar(128) | No | ||||
| user | varchar(16) | No | ||||
| slsmnid | varchar(128) | No | ||||
| brk_id | varchar(64) | No | ||||
| broker_id | text | No | ||||
| shared_brkid | varchar(256) | No | ||||
| ded_location | varchar(256) | No | ||||
| corpcustnum | varchar(128) | Yes | ||||
| blockcorpcustnum | varchar(128) | Yes | ||||
| group_name | varchar(32) | No | ||||
| mgr_slsmnid | varchar(256) | No | ||||
| status | int(1) | No | 1 | 0=del, 1=live, 3=pending |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | user_id | 419 | A | No |