SchemaSpy - Table ss720en.notifications

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	255	√	null
date_entered	datetime	19	√	null
date_modified	datetime	19	√	null
modified_user_id	char	36	√	null
created_by	char	36	√	null
description	text	65535	√	null
deleted	bit	1	√	0
assigned_user_id	char	36	√	null
is_read	bit	1	√	0
severity	varchar	15	√	null
parent_type	varchar	100	√	null
parent_id	char	36	√	null

Analyzed at Mon Apr 21 08:36 UTC 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
id	Primary key	Asc	PRIMARY
assigned_user_id + is_read + deleted	Performance	Asc/Asc/Asc	idx_notifications_my_unread_items
date_modified	Performance	Asc	notificationsmod