ODMX [ODMX_DBWrench_Schema.xml]
Describes organizations - as in research groups, companies, universities, etc.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| OrganizationID | Integer |
| nextval('"ODMXCore"."Organizations_OrganizationID_seq"'::regclass) | Primary key identifier | ||
| OrganizationTypeCV | VarChar() | CV term defining the type of organization (e.g., government agency, university, etc.) |
|
||||
| OrganizationCode | VarChar() | A text code identifying the Organization (e.g., USGS) | |||||
| OrganizationName | VarChar() | The full text name of the organization | |||||
| OrganizationDescription | VarChar() |
| A text description of the organization | ||||
| OrganizationLink | VarChar() |
| A URL for the organization's website | ||||
| ParentOrganizationID | Integer |
| Foreign key of the parent organization of the current organization |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Organizations_CV_OrganizationType | ODMXCV.CV_OrganizationType | ODMXCore.Organizations | Term | OrganizationTypeCV |
| fk_Organizations_Organizations | ODMXCore.Organizations | ODMXCore.Organizations | OrganizationID | ParentOrganizationID |
(none)
| Name | Table | Columns |
| uc_OrganizationCode | ODMXCore.Organizations | OrganizationCode |
| Diagram Name |
| ODMXCore |
| ODMXOverviewSimplified |
| ODMXSimulation |