Table oplist.OPLIST_COMMENT
Tabelle zur Speicherung der Benutzerkommentare

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
OPCID bigint 19  √ 
OPUID bigint 19
OPLIST_USERS.OPUID Implied Constraint R
OPCTEXT varchar 4000  √  null
OPCDATE timestamp 19 CURRENT_TIMESTAMP
OPID bigint 19
OPLIST.OPID Implied Constraint R
OPCPRIVATE int 10 0
OPCFILENAME varchar 20  √  null

Table contained 35 rows at Mo Jul 03 23:11 MESZ 2017

Indexes:
Column(s) Type Sort Constraint Name
OPCID Primary key Asc PRIMARY
OPUID Performance Asc IDX_COMMENT01
OPID Performance Asc IDX_COMMENT02

Close relationships: