"Logbook V to User Subscription" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Logbook V |
Child Entity | User Subscription |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Logbook V to User Subscription" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Logbook V to User Subscription" Foreign Keys |
Parent Key | Child Key |
Logbook Id | Logbook Id |
"Logbook V to User Subscription" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Logbook V to User Subscription" Bound Attachments |
Name | Current Value |
"Equipment Category to User Subscription" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Equipment Category |
Child Entity | User Subscription |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Equipment Category to User Subscription" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Equipment Category to User Subscription" Foreign Keys |
Parent Key | Child Key |
Operation Group Identifier | Operation Group Identifier |
"Equipment Category to User Subscription" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Equipment Category to User Subscription" Bound Attachments |
Name | Current Value |
"Log Entry to Log Entry Categories" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Entry |
Child Entity | Log Entry Categories |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Log Entry to Log Entry Categories" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Entry to Log Entry Categories" Foreign Keys |
Parent Key | Child Key |
Log Entry Id | Log Entry Id |
"Log Entry to Log Entry Categories" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Entry to Log Entry Categories" Bound Attachments |
Name | Current Value |
"Log Entry to Log Entry Bookmark" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Entry |
Child Entity | Log Entry Bookmark |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Log Entry to Log Entry Bookmark" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Entry to Log Entry Bookmark" Foreign Keys |
Parent Key | Child Key |
Log Entry Id | Log Entry Id |
"Log Entry to Log Entry Bookmark" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Entry to Log Entry Bookmark" Bound Attachments |
Name | Current Value |
"Log Entry to Daily Order Required Reading" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Entry |
Child Entity | Daily Order Required Reading |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Log Entry to Daily Order Required Reading" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Entry to Daily Order Required Reading" Foreign Keys |
Parent Key | Child Key |
Log Entry Id | Log Entry Id |
"Log Entry to Daily Order Required Reading" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Entry to Daily Order Required Reading" Bound Attachments |
Name | Current Value |
"Logbook User Category to Log Entry Type" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Logbook User Category |
Child Entity | Log Entry Type |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Logbook User Category to Log Entry Type" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Logbook User Category to Log Entry Type" Foreign Keys |
Parent Key | Child Key |
User Cat Id | User Cat Id |
"Logbook User Category to Log Entry Type" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Logbook User Category to Log Entry Type" Bound Attachments |
Name | Current Value |
"Log Entry to Log Entry Read" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Entry |
Child Entity | Log Entry Read |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Log Entry to Log Entry Read" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Entry to Log Entry Read" Foreign Keys |
Parent Key | Child Key |
Log Entry Id | Log Entry Id |
"Log Entry to Log Entry Read" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Entry to Log Entry Read" Bound Attachments |
Name | Current Value |
"Required Reading Frequency to Daily Order Required Reading" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Required Reading Frequency |
Child Entity | Daily Order Required Reading |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Required Reading Frequency to Daily Order Required Reading" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Required Reading Frequency to Daily Order Required Reading" Foreign Keys |
Parent Key | Child Key |
Reqd Read Freq Id | Reqd Read Freq Id |
"Required Reading Frequency to Daily Order Required Reading" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Required Reading Frequency to Daily Order Required Reading" Bound Attachments |
Name | Current Value |
"Log Category to Log Entry Categories" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | CATEGORY_FK |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Category |
Child Entity | Log Entry Categories |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Log Category to Log Entry Categories" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Category to Log Entry Categories" Foreign Keys |
Parent Key | Child Key |
Cat Id | Cat Id |
"Log Category to Log Entry Categories" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Category to Log Entry Categories" Bound Attachments |
Name | Current Value |
"Log Entry to Draft Log Entry Work Order Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_dlewoa_to_log_entry |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Entry |
Child Entity | Draft Log Entry Work Order Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Log Entry to Draft Log Entry Work Order Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Entry to Draft Log Entry Work Order Association" Foreign Keys |
Parent Key | Child Key |
Log Entry Id | Log Entry Id |
"Log Entry to Draft Log Entry Work Order Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Entry to Draft Log Entry Work Order Association" Bound Attachments |
Name | Current Value |
"Image to Log Entry Image" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | image_log_entry_image_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Image |
Child Entity | Log Entry Image |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Image to Log Entry Image" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Image to Log Entry Image" Foreign Keys |
Parent Key | Child Key |
Image Id | Image Id |
"Image to Log Entry Image" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Image to Log Entry Image" Bound Attachments |
Name | Current Value |
"Image Type to Image" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | image_type_image_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Image Type |
Child Entity | Image |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Image Type to Image" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Image Type to Image" Foreign Keys |
Parent Key | Child Key |
Image Type ID | Image Type ID |
"Image Type to Image" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Image Type to Image" Bound Attachments |
Name | Current Value |
"Logbook V to Logbook Log Categories" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | LOG_CAT_LOGBOOK_FK |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Logbook V |
Child Entity | Logbook Log Categories |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Logbook V to Logbook Log Categories" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Logbook V to Logbook Log Categories" Foreign Keys |
Parent Key | Child Key |
Logbook Id | Logbook Id |
"Logbook V to Logbook Log Categories" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Logbook V to Logbook Log Categories" Bound Attachments |
Name | Current Value |
"Log Category to Logbook Log Categories" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | LOG_CATEGORIES_FK |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Category |
Child Entity | Logbook Log Categories |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Log Category to Logbook Log Categories" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Category to Logbook Log Categories" Foreign Keys |
Parent Key | Child Key |
Cat Id | Cat Id |
"Log Category to Logbook Log Categories" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Category to Logbook Log Categories" Bound Attachments |
Name | Current Value |
"Log Entry to Log Entry Attachment" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | LOG_ENTRY_IMAGE_ENTRY_FK |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Entry |
Child Entity | Log Entry Attachment |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Log Entry to Log Entry Attachment" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Entry to Log Entry Attachment" Foreign Keys |
Parent Key | Child Key |
Log Entry Id | Log Entry Id |
"Log Entry to Log Entry Attachment" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Entry to Log Entry Attachment" Bound Attachments |
Name | Current Value |
"Log Entry to Log Entry Image" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | log_entry_log_entry_img_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Entry |
Child Entity | Log Entry Image |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Log Entry to Log Entry Image" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Entry to Log Entry Image" Foreign Keys |
Parent Key | Child Key |
Log Entry Id | Log Entry Id |
"Log Entry to Log Entry Image" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Entry to Log Entry Image" Bound Attachments |
Name | Current Value |
"Log Entry to Log Entry Keyword" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | log_entry_log_entry_keywd_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Entry |
Child Entity | Log Entry Keyword |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Log Entry to Log Entry Keyword" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Entry to Log Entry Keyword" Foreign Keys |
Parent Key | Child Key |
Log Entry Id | Log Entry Id |
"Log Entry to Log Entry Keyword" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Entry to Log Entry Keyword" Bound Attachments |
Name | Current Value |
"Log Entry Type to Log Entry" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | log_entry_log_entry_label_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Entry Type |
Child Entity | Log Entry |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Log Entry Type to Log Entry" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Entry Type to Log Entry" Foreign Keys |
Parent Key | Child Key |
Type Id | Type Id |
"Log Entry Type to Log Entry" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Entry Type to Log Entry" Bound Attachments |
Name | Current Value |
"Log Entry to Log Entry Notif" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | log_entry_log_entry_rd_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Entry |
Child Entity | Log Entry Notif |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Log Entry to Log Entry Notif" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Entry to Log Entry Notif" Foreign Keys |
Parent Key | Child Key |
Log Entry Id | Log Entry Id |
"Log Entry to Log Entry Notif" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Entry to Log Entry Notif" Bound Attachments |
Name | Current Value |
"Log Entry to Log Entry" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | log_entry_prnt_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Entry |
Child Entity | Log Entry |
Cardinality | Zero or One to Zero or More |
Existence | Optional |
Propagated Key | Primary Key |
"Log Entry to Log Entry" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Entry to Log Entry" Foreign Keys |
Parent Key | Child Key |
Log Entry Id | Prnt Log Entry Id |
"Log Entry to Log Entry" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Entry to Log Entry" Bound Attachments |
Name | Current Value |
"Log Keyword to Log Entry Keyword" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | log_keywd_log_entry_keywd_rf |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Log Keyword |
Child Entity | Log Entry Keyword |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Log Keyword to Log Entry Keyword" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Log Keyword to Log Entry Keyword" Foreign Keys |
Parent Key | Child Key |
Log Keyword Id | Log Keyword Id |
"Log Keyword to Log Entry Keyword" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Log Keyword to Log Entry Keyword" Bound Attachments |
Name | Current Value |
"Logbook V to Entry Logbook" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | LOGBOOK_FK |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Logbook V |
Child Entity | Entry Logbook |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Logbook V to Entry Logbook" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Logbook V to Entry Logbook" Foreign Keys |
Parent Key | Child Key |
Logbook Id | Logbook Id |
"Logbook V to Entry Logbook" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Logbook V to Entry Logbook" Bound Attachments |
Name | Current Value |