"ICS_SFTW_APPL_ACCESS to ICS_SFTW_APPL_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SFTW_ACC_ASSC_USER_ACC |
Relationship Business Name | |
Physical Only | No |
Parent Table | ICS_SFTW_APPL_ACCESS |
Child Table | ICS_SFTW_APPL_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"ICS_SFTW_APPL_ACCESS to ICS_SFTW_APPL_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ICS_SFTW_APPL_ACCESS to ICS_SFTW_APPL_ASSC" Foreign Keys |
Parent Key | Child Key |
ACCESS_ID | ACCESS_ID |
"ICS_SFTW_APPL_ACCESS to ICS_SFTW_APPL_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"ICS_SFTW_APPL_ACCESS to ICS_SFTW_APPL_ASSC" Bound Attachments |
Name | Current Value |
"ICS_APPL_SFTW to ICS_SFTW_APPL_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SFTW_ACCESS_ASSC_SFTW_APPL |
Relationship Business Name | |
Physical Only | No |
Parent Table | ICS_APPL_SFTW |
Child Table | ICS_SFTW_APPL_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"ICS_APPL_SFTW to ICS_SFTW_APPL_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ICS_APPL_SFTW to ICS_SFTW_APPL_ASSC" Foreign Keys |
Parent Key | Child Key |
APPL_NM | APPL_NM |
"ICS_APPL_SFTW to ICS_SFTW_APPL_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"ICS_APPL_SFTW to ICS_SFTW_APPL_ASSC" Bound Attachments |
Name | Current Value |
"ICS_DATA_REPOS to ICS_APPL_SFTW" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SFTW_APPL_DATA_INPUT |
Relationship Business Name | |
Physical Only | No |
Parent Table | ICS_DATA_REPOS |
Child Table | ICS_APPL_SFTW |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"ICS_DATA_REPOS to ICS_APPL_SFTW" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ICS_DATA_REPOS to ICS_APPL_SFTW" Foreign Keys |
Parent Key | Child Key |
REPOS_ID | DATA_INPUT_REPOS_ID |
"ICS_DATA_REPOS to ICS_APPL_SFTW" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"ICS_DATA_REPOS to ICS_APPL_SFTW" Bound Attachments |
Name | Current Value |
"ICS_DATA_REPOS to ICS_APPL_SFTW" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SFTW_APPL_DATA_OUTPUT |
Relationship Business Name | |
Physical Only | No |
Parent Table | ICS_DATA_REPOS |
Child Table | ICS_APPL_SFTW |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"ICS_DATA_REPOS to ICS_APPL_SFTW" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ICS_DATA_REPOS to ICS_APPL_SFTW" Foreign Keys |
Parent Key | Child Key |
REPOS_ID | DATA_OUPUT_REPOS_ID |
"ICS_DATA_REPOS to ICS_APPL_SFTW" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"ICS_DATA_REPOS to ICS_APPL_SFTW" Bound Attachments |
Name | Current Value |
"EMPLOYEE to ICS_APPL_SFTW" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SFTW_APPL_EMPLOYEE |
Relationship Business Name | |
Physical Only | No |
Parent Table | EMPLOYEE |
Child Table | ICS_APPL_SFTW |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"EMPLOYEE to ICS_APPL_SFTW" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"EMPLOYEE to ICS_APPL_SFTW" Foreign Keys |
Parent Key | Child Key |
BN | SFTW_MAINT_BN |
"EMPLOYEE to ICS_APPL_SFTW" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"EMPLOYEE to ICS_APPL_SFTW" Bound Attachments |
Name | Current Value |
"ICS_SRV to ICS_APPL_SFTW" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SFTW_APPL_SRV |
Relationship Business Name | |
Physical Only | No |
Parent Table | ICS_SRV |
Child Table | ICS_APPL_SFTW |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"ICS_SRV to ICS_APPL_SFTW" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ICS_SRV to ICS_APPL_SFTW" Foreign Keys |
Parent Key | Child Key |
SRV_NM | SRV_NM |
"ICS_SRV to ICS_APPL_SFTW" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"ICS_SRV to ICS_APPL_SFTW" Bound Attachments |
Name | Current Value |
"ICS_USER_INTFC to ICS_APPL_SFTW" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_SFTW_APPL_USER_INTFC |
Relationship Business Name | |
Physical Only | No |
Parent Table | ICS_USER_INTFC |
Child Table | ICS_APPL_SFTW |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"ICS_USER_INTFC to ICS_APPL_SFTW" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ICS_USER_INTFC to ICS_APPL_SFTW" Foreign Keys |
Parent Key | Child Key |
USER_INTFC_ID | USER_INTFC_ID |
"ICS_USER_INTFC to ICS_APPL_SFTW" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"ICS_USER_INTFC to ICS_APPL_SFTW" Bound Attachments |
Name | Current Value |
"ICS_APPL_SFTW to ICS_SFTW_APPL_LANG_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SFTW_ASSC_APPL |
Relationship Business Name | |
Physical Only | No |
Parent Table | ICS_APPL_SFTW |
Child Table | ICS_SFTW_APPL_LANG_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"ICS_APPL_SFTW to ICS_SFTW_APPL_LANG_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ICS_APPL_SFTW to ICS_SFTW_APPL_LANG_ASSC" Foreign Keys |
Parent Key | Child Key |
APPL_NM | APPL_NM |
"ICS_APPL_SFTW to ICS_SFTW_APPL_LANG_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"ICS_APPL_SFTW to ICS_SFTW_APPL_LANG_ASSC" Bound Attachments |
Name | Current Value |
"ICS_SFTW_LANG to ICS_SFTW_APPL_LANG_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_SFTW_ASSC_LANG |
Relationship Business Name | |
Physical Only | No |
Parent Table | ICS_SFTW_LANG |
Child Table | ICS_SFTW_APPL_LANG_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"ICS_SFTW_LANG to ICS_SFTW_APPL_LANG_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ICS_SFTW_LANG to ICS_SFTW_APPL_LANG_ASSC" Foreign Keys |
Parent Key | Child Key |
LANG_NM | LANG_NM |
"ICS_SFTW_LANG to ICS_SFTW_APPL_LANG_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"ICS_SFTW_LANG to ICS_SFTW_APPL_LANG_ASSC" Bound Attachments |
Name | Current Value |