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

Triggers (none)

Used in Diagrams

Diagram Name

ODM2Core

ODM2OverviewSimplified

ODM2Simulation