Campsite Table

Column Name Type Allow Nulls Notes
CampsiteID int No Primary Key
CampsiteCode varchar(40) No  
CampsiteName varchar(256) No  
CampsiteDesc varchar(256) Yes  
OrganizationID int No  
CampID int No  
SubCampID int No  
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 date No  
LastUpdatedBy nvarchar(256) No  
MaxSize int Yes  
HasElectrical varchar(1) Yes  
HasWater varchar(1) Yes  
HasRestrooms varchar(128) Yes  
HasShelter varchar(1) Yes  
HandicappAccessible varchar(1) Yes