Campsites

115013 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CampsiteID INTEGER 2000000000,10 null
CampsiteAttributes.EntityId R
PermittedEquipment.CampsiteID R
FacilityID INTEGER 2000000000,10 null
Facilities.FacilityID R
CampsiteName VARCHAR 2000000000,10 √ null
CampsiteType VARCHAR 2000000000,10 √ null
TypeOfUse VARCHAR 2000000000,10 null
Loop VARCHAR 2000000000,10 √ null
CampsiteAccessible BOOLEAN 2000000000,10 null
CampsiteLongitude FLOAT 2000000000,10 null
CampsiteLatitude FLOAT 2000000000,10 null
CreatedDate DATE 2000000000,10 null
LastUpdatedDate DATE 2000000000,10 null

Indexes

Constraint Name Type Sort Column(s)
Campsites_s_pk Primary key Asc CampsiteID
ix_Campsites_CampsiteID Performance Asc CampsiteID
ix_Campsites_FacilityID Performance Asc FacilityID
ix_Campsites_TypeOfUse Performance Asc TypeOfUse

Relationships

Close relationships within degrees of separation