SchemaSpy - Table ilias4_3.ecs

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
server_id	int	10		0
active	tinyint	3	√	0
protocol	tinyint	3	√	1
server	varchar	255	√	null
port	smallint	5	√	1
auth_type	tinyint	3	√	1
client_cert_path	varchar	512	√	null
ca_cert_path	varchar	512	√	null
key_path	varchar	512	√	null
key_password	varchar	32	√	null
cert_serial	varchar	32	√	null
polling_time	int	10	√	0
import_id	int	10	√	0
global_role	int	10	√	0
econtent_rcp	varchar	512	√	null
user_rcp	varchar	512	√	null
approval_rcp	varchar	512	√	null
duration	int	10	√	0
title	varchar	128	√	null
auth_user	varchar	32	√	null
auth_pass	varchar	32	√	null

Table contained 0 rows at Sun May 01 00:15 CEST 2016

Indexes:

Column(s)	Type	Sort	Constraint Name
server_id	Primary key	Asc	PRIMARY