Table eprints_cchange.eprints_cchange.saved_search Generated by
SchemaSpy
Legend:
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
id int 10
rev_number int 10  √  null
userid int 10  √  null
user.userid Defined in XML R
pos int 10  √  null
name varchar 255  √  null
spec mediumtext 16777215  √  null
frequency varchar 255  √  null
mailempty set 10  √  null
public set 10  √  null

Table contained 14 rows at Wed Apr 20 16:58 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
frequency Performance Asc frequency
mailempty Performance Asc mailempty
pos Performance Asc pos
public Performance Asc public
rev_number Performance Asc rev_number
userid Performance Asc userid

Close relationships: