Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('record_contributors_id_seq'::regclass) |
|
|
||||
| record_id | int4 | 10 | null |
|
|
|||||
| name_entity_id | int4 | 10 | null |
|
|
|||||
| contributor_type | text | 2147483647 | √ | null |
|
|
||||
| created_at | timestamp | 29,6 | now() |
|
|
|||||
| updated_at | timestamp | 29,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| record_contributors_pkey | Primary key | Asc | id |
| record_contributors_record_id_name_id_key | Must be unique | Asc/Asc | record_id + name_entity_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| record_contributors_contributor_type_check | ((contributor_type = ANY (ARRAY['ContactPerson'::text, 'DataCollector'::text, 'DataCurator'::text, 'DataManager'::text, 'Distributor'::text, 'Editor'::text, 'HostingInstitution'::text, 'Producer'::text, 'ProjectLeader'::text, 'ProjectManager'::text, 'ProjectMember'::text, 'RegistrationAgency'::text, 'RegistrationAuthority'::text, 'RelatedPerson'::text, 'Researcher'::text, 'ResearchGroup'::text, 'RightsHolder'::text, 'Sponsor'::text, 'Supervisor'::text, 'WorkPackageLeader'::text, 'Other'::text]))) |
Relationships
Close relationships within degrees of separation
