person_material_source

302 rows


Description

Linking people to a material source (e.g. owner of a quarry)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
person_material_source_id INT 10 √ null

Primary key, autoincrementing
material_source_id INT 10 null
material_source.material_source_id person_material_source_ibfk_1 R

Link to material_source table
person_id INT 10 √ NULL
person.person_id person_material_source_ibfk_2 R

Link to person table
role_id INT 10 √ NULL
dic_role.role_id person_material_source_ibfk_3 R

Link to dic_role table
dates VARCHAR 400 √ NULL

Dates when this person or organization was related to the material source. Usually not precise. Where known ranges should have the following format: 1800-1810.
start_date VARCHAR 250 √ NULL

Start date, with the degree of detail known (i.e. could be to the century, year, month, day).
end_date VARCHAR 250 √ NULL

End date, with the degree of detail known (i.e. could be to the century, year, month, day).
start_date_artificial DATE 10 √ NULL

Date when this person was first associated with the material source. Over-precise date, for sorting purposes.
end_date_artificial DATE 10 √ NULL

Date when the person stopped being associated with the material source. Over-precise, to be used for sorting.
is_primary TINYINT 3 √ NULL

Is the primary person associated with this material source
notes_public TEXT 65535 √ NULL

Notes about the relationship of this person (or group) to the material source
verbatim_name TEXT 65535 √ NULL

Verbatim name of the person/group
notes_other TEXT 65535 √ NULL

Any other notes, not for the website
documentary_sources TEXT 65535 √ NULL

Sources linking person to material_source
relative_position INT 10 √ NULL

Indexes

Constraint Name Type Sort Column(s)
person_material_source_s_pk Primary key Asc person_material_source_id
material_source_id Performance Asc material_source_id
person_material_source_person_fk Performance Asc person_id
person_material_source_role_fk Performance Asc role_id
PRIMARY Must be unique Asc person_material_source_id

Relationships

Close relationships within degrees of separation