| "INSTR_SHIFT_SUMM to INSTR_DOWNTIME_ACCT" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ISA_TO_INSTR_SHIFT_SUMM |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR_SHIFT_SUMM |
| Child Table | INSTR_DOWNTIME_ACCT |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR_SHIFT_SUMM to INSTR_DOWNTIME_ACCT" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR_SHIFT_SUMM to INSTR_DOWNTIME_ACCT" Foreign Keys |
| Parent Key | Child Key |
| SHIFT_ID, FACIL_ID, CAL_DTE | SHIFT_ID, FACIL_ID, CAL_DTE |
| "INSTR_SHIFT_SUMM to INSTR_DOWNTIME_ACCT" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR_SHIFT_SUMM to INSTR_DOWNTIME_ACCT" Bound Attachments |
| Name | Current Value |
| "INSTR_SUP_ACT_STAT to INSTR_SUP_ACT" |
| RelationshipType | Non-Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ISA_TO_INSTR_SUP_ACT_STAT |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR_SUP_ACT_STAT |
| Child Table | INSTR_SUP_ACT |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR_SUP_ACT_STAT to INSTR_SUP_ACT" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR_SUP_ACT_STAT to INSTR_SUP_ACT" Foreign Keys |
| Parent Key | Child Key |
| STAT_ID | STAT_ID |
| "INSTR_SUP_ACT_STAT to INSTR_SUP_ACT" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR_SUP_ACT_STAT to INSTR_SUP_ACT" Bound Attachments |
| Name | Current Value |
| "OPER_GRP to INSTR_DOWNTIME_ACCT" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_ISA_TO_OPER_GRP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_GRP |
| Child Table | INSTR_DOWNTIME_ACCT |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | YES |
| "OPER_GRP to INSTR_DOWNTIME_ACCT" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_GRP to INSTR_DOWNTIME_ACCT" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID | OPER_GRP_ID |
| "OPER_GRP to INSTR_DOWNTIME_ACCT" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_GRP to INSTR_DOWNTIME_ACCT" Bound Attachments |
| Name | Current Value |
| "TEXT_MSG_NOTIF to TEXT_MSG_NOTIF_SENT" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_NOTIF_ID_TO_TEXT_MSG_NOTIF |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | TEXT_MSG_NOTIF |
| Child Table | TEXT_MSG_NOTIF_SENT |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "TEXT_MSG_NOTIF to TEXT_MSG_NOTIF_SENT" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "TEXT_MSG_NOTIF to TEXT_MSG_NOTIF_SENT" Foreign Keys |
| Parent Key | Child Key |
| NOTIF_ID | NOTIF_ID |
| "TEXT_MSG_NOTIF to TEXT_MSG_NOTIF_SENT" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "TEXT_MSG_NOTIF to TEXT_MSG_NOTIF_SENT" Bound Attachments |
| Name | Current Value |
| "NS_OPER_ROLE to NS_OPER_ROLE_USR_ASSC" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_NS_OPER_ROLE_PRP_ASSC |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | NS_OPER_ROLE |
| Child Table | NS_OPER_ROLE_USR_ASSC |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "NS_OPER_ROLE to NS_OPER_ROLE_USR_ASSC" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "NS_OPER_ROLE to NS_OPER_ROLE_USR_ASSC" Foreign Keys |
| Parent Key | Child Key |
| ROLE_ID | ROLE_ID |
| "NS_OPER_ROLE to NS_OPER_ROLE_USR_ASSC" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "NS_OPER_ROLE to NS_OPER_ROLE_USR_ASSC" Bound Attachments |
| Name | Current Value |
| "NSSD_AREA to NSSD_AREA_ROLE_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_NSSD_ASGN_AREA |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | NSSD_AREA |
| Child Table | NSSD_AREA_ROLE_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "NSSD_AREA to NSSD_AREA_ROLE_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "NSSD_AREA to NSSD_AREA_ROLE_ASGN" Foreign Keys |
| Parent Key | Child Key |
| AREA_ID | AREA_ID |
| "NSSD_AREA to NSSD_AREA_ROLE_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "NSSD_AREA to NSSD_AREA_ROLE_ASGN" Bound Attachments |
| Name | Current Value |
| "NSSD_AREA_ROLE to NSSD_AREA_ROLE_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_NSSD_ASGN_ROLE |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | NSSD_AREA_ROLE |
| Child Table | NSSD_AREA_ROLE_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "NSSD_AREA_ROLE to NSSD_AREA_ROLE_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "NSSD_AREA_ROLE to NSSD_AREA_ROLE_ASGN" Foreign Keys |
| Parent Key | Child Key |
| ROLE_ID | ROLE_ID |
| "NSSD_AREA_ROLE to NSSD_AREA_ROLE_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "NSSD_AREA_ROLE to NSSD_AREA_ROLE_ASGN" Bound Attachments |
| Name | Current Value |
| "OPER_GRP to OPER_SUBGRP1" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_OPER_SUBGRP1_OPER_GRP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_GRP |
| Child Table | OPER_SUBGRP1 |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_GRP to OPER_SUBGRP1" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_GRP to OPER_SUBGRP1" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID | OPER_GRP_ID |
| "OPER_GRP to OPER_SUBGRP1" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_GRP to OPER_SUBGRP1" Bound Attachments |
| Name | Current Value |
| "OPER_GRP to PERS_ROLE_OPER_GRP_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PRECA_TO_OPER_GRP |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_GRP |
| Child Table | PERS_ROLE_OPER_GRP_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_GRP to PERS_ROLE_OPER_GRP_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_GRP to PERS_ROLE_OPER_GRP_ASGN" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID | OPER_GRP_ID |
| "OPER_GRP to PERS_ROLE_OPER_GRP_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_GRP to PERS_ROLE_OPER_GRP_ASGN" Bound Attachments |
| Name | Current Value |
| "PERS_ROLES to PERS_ROLE_OPER_GRP_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PROGP_PERS_ROLES_BN |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERS_ROLES |
| Child Table | PERS_ROLE_OPER_GRP_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERS_ROLES to PERS_ROLE_OPER_GRP_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERS_ROLES to PERS_ROLE_OPER_GRP_ASGN" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "PERS_ROLES to PERS_ROLE_OPER_GRP_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERS_ROLES to PERS_ROLE_OPER_GRP_ASGN" Bound Attachments |
| Name | Current Value |
| "PERS_ROLES to PERS_ROLE_OPER_SUBGRP_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PROSA_PERS_ROLES_BN |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | PERS_ROLES |
| Child Table | PERS_ROLE_OPER_SUBGRP_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "PERS_ROLES to PERS_ROLE_OPER_SUBGRP_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "PERS_ROLES to PERS_ROLE_OPER_SUBGRP_ASGN" Foreign Keys |
| Parent Key | Child Key |
| BN | BN |
| "PERS_ROLES to PERS_ROLE_OPER_SUBGRP_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "PERS_ROLES to PERS_ROLE_OPER_SUBGRP_ASGN" Bound Attachments |
| Name | Current Value |
| "OPER_SUBGRP1 to PERS_ROLE_OPER_SUBGRP_ASGN" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_PROSG1_TO_OPER_SUBGRP1 |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | OPER_SUBGRP1 |
| Child Table | PERS_ROLE_OPER_SUBGRP_ASGN |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "OPER_SUBGRP1 to PERS_ROLE_OPER_SUBGRP_ASGN" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "OPER_SUBGRP1 to PERS_ROLE_OPER_SUBGRP_ASGN" Foreign Keys |
| Parent Key | Child Key |
| OPER_GRP_ID, OPER_SUBGRP1_ID | OPER_GRP_ID, OPER_SUBGRP1_ID |
| "OPER_SUBGRP1 to PERS_ROLE_OPER_SUBGRP_ASGN" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "OPER_SUBGRP1 to PERS_ROLE_OPER_SUBGRP_ASGN" Bound Attachments |
| Name | Current Value |
| "TEXT_MSG_NOTIF_REG to TEXT_MSG_NOTIF_SENT" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_REGID_TO_TEXT_MSG_NOTIF_REG |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | TEXT_MSG_NOTIF_REG |
| Child Table | TEXT_MSG_NOTIF_SENT |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "TEXT_MSG_NOTIF_REG to TEXT_MSG_NOTIF_SENT" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "TEXT_MSG_NOTIF_REG to TEXT_MSG_NOTIF_SENT" Foreign Keys |
| Parent Key | Child Key |
| REG_ID | REG_ID |
| "TEXT_MSG_NOTIF_REG to TEXT_MSG_NOTIF_SENT" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "TEXT_MSG_NOTIF_REG to TEXT_MSG_NOTIF_SENT" Bound Attachments |
| Name | Current Value |
| "INSTR_SHIFT_SUMM to SHIFT_INSTR_NOTE" |
| RelationshipType | Identifying |
| Do Not Generate | False |
| Relationship Name | FK_SIN_TO_INSTR_SHIFT_SUM |
| Relationship Business Name | |
| Physical Only | No |
| Parent Table | INSTR_SHIFT_SUMM |
| Child Table | SHIFT_INSTR_NOTE |
| Cardinality | One To Zero or More |
| Existence | Mandatory |
| Propagated Key | Primary Key |
| Deferrable | NO |
| Initially Deferred | NO |
| Disabled | NO |
| NoValidate | NO |
| "INSTR_SHIFT_SUMM to SHIFT_INSTR_NOTE" Relationship Description |
| Verb Sentence | |
| Inverse Verb Sentence | |
| Definition | |
| Note |
| "INSTR_SHIFT_SUMM to SHIFT_INSTR_NOTE" Foreign Keys |
| Parent Key | Child Key |
| SHIFT_ID, FACIL_ID, CAL_DTE | SHIFT_ID, FACIL_ID, CAL_DTE |
| "INSTR_SHIFT_SUMM to SHIFT_INSTR_NOTE" Trigger Templates |
| ParentInsert | None |
| ParentUpdate | None |
| ParentDelete | None |
| ChildInsert | None |
| ChildUpdate | None |
| ChildDelete | None |
| "INSTR_SHIFT_SUMM to SHIFT_INSTR_NOTE" Bound Attachments |
| Name | Current Value |