Table HLPDTEST.STATEGPS.T_MESSAGES Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
MESSAGE_ID number 22
MESSAGE_CODE varchar2 500  √  null
MESSAGE_NAME varchar2 500  √  null
CATEGORY varchar2 100  √  null
MESSAGE varchar2 500  √  null
CAUSE varchar2 500  √  null
ACTION varchar2 500  √  null
DESCRIPTION varchar2 500  √  null

Table contained 0 rows at Thu Aug 13 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name Anomalies
MESSAGE_ID Primary key Asc SYS_C0010158  
MESSAGE_CODE Must be unique Asc SYS_C0010159 This unique column is also nullable
MESSAGE_NAME Must be unique Asc SYS_C0010160 This unique column is also nullable
MESSAGE + MESSAGE_CODE + MESSAGE_NAME Performance Asc/Asc/Asc T_MESSAGES_INDEX