Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| elementid | VARCHAR | 255 |
|
|
The unique id for the text editor in the form. |
|||||
| contextid | BIGINT | 19 | null |
|
|
The contextid that the form was loaded with. |
||||
| pagehash | VARCHAR | 64 |
|
|
The HTML DOM id of the page that loaded the form. |
|||||
| userid | BIGINT | 19 | null |
|
|
The id of the user that loaded the form. |
||||
| drafttext | LONGTEXT | 2147483647 | null |
|
|
The draft text |
||||
| draftid | BIGINT | 19 | √ | null |
|
|
Optional draft area id containing draft files. |
|||
| pageinstance | VARCHAR | 64 |
|
|
The browser tab instance that last saved the draft text. This is to prevent multiple tabs from the same user saving different text alternately. |
|||||
| timemodified | BIGINT | 19 | 0 |
|
|
Store the last modified time for the auto save text. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| editattoauto_eleconusepag2_uix | Must be unique | Asc/Asc/Asc/Asc | elementid + contextid + userid + pagehash |
Relationships
Close relationships within degrees of separation
