| Company: Armitage Technologies Ltd. | Generated by CasualWriter on 2003/02/07 21:20:23 |
Data Dictionary of SqlAnywhere
| Table | No | Column | Type | Width | Dec | Null | Key |
| dba.customer | 1 | cus_no | varchar | 10 | 0 | No | Yes |
| 2 | cus_type | varchar | 6 | 0 | Yes | No | |
| 3 | cus_name | varchar | 100 | 0 | Yes | No | |
| 4 | cus_addr | varchar | 200 | 0 | Yes | No | |
| 5 | chn_addr | varchar | 200 | 0 | Yes | No | |
| 6 | delivery_addr | varchar | 200 | 0 | Yes | No | |
| 7 | cus_tel | varchar | 80 | 0 | Yes | No | |
| 8 | cus_fax | varchar | 80 | 0 | Yes | No | |
| 9 | cus_email | varchar | 80 | 0 | Yes | No | |
| 10 | contact_person | varchar | 80 | 0 | Yes | No | |
| 11 | chn_name | varchar | 100 | 0 | Yes | No | |
| 12 | remarks | varchar | 250 | 0 | Yes | No | |
| 13 | update_user | varchar | 10 | 0 | Yes | No | |
| 14 | update_date | timestamp | 8 | 0 | Yes | No | |
| dba.Invoice | 1 | inv_no | varchar | 10 | 0 | No | Yes |
| 2 | inv_date | date | 4 | 0 | Yes | No | |
| 3 | inv_status | char | 1 | 0 | Yes | No | |
| 4 | cus_no | varchar | 10 | 0 | Yes | No | |
| 5 | store_no | varchar | 10 | 0 | Yes | No | |
| 6 | stock_date | date | 4 | 0 | Yes | No | |
| 7 | remarks | varchar | 250 | 0 | Yes | No | |
| 8 | update_user | varchar | 10 | 0 | Yes | No | |
| 9 | update_date | timestamp | 8 | 0 | Yes | No | |
| dba.labdip_detail | 1 | ld_no | varchar | 10 | 0 | No | Yes |
| 2 | color_no | varchar | 10 | 0 | No | Yes | |
| 3 | color_name | varchar | 10 | 0 | Yes | No | |
| 4 | ok_dip | varchar | 10 | 0 | Yes | No | |
| 5 | remarks | varchar | 80 | 0 | Yes | No |