Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| bridge_num | serial | 10 | √ | nextval('citation_external_identifier_bridge_num_seq'::regclass) |
|
|
||||
| citation_num | int4 | 10 | null |
|
|
|||||
| external_identifier_system_num | int4 | 10 | null |
|
|
|||||
| citation_external_identifier | varchar | 2000 | null |
|
|
Such as DOI without URI:10.1016/0040-1951(88)90298-3 |
||||
| citation_external_identifier_uri | varchar | 2000 | √ | null |
|
|
10.1016/0040-1951(88)90298-3 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| citation_external_identifier_pkey | Primary key | Asc | bridge_num |
| uc_citation_num_external_identifier_system_num_citation_externa | Must be unique | Asc/Asc/Asc | citation_num + external_identifier_system_num + citation_external_identifier |
Relationships
Close relationships within degrees of separation
