artefact_stack

22748 rows


Description

This table stores the relationship between artefacts which make up a stack, meaning that they represent parallel layers in a stack. This could be:
a) Artefact A is and B represent recto/verso of one layer (artefact), then the layer_A and layer_B must be the same
b) A and B represent parts of different layers of a already decomposed stack (reason= ‚found in a stack‘) or as part of wad (reason = ‚part of a wad‘) or as thought by the scholar to belong in the same perimeter of the manuscript (reason=‚reconstructed‘).

The tables allow the creation of a sequence of artefacts: A = recto of layer 1 -> B = verso of layer 1 -> C = recto of recto of layer 2 -> D = verso of layer 2 … (where -> represents a record with the left as artefact_A and the right term as artefact_B)

A special case is marked by shared. We could, e.g., have A as verso and B as recto and additionally a subregion of B as shared to A.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
artefact_stack_id INT UNSIGNED 10 √ null
artefact_stack_owner.artefact_stack_id fk_artefact_stack_owner_to_artefact_stackR
artefact_A_id INT UNSIGNED 10 null
artefact.artefact_id fk_af_stack_A_to_artefactR

The first artefact in the stack.
artefact_B_id INT UNSIGNED 10 null
artefact.artefact_id fk_af_stack_B_to_artefactR

The second artefact in the stack.
artefact_B_offset GEOMETRY 0 st_geometryfromtext('POINT(0 0)')

Gives the offset by which the artefact B must be moved to match the artefact A. The offset is a POINT geometry.
layer_A TINYINT UNSIGNED 3 1

Gives the number of the layer in the stack to which artefact A belongs. In the case of a recto/verso match, this would be 0. In the case of a wad, a higher number should indicate a layer that is closer to the outside of the scroll, or the front of the codex.
layer_B TINYINT UNSIGNED 3 1

Gives the number of the layer in the stack to which artefact B belongs. In the case of a recto/verso match, this would be 0. In the case of a wad, a higher number should indicate a layer that is closer to the outside of the scroll, or the front of the codex.
A_is_verso TINYINT UNSIGNED 3 0

Boolean whether srtefact A is recto=0 or verso=1.
B_is_verso TINYINT UNSIGNED 3 1

Boolean whether srtefact B is recto=0 or verso=1.
reason enum('RECTO_VERSO', 'FOUND_IN_A_STACK', 'PART_OF_A_WAD', 'RECONSTRUCTED_STACK') 19 'RECTO_VERSO'
shared TINYINT UNSIGNED 3 0

True if the given region of artefact_B represents a region which appears on the surface of artefact_A (bleeding through, ink glued to the next layer).

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc artefact_stack_id
fk_af_stack_A_to_artefact_idx Performance Asc artefact_A_id
fk_af_stack_B_to_artefact_idx Performance Asc artefact_B_id
unique_artefact_stack Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc A_is_verso + artefact_A_id + artefact_B_id + artefact_B_offset + B_is_verso + layer_A + layer_B + reason + shared

Relationships

Close relationships within degrees of separation