LOG_ENTRY |
Logical Entity Name | Log Entry |
Default Table Name | LOG_ENTRY |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | LOGBOOK |
Definition | Log Entry: A table used to store comments regarding the SNS facility. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE LOGBOOK.LOG_ENTRY(      LOG_ENTRY_ID                     NUMBER(38, 0)      NOT NULL,      BN                               VARCHAR2(10),      PRNT_LOG_ENTRY_ID                NUMBER(38, 0),      TYPE_ID                          NUMBER(38, 0),      TITLE                            VARCHAR2(120)      NOT NULL,      CONTENT                          VARCHAR2(2000),      HTML_INDICATOR                   CHAR(1)            DEFAULT 'N' NOT NULL,      ORIG_POST                        TIMESTAMP(6)       NOT NULL,      OCCUR_DTE                        DATE               NOT NULL,      EMAIL_NOTIFICATION_INDICATOR     CHAR(1)            DEFAULT 'N' NOT NULL,      ANNOT_IND                        CHAR(1)            DEFAULT 'N' NOT NULL,      PUB_STAT_ID                      CHAR(1)            DEFAULT 'N' NOT NULL,      CONSTRAINT LOG_ENTRY_PK PRIMARY KEY (LOG_ENTRY_ID)      USING INDEX          PCTFREE 10          INITRANS 2          MAXTRANS 255          TABLESPACE LOGBOOK          LOGGING          STORAGE(INITIAL 4224K                  NEXT 1024K                  MINEXTENTS 1                  MAXEXTENTS UNLIMITED                  PCTINCREASE 0                  ),      CONSTRAINT LOG_ENTRY_LOG_ENTRY_LABEL_RF FOREIGN KEY (TYPE_ID)      REFERENCES LOGBOOK.LOG_ENTRY_TYPE(TYPE_ID),      CONSTRAINT LOG_ENTRY_PRNT_RF FOREIGN KEY (PRNT_LOG_ENTRY_ID)      REFERENCES LOGBOOK.LOG_ENTRY(LOG_ENTRY_ID) ) PCTFREE 10 INITRANS 1 MAXTRANS 255 TABLESPACE LOGBOOK LOGGING NOPARALLEL STORAGE(INITIAL 75392K          NEXT 1024K          MINEXTENTS 1          MAXEXTENTS UNLIMITED          PCTINCREASE 0          ) NOCACHE NOCOMPRESS ; |
PostSQL |
LOG_ENTRY Columns |
ColumnName | Domain | Datatype | NULL | Definition |
LOG_ENTRY_ID | NUMBER(38, 0) | NO | Log Entry Identifier: The unique identifier for a log entry. This number is automatically generated in sequential order. |
|
BN | VARCHAR2(10) | YES | ||
PRNT_LOG_ENTRY_ID | NUMBER(38, 0) | 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 | NUMBER(38, 0) | YES | ||
TITLE | Name | VARCHAR2(120) | NO | Title: A short, one line title, describing the log entry. |
CONTENT | Comment | VARCHAR2(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. |
ORIG_POST | Datetime | TIMESTAMP(6) | NO | Original Post Date: The date the log entry record was created. |
OCCUR_DTE | 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. |
ANNOT_IND | 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. |
PUB_STAT_ID | Indicator | CHAR(1) | NO |
LOG_ENTRY Primary and Unique Keys |
Key Name | Key Type | Keys |
LOG_ENTRY_PK | PrimaryKey | LOG_ENTRY_ID |
LOG_ENTRY Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
LOG_ENTRY_TYPE | Non-Identifying | Zero or One to Zero or More | LOG_ENTRY_LOG_ENTRY_LABEL_RF | TYPE_ID | NO | NO | NO | ||
LOG_ENTRY | Non-Identifying | Zero or One to Zero or More | LOG_ENTRY_PRNT_RF | PRNT_LOG_ENTRY_ID | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
DAILY_ORDER_REQD_READ | Identifying | One To Zero or More | DAILY_ORDER_LOG_ENTRY_FK | NO | NO | NO | |||
LOG_ENTRY_CATEGORIES | Non-Identifying | Zero or One to Zero or More | ENTRY_FK | NO | NO | NO | |||
DRAFT_LOG_ENTRY_WO_ASSC | Identifying | One To Zero or More | FK_DLEWOA_TO_LOG_ENTRY | NO | NO | NO | |||
LOG_ENTRY_RAD_AREA | Identifying | One To Zero or More | FK_LOG_ENTRY_AREA_ENTRY | NO | NO | NO | |||
LOG_ENTRY_BOOKMARK | Identifying | One To Zero or More | LOG_ENTRY_BMRK_LOG_ENTRY_FK | NO | NO | NO | |||
LOG_ENTRY_ATTACHMENT | Identifying | One To Zero or More | LOG_ENTRY_IMAGE_ENTRY_FK | NO | NO | NO | |||
LOG_ENTRY_IMAGE | Identifying | One To Zero or More | LOG_ENTRY_LOG_ENTRY_IMG_RF | NO | NO | NO | |||
LOG_ENTRY_KEYWORD | Identifying | One To Zero or More | LOG_ENTRY_LOG_ENTRY_KEYWD_RF | NO | NO | NO | |||
LOG_ENTRY_READ | Identifying | One To Zero or More | LOG_ENTRY_LOG_ENTRY_RD_FK | NO | NO | NO | |||
LOG_ENTRY_NOTIF | Identifying | One To Zero or More | LOG_ENTRY_LOG_ENTRY_RD_RF | NO | NO | NO | |||
LOG_ENTRY | Non-Identifying | One To Zero or More | LOG_ENTRY_PRNT_RF | NO | NO | NO | |||
ENTRY_LOGBOOK | Identifying | One To Zero or More | LOGBOOK_ENTRY_FK | NO | NO | NO |
LOG_ENTRY Check Constraints |
Check Constraint Name | CheckConstraint |
LOG_ENTRY Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | LOGBOOK |
PctFree | 10 |
PCTUSED | 0 |
MinExtents | 1 |
MaxExtents | 2147483645 |
Initial | 75392 |
Next | 1024 |
PctIncrease | 0 |
InitTrans | 1 |
MaxTrans | 255 |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Table Compression | NO |
Compress Expression | |
Row Movement | Disabled |
LOG_ENTRY Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
LOG_ENTRY Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 0 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
Average Row Size | 0 |
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) LOGBOOK.LOG_ENTRY |
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 |
Instrument Logbook (Oracle) | Main Model |
Logbook (Oracle) | Main Model |
LOG_ENTRY Data Movement Rules |
Name | Type | Rule Text/Value |