Tables [dbo].[Person_Address]
Postal Address for a person
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Person_Address_ID_AddressType: ID\AddressTypeIndexes TWstat_Person_Address_AddressLine1_ID_AddressType, TWstat_Person_Address_AddressLine2_ID_AddressType, TWstat_Person_Address_AddressType_ID, TWstat_Person_Address_City_ID_AddressType, TWstat_Person_Address_Country_ID_AddressType, TWstat_Person_Address_County_ID_AddressType, TWstat_Person_Address_State_ID_AddressType, TWstat_Person_Address_ZipCode_ID_AddressType, TWstat_Person_Address_ZipCodeInternational_ID_AddressType(9)Foreign Keys FK_Person_Address_ID_Person_ID: [dbo].[Person].IDIDnumeric(16,0)9NOT NULLPerson. Key to the Person Table
Cluster Primary Key PK_Person_Address_ID_AddressType: ID\AddressTypeIndexes TWstat_Person_Address_AddressLine1_ID_AddressType, TWstat_Person_Address_AddressLine2_ID_AddressType, TWstat_Person_Address_AddressType_ID, TWstat_Person_Address_City_ID_AddressType, TWstat_Person_Address_Country_ID_AddressType, TWstat_Person_Address_County_ID_AddressType, TWstat_Person_Address_State_ID_AddressType, TWstat_Person_Address_ZipCode_ID_AddressType, TWstat_Person_Address_ZipCodeInternational_ID_AddressType(9)Check Constraints CK_Person_Address_AddressType_AddressType : ([AddressType]='Permanent' OR [AddressType]='Home' OR [AddressType]='Work' OR [AddressType]='Mailing')AddressTypevarchar(10)10NOT NULLThis contains the address type - [AddressType]='Mailing' [AddressType]='Work'  [AddressType]='Home'
Indexes TWstat_Person_Address_AddressLine1_ID_AddressTypeAddressLine1varchar(40)40NOT NULL('')First street address line
Indexes TWstat_Person_Address_AddressLine2_ID_AddressTypeAddressLine2varchar(40)40NOT NULL('')Second street address line
Indexes TWstat_Person_Address_City_ID_AddressTypeCityvarchar(35)35NOT NULL('')City
Indexes TWstat_Person_Address_State_ID_AddressTypeStatevarchar(15)15NOT NULL('')State 2 digit Abbreviation
Indexes TWstat_Person_Address_ZipCode_ID_AddressTypeZipCodechar(10)10NOT NULL('')Zip Code
Indexes TWstat_Person_Address_ZipCodeInternational_ID_AddressTypeZipCodeInternationalvarchar(14)14NOT NULL('')International Zip Code
Indexes TWstat_Person_Address_Country_ID_AddressTypeCountryvarchar(30)30NOT NULL('')Country
Indexes TWstat_Person_Address_County_ID_AddressTypeCountyvarchar(35)35NOT NULL('')County
SupplementalAddressvarchar(255)255NULL allowedSupplemental Address ( Ex. Post Box Number)
StartDatedatetime8NULL allowedAddress start date
EndDatedatetime8NULL allowedAddress end date