Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FacilityID | VARCHAR | 2000000000,10 | null |
|
|
|||||||||
| LegacyFacilityID | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| OrgFacilityID | INTEGER | 2000000000,10 | null |
|
|
|||||||||
| ParentOrgID | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| ParentRecAreaID | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| FacilityName | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| FacilityDescription | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| FacilityTypeDescription | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| FacilityUseFeeDescription | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| FacilityDirections | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| FacilityPhone | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| FacilityEmail | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| FacilityReservationURL | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| FacilityMapURL | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| FacilityAdaAccess | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| FacilityLongitude | FLOAT | 2000000000,10 | null |
|
|
|||||||||
| FacilityLatitude | FLOAT | 2000000000,10 | null |
|
|
|||||||||
| Keywords | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| StayLimit | VARCHAR | 2000000000,10 | √ | null |
|
|
||||||||
| Reservable | BOOLEAN | 2000000000,10 | null |
|
|
|||||||||
| Enabled | BOOLEAN | 2000000000,10 | null |
|
|
|||||||||
| LastUpdatedDate | DATE | 2000000000,10 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| Facilities_s_pk | Primary key | Asc | FacilityID |
| ix_Facilities_FacilityID | Performance | Asc | FacilityID |
| ix_Facilities_FacilityName | Performance | Asc | FacilityName |
| ix_Facilities_ParentRecAreaID | Performance | Asc | ParentRecAreaID |
| sqlite_autoindex_Facilities_1 | Must be unique | Asc | FacilityID |
Relationships
Close relationships within degrees of separation
