Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| bridge_num | serial | 10 | √ | nextval('person_external_identifier_bridge_num_seq'::regclass) |
|
|
||||
| person_num | int4 | 10 | null |
|
|
|||||
| person_external_identifier | varchar | 256 | null |
|
|
|||||
| person_external_identifier_uri | varchar | 2000 | √ | null |
|
|
||||
| external_identifier_system_num | int4 | 10 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| person_external_identifier_pkey | Primary key | Asc | bridge_num |
| uc_person_external_identifier | Must be unique | Asc/Asc/Asc | person_num + person_external_identifier + external_identifier_system_num |
Relationships
Close relationships within degrees of separation
