address-book
- Allan Sun
- tuhao
Owned by Allan Sun
URI: http://test.birdsystem.com/client/address-book
| Field | Usage | Mandatory | Data Type |
|---|---|---|---|
id | ID | INT(10) | |
| company_id | Company ID | INT(10) | |
| client_id | Client ID | INT(10) | |
reference | Reference to identify this address | YES | VARCHAR(50) |
contact | Contact | YES | VARCHAR(50) |
business_name | Business name | VARCHAR(50) | |
country_iso | Country ISO (2 digits) | YES | VARCHAR(100) |
post_code | Post code | YES | VARCHAR(100) |
county | Country / Province | VARCHAR(100) | |
city | City | YES | VARCHAR(50) |
address_line1 | Address line 1 | YES | VARCHAR(50) |
address_line2 | Address line 2 | VARCHAR(10) | |
address_line3 | Address line 3 | CHAR(2) | |
telephone | Telephone | YES | VARCHAR(50) |
VARCHAR(50) | |||
| is_public | 1 means it's set by system and shared among all Clients | TINYINT(1) | |
| type | 'CLIENT_DISPATCH','CONSIGNMENT' |