Organizations - Table
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

OrganizationsDescribes organizations - as in research groups, companies, universiti...

PKNameData TypeNULLsA/NDefaultCommentFK

OrganizationIDInteger

Primary key identifier
OrganizationTypeCVVarChar(255) CV term defining the type of organization (e.g., government agency, university, etc.)

OrganizationCodeVarChar(50) A text code identifying the Organization (e.g., USGS)
OrganizationNameVarChar(255) The full text name of the organization
OrganizationDescriptionVarChar(5000)

A text description of the organization
OrganizationLinkVarChar(255)

A URL for the organization's website
ParentOrganizationIDInteger

Foreign key of the parent organization of the current organization



NameParent TableChild TableParent ColumnsChild Columns
fk_Organizations_CV_OrganizationTypeODM2CV.CV_OrganizationTypeODM2Core.OrganizationsNameOrganizationTypeCV
fk_Organizations_OrganizationsODM2Core.OrganizationsODM2Core.OrganizationsOrganizationIDParentOrganizationID

NameParent TableChild TableParent ColumnsChild Columns
fk_Affiliations_OrganizationsODM2Core.OrganizationsODM2Core.AffiliationsOrganizationIDOrganizationID
fk_Methods_OrganizationsODM2Core.OrganizationsODM2Core.MethodsOrganizationIDOrganizationID
fk_Organizations_OrganizationsODM2Core.OrganizationsODM2Core.OrganizationsOrganizationIDParentOrganizationID
fk_ReferenceMaterials_OrganizationsODM2Core.OrganizationsODM2DataQuality.ReferenceMaterialsOrganizationIDReferenceMaterialOrganizationID
fk_Equipment_OrganizationsODM2Core.OrganizationsODM2Equipment.EquipmentOrganizationIDEquipmentVendorID
fk_EquipmentModels_OrganizationsODM2Core.OrganizationsODM2Equipment.EquipmentModelsOrganizationIDModelManufacturerID
fk_ExternalIdentifierSystems_OrganizationsODM2Core.OrganizationsODM2ExternalIdentifiers.ExternalIdentifierSystemsOrganizationIDIdentifierSystemOrganizationID

Diagram Name
ODM2Core
ODM2OverviewSimplified
ODM2Simulation