|
id
|
The Company ID automatically generated by the database
|
int(11)
|
|
PRI
|
1
|
NO
|
|
code
|
Code issued to the company by the system
|
varchar(11)
|
11
|
|
2
|
YES
|
|
organisation_type
|
Type of organisation (Association, Company)
|
varchar(60)
|
60
|
|
3
|
YES
|
|
organisation
|
Name of the organisation
|
varchar(255)
|
255
|
|
4
|
NO
|
|
country
|
Jurisdiction where the organisation was incorporated
|
varchar(180)
|
180
|
|
5
|
YES
|
|
country_code
|
ISO 3166-1 alpha-2 country code for the jurisdiction where the organisation was incorporated
|
char(2)
|
2
|
|
6
|
YES
|
|
address
|
Physical address of the organisations head office
|
varchar(255)
|
255
|
|
7
|
YES
|
|
contact_name
|
Contact person at the organisation
|
varchar(120)
|
120
|
|
8
|
YES
|
|
email
|
Email address of the contact person at the company
|
varchar(180)
|
180
|
|
9
|
YES
|
|
phone
|
Phone number of the contact person at the company
|
varchar(60)
|
60
|
|
10
|
YES
|
|
fax
|
Fax number for the contact person at the company
|
varchar(60)
|
60
|
|
11
|
YES
|