| doc_id | int(8) |
|
|
|
| req_id | int(8) |
|
|
|
| temp_code | varchar(16) |
|
|
|
| doc_name | varchar(128) |
|
|
|
| customer_name | varchar(80) |
|
|
|
| customer_code | varchar(80) |
|
|
|
| item_code | varchar(6) |
|
|
|
| item_desc | varchar(70) |
|
|
|
| assi | varchar(30) |
|
|
|
| temp_header | text |
|
|
|
| temp_address | text |
|
|
|
| temp_body | text |
|
|
|
| temp_sig | text |
|
|
|
| temp_footer | text |
|
|
|
| temp_link | varchar(128) |
|
|
|
| create_user | varchar(30) |
|
|
|
| create_date | timestamp |
|
|
current_timestamp()
|
| mod_user | varchar(30) |
|
|
|
| mod_date | date |
|
|
0000-00-00
|
| user_level | tinyint(2) |
|
|
|
| branch | varchar(32) |
|
|
|
| status | varchar(30) |
|
|
|