Table mob_odm2.odm2.organizations 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
organizationid serial 10  √  nextval('odm2.organizations_organizationid_seq'::regclass)
affiliations.organizationid fk_affiliations_organizations C
equipment.equipmentvendorid fk_equipment_organizations C
equipmentmodels.modelmanufacturerid fk_equipmentmodels_organizations C
externalidentifiersystems.identifiersystemorganizationid fk_externalidentifiersystems_organizations C
methods.organizationid fk_methods_organizations C
organizations.parentorganizationid fk_organizations_organizations C
referencematerials.referencematerialorganizationid fk_referencematerials_organizations C
organizationtypecv varchar 255
cv_organizationtype.name fk_organizations_cv_organizationtype C
organizationcode varchar 50
organizationname varchar 255
organizationdescription varchar 5000  √  null
organizationlink varchar 255  √  null
parentorganizationid int4 10  √  null
organizations.organizationid fk_organizations_organizations C

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

Indexes:
Column(s) Type Sort Constraint Name
organizationid Primary key Asc organizations_pkey
organizationcode Must be unique Asc organizations_organizationcode_key

Close relationships  within of separation: