Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| use_feature_id | INT | 10 | √ | null |
|
|
|||||
| use_feature | VARCHAR | 200 | null |
|
|
Feature e.g. wall, column |
|||||
| use_feature_description | TEXT | 65535 | √ | NULL |
|
|
Definition/decsription of the feature with source if relevant |
||||
| alternate_names | VARCHAR | 500 | √ | NULL |
|
|
Any alternate names for the feature |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| dic_use_feature_s_pk | Primary key | Asc | use_feature_id |
| PRIMARY | Must be unique | Asc | use_feature_id |
| use_feature | Performance | Asc | use_feature |
Relationships
Close relationships within degrees of separation
