external_identifier_system

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
external_identifier_system_num serial 10 √ nextval('external_identifier_system_external_identifier_system_num_seq'::regclass)
action_external_identifier.external_identifier_system_num action_external_identifier_external_identifier_system_num_fkeyR
citation_external_identifier.external_identifier_system_num fk_citation_external_identifier_external_identifierR
d_citation_external_identifier.external_identifier_system_num Implied ConstraintR
dataset_external_identifier.external_identifier_system_num fk_dataset_external_identifier_external_identifierR
person_external_identifier.external_identifier_system_num fk_person_external_identifier_external_identifierR
sampling_feature_external_identifier.external_identifier_system_num sampling_feature_external_ide_external_identifier_system_n_fkeyR
taxonomic_classifier_external_identifer.external_identifier_system_num fk_taxonomic_classifier_external_identifer_external_identifierR
external_identifier_system_name varchar 256 null

ORCID, DOI, IGSN
external_identifier_system_organization_num int4 10 null
organization.organization_num Implied ConstraintR
external_identifier_system_description varchar 2000 √ null
external_identifier_system_url varchar 2000 √ null

Indexes

Constraint Name Type Sort Column(s)
external_identifier_system_pkey Primary key Asc external_identifier_system_num
uc_external_identifier_system Must be unique Asc/Asc external_identifier_system_name + external_identifier_system_organization_num

Relationships

Close relationships within degrees of separation