"DIALOG to DIALOG" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_DIALOG_TO_DIALOG |
Relationship Business Name | |
Physical Only | No |
Parent Table | DIALOG |
Child Table | DIALOG |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DIALOG to DIALOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DIALOG to DIALOG" Foreign Keys |
Parent Key | Child Key |
DIALOG_ID | PREV_DIALOG_ID |
"DIALOG to DIALOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DIALOG to DIALOG" Bound Attachments |
Name | Current Value |
"DIALOG_TYPE to DIALOG" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_DIALOG_TO_DIALOG_TYPE |
Relationship Business Name | |
Physical Only | No |
Parent Table | DIALOG_TYPE |
Child Table | DIALOG |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DIALOG_TYPE to DIALOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DIALOG_TYPE to DIALOG" Foreign Keys |
Parent Key | Child Key |
DIALOG_TYPE_ID | DIALOG_TYPE_ID |
"DIALOG_TYPE to DIALOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DIALOG_TYPE to DIALOG" Bound Attachments |
Name | Current Value |
"EMPLOYEE to DIALOG" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_DIALOG_TO_EMP |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | DIALOG |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to DIALOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to DIALOG" Foreign Keys |
Parent Key | Child Key |
BN | BN |
"EMPLOYEE to DIALOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to DIALOG" Bound Attachments |
Name | Current Value |
"EVENT to DIALOG" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_DIALOG_TO_EVENT |
Relationship Business Name | |
Physical Only | No |
Parent Table | EVENT |
Child Table | DIALOG |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EVENT to DIALOG" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EVENT to DIALOG" Foreign Keys |
Parent Key | Child Key |
EVENT_ID | EVENT_ID |
"EVENT to DIALOG" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EVENT to DIALOG" Bound Attachments |
Name | Current Value |
"DIALOG to DIALOG_PART_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_DPA_TO_DIALOG |
Relationship Business Name | |
Physical Only | No |
Parent Table | DIALOG |
Child Table | DIALOG_PART_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DIALOG to DIALOG_PART_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DIALOG to DIALOG_PART_ASSC" Foreign Keys |
Parent Key | Child Key |
DIALOG_ID | DIALOG_ID |
"DIALOG to DIALOG_PART_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DIALOG to DIALOG_PART_ASSC" Bound Attachments |
Name | Current Value |
"PARTICIPANT to DIALOG_PART_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_DPA_TO_PART |
Relationship Business Name | |
Physical Only | No |
Parent Table | PARTICIPANT |
Child Table | DIALOG_PART_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PARTICIPANT to DIALOG_PART_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PARTICIPANT to DIALOG_PART_ASSC" Foreign Keys |
Parent Key | Child Key |
PART_ID | PART_ID |
"PARTICIPANT to DIALOG_PART_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PARTICIPANT to DIALOG_PART_ASSC" Bound Attachments |
Name | Current Value |
"EVENT to EVENT_PART_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EPA_TO_EVENT |
Relationship Business Name | |
Physical Only | No |
Parent Table | EVENT |
Child Table | EVENT_PART_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EVENT to EVENT_PART_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EVENT to EVENT_PART_ASSC" Foreign Keys |
Parent Key | Child Key |
EVENT_ID | EVENT_ID |
"EVENT to EVENT_PART_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EVENT to EVENT_PART_ASSC" Bound Attachments |
Name | Current Value |
"PARTICIPANT to EVENT_PART_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_EPA_TO_PART |
Relationship Business Name | |
Physical Only | No |
Parent Table | PARTICIPANT |
Child Table | EVENT_PART_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PARTICIPANT to EVENT_PART_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PARTICIPANT to EVENT_PART_ASSC" Foreign Keys |
Parent Key | Child Key |
PART_ID | PART_ID |
"PARTICIPANT to EVENT_PART_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PARTICIPANT to EVENT_PART_ASSC" Bound Attachments |
Name | Current Value |
"PART_TYPE to EVENT_PART_ASSC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_EPA_TO_PART_TYPE |
Relationship Business Name | |
Physical Only | No |
Parent Table | PART_TYPE |
Child Table | EVENT_PART_ASSC |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PART_TYPE to EVENT_PART_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PART_TYPE to EVENT_PART_ASSC" Foreign Keys |
Parent Key | Child Key |
PART_TYPE_ID | PART_TYPE_ID |
"PART_TYPE to EVENT_PART_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PART_TYPE to EVENT_PART_ASSC" Bound Attachments |
Name | Current Value |
"EVENT_TYPE to EVENT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_EVENT_TO_EVENT_TYPE |
Relationship Business Name | |
Physical Only | No |
Parent Table | EVENT_TYPE |
Child Table | EVENT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EVENT_TYPE to EVENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EVENT_TYPE to EVENT" Foreign Keys |
Parent Key | Child Key |
EVENT_TYPE_ID | EVENT_TYPE_ID |
"EVENT_TYPE to EVENT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EVENT_TYPE to EVENT" Bound Attachments |
Name | Current Value |
"INST to EVENT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_EVENT_TO_INST |
Relationship Business Name | |
Physical Only | No |
Parent Table | INST |
Child Table | EVENT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INST to EVENT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INST to EVENT" Foreign Keys |
Parent Key | Child Key |
INST_ID | HOST_INST |
"INST to EVENT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INST to EVENT" Bound Attachments |
Name | Current Value |
"INST to INST_NM_ALIAS" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_INST_NM_ALIAS_TO_INST |
Relationship Business Name | |
Physical Only | No |
Parent Table | INST |
Child Table | INST_NM_ALIAS |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INST to INST_NM_ALIAS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INST to INST_NM_ALIAS" Foreign Keys |
Parent Key | Child Key |
INST_ID | INST_ID |
"INST to INST_NM_ALIAS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INST to INST_NM_ALIAS" Bound Attachments |
Name | Current Value |
"INST to PART_INST_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PART_INST_ASSC_TO_INST |
Relationship Business Name | |
Physical Only | No |
Parent Table | INST |
Child Table | PART_INST_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INST to PART_INST_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INST to PART_INST_ASSC" Foreign Keys |
Parent Key | Child Key |
INST_ID | INST_ID |
"INST to PART_INST_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INST to PART_INST_ASSC" Bound Attachments |
Name | Current Value |
"PARTICIPANT to PART_INST_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_PART_INST_ASSC_TO_PART |
Relationship Business Name | |
Physical Only | No |
Parent Table | PARTICIPANT |
Child Table | PART_INST_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PARTICIPANT to PART_INST_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PARTICIPANT to PART_INST_ASSC" Foreign Keys |
Parent Key | Child Key |
PART_ID | PART_ID |
"PARTICIPANT to PART_INST_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PARTICIPANT to PART_INST_ASSC" Bound Attachments |
Name | Current Value |
"INST_ROLE to PART_INST_ASSC" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PART_INST_ASSC_TO_ROLE |
Relationship Business Name | |
Physical Only | No |
Parent Table | INST_ROLE |
Child Table | PART_INST_ASSC |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INST_ROLE to PART_INST_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INST_ROLE to PART_INST_ASSC" Foreign Keys |
Parent Key | Child Key |
ROLE_ID | ROLE_ID |
"INST_ROLE to PART_INST_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INST_ROLE to PART_INST_ASSC" Bound Attachments |
Name | Current Value |
"PERSON to PARTICIPANT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PART_TO_PERSON |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERSON |
Child Table | PARTICIPANT |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERSON to PARTICIPANT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERSON to PARTICIPANT" Foreign Keys |
Parent Key | Child Key |
PERSON_ID | PERSON_ID |
"PERSON to PARTICIPANT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERSON to PARTICIPANT" Bound Attachments |
Name | Current Value |
"INST to PERSON" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_PERSON_TO_INST |
Relationship Business Name | |
Physical Only | No |
Parent Table | INST |
Child Table | PERSON |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INST to PERSON" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INST to PERSON" Foreign Keys |
Parent Key | Child Key |
INST_ID | INST_ID |
"INST to PERSON" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INST to PERSON" Bound Attachments |
Name | Current Value |