Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | 0 |
|
|
|||
| c_online | VARCHAR | 3 | √ | n |
|
|
||
| api_adapter | VARCHAR | 80 | √ | API |
|
|
||
| api_func_prefix | VARCHAR | 20 | √ | LMS |
|
|
||
| credit | VARCHAR | 10 | √ | credit |
|
|
||
| default_lesson_mode | VARCHAR | 8 | √ | normal |
|
|
||
| auto_review | VARCHAR | 3 | √ | n |
|
|
||
| c_type | VARCHAR | 10 | √ | null |
|
|
||
| max_attempt | INT | 10 | √ | 0 |
|
|
||
| module_version | INT | 10 | √ | 1 |
|
|
||
| editable | INT | 10 | 0 |
|
|
|||
| stylesheet | INT | 10 | 0 |
|
|
|||
| glossary | INT | 10 | 0 |
|
|
|||
| question_tries | INT | 10 | √ | 3 |
|
|
||
| unlimited_session | VARCHAR | 1 | n |
|
|
|||
| VARCHAR | 1 | n |
|
|
||||
| VARCHAR | 1 | n |
|
|
||||
| debug | VARCHAR | 1 | n |
|
|
|||
| debugpw | VARCHAR | 50 | √ | n |
|
|
||
| entry_page | INT | 10 | 0 |
|
|
|||
| seq_exp_mode | TINYINT | 3 | √ | 0 |
|
|
||
| localization | VARCHAR | 2 | √ | null |
|
|
||
| open_mode | TINYINT | 3 | 0 |
|
|
|||
| width | SMALLINT | 5 | 950 |
|
|
|||
| height | SMALLINT | 5 | 650 |
|
|
|||
| auto_continue | VARCHAR | 1 | n |
|
|
|||
| sequencing | VARCHAR | 1 | y |
|
|
|||
| interactions | VARCHAR | 1 | y |
|
|
|||
| objectives | VARCHAR | 1 | y |
|
|
|||
| time_from_lms | VARCHAR | 1 | n |
|
|
|||
| comments | VARCHAR | 1 | y |
|
|
|||
| auto_last_visited | VARCHAR | 1 | y |
|
|
|||
| check_values | VARCHAR | 1 | y |
|
|
|||
| offline_mode | VARCHAR | 1 | n |
|
|
|||
| offline_zip_created | DATETIME | 19 | √ | null |
|
|
||
| auto_suspend | VARCHAR | 1 | n |
|
|
|||
| fourth_edition | VARCHAR | 1 | n |
|
|
|||
| ie_compatibility | VARCHAR | 1 | √ | null |
|
|
||
| ie_force_render | VARCHAR | 1 | n |
|
|
|||
| mastery_score | TINYINT | 3 | √ | null |
|
|
||
| id_setting | TINYINT | 3 | 0 |
|
|
|||
| name_setting | TINYINT | 3 | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors