ODMX [ODMX_DBWrench_Schema.xml]
Affiliates people with actions and describes thier role in the action.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| BridgeID | Integer |
| nextval('"ODMXCore"."ActionBy_BridgeID_seq"'::regclass) | 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() |
| Foreign key identifier for a role played by a person in performing an action |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_ActionPeople_Actions | ODMXCore.Actions | ODMXCore.ActionBy | ActionID | ActionID |
| fk_ActionPeople_Affiliations | ODMXCore.Affiliations | ODMXCore.ActionBy | AffiliationID | AffiliationID |
(none)
| Diagram Name |
| ODMXCore |
| ODMXOverviewSimplified |
| ODMXSimulation |