"OPER_PROC_MAN to OPER_PROC_MAN_REV" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Physical Only | No |
Parent Table | OPER_PROC_MAN |
Child Table | OPER_PROC_MAN_REV |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"OPER_PROC_MAN to OPER_PROC_MAN_REV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER_PROC_MAN to OPER_PROC_MAN_REV" Foreign Keys |
Parent Key | Child Key |
OPER_PROC_MAN_ID | OPER_PROC_MAN_ID |
"OPER_PROC_MAN to OPER_PROC_MAN_REV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER_PROC_MAN to OPER_PROC_MAN_REV" 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 |
"EMPLOYEE to OPM_AUTHOR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_opm_auth_assc_to_emp |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | OPM_AUTHOR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to OPM_AUTHOR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to OPM_AUTHOR_ASSC" Foreign Keys |
Parent Key | Child Key |
BN | BN |
"EMPLOYEE to OPM_AUTHOR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to OPM_AUTHOR_ASSC" Bound Attachments |
Name | Current Value |
"OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_opm_auth_assc_to_opm_rev |
Relationship Business Name | |
Physical Only | No |
Parent Table | OPER_PROC_MAN_REV |
Child Table | OPM_AUTHOR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" Foreign Keys |
Parent Key | Child Key |
OPER_PROC_MAN_ID, REV_NBR | OPER_PROC_MAN_ID, REV_NBR |
"OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER_PROC_MAN_REV to OPM_AUTHOR_ASSC" Bound Attachments |
Name | Current Value |
"OPER_PROC_MAN_REV to OPM_CHAP" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_opm_chap_to_opm_rev |
Relationship Business Name | |
Physical Only | No |
Parent Table | OPER_PROC_MAN_REV |
Child Table | OPM_CHAP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"OPER_PROC_MAN_REV to OPM_CHAP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER_PROC_MAN_REV to OPM_CHAP" Foreign Keys |
Parent Key | Child Key |
OPER_PROC_MAN_ID, REV_NBR | OPER_PROC_MAN_ID, REV_NBR |
"OPER_PROC_MAN_REV to OPM_CHAP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER_PROC_MAN_REV to OPM_CHAP" Bound Attachments |
Name | Current Value |
"OPER_GRP to OPM_GRP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_opm_grp_to_oper_grp |
Relationship Business Name | |
Physical Only | No |
Parent Table | OPER_GRP |
Child Table | OPM_GRP |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"OPER_GRP to OPM_GRP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER_GRP to OPM_GRP" Foreign Keys |
Parent Key | Child Key |
OPER_GRP_ID | OPER_GRP_ID |
"OPER_GRP to OPM_GRP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER_GRP to OPM_GRP" Bound Attachments |
Name | Current Value |
"OPER_SUBGRP1 to OPM_GRP" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_opm_grp_to_oper_subgrp1 |
Relationship Business Name | |
Physical Only | No |
Parent Table | OPER_SUBGRP1 |
Child Table | OPM_GRP |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"OPER_SUBGRP1 to OPM_GRP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER_SUBGRP1 to OPM_GRP" Foreign Keys |
Parent Key | Child Key |
OPER_GRP_ID, OPER_SUBGRP1_ID | OPER_GRP_ID, OPER_SUBGRP1_ID |
"OPER_SUBGRP1 to OPM_GRP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER_SUBGRP1 to OPM_GRP" Bound Attachments |
Name | Current Value |
"OPM_GRP to OPER_PROC_MAN" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_opm_grp_to_opm |
Relationship Business Name | |
Physical Only | No |
Parent Table | OPM_GRP |
Child Table | OPER_PROC_MAN |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"OPM_GRP to OPER_PROC_MAN" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPM_GRP to OPER_PROC_MAN" Foreign Keys |
Parent Key | Child Key |
GRP_ID | GRP_ID |
"OPM_GRP to OPER_PROC_MAN" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPM_GRP to OPER_PROC_MAN" Bound Attachments |
Name | Current Value |
"EMPLOYEE to OPM_REVIEWER_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_opm_rev_assc_to_emp |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | OPM_REVIEWER_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to OPM_REVIEWER_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to OPM_REVIEWER_ASSC" Foreign Keys |
Parent Key | Child Key |
BN | BN |
"EMPLOYEE to OPM_REVIEWER_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to OPM_REVIEWER_ASSC" Bound Attachments |
Name | Current Value |
"OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_opm_rev_assc_to_opm_rev |
Relationship Business Name | |
Physical Only | No |
Parent Table | OPER_PROC_MAN_REV |
Child Table | OPM_REVIEWER_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" Foreign Keys |
Parent Key | Child Key |
OPER_PROC_MAN_ID, REV_NBR | OPER_PROC_MAN_ID, REV_NBR |
"OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPER_PROC_MAN_REV to OPM_REVIEWER_ASSC" Bound Attachments |
Name | Current Value |
"OPM_REVIEW_STAT to OPER_PROC_MAN_REV" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_opm_to_opm_rev_stat |
Relationship Business Name | |
Physical Only | No |
Parent Table | OPM_REVIEW_STAT |
Child Table | OPER_PROC_MAN_REV |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"OPM_REVIEW_STAT to OPER_PROC_MAN_REV" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"OPM_REVIEW_STAT to OPER_PROC_MAN_REV" Foreign Keys |
Parent Key | Child Key |
REVIEW_STAT_ID | REVIEW_STAT_ID |
"OPM_REVIEW_STAT to OPER_PROC_MAN_REV" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"OPM_REVIEW_STAT to OPER_PROC_MAN_REV" Bound Attachments |
Name | Current Value |
"JOB_TITLE to PERS_ROLES" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_pers_role_to_job_title |
Relationship Business Name | |
Physical Only | No |
Parent Table | JOB_TITLE |
Child Table | PERS_ROLES |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"JOB_TITLE to PERS_ROLES" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"JOB_TITLE to PERS_ROLES" Foreign Keys |
Parent Key | Child Key |
JOB_TITLE_ID | JOB_TITLE_ID |
"JOB_TITLE to PERS_ROLES" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"JOB_TITLE to PERS_ROLES" Bound Attachments |
Name | Current Value |