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 |