Table ab509734.folders 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
id char 36
name varchar 25  √  null
folder_type varchar 25  √  null
parent_folder char 36  √  null
has_child bit 1  √  0
is_group bit 1  √  0
is_dynamic bit 1  √  0
dynamic_query text 65535  √  null
assign_to_id char 36  √  null
team_id char 36  √  null
team_set_id char 36  √  null
created_by char 36
modified_by char 36
deleted bit 1  √  0

Analyzed at Mon Jun 15 09:01 UTC 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
parent_folder Performance Asc idx_parent_folder