Columns
| Column | Type | Size | Nulls | Auto | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|
| data_provider_id | int4 | 10 |
|
|
Identifies the data provider. |
|||||
| data_provider_code | text | 2147483647 | √ |
|
|
Optional code used to identify the data provider in an external or local system. |
||||
| data_provider_uuid | uuid | 2147483647 |
|
|
Unique UUID generated for the data provider. |
|||||
| data_provider_name | text | 2147483647 |
|
|
Name of the organization or individual that provides data. |
|||||
| notes | text | 2147483647 | √ |
|
|
Additional information about the data provider. |
||||
| contact_id | int4 | 10 | √ |
|
|
Identifies the contact person associated with the data provider. |
||||
| biblio_id | int4 | 10 | √ |
|
|
Identifies the bibliography entry associated with the data provider. |
||||
| url | text | 2147483647 | √ |
|
|
Web address for the data provider. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_data_providers_pkey | Primary key | Asc | data_provider_id |
| tbl_data_providers_data_provider_code_key | Must be unique | Asc | data_provider_code |
| tbl_data_providers_data_provider_name_key | Must be unique | Asc | data_provider_name |
| tbl_data_providers_data_provider_uuid_key | Must be unique | Asc | data_provider_uuid |
Relationships
Close relationships within degrees of separation
