Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| toolproxyid | BIGINT | 19 | null |
|
|
Primary key of related tool proxy |
||||
| typeid | BIGINT | 19 | √ | null |
|
|
||||
| course | BIGINT | 19 | √ | null |
|
|
Primary key of course (null for system-wide settings) |
|||
| coursemoduleid | BIGINT | 19 | √ | null |
|
|
Primary key of course module - tool link added to course (null for system-wide and context-wide settings) |
|||
| settings | LONGTEXT | 2147483647 | null |
|
|
Setting values as JSON |
||||
| timecreated | BIGINT | 19 | null |
|
|
Date/time at which the record was created |
||||
| timemodified | BIGINT | 19 | null |
|
|
Date/time at which the record was last modified |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| ltitoolsett_cou6_ix | Performance | Asc | course |
| ltitoolsett_cou8_ix | Performance | Asc | coursemoduleid |
| ltitoolsett_too4_ix | Performance | Asc | toolproxyid |
| ltitoolsett_typ4_ix | Performance | Asc | typeid |
Relationships
Close relationships within degrees of separation
