Log Entry:  A table used to store comments regarding the SNS facility.

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.
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.
BN		VARCHAR2(10)	NO	Author Identifier: The badge number of the person who created the log entry. Only the originator of the entry is allowed to modify the entry.
TITLE		VARCHAR2(120)	NO	Title: A short, one line title, describing the log entry.
CONTENT		VARCHAR2(4000)	NO	Content: A free form text field used to store the specific log entry. This field may contain html code.
HTML_IND		CHAR(1)	NO	HTML Indicator: Default is "N." When set to "Y" it indicates the Content field contains HTML code.
ORIG_POST		DATE	NO	Original Posting: The date and time the entry was posted.
OCCUR_DTE		DATE	NO	Modify Date: The date the log entry record was last modified.
LABEL_ID		NUMBER(38, 0)	YES
PRIOR_ID		NUMBER(38, 0)	YES
TYPE_ID		NUMBER(38, 0)	YES
EMAIL_NOTIF_IND		CHAR(1)	YES
ANNOT_IND		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.

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_PRIOR	Non-Identifying	Zero or One to Zero or More	LOG_ENTRY_LOG_PRIOR_FK			PRIOR_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	One To Zero or More	ENTRY_FK				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	Non-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	64
Next	1024
PctIncrease	0
InitTrans	1
MaxTrans	255
Organization	Heap
Cache	NO
Logging	Logged
Parallel	NO
Parallel Degrees
Parallel Instances
FREELISTS	FreeLists
FREELIST GROUPS	FreeList Groups
Buffer Pool	DEFAULT
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 Does Not Exist	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
Instrument Logbook (Oracle)	Main Model
Logbook (Oracle)	Main Model

LOG_ENTRY Data Movement Rules

Name

Type

Rule Text/Value