person_material_use

21 rows


Description

Linking people to a material use (e.g. stonemason to a carving)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
person_material_use_id INT 10 √ null
material_use_id INT 10 null
material_use.material_use_id person_material_use_ibfk_1 R

FK. Link to material use
person_id INT 10 null
person.person_id person_material_use_ibfk_2 R

FK. The person working on this feature
role_id INT 10 √ NULL
dic_role.role_id person_material_use_ibfk_3 R

FK. The role the person had while working on this feature (e.g. as a stoneworker)
person_location_id INT 10 √ NULL
person_location.person_location_id person_material_use_ibfk_4 R

FK. Link to person_location
is_primary TINYINT 3 √ NULL

Whether or not this person was the primary person working on this feature
notes_public TEXT 65535 √ NULL

Notes which could be made public about the person’s link to the material use.
notes_other TEXT 65535 √ NULL

Internal notes

Indexes

Constraint Name Type Sort Column(s)
person_material_use_s_pk Primary key Asc person_material_use_id
material_use_id Performance Asc material_use_id
person_id Performance Asc person_id
person_location_id Performance Asc person_location_id
PRIMARY Must be unique Asc person_material_use_id
role_id Performance Asc role_id

Relationships

Close relationships within degrees of separation