ODM2 [ODM2_DBWrench_Schema.xml] |
Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
Affiliations | Describes affiliations of people with organizations. |
Columns | |||||||
PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
| AffiliationID | Integer |
| 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 | ||||
PrimaryPhone | VarChar(50) |
| The primary phone number of the person | ||||
PrimaryEmail | VarChar(255) | The primary email address of the person | |||||
PrimaryAddress | VarChar(255) |
| The primary mailing address of the person, including street, city, state, zip, and country | ||||
PersonLink | VarChar(255) |
| A URL for the website for a person |
Indexes (none) |
Foreign Keys | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_Affiliations_Organizations | ODM2Core.Organizations | ODM2Core.Affiliations | OrganizationID | OrganizationID |
fk_Affiliations_People | ODM2Core.People | ODM2Core.Affiliations | PersonID | PersonID |
Parent Relations | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_ActionPeople_Affiliations | ODM2Core.Affiliations | ODM2Core.ActionBy | AffiliationID | AffiliationID |
fk_DataloggerProgramFiles_Affiliations | ODM2Core.Affiliations | ODM2Equipment.DataloggerProgramFiles | AffiliationID | AffiliationID |
fk_ModelAffiliations_Affiliations | ODM2Core.Affiliations | ODM2Simulation.ModelAffiliations | AffiliationID | AffiliationID |
Used in Diagrams |
Diagram Name |
ODM2Core |
ODM2OverviewSimplified |
ODM2Simulation |