SchemaSpy - Table iliaseassessment.ut

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
id	int	10		0
user_id	int	10		0
action_type	char	10	√	null
php_script	char	100	√	null
client_ip	char	15	√	null
acc_obj_type	char	10	√	null
acc_obj_id	int	10		0
acc_sub_type	char	10	√	null
acc_sub_id	int	10		0
language	char	15	√	null
browser	char	255	√	null
session_id	char	40	√	null
acc_time	datetime	19	√	null
ut_month	varchar	10	√	null

Table contained 0 rows at Mon Apr 25 19:42 CEST 2016

Indexes:

Column(s)	Type	Sort	Constraint Name
id	Primary key	Asc	PRIMARY
acc_obj_id + acc_sub_id + session_id	Performance	Asc/Asc/Asc	i1_idx