sys_users

Columns

Related columns Constraint Comments

Search:

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

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

Showing 1 to 8 of 8 entries

Table contained 0 rows

Indexes

Search:

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

Showing 1 to 4 of 4 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation