Log Entry |
EntityType | Independent |
Logical Entity Name | Log Entry |
Default Table Name | Log Entry |
Logical Only | NO |
Owner | LOGBOOK |
Definition | Log Entry: A table used to store comments regarding the SNS facility. |
Note |
Log Entry Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Log Entry Id | INTEGER | NO | Log Entry Identifier: The unique identifier for a log entry. This number is automatically generated in sequential order. |
|
Badge Number | VARCHAR(10) | YES | ||
Prnt Log Entry Id | INTEGER | YES | Parent Log Entry Identifier: The unique identifier pointing the to parent log entry. This provides the ability to develop a "chain" of log entries related to a specific topic. |
|
Type Id | INTEGER | YES | ||
Title | Name | VARCHAR(120) | NO | Title: A short, one line title, describing the log entry. |
Content | Comment | VARCHAR(2000) | YES | Content: A free form text field used to store the specific log entry. This field may contain html code. |
HTML Indicator | Indicator | CHAR(1) | NO | HTML Indicator: Default is "N." When set to "Y" it indicates the Content field contains HTML code. |
Orignal Post | Datetime | DATETIME | NO | Original Post Date: The date the log entry record was created. |
Occururence Date | Modify Date | DATE | NO | Occurrence Date: The date and time when the item being described in the logbook entry actually occurred. |
Email Notification Indicator | Indicator | CHAR(1) | NO | Email Notifcation Indicator: Indicates the entry should have an email notification to user subscribers and group subscribers. |
Annotation Indicator | Indicator | CHAR(1) | NO | Annotation Indicator: If an entry's annotation value is 'Y' then it indicates that this entry is an annotation to it parent entry rather than a thread response. In this way the author of an entry can annotate their original entry (parent entry) and it will be displayed sequentially with the parent entry in chronological order. Users can use this feature to correct mistakes but without actually editing the original entry. Effectively, they can append to their original entry. |
Publication Status Indicator | Indicator | CHAR(1) | NO |
Log Entry Keys |
Key Name | Key Type | Keys |
log_entry_pk | PrimaryKey | Log Entry Id |
Log Entry Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Employee | Non-Identifying | Zero or One to Zero or More | Badge Number | NO | |||
Log Entry Type | Non-Identifying | Zero or One to Zero or More | Type Id | NO | |||
Log Entry | Non-Identifying | Zero or One to Zero or More | Prnt Log Entry Id | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
Shift Instrument Note | Non-Identifying | One To Zero or More | NO | ||||
Log Entry Categories | Identifying | One To Zero or More | NO | ||||
Log Entry Bookmark | Identifying | One To Zero or More | NO | ||||
Daily Order Required Reading | Identifying | One To Zero or More | NO | ||||
Log Entry Read | Identifying | One To Zero or More | NO | ||||
Draft Log Entry Work Order Association | Identifying | One To Zero or More | NO | ||||
Log Entry Attachment | Identifying | One To Zero or More | NO | ||||
Log Entry Image | Identifying | One To Zero or More | NO | ||||
Log Entry Keyword | Identifying | One To Zero or More | NO | ||||
Log Entry Notif | Identifying | One To Zero or More | NO | ||||
Log Entry | Non-Identifying | Zero or One to Zero or More | NO |
Log Entry Check Constraints |
Check Constraint Name | CheckConstraint |
Log Entry Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
Log Entry Security Types |
Name | Current Value |
Log Entry Bound Attachments |
Name | Current Value |
Log Entry Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical LOGBOOK.Log Entry |
NO | |||
ALARM_MYSQL (MySQL) Does Not Exist |
NO | |||
ALARM_ORACLE (Oracle) Does Not Exist |
NO | |||
BICS (Oracle) Does Not Exist |
NO | |||
BLM (Oracle) Does Not Exist |
NO | |||
BYPASS_REQ (Oracle) Does Not Exist |
NO | |||
CHAN_ARCH (Oracle) Does Not Exist |
NO | |||
CNMS_PRPSL (Oracle) Does Not Exist |
NO | |||
DIAG (Oracle) Does Not Exist |
NO | |||
DIAG_MPS (Oracle) Does Not Exist |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) Does Not Exist |
NO | |||
EQUIP (Oracle) Does Not Exist |
NO | |||
EXPRESS (Oracle) Does Not Exist |
NO | |||
ICS_SFTW_APPL (Oracle) Does Not Exist |
NO | |||
INSTR (Oracle) Does Not Exist |
NO | |||
Instrument Logbook (Oracle) Does Not Exist |
NO | |||
INVT (Oracle) Does Not Exist |
NO | |||
IONSRC (Oracle) Does Not Exist |
NO | |||
IONSRC1 (Oracle) Does Not Exist |
NO | |||
IPTSv5 (Oracle) Does Not Exist |
NO | |||
IRMISBase (Oracle) Does Not Exist |
NO | |||
Logbook (Oracle) LOGBOOK.LOG_ENTRY |
NO | |||
Magnet (Oracle) Does Not Exist |
NO | |||
MPS (Oracle) Does Not Exist |
NO | |||
NS_OPER (Oracle) Does Not Exist |
NO | |||
OPER (Oracle) Does Not Exist |
NO | |||
PART (Oracle) Does Not Exist |
NO | |||
PRINT (Oracle) Does Not Exist |
NO | |||
PROC (Oracle) Does Not Exist |
NO | |||
PRPSL (Oracle) Does Not Exist |
NO | |||
PUBL (Oracle) Does Not Exist |
NO | |||
PUBL_V1 (Oracle) Does Not Exist |
NO | |||
PV_LOGGER (Oracle) Does Not Exist |
NO | |||
SCORE (Oracle) Does Not Exist |
NO | |||
SICAT (Oracle) Does Not Exist |
NO | |||
SMPL (Oracle) Does Not Exist |
NO | |||
SMPLACT (Oracle) Does Not Exist |
NO | |||
SURVEY (Oracle) Does Not Exist |
NO | |||
Watchman (Oracle) Does Not Exist |
NO | |||
XAL_OPTICS (Oracle) Does Not Exist |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
Log Entry Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Logbook |
Logbook (Oracle) | Main Model |
Log Entry Data Movement Rules |
Name | Type | Rule Text/Value |