Table: Address
Address information for various entities
| Name | Type | Description | Remarks |
|---|---|---|---|
| Address1 |
varchar(100) |
Address Line 1 |
|
| Address2 |
varchar(100) |
Address Line 2 |
|
|
AddressTypeID |
int |
Address Type Identifier |
GenLookup AddressTypeID is a foreign key to the CatElementLU table of type 5. |
| City |
varchar(50) |
City Name |
|
|
CountryID |
int |
Country Code Identifier |
GenLookup CountryID is a foreign key to the CatElementLU table of type 204. |
|
IsPrimary |
bit |
Primary Address Indicator |
For entities with multiple addresses, only the primary address will be indicated. |
| State |
varchar(2) |
State Code |
|
| ZipCode |
varchar(30) |
Zip Code / Postal Code |