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

AffiliationsDescribes affiliations of people with organizations.

PKNameData TypeNULLsA/NDefaultCommentFK

AffiliationIDInteger

Primay key identifier
PersonIDInteger Foreign key identifer for a person

OrganizationIDInteger

Foreigh key identifier for an organization

IsPrimaryOrganizationContactBoolean

Boolean indication of whether the person is the organizations primary contact person
AffiliationStartDateDate The date on which the person became affiliated with the organization
AffiliationEndDateDate

The date on which the person's affiliation with the organization ended
PrimaryPhoneVarChar(50)

The primary phone number of the person
PrimaryEmailVarChar(255) The primary email address of the person
PrimaryAddressVarChar(255)

The primary mailing address of the person, including street, city, state, zip, and country
PersonLinkVarChar(255)

A URL for the website for a person


NameParent TableChild TableParent ColumnsChild Columns
fk_Affiliations_OrganizationsODM2Core.OrganizationsODM2Core.AffiliationsOrganizationIDOrganizationID
fk_Affiliations_PeopleODM2Core.PeopleODM2Core.AffiliationsPersonIDPersonID

NameParent TableChild TableParent ColumnsChild Columns
fk_ActionPeople_AffiliationsODM2Core.AffiliationsODM2Core.ActionByAffiliationIDAffiliationID
fk_DataloggerProgramFiles_AffiliationsODM2Core.AffiliationsODM2Equipment.DataloggerProgramFilesAffiliationIDAffiliationID
fk_ModelAffiliations_AffiliationsODM2Core.AffiliationsODM2Simulation.ModelAffiliationsAffiliationIDAffiliationID

Diagram Name
ODM2Core
ODM2OverviewSimplified
ODM2Simulation