Table mob_odm2.odm2.externalidentifiersystems Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
externalidentifiersystemid serial 10  √  nextval('odm2.externalidentifiersystems_externalidentifiersystemid_seq'::regclass)
citationexternalidentifiers.externalidentifiersystemid fk_citationexternalidentifiers_externalidentifiersystems C
methodexternalidentifiers.externalidentifiersystemid fk_methodexternalidentifiers_externalidentifiersystems C
personexternalidentifiers.externalidentifiersystemid fk_personexternalidentifiers_externalidentifiersystems C
referencematerialexternalidentifiers.externalidentifiersystemid fk_refmaterialextidentifiers_extidentifiersystems C
samplingfeatureexternalidentifiers.externalidentifiersystemid fk_samplingfeatureexternalidentifiers_externalidentifiersystems C
spatialreferenceexternalidentifiers.externalidentifiersystemid fk_spatialreferenceexternalidentifiers_externalidentifiersystem C
taxonomicclassifierexternalidentifiers.externalidentifiersystemid fk_taxonomicclassifierextids_extidsystems C
variableexternalidentifiers.externalidentifiersystemid fk_variableexternalidentifiers_externalidentifiersystems C
externalidentifiersystemname varchar 255
identifiersystemorganizationid int4 10
organizations.organizationid fk_externalidentifiersystems_organizations C
externalidentifiersystemdescription varchar 5000  √  null
externalidentifiersystemurl varchar 255  √  null

Table contained 0 rows at Fri Mar 08 15:58 PST 2019

Indexes:
Column(s) Type Sort Constraint Name
externalidentifiersystemid Primary key Asc externalidentifiersystems_pkey

Close relationships  within of separation: