person

620 rows


Description

People and firms/companies, including dates

Columns

Column Type Size Nulls Auto Default Children Parents Comments
person_id INT 10 √ null
person_construction.person_id person_construction_ibfk_2 R
person_location.person_id person_location_ibfk_1 R
person_material_source.person_id person_material_source_ibfk_2 R
person_material_use.person_id person_material_use_ibfk_2 R
person_relationship.person_id1 person_relationship_ibfk_1 R
person_relationship.person_id2 person_relationship_ibfk_2 R
person_title.person_id person_person_title_fk R

PK autoincrementing unique identifer for people
last_name VARCHAR 100 √ NULL

Last name of the person
first_names VARCHAR 100 √ NULL

First names of the person
form_of_address_id INT 10 √ NULL
dic_form_of_address.form_of_address_id person_form_of_address_fk R

FK. Link to dic_form_of_address
person_suffix_id INT 10 √ NULL
dic_person_suffix.person_suffix_id person_suffix_fk R

FK. Link to dic_person_suffix
birth_year INT 10 √ NULL

Birth year (YYYY)
death_year INT 10 √ NULL

Death year (YYYY)
birth_date DATE 10 √ NULL

Birth date
death_date DATE 10 √ NULL

Death date
birth_date_verbatim VARCHAR 250 √ NULL

Verbatim birth date
death_date_verbatim VARCHAR 250 √ NULL

Verbatim death date
floruit_start INT 10 √ NULL

A start year for when this person or organization was most active (especially if no birth-death dates known).
floruit_end INT 10 √ NULL

End year for when this person or organization was active (esp. if birth-death dates not known).
dia_id INT 10 √ NULL

Dictionary of Irish Architects ID
dib_doi VARCHAR 3000 √ NULL

DOI for the Dictionary of Irish Biography
notes TEXT 65535 √ NULL

Any notes about the person
role_id INT 10 √ NULL
dic_role.role_id person_role_fk R

Primary role id - links to dictionary of roles
primary_location VARCHAR 100 √ NULL

Primary location of the person, can be useful for distinguishing between people with the same name. Concatented with name e.g. John Smith (of Mayo).
wikidata_id VARCHAR 100 √ NULL

Wikidata ID
person_tag_old VARCHAR 500 √ NULL

Stores the old person tag, now replaced with an auto-generated version.
is_individual TINYINT 3 √ 1

Whether or not this is a single person or other (company, group etc.)
is_public TINYINT 3 √ 1

Whether or not the information is public - will control appearance on the website.
is_current TINYINT 3 √ NULL

Whether or not the person/firm is current
trading_as VARCHAR 500 √ NULL

Trading as, abbreviated to t/a.
person_desc TEXT 65535 √ NULL

Description of the person
entered_by VARCHAR 250 √ NULL
entered_date DATE 10 √ current_timestamp()
modified_by VARCHAR 250 √ NULL
modified_date DATETIME 19 √ NULL

Date of latest modification
pre_tag VARCHAR 500 √ NULL

Concatentates last name, first names, birth year, death year and primary location. First step to auto-generate a tag for the person.
person_tag VARCHAR 500 √ NULL

Autogenerates a tag for people by removing special characters (except ampersands) from the pre-tag and replacing spaces with underscores.

Indexes

Constraint Name Type Sort Column(s)
person_s_pk Primary key Asc person_id
first_names Performance Asc first_names
last_name Performance Asc last_name
person_form_of_address_fk Performance Asc form_of_address_id
person_suffix_fk Performance Asc person_suffix_id
person_tag_unique Must be unique Asc person_tag
PRIMARY Must be unique Asc person_id
role_id Performance Asc role_id

Relationships

Close relationships within degrees of separation