sys_users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
ftp_users.sys_user_id ftp_users_ibfk_2 R
hosting.sys_user_id hosting_ibfk_2 R
ScheduledTasks.sysUserId ScheduledTasks_ibfk_2 R
subdomains.sys_user_id subdomains_ibfk_1 R
web_users.sys_user_id web_users_ibfk_2 R
serviceNodeId INT UNSIGNED 10 0
ServiceNodes.id sys_users_ibfk_1 R
login VARCHAR 20 null
account_id INT UNSIGNED 10 0
accounts.id sys_users_ibfk_2 R
home VARCHAR 255 null
shell VARCHAR 255 null
quota BIGINT UNSIGNED 20 0
mapped_to INT UNSIGNED 10 √ null

Table contained 0 rows

Indexes

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

Relationships

Close relationships within degrees of separation