ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

ActionBy

Affiliates people with actions and describes thier role in the action.

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	BridgeID	Integer				Primary key for a bridge table, enabling many-to-many joins.
	ActionID	Integer				Foreign key identifier of an action.
	AffiliationID	Integer				Foreign key identifier of a person
	IsActionLead	Boolean				Indicator of whether the affiliated person was the lead for the action
	RoleDescription	VarChar(5000)				Foreign key identifier for a role played by a person in performing an action

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ActionPeople_Actions	ODM2Core.Actions	ODM2Core.ActionBy	ActionID	ActionID
fk_ActionPeople_Affiliations	ODM2Core.Affiliations	ODM2Core.ActionBy	AffiliationID	AffiliationID

Parent Relations (none)

Used in Diagrams

Diagram Name

ODM2Core

ODM2OverviewSimplified

ODM2Simulation