DatabaseServers


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
data_bases.db_server_id data_bases_ibfk_2 R
db_users.db_server_id db_users_ibfk_4 R
host VARCHAR 63 null
port INT UNSIGNED 10 √ null
type enum('mysql', 'postgresql', 'mssql') 10 mysql
server_version CHAR 255 √ null
admin_login CHAR 255 null
admin_password CHAR 255 null
parameters_id INT UNSIGNED 10 √ null
Parameters.id DatabaseServers_ibfk_1 R
last_error enum('no_error', 'connection_failed', 'permission_denied', 'other_error', 'credentials_not_set') 19 no_error

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
host_port Performance Asc/Asc host + port
parameters_id Performance Asc parameters_id

Relationships

Close relationships within degrees of separation