Table | urls |
|---|---|
Description | URLs for an Entity |
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 | |
| person_role_id | integer, foreign key | Person Role ID | person_roles:id | Exactly one entity foreign key is required | |
| external_identity_id | integer, foreign key | External Identity ID | external_identities:id | Exactly one entity foreign key is required | |
| external_identity_role_id | integer, foreign key | External Identity Role ID | external_identity_roles:id | Exactly one entity foreign key is required | |
| url | varchar(256) | Attribute Tag | | ||
| description | varchar(128) | Attribute Value | |||
| type | integer, foreign key | Type of this URL | types:id | | |
| source_url_id | integer, foreign key | External Identity URL that was the source for this URL | urls:id | ||
| frozen | boolean | Whether or not Pipeline processing will update this record |
|