Table iliasRelease_3_9_x_branch.frm_posts 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
pos_pk bigint 19  √ 
pos_top_fk bigint 19 0
pos_thr_fk bigint 19 0
pos_usr_id bigint 19 0
pos_usr_alias varchar 255
pos_message text 65535
pos_subject text 65535
pos_date datetime 19 0000-00-00 00:00:00
pos_update datetime 19 0000-00-00 00:00:00
update_user int 10 0
pos_cens tinyint 3 0
pos_cens_com text 65535
notify bit 0 0
import_name text 65535  √  null
pos_status bit 0 1

Table contained 0 rows at Fri Dec 13 20:19 CET 2013

Indexes:
Column(s) Type Sort Constraint Name
pos_pk Primary key Asc PRIMARY
pos_message + pos_subject Performance Asc/Asc message_subject
pos_date Performance Asc pos_date
pos_thr_fk Performance Asc pos_thr_fk
pos_top_fk Performance Asc pos_top_fk