Table | identifiers |
|---|---|
Description | Identifiers for a Person or External Identity |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| person_id | integer, foreign key | Person ID | people:id | Exactly one entity foreign key is required | |
| group_id | integer, foreign key | Group ID | groups:id | Exactly one entity foreign key is required | |
identifier | varchar(512) | Identifier | | ||
status | varchar(2) | Status of this Identifier |
| | |
login | boolean | Whether this Identifier may be used to login to Registry |
| Only applies to Identifiers attached to a Person | |
| type_id | integer, foreign key | Type of this Identifier | types:id | | |
| source_identifier_id | integer, foreign key | External Identity Identifier that was the source for this Identifier | identifiers:id | ||
| frozen | boolean | Whether or not Pipeline processing will update this record |
|