Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (9)![Foreign Keys FK_Person_Address_ID_Person_ID: [dbo].[Person].ID Foreign Keys FK_Person_Address_ID_Person_ID: [dbo].[Person].ID](../../../../Images/fk.png) | ID | numeric(16,0) | 9 | NOT NULL | | Person. Key to the Person Table |
 (9)![Check Constraints CK_Person_Address_AddressType_AddressType : ([AddressType]='Permanent' OR [AddressType]='Home' OR [AddressType]='Work' OR [AddressType]='Mailing') Check Constraints CK_Person_Address_AddressType_AddressType : ([AddressType]='Permanent' OR [AddressType]='Home' OR [AddressType]='Work' OR [AddressType]='Mailing')](../../../../Images/c-constraint.png) | AddressType | varchar(10) | 10 | NOT NULL | | This contains the address type - [AddressType]='Mailing' [AddressType]='Work' [AddressType]='Home' |
 | AddressLine1 | varchar(40) | 40 | NOT NULL | ('') | First street address line |
 | AddressLine2 | varchar(40) | 40 | NOT NULL | ('') | Second street address line |
 | City | varchar(35) | 35 | NOT NULL | ('') | City |
 | State | varchar(15) | 15 | NOT NULL | ('') | State 2 digit Abbreviation |
 | ZipCode | char(10) | 10 | NOT NULL | ('') | Zip Code |
 | ZipCodeInternational | varchar(14) | 14 | NOT NULL | ('') | International Zip Code |
 | Country | varchar(30) | 30 | NOT NULL | ('') | Country |
 | County | varchar(35) | 35 | NOT NULL | ('') | County |
| SupplementalAddress | varchar(255) | 255 | NULL allowed | | Supplemental Address ( Ex. Post Box Number) |
| StartDate | datetime | 8 | NULL allowed | | Address start date |
| EndDate | datetime | 8 | NULL allowed | | Address end date |