SchemaSpy - Table ae392fe7.systems

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Auto	Default
id	char	36
system_id	int	11		√
system_key	varchar	36	√		null
user_id	char	36	√		null
last_connect_date	datetime	19	√		null
status	varchar	255	√		Active
num_syncs	int	11	√		0
system_name	varchar	100	√		null
install_method	varchar	100	√		null
date_entered	datetime	19	√		null
date_modified	datetime	19	√		null
deleted	bit	1	√		0

Analyzed at Wed Jun 07 08:12 UTC 2017

Indexes:

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