prc_names
Title | prc_names |
---|---|
Type | Calculated |
Description | Calculated names |
Column | Format | Nullable | Description | Definition | Comments |
---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | ||
person_id | integer, foreign key | Person this name is attached to | prc_persons:id | ||
standardized_name_id | integer, foreign key | SOR name that generated this calculated name | prs_names:id | ||
prefix | varchar(5) | Prefix | |||
given_name | varchar(100) | Given/first name |
|
| |
middle_name | varchar(100) | Middle name(s) | |||
family_name | varchar(100) | Family/last name | |||
suffix | varchar(5) | Suffix | |||
name_t | integer, foreign key | Type of this name | ctx_data_types:id | data_type=NAME | |
primary | boolean | Whether this is considered the "primary" name for this Person | No more than one name per person_id should be flagged primary | ||
language | varchar(16) | Language encoding of this name | RFC 5646 |
Migration Notes From OR 1
primary
added (Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.)language
added ( )family_comparison_value
dropped (what was this?) ( )given_comparison_value
dropped (what was this?) ( )is_official_name
dropped (usename_t
instead) ( )is_preferred_name
dropped (usename_t
instead) ( )name_source_id
dropped (what was this?) ( )standardized_name_id
added ( )