Table | cm_urls |
|---|---|
Description | URLs |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
|
url | varchar(256) | URL |
| |
| description | varchar(128) | Description | ||
type | varchar(32) | Type of url, as enumerated |
| When attached to a CO Person, types may be configured on a per-CO basis. See Extending the Registry Data Model. |
co_person_id | integer, foreign key | CO Person Record ID | cm_co_people:id | Only one of |
org_identity_id | integer, foreign key | Org Identity Record ID | Only one of | |
| co_department_id | integer, foreign key | CO Department Record ID | cm_co_departments:id | Only one of co_person_id, org_identity_id, or co_department_id may be specified |
| source_url_id | integer, foreign key | If Pipelines are in use, the URL ID for the Org Identity URL that created this record. | cm_urls:id |