Table iliasRelease_4_0_x_branch.personal_clipboard 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
user_id int 10 0
item_id int 10 0
type char 4
title char 70  √  null
insert_time datetime 19  √  null
parent int 10 0
order_nr int 10 0

Table contained 0 rows at Wed Apr 27 19:42 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
user_id + item_id + type Primary key Asc/Asc/Asc PRIMARY
item_id + type Performance Asc/Asc it_idx