SchemaSpy - Table ad4529b5.folders

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
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
acl_team_set_id	char	36	√	null
created_by	char	36
modified_by	char	36
deleted	bit	1	√	0

Analyzed at Wed Feb 28 08:47 UTC 2018

Indexes:

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