| id |
serial |
10 |
|
√ |
nextval('edp_core_tdta_contact_id_seq'::regclass) |
|
|
Unique identifier for contact |
| name |
varchar |
255 |
|
|
null |
|
|
Last name of contact - Mandatory, p.1.7.1.1 of the Specification |
| firstname |
varchar |
255 |
√ |
|
null |
|
|
First name of contact - p.1.7.1.1 of the Specification |
| organisation |
varchar |
255 |
√ |
|
null |
|
|
Organisation name of contact - Mandatory, p.1.7.1.2 of the Specification |
| email |
varchar |
254 |
|
|
null |
|
|
Email address of contact - Mandatory, p.1.7.1.6 of the Specification |
| phone |
varchar |
255 |
|
|
null |
|
|
Phone number with international prefix - Optional, p.1.7.1.5 of the Specification |
| position |
varchar |
120 |
√ |
|
null |
|
|
Job position in the organisation - Optional, p.1.7.1.3 of the Specification |