| mdoc_id | int(10) |
|
|
|
| req_id | int(8) |
|
|
|
| doc_code | varchar(16) |
|
|
|
| doc_desc | varchar(128) |
|
|
|
| comments | text |
|
|
|
| customer_name | varchar(80) |
|
|
|
| customer_code | varchar(80) |
|
|
|
| item_code | varchar(6) |
|
|
|
| item_desc | varchar(70) |
|
|
|
| assi | varchar(30) |
|
|
|
| file_link | varchar(256) |
|
|
|
| create_user | varchar(30) |
|
|
|
| create_date | timestamp |
|
|
current_timestamp()
|
| mod_user | varchar(30) |
|
|
|
| mod_date | timestamp |
|
|
current_timestamp()
|
| approver | varchar(30) |
|
|
|
| approved_date | timestamp |
|
|
current_timestamp()
|
| branch | varchar(32) |
|
|
|
| status | varchar(30) |
|
|
|