Table iliasRelease_3_8_x_branch.frm_posts Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
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

Table contained 0 rows at Fri Dec 13 17:53 CET 2013

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