Table oplist.OPLIST
Tabelle zur Speicherung der OP-Punkte

 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
OPID bigint 19  √ 
OPLIST_COMMENT.OPID Implied Constraint R
OPDATECREATED timestamp 19 CURRENT_TIMESTAMP
OPDATEUPDATED timestamp 19 CURRENT_TIMESTAMP
OPSID bigint 19 0
OPLIST_STAT.OPSID Implied Constraint R
OPENTRY varchar 4000
OPAID bigint 19 4
OPLIST_AREA.OPAID Implied Constraint R
OPDESC varchar 4000  √  null
OPPID bigint 19 4
OPLIST_PRODUCT.OPPID Implied Constraint R
OPPRIO int 10 0
OPUID_CREATED bigint 19 0
OPUID_UPDATED bigint 19 0
OPUID_ASSIGNED bigint 19 0
OPDELETED int 10 0
OPDEADLINE date 10  √  null Termin

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

Indexes:
Column(s) Type Sort Constraint Name
OPID Primary key Asc PRIMARY
OPSID Performance Asc IDX_OPLIST01
OPAID Performance Asc IDX_OPLIST02
OPPID Performance Asc IDX_OPLIST03
OPUID_CREATED Performance Asc IDX_OPLIST04
OPUID_UPDATED Performance Asc IDX_OPLIST05
OPUID_ASSIGNED Performance Asc IDX_OPLIST06

Close relationships: