artefact_group_member

0 rows


Description

This table is used to aggregate artefacts into groups. An artefact group consists of a name (see artefact_group_name) and a list of members (see artefact_group_member). It is up to the user to determine what an artefact group is meant to do functionally. Typically we assume that when one member of a group is transformed, all members of the group will also be transformed accordingly. The responsibility for such operations, however, lies downstream from the database (i.e., there are no database triggers involved with artefact groups).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
artefact_group_member_id INT UNSIGNED 10 √ null
artefact_group_member_owner.artefact_group_member_id artefact_group_member_owner_to_artefact_group_memberR
artefact_group_id INT UNSIGNED 10 null
artefact_group.artefact_group_id artefact_group_member_to_artefact_groupR

The id of the artefact group to which the artefact belongs.
artefact_id INT UNSIGNED 10 null
artefact.artefact_id artefact_group_member_to_artefactR

The id of the artefact to add to the artefact group.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc artefact_group_member_id
artefact_group_member_to_artefact Performance Asc artefact_id
artefact_group_member_to_artefact_group Performance Asc artefact_group_id

Relationships

Close relationships within degrees of separation