Table oplist.OPLIST_USERS
Tabelle zur Speicherung der Benutzer

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
OPUID bigint 19  √ 
OPLIST_COMMENT.OPUID Implied Constraint R
OPGID bigint 19 3
OPLIST_GROUP.OPGID Implied Constraint R
OPUUSERNAME varchar 255
OPULNAME varchar 255
OPUFNAME varchar 255
OPUEMAIL varchar 255  √  null
OPUPASSWORD varchar 100 pwd
OPUACTIVE int 10 0
OPUDATE timestamp 19 CURRENT_TIMESTAMP

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

Indexes:
Column(s) Type Sort Constraint Name
OPUID Primary key Asc PRIMARY
OPGID Performance Asc IDX_USERS01

Close relationships: