Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| AttributeID | INTEGER | 2000000000,10 | null |
|
|
|||||
| AttributeName | VARCHAR | 2000000000,10 | null |
|
|
|||||
| AttributeValue | VARCHAR | 2000000000,10 | √ | null |
|
|
||||
| EntityId | INTEGER | 2000000000,10 | null |
|
|
|||||
| EntityType | VARCHAR | 2000000000,10 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| CampsiteAttributes_s_pk | Primary key | Asc/Asc | AttributeID + EntityId |
| ix_CampsiteAttributes_AttributeID | Performance | Asc | AttributeID |
| ix_CampsiteAttributes_AttributeName | Performance | Asc | AttributeName |
| ix_CampsiteAttributes_AttributeValue | Performance | Asc | AttributeValue |
| ix_CampsiteAttributes_EntityId | Performance | Asc | EntityId |
| sqlite_autoindex_CampsiteAttributes_1 | Must be unique | Asc/Asc | AttributeID + EntityId |
Relationships
Close relationships within degrees of separation
