prc_identifiers

Column	Format	Nullable	Description	Definition	Comments
id	integer, primary key		Row identifier	autoincrement
person_id	integer, foreign key		Person this identifier is attached to	prc_persons:id
standardized_identifier_id	integer, foreign key		SOR identifier associated with this identifer	prs_identifiers:id	Unclear if this has the same relation as other pr[cs] table pairs
identifier	varchar(100)		Identifier
identifier_t	integer, foreign key		Identifier type	ctx_data_types:id	data_type=IDENTIFIER
identifier_status_t	integer, foreign key		Identifier status	ctx_data_types:id	data_type=STATUS
primary_identifier	boolean		Whether this is the "primary" identifier of this type for this person

Migration Notes From OR 1

• changeable dropped (should be an aspect of the identifier type, not copied to each identifier; this may imply separation from ctx_data_types) ( ORII-78 - Getting issue details... STATUS )
• change_expiration_date dropped (need use case) ( ORII-78 - Getting issue details... STATUS )
• standardized_identifier_id added ( ORII-79 - Getting issue details... STATUS )
• creation_date dropped (should review for more general applicability) ( ORII-78 - Getting issue details... STATUS )

• is_deleted replaced with identifier_status_t ( ORII-80 - Getting issue details... STATUS )

• deleted_date dropped (need use case) ( ORII-78 - Getting issue details... STATUS )
• notification_date dropped (need use case) ( ORII-78 - Getting issue details... STATUS )
• is_primary renamed primary_identifier ( ORII-81 - Getting issue details... STATUS )