Address Table

Column Name Type Allow Nulls Notes
AddressID int No Primary Key
OrganizationID int Yes  
PersonID int Yes  
PersonFullName varchar(512) Yes  
CampID int Yes  
OrgID int No  
Address1 varchar(256) No  
Address2 varchar(256) Yes  
Address3 varchar(256) Yes  
Address4 varchar(256) Yes  
City varchar(128) Yes  
State varchar(128) Yes  
PostalCode varchar(128) Yes  
County varchar(128) Yes  
Country varchar(128) Yes  
PrimaryPhone varchar(48) Yes  
SecondaryPhone varchar(48) Yes  
PrimaryPhoneType varchar(128) Yes  
SecondaryPhoneType varchar(128) Yes  
PrimaryPersonRecord bit Yes  
PrimaryOrgRecord bit Yes  
PrimaryCampRecord bit Yes  
Attribute1 varchar(128) Yes  
Attribute2 varchar(128) Yes  
Attribute3 varchar(128) Yes  
Attribute4 varchar(128) Yes  
Attribute5 varchar(128) Yes  
Attribute6 varchar(128) Yes  
Attribute7 varchar(128) Yes  
Attribute8 varchar(128) Yes  
Attribute9 varchar(128) Yes  
Attribute10 varchar(128) Yes  
ActiveFlag varchar(1) No  
CreationDate datetime No  
CreatedBy nvarchar(256) No  
LastUpdateDate datetime No  
LastUpdatedBy nvarchar(256) No