Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| type_id | INT | 10 | 0 |
|
|
|||
| title | VARCHAR | 255 | √ | null |
|
|
||
| description | VARCHAR | 4000 | √ | null |
|
|
||
| availability | INT | 10 | 1 |
|
|
|||
| remarks | VARCHAR | 4000 | √ | null |
|
|
||
| time_to_delete | INT | 10 | √ | null |
|
|
||
| lrs_endpoint | VARCHAR | 255 | null |
|
|
|||
| lrs_key | VARCHAR | 128 | null |
|
|
|||
| lrs_secret | VARCHAR | 128 | null |
|
|
|||
| privacy_comment_default | VARCHAR | 2000 | null |
|
|
|||
| external_lrs | TINYINT | 3 | 0 |
|
|
|||
| force_privacy_settings | TINYINT | 3 | 0 |
|
|
|||
| bypass_proxy | TINYINT | 3 | 0 |
|
|
|||
| only_moveon | TINYINT | 3 | 0 |
|
|
|||
| achieved | TINYINT | 3 | 1 |
|
|
|||
| answered | TINYINT | 3 | 1 |
|
|
|||
| completed | TINYINT | 3 | 1 |
|
|
|||
| failed | TINYINT | 3 | 1 |
|
|
|||
| initialized | TINYINT | 3 | 1 |
|
|
|||
| passed | TINYINT | 3 | 1 |
|
|
|||
| progressed | TINYINT | 3 | 1 |
|
|
|||
| satisfied | TINYINT | 3 | 1 |
|
|
|||
| c_terminated | TINYINT | 3 | 1 |
|
|
|||
| hide_data | TINYINT | 3 | 0 |
|
|
|||
| c_timestamp | TINYINT | 3 | 0 |
|
|
|||
| duration | TINYINT | 3 | 1 |
|
|
|||
| no_substatements | TINYINT | 3 | 0 |
|
|
|||
| privacy_ident | SMALLINT | 5 | 0 |
|
|
|||
| privacy_name | SMALLINT | 5 | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | type_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors