Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| obj_id | INT | 10 | 0 |
|
|
|||
| lrs_type_id | INT | 10 | 0 |
|
|
|||
| content_type | VARCHAR | 32 | √ | null |
|
|
||
| source_type | VARCHAR | 32 | √ | null |
|
|
||
| activity_id | VARCHAR | 255 | √ | null |
|
|
||
| instructions | VARCHAR | 4000 | √ | null |
|
|
||
| offline_status | TINYINT | 3 | 1 |
|
|
|||
| launch_url | VARCHAR | 255 | √ | null |
|
|
||
| auth_fetch_url | TINYINT | 3 | 0 |
|
|
|||
| launch_method | VARCHAR | 32 | √ | null |
|
|
||
| launch_mode | VARCHAR | 32 | √ | null |
|
|
||
| mastery_score | DOUBLE | 22 | 0 |
|
|
|||
| keep_lp | TINYINT | 3 | 0 |
|
|
|||
| usr_privacy_comment | VARCHAR | 4000 | √ | null |
|
|
||
| show_statements | TINYINT | 3 | 0 |
|
|
|||
| xml_manifest | LONGTEXT | 2147483647 | √ | null |
|
|
||
| version | INT | 10 | 1 |
|
|
|||
| highscore_enabled | TINYINT | 3 | 0 |
|
|
|||
| highscore_achieved_ts | TINYINT | 3 | 0 |
|
|
|||
| highscore_percentage | TINYINT | 3 | 0 |
|
|
|||
| highscore_wtime | TINYINT | 3 | 0 |
|
|
|||
| highscore_own_table | TINYINT | 3 | 0 |
|
|
|||
| highscore_top_table | TINYINT | 3 | 0 |
|
|
|||
| highscore_top_num | INT | 10 | 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 | obj_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors