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)
email	Email		VARCHAR(50)
is_public	1 means it's set by system and shared among all Clients		TINYINT(1)
type	'CLIENT_DISPATCH','CONSIGNMENT'