Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| artefact_position_id | INT UNSIGNED | 10 | √ | null |
|
|
||||
| artefact_id | INT UNSIGNED | 10 | null |
|
|
The id of the artefact to be positioned on the virtual manuscript. |
||||
| z_index | INT | 10 | 0 |
|
|
This value can move artefacts up or down in relation to other artefacts in the scroll. That is, it sends an artefact further into the foreground or background. |
||||
| scale | DECIMAL UNSIGNED | 6,4 | 1.0000 |
|
|
Resizing to be applied to the artefact. |
||||
| rotate | DECIMAL UNSIGNED | 6,2 | 0.00 |
|
|
Rotation to be applied to the artefact. |
||||
| translate_x | INT | 10 | √ | NULL |
|
|
Translation of the artefact on the horizontal axis. |
|||
| translate_y | INT | 10 | √ | NULL |
|
|
Translation of the artefact on the vertical axis. |
|||
| translate_x_non_null | INT | 10 | √ | NULL |
|
|
This is a generated column for the sake of uniqueness constraints. It reads the highest possible value of an int instead of NULL, since that value is basically never going to be used (no scroll or manuscript has pages of such a length). |
|||
| translate_y_non_null | INT | 10 | √ | NULL |
|
|
This is a generated column for the sake of uniqueness constraints. I reads the highest possible value of an int instead of NULL, since that value is basically never going to be used (no scroll or manuscript has pages of such a length). |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | artefact_position_id |
| fk_artefact_position_to_artefact | Performance | Asc | artefact_id |
| fk_unique_artefact_position | Must be unique | Asc/Asc/Asc/Asc/Asc/Asc | artefact_id + rotate + scale + translate_x_non_null + translate_y_non_null + z_index |