name | type | comment | NOT NULL | primary key | foreign key |
---|---|---|---|---|---|
ID | INTEGER | unique customer ID | X | X | |
NAME | VARCHAR | name and surname of contact person | X | ||
PHONE | VARCHAR | phone number of contact person | |||
FAX | VARCHAR | fax number of contact person | |||
CELLPHONE | VARCHAR | cellphone number of contact person | |||
VARCHAR | email of contact person |