ADDRESS – This table contains addresses relating to any number of other objects in the system such as Clients, and Employees.
Ÿ ID – The unique ID for an address. (PK)
Ÿ LINKID – The ID of the object that it links to. (FK)
Ÿ LINKTYPE – The type of object the address links to. (“P” for project etc.)
Ÿ LINE1 – The first line of the address.
Ÿ LINE2 – The second line of the address.
Ÿ CITY – The city/town for the address.
Ÿ STATE – The province/state for the address.
Ÿ POSTAL – The postal/zip code for the address.
Ÿ DISPLAY – “T” if it is the default display address “F” otherwise.
Ÿ URL – An URL for the address.
Ÿ EMAIL – An email for the address.