ODMX [ODMX_DBWrench_Schema.xml]
Describes affiliations of people with organizations.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| AffiliationID | Integer |
| nextval('"ODMXCore"."Affiliations_AffiliationID_seq"'::regclass) | Primay key identifier | ||
| PersonID | Integer | Foreign key identifer for a person |
|
||||
| OrganizationID | Integer |
| Foreigh key identifier for an organization |
|
|||
| IsPrimaryOrganizationContact | Boolean |
| Boolean indication of whether the person is the organizations primary contact person | ||||
| AffiliationStartDate | Date |
| The date on which the person became affiliated with the organization | ||||
| AffiliationEndDate | Date |
| The date on which the person's affiliation with the organization ended | ||||
| Phone | VarChar() |
| The primary phone number of the person | ||||
| VarChar() |
| The primary email address of the person | |||||
| Address | VarChar() |
| The primary mailing address of the person, including street, city, state, zip, and country | ||||
| City | VarChar() |
| |||||
| StateProvince | VarChar() |
| |||||
| PostalCode | VarChar() |
| |||||
| Country | VarChar() |
| |||||
| PersonLink | VarChar() |
| A URL for the website for a person | ||||
| JobTitle | VarChar() |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Affiliations_Organizations | ODMXCore.Organizations | ODMXCore.Affiliations | OrganizationID | OrganizationID |
| fk_Affiliations_People | ODMXCore.Persons | ODMXCore.Affiliations | PersonID | PersonID |
(none)
| Diagram Name |
| ODMXCore |
| ODMXOverviewSimplified |
| ODMXSimulation |