Location Table

Column Name Type Allow Nulls Notes
LocationID int No Unique ID
OrganizationID int No  
CampID int No  
LocationCode varchar(40) No  
LocationName varchar(256) No  
LocationDesc varchar(256) Yes  
MaxSize int Yes  
HandicappAccessible varchar(1) Yes  
HasElectrical varchar(1) Yes  
HasWater varchar(1) Yes  
HasRestrooms varchar(128) 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