Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
||||||
| parameter_name | VARCHAR | 45 | null |
|
|
|||||||
| parameter_variable | VARCHAR | 45 | √ | NULL |
|
|
||||||
| parameter_label | VARCHAR | 45 | null |
|
|
|||||||
| parameter_displayType | VARCHAR | 45 | null |
|
|
|||||||
| parameter_FormatType | VARCHAR | 10 | null |
|
|
|||||||
| parameter_default | VARCHAR | 45 | null |
|
|
|||||||
| special | VARCHAR | 1 | √ | NULL |
|
|
||||||
| selectOne | VARCHAR | 1 | √ | NULL |
|
|
||||||
| selectAll | VARCHAR | 1 | √ | NULL |
|
|
||||||
| parameter_sql | TEXT | 65535 | √ | NULL |
|
|
||||||
| parent_id | INT | 10 | √ | NULL |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| fk_stretchy_parameter_001_idx | Performance | Asc | parent_id |
| parameter_name | Must be unique | Asc | parameter_name |