prc_names

Titleprc_names
TypeCalculated
DescriptionCalculated names
ColumnFormatNullableDescriptionDefinitionComments
idinteger, primary key(error)Row identifierautoincrement 
person_idinteger, foreign key(error)Person this name is attached toprc_persons:id 
standardized_name_idinteger, foreign key(tick)SOR name that generated this calculated nameprs_names:id 
prefixvarchar(5)(tick)Prefix  
given_namevarchar(100)(error)Given/first name

 

 

middle_namevarchar(100)(tick)Middle name(s)  
family_namevarchar(100)(tick)Family/last name  
suffixvarchar(5)(tick)Suffix  
name_tinteger, foreign key(error)Type of this namectx_data_types:iddata_type=NAME
primaryboolean(tick)Whether this is considered the "primary" name for this Person No more than one name per person_id should be flagged primary
languagevarchar(16)(tick)Language encoding of this nameRFC 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 ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • family_comparison_value dropped (what was this?) ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • given_comparison_value dropped (what was this?) ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • is_official_name dropped (use name_t instead) ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • is_preferred_name dropped (use name_t instead) ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • name_source_id dropped (what was this?) ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )
  • standardized_name_id added ( Unable to locate Jira server for this macro. It may be due to Application Link configuration. )