Editor Atto Autosave Table Schema (editor_atto_autosave)


Description

Draft text that is auto-saved every 5 seconds while an editor is open.

editor_atto_autosave table 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
context.id Implied Constraint R

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
user.id Implied Constraint R

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.

Table contained -1 rows

editor_atto_autosave table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
editattoauto_eleconusepag_uix Must be unique Asc/Asc/Asc/Asc elementid + contextid + userid + pagehash

editor_atto_autosave table relationships

Close relationships within degrees of separation