Table iliasRelease_5_0_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 0
pos_top_fk bigint 19 0
pos_thr_fk bigint 19 0
pos_usr_alias varchar 255  √  null
pos_subject varchar 4000  √  null
pos_date datetime 19  √  null
pos_update datetime 19  √  null
update_user int 10 0
pos_cens tinyint 3 0
pos_cens_com varchar 4000  √  null
notify tinyint 3 0
import_name varchar 4000  √  null
pos_status tinyint 3 1
pos_message longtext 2147483647  √  null
pos_author_id int 10 0
pos_display_user_id int 10 0
is_author_moderator tinyint 3  √  null

Table contained 0 rows at Thu Apr 28 00:43 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
pos_pk Primary key Asc PRIMARY
pos_thr_fk Performance Asc i1_idx
pos_top_fk Performance Asc i2_idx
pos_date Performance Asc i3_idx
pos_subject Performance Asc i4_idx