"STUDY to KEYWORD_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059583 |
Relationship Business Name | |
Physical Only | No |
Parent Table | STUDY |
Child Table | KEYWORD_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"STUDY to KEYWORD_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"STUDY to KEYWORD_LIST" Foreign Keys |
Parent Key | Child Key |
ID | STUDY_ID |
"STUDY to KEYWORD_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"STUDY to KEYWORD_LIST" Bound Attachments |
Name | Current Value |
"KEYWORD to KEYWORD_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059584 |
Relationship Business Name | |
Physical Only | No |
Parent Table | KEYWORD |
Child Table | KEYWORD_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"KEYWORD to KEYWORD_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"KEYWORD to KEYWORD_LIST" Foreign Keys |
Parent Key | Child Key |
ID | KEYWORD_ID |
"KEYWORD to KEYWORD_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"KEYWORD to KEYWORD_LIST" Bound Attachments |
Name | Current Value |
"STUDY to TOPIC_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059586 |
Relationship Business Name | |
Physical Only | No |
Parent Table | STUDY |
Child Table | TOPIC_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"STUDY to TOPIC_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"STUDY to TOPIC_LIST" Foreign Keys |
Parent Key | Child Key |
ID | STUDY_ID |
"STUDY to TOPIC_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"STUDY to TOPIC_LIST" Bound Attachments |
Name | Current Value |
"TOPIC to TOPIC_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059587 |
Relationship Business Name | |
Physical Only | No |
Parent Table | TOPIC |
Child Table | TOPIC_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"TOPIC to TOPIC_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"TOPIC to TOPIC_LIST" Foreign Keys |
Parent Key | Child Key |
ID | TOPIC_ID |
"TOPIC to TOPIC_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"TOPIC to TOPIC_LIST" Bound Attachments |
Name | Current Value |
"STUDY to PUBLICATION_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059589 |
Relationship Business Name | |
Physical Only | No |
Parent Table | STUDY |
Child Table | PUBLICATION_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"STUDY to PUBLICATION_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"STUDY to PUBLICATION_LIST" Foreign Keys |
Parent Key | Child Key |
ID | STUDY_ID |
"STUDY to PUBLICATION_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"STUDY to PUBLICATION_LIST" Bound Attachments |
Name | Current Value |
"PUBLICATION to PUBLICATION_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059590 |
Relationship Business Name | |
Physical Only | No |
Parent Table | PUBLICATION |
Child Table | PUBLICATION_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PUBLICATION to PUBLICATION_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PUBLICATION to PUBLICATION_LIST" Foreign Keys |
Parent Key | Child Key |
ID | PUBLICATION_ID |
"PUBLICATION to PUBLICATION_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PUBLICATION to PUBLICATION_LIST" Bound Attachments |
Name | Current Value |
"STUDY to INVESTIGATION_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059600 |
Relationship Business Name | |
Physical Only | No |
Parent Table | STUDY |
Child Table | INVESTIGATION_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"STUDY to INVESTIGATION_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"STUDY to INVESTIGATION_LIST" Foreign Keys |
Parent Key | Child Key |
ID | STUDY_ID |
"STUDY to INVESTIGATION_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"STUDY to INVESTIGATION_LIST" Bound Attachments |
Name | Current Value |
"INVESTIGATION to INVESTIGATION_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059601 |
Relationship Business Name | |
Physical Only | No |
Parent Table | INVESTIGATION |
Child Table | INVESTIGATION_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INVESTIGATION to INVESTIGATION_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INVESTIGATION to INVESTIGATION_LIST" Foreign Keys |
Parent Key | Child Key |
ID | INVESTIGATION_ID |
"INVESTIGATION to INVESTIGATION_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INVESTIGATION to INVESTIGATION_LIST" Bound Attachments |
Name | Current Value |
"DATAFILE_FORMAT to DATAFILE" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059610 |
Relationship Business Name | |
Physical Only | No |
Parent Table | DATAFILE_FORMAT |
Child Table | DATAFILE |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DATAFILE_FORMAT to DATAFILE" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DATAFILE_FORMAT to DATAFILE" Foreign Keys |
Parent Key | Child Key |
ID | DATAFILE_FORMAT |
"DATAFILE_FORMAT to DATAFILE" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DATAFILE_FORMAT to DATAFILE" Bound Attachments |
Name | Current Value |
"DATAFILE to PARAMETER_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059612 |
Relationship Business Name | |
Physical Only | No |
Parent Table | DATAFILE |
Child Table | PARAMETER_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DATAFILE to PARAMETER_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DATAFILE to PARAMETER_LIST" Foreign Keys |
Parent Key | Child Key |
ID | DATAFILE_ID |
"DATAFILE to PARAMETER_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DATAFILE to PARAMETER_LIST" Bound Attachments |
Name | Current Value |
"PARAMETER to PARAMETER_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059613 |
Relationship Business Name | |
Physical Only | No |
Parent Table | PARAMETER |
Child Table | PARAMETER_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PARAMETER to PARAMETER_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PARAMETER to PARAMETER_LIST" Foreign Keys |
Parent Key | Child Key |
ID | PARAMETER_ID |
"PARAMETER to PARAMETER_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PARAMETER to PARAMETER_LIST" Bound Attachments |
Name | Current Value |
"DATASET to DATAFILE_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059615 |
Relationship Business Name | |
Physical Only | No |
Parent Table | DATASET |
Child Table | DATAFILE_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DATASET to DATAFILE_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DATASET to DATAFILE_LIST" Foreign Keys |
Parent Key | Child Key |
ID | DATASET_ID |
"DATASET to DATAFILE_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DATASET to DATAFILE_LIST" Bound Attachments |
Name | Current Value |
"DATAFILE to DATAFILE_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059616 |
Relationship Business Name | |
Physical Only | No |
Parent Table | DATAFILE |
Child Table | DATAFILE_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DATAFILE to DATAFILE_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DATAFILE to DATAFILE_LIST" Foreign Keys |
Parent Key | Child Key |
ID | DATAFILE_ID |
"DATAFILE to DATAFILE_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DATAFILE to DATAFILE_LIST" Bound Attachments |
Name | Current Value |
"INVESTIGATION to DATASET_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059618 |
Relationship Business Name | |
Physical Only | No |
Parent Table | INVESTIGATION |
Child Table | DATASET_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INVESTIGATION to DATASET_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INVESTIGATION to DATASET_LIST" Foreign Keys |
Parent Key | Child Key |
ID | INVESTIGATION_ID |
"INVESTIGATION to DATASET_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INVESTIGATION to DATASET_LIST" Bound Attachments |
Name | Current Value |
"DATASET to DATASET_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059619 |
Relationship Business Name | |
Physical Only | No |
Parent Table | DATASET |
Child Table | DATASET_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DATASET to DATASET_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DATASET to DATASET_LIST" Foreign Keys |
Parent Key | Child Key |
ID | DATASET_ID |
"DATASET to DATASET_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DATASET to DATASET_LIST" Bound Attachments |
Name | Current Value |
"CALIBRATION to CALIBRATION_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059621 |
Relationship Business Name | |
Physical Only | No |
Parent Table | CALIBRATION |
Child Table | CALIBRATION_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CALIBRATION to CALIBRATION_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CALIBRATION to CALIBRATION_LIST" Foreign Keys |
Parent Key | Child Key |
ID | CALIBRATION_ID |
"CALIBRATION to CALIBRATION_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CALIBRATION to CALIBRATION_LIST" Bound Attachments |
Name | Current Value |
"PARAMETER to CALIBRATION_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059622 |
Relationship Business Name | |
Physical Only | No |
Parent Table | PARAMETER |
Child Table | CALIBRATION_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PARAMETER to CALIBRATION_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PARAMETER to CALIBRATION_LIST" Foreign Keys |
Parent Key | Child Key |
ID | PARAMETER_ID |
"PARAMETER to CALIBRATION_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PARAMETER to CALIBRATION_LIST" Bound Attachments |
Name | Current Value |
"INVESTIGATION to PERMISSIONS" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059626 |
Relationship Business Name | |
Physical Only | No |
Parent Table | INVESTIGATION |
Child Table | PERMISSIONS |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INVESTIGATION to PERMISSIONS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INVESTIGATION to PERMISSIONS" Foreign Keys |
Parent Key | Child Key |
ID | INVESTIGATION_ID |
"INVESTIGATION to PERMISSIONS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INVESTIGATION to PERMISSIONS" Bound Attachments |
Name | Current Value |
"ACCESS_GROUP to PARTY_ACCESS_GROUP" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059628 |
Relationship Business Name | |
Physical Only | No |
Parent Table | ACCESS_GROUP |
Child Table | PARTY_ACCESS_GROUP |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"ACCESS_GROUP to PARTY_ACCESS_GROUP" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ACCESS_GROUP to PARTY_ACCESS_GROUP" Foreign Keys |
Parent Key | Child Key |
ID | ACCESS_GROUP_ID |
"ACCESS_GROUP to PARTY_ACCESS_GROUP" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"ACCESS_GROUP to PARTY_ACCESS_GROUP" Bound Attachments |
Name | Current Value |
"INVESTIGATION to INVESTIGATOR_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059630 |
Relationship Business Name | |
Physical Only | No |
Parent Table | INVESTIGATION |
Child Table | INVESTIGATOR_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"INVESTIGATION to INVESTIGATOR_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"INVESTIGATION to INVESTIGATOR_LIST" Foreign Keys |
Parent Key | Child Key |
ID | INVESTIGATION_ID |
"INVESTIGATION to INVESTIGATOR_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"INVESTIGATION to INVESTIGATOR_LIST" Bound Attachments |
Name | Current Value |
"SAMPLE to SAMPLE_TYPE_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059632 |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SAMPLE_TYPE_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SAMPLE_TYPE_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SAMPLE_TYPE_LIST" Foreign Keys |
Parent Key | Child Key |
ID | SAMPLE_ID |
"SAMPLE to SAMPLE_TYPE_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SAMPLE_TYPE_LIST" Bound Attachments |
Name | Current Value |
"SAMPLE_TYPE to SAMPLE_TYPE_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059633 |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE_TYPE |
Child Table | SAMPLE_TYPE_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE_TYPE to SAMPLE_TYPE_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE_TYPE to SAMPLE_TYPE_LIST" Foreign Keys |
Parent Key | Child Key |
ID | SAMPLE_TYPE_ID |
"SAMPLE_TYPE to SAMPLE_TYPE_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE_TYPE to SAMPLE_TYPE_LIST" Bound Attachments |
Name | Current Value |
"ACCESS_GROUP to ACCESS_GROUP_PERMISSIONS" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059635 |
Relationship Business Name | |
Physical Only | No |
Parent Table | ACCESS_GROUP |
Child Table | ACCESS_GROUP_PERMISSIONS |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"ACCESS_GROUP to ACCESS_GROUP_PERMISSIONS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"ACCESS_GROUP to ACCESS_GROUP_PERMISSIONS" Foreign Keys |
Parent Key | Child Key |
ID | ACCESS_GROUP_ID |
"ACCESS_GROUP to ACCESS_GROUP_PERMISSIONS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"ACCESS_GROUP to ACCESS_GROUP_PERMISSIONS" Bound Attachments |
Name | Current Value |
"PERMISSIONS to ACCESS_GROUP_PERMISSIONS" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059636 |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERMISSIONS |
Child Table | ACCESS_GROUP_PERMISSIONS |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERMISSIONS to ACCESS_GROUP_PERMISSIONS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERMISSIONS to ACCESS_GROUP_PERMISSIONS" Foreign Keys |
Parent Key | Child Key |
ID | PERMISSIONS_ID |
"PERMISSIONS to ACCESS_GROUP_PERMISSIONS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERMISSIONS to ACCESS_GROUP_PERMISSIONS" Bound Attachments |
Name | Current Value |
"PERMISSIONS to PARTY_PERMISSIONS" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059638 |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERMISSIONS |
Child Table | PARTY_PERMISSIONS |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERMISSIONS to PARTY_PERMISSIONS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERMISSIONS to PARTY_PERMISSIONS" Foreign Keys |
Parent Key | Child Key |
ID | PERMISSIONS_ID |
"PERMISSIONS to PARTY_PERMISSIONS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERMISSIONS to PARTY_PERMISSIONS" Bound Attachments |
Name | Current Value |
"PERMISSIONS to DATAFILE_DOWNLOAD" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059640 |
Relationship Business Name | |
Physical Only | No |
Parent Table | PERMISSIONS |
Child Table | DATAFILE_DOWNLOAD |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PERMISSIONS to DATAFILE_DOWNLOAD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PERMISSIONS to DATAFILE_DOWNLOAD" Foreign Keys |
Parent Key | Child Key |
ID | PERMISSIONS_ID |
"PERMISSIONS to DATAFILE_DOWNLOAD" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PERMISSIONS to DATAFILE_DOWNLOAD" Bound Attachments |
Name | Current Value |
"DATAFILE to DATAFILE_DOWNLOAD" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059641 |
Relationship Business Name | |
Physical Only | No |
Parent Table | DATAFILE |
Child Table | DATAFILE_DOWNLOAD |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DATAFILE to DATAFILE_DOWNLOAD" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DATAFILE to DATAFILE_DOWNLOAD" Foreign Keys |
Parent Key | Child Key |
ID | DATAFILE_ID |
"DATAFILE to DATAFILE_DOWNLOAD" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DATAFILE to DATAFILE_DOWNLOAD" Bound Attachments |
Name | Current Value |
"SAMPLE to SAMPLE_PARAMETER_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059643 |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SAMPLE_PARAMETER_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SAMPLE_PARAMETER_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SAMPLE_PARAMETER_LIST" Foreign Keys |
Parent Key | Child Key |
ID | SAMPLE_ID |
"SAMPLE to SAMPLE_PARAMETER_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SAMPLE_PARAMETER_LIST" Bound Attachments |
Name | Current Value |
"PARAMETER to SAMPLE_PARAMETER_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059644 |
Relationship Business Name | |
Physical Only | No |
Parent Table | PARAMETER |
Child Table | SAMPLE_PARAMETER_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PARAMETER to SAMPLE_PARAMETER_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PARAMETER to SAMPLE_PARAMETER_LIST" Foreign Keys |
Parent Key | Child Key |
ID | PARAMETER_ID |
"PARAMETER to SAMPLE_PARAMETER_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PARAMETER to SAMPLE_PARAMETER_LIST" Bound Attachments |
Name | Current Value |
"SOFTWARE to SOFTWARE_VERSION" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059648 |
Relationship Business Name | |
Physical Only | No |
Parent Table | SOFTWARE |
Child Table | SOFTWARE_VERSION |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SOFTWARE to SOFTWARE_VERSION" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SOFTWARE to SOFTWARE_VERSION" Foreign Keys |
Parent Key | Child Key |
ID | SOFTWARE_ID |
"SOFTWARE to SOFTWARE_VERSION" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SOFTWARE to SOFTWARE_VERSION" Bound Attachments |
Name | Current Value |
"DATAFILE to RELATED_DATAFILES" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059650 |
Relationship Business Name | |
Physical Only | No |
Parent Table | DATAFILE |
Child Table | RELATED_DATAFILES |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DATAFILE to RELATED_DATAFILES" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DATAFILE to RELATED_DATAFILES" Foreign Keys |
Parent Key | Child Key |
ID | SOURCE_DATAFILE_ID |
"DATAFILE to RELATED_DATAFILES" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DATAFILE to RELATED_DATAFILES" Bound Attachments |
Name | Current Value |
"DATAFILE to RELATED_DATAFILES" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059651 |
Relationship Business Name | |
Physical Only | No |
Parent Table | DATAFILE |
Child Table | RELATED_DATAFILES |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DATAFILE to RELATED_DATAFILES" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DATAFILE to RELATED_DATAFILES" Foreign Keys |
Parent Key | Child Key |
ID | DESTINATION_DATAFILE_ID |
"DATAFILE to RELATED_DATAFILES" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DATAFILE to RELATED_DATAFILES" Bound Attachments |
Name | Current Value |
"SOFTWARE_VERSION to RELATED_DATAFILES" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059652 |
Relationship Business Name | |
Physical Only | No |
Parent Table | SOFTWARE_VERSION |
Child Table | RELATED_DATAFILES |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SOFTWARE_VERSION to RELATED_DATAFILES" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SOFTWARE_VERSION to RELATED_DATAFILES" Foreign Keys |
Parent Key | Child Key |
ID | SOFTWARE_VERSION_ID |
"SOFTWARE_VERSION to RELATED_DATAFILES" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SOFTWARE_VERSION to RELATED_DATAFILES" Bound Attachments |
Name | Current Value |
"SOFTWARE_VERSION to SOFTWARE_AUTHORS" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059654 |
Relationship Business Name | |
Physical Only | No |
Parent Table | SOFTWARE_VERSION |
Child Table | SOFTWARE_AUTHORS |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SOFTWARE_VERSION to SOFTWARE_AUTHORS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SOFTWARE_VERSION to SOFTWARE_AUTHORS" Foreign Keys |
Parent Key | Child Key |
ID | SOFTWARE_VERSION_ID |
"SOFTWARE_VERSION to SOFTWARE_AUTHORS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SOFTWARE_VERSION to SOFTWARE_AUTHORS" Bound Attachments |
Name | Current Value |
"SOFTWARE_VERSION to SOFTWARE_PLATFORM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059656 |
Relationship Business Name | |
Physical Only | No |
Parent Table | SOFTWARE_VERSION |
Child Table | SOFTWARE_PLATFORM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SOFTWARE_VERSION to SOFTWARE_PLATFORM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SOFTWARE_VERSION to SOFTWARE_PLATFORM" Foreign Keys |
Parent Key | Child Key |
ID | SOFTWARE_VERSION_ID |
"SOFTWARE_VERSION to SOFTWARE_PLATFORM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SOFTWARE_VERSION to SOFTWARE_PLATFORM" Bound Attachments |
Name | Current Value |
"PLATFORM to SOFTWARE_PLATFORM" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059657 |
Relationship Business Name | |
Physical Only | No |
Parent Table | PLATFORM |
Child Table | SOFTWARE_PLATFORM |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"PLATFORM to SOFTWARE_PLATFORM" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"PLATFORM to SOFTWARE_PLATFORM" Foreign Keys |
Parent Key | Child Key |
ID | SOFTWARE_PLATFORM_ID |
"PLATFORM to SOFTWARE_PLATFORM" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"PLATFORM to SOFTWARE_PLATFORM" Bound Attachments |
Name | Current Value |
"SOFTWARE_VERSION to SOFTWARE_FORMATS" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059659 |
Relationship Business Name | |
Physical Only | No |
Parent Table | SOFTWARE_VERSION |
Child Table | SOFTWARE_FORMATS |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SOFTWARE_VERSION to SOFTWARE_FORMATS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SOFTWARE_VERSION to SOFTWARE_FORMATS" Foreign Keys |
Parent Key | Child Key |
ID | SOFTWARE_VERSION_ID |
"SOFTWARE_VERSION to SOFTWARE_FORMATS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SOFTWARE_VERSION to SOFTWARE_FORMATS" Bound Attachments |
Name | Current Value |
"DATAFILE_FORMAT to SOFTWARE_FORMATS" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0059660 |
Relationship Business Name | |
Physical Only | No |
Parent Table | DATAFILE_FORMAT |
Child Table | SOFTWARE_FORMATS |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DATAFILE_FORMAT to SOFTWARE_FORMATS" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DATAFILE_FORMAT to SOFTWARE_FORMATS" Foreign Keys |
Parent Key | Child Key |
ID | DATAFILE_FORMAT_ID |
"DATAFILE_FORMAT to SOFTWARE_FORMATS" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DATAFILE_FORMAT to SOFTWARE_FORMATS" Bound Attachments |
Name | Current Value |
"DATASET to SAMPLE_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0063678 |
Relationship Business Name | |
Physical Only | No |
Parent Table | DATASET |
Child Table | SAMPLE_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DATASET to SAMPLE_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DATASET to SAMPLE_LIST" Foreign Keys |
Parent Key | Child Key |
ID | DATASET_ID |
"DATASET to SAMPLE_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DATASET to SAMPLE_LIST" Bound Attachments |
Name | Current Value |
"SAMPLE to SAMPLE_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0063679 |
Relationship Business Name | |
Physical Only | No |
Parent Table | SAMPLE |
Child Table | SAMPLE_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"SAMPLE to SAMPLE_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"SAMPLE to SAMPLE_LIST" Foreign Keys |
Parent Key | Child Key |
ID | SAMPLE_ID |
"SAMPLE to SAMPLE_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"SAMPLE to SAMPLE_LIST" Bound Attachments |
Name | Current Value |
"CALIBRATION to CALIBRATION_DATAFILE_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0073126 |
Relationship Business Name | |
Physical Only | No |
Parent Table | CALIBRATION |
Child Table | CALIBRATION_DATAFILE_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CALIBRATION to CALIBRATION_DATAFILE_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CALIBRATION to CALIBRATION_DATAFILE_LIST" Foreign Keys |
Parent Key | Child Key |
ID | CALIBRATION_ID |
"CALIBRATION to CALIBRATION_DATAFILE_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CALIBRATION to CALIBRATION_DATAFILE_LIST" Bound Attachments |
Name | Current Value |
"DATAFILE to CALIBRATION_DATAFILE_LIST" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | SYS_C0073127 |
Relationship Business Name | |
Physical Only | No |
Parent Table | DATAFILE |
Child Table | CALIBRATION_DATAFILE_LIST |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DATAFILE to CALIBRATION_DATAFILE_LIST" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DATAFILE to CALIBRATION_DATAFILE_LIST" Foreign Keys |
Parent Key | Child Key |
ID | DATAFILE_ID |
"DATAFILE to CALIBRATION_DATAFILE_LIST" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | Cascade |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DATAFILE to CALIBRATION_DATAFILE_LIST" Bound Attachments |
Name | Current Value |