Table iliasRelease_4_3_x_branch.frm_threads 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
thr_pk bigint 19 0
thr_top_fk bigint 19 0
thr_subject varchar 255  √  null
thr_usr_id bigint 19 0
thr_usr_alias varchar 255  √  null
thr_num_posts int 10 0
thr_last_post varchar 50  √  null
thr_date datetime 19  √  null
thr_update datetime 19  √  null
visits int 10 0
import_name varchar 4000  √  null
is_sticky tinyint 3 0
is_closed tinyint 3 0

Table contained 0 rows at Sun Apr 24 00:38 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
thr_pk Primary key Asc PRIMARY
thr_subject Performance Asc i1_idx
thr_top_fk Performance Asc i2_idx