person_location

78 rows


Description

Linking people to a location (e.g. a marble mill, stoneworks)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
person_location_id INT 10 √ null
person_material_use.person_location_id person_material_use_ibfk_4 R

PK. Autoincrementing ID.
person_id INT 10 null
person.person_id person_location_ibfk_1 R

FK. Link to person table.
location_id INT 10 null
location.location_id person_location_ibfk_2 R

FK. Location table.
start_year INT 10 √ NULL

Year the person was first associated with the location.
end_year INT 10 √ NULL

Year the person was last associated with the location
start_year_verbatim VARCHAR 250 √ NULL

Verbatim start year, can be used to express uncertainty e.g. c.1981
end_year_verbatim VARCHAR 250 √ NULL

Verbatim end year, can be used to express uncertainty e.g. c.1981
start_date_artificial DATE 10 √ NULL

Start date to be used for sorting - overprecise. January 1st used where only year is known.
end_date_artificial DATE 10 √ NULL

End date to be used for sorting - overprecise. December 31st used where only year is known.
notes TEXT 65535 √ NULL

Notes about the person’s link to the location
documentary_sources TEXT 65535 √ NULL

Sources which refer specifically to the persons link to the location.
entered_by VARCHAR 250 √ NULL
entered_date DATE 10 √ current_timestamp()
modified_by VARCHAR 250 √ NULL
modified_date TIMESTAMP 19 √ NULL

Indexes

Constraint Name Type Sort Column(s)
person_location_s_pk Primary key Asc person_location_id
location_id Performance Asc location_id
person_id Performance Asc person_id
PRIMARY Must be unique Asc person_location_id

Relationships

Close relationships within degrees of separation