db_users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
data_bases.default_user_id data_bases_ibfk_3 R
DatabaseUserRemoteAccessRules.databaseUserId DatabaseUserRemoteAccessRules_ibfk_1 R
login VARCHAR 128 null
account_id INT UNSIGNED 10 null
accounts.id db_users_ibfk_1 R
db_id INT UNSIGNED 10 0
data_bases.id db_users_ibfk_2 R
status enum('normal', 'orphaned') 8 normal
dom_id INT UNSIGNED 10 0
domains.id db_users_ibfk_3 R
db_server_id INT UNSIGNED 10 0
DatabaseServers.id db_users_ibfk_4 R
passwd VARCHAR 16 null
external_id VARCHAR 255 √ null
BlUpgrades.id Implied Constraint R
role VARCHAR 255 readWrite

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
account_id Performance Asc account_id
db_id Performance Asc db_id
db_server_id Must be unique Asc/Asc/Asc db_server_id + db_id + login
dom_id Performance Asc dom_id

Relationships

Close relationships within degrees of separation