Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| single_action_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| main_action_id | INT UNSIGNED | 10 | null |
|
|
Id of the main action that this single action belongs to. |
||||
| action | enum('add', 'delete') | 6 | √ | NULL |
|
|
The nature of the action applied. A link to an edition was either added or deleted. |
|||
| table | VARCHAR | 255 | √ | 'NULL' |
|
|
Table containing the entry that was either added to or deleted from the edition. |
|||
| id_in_table | INT UNSIGNED | 10 | 0 |
|
|
Id of the record that was added to or deleted from the edition (of the linked main_action) in the “table”_owner table. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | single_action_id |
| fk_single_action_to_main_idx | Performance | Asc | main_action_id |