smb_users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
EmailActivations.smbUserId fk_EmailActivations_smb_users1 R
fileSharingUsers.userId fileSharingUsers_ibfk_1 R
mail.userId mail_ibfk_1 R
smb_servicePermissionAccounts.userId smb_servicePermissionAccounts_ibfk_1 R
smb_userServicePermissions.userId smb_userServicePermissions_ibfk_1 R
login VARCHAR 255 √ null
password VARCHAR 255 √ null
contactName VARCHAR 255 √ null
email VARCHAR 255 √ null
companyName VARCHAR 255 √ null
phone VARCHAR 255 √ null
fax VARCHAR 255 √ null
address TEXT 65535 √ null
city VARCHAR 255 √ null
state VARCHAR 255 √ null
zip VARCHAR 255 √ null
country VARCHAR 255 √ null
creationDate VARCHAR 25 null
isBuiltIn INT 10 √ 0
isDomainAdmin INT 10 √ 0
roleId INT 10 null
smb_roles.id smb_users_ibfk_1 R
uuid VARCHAR 36 null
isLocked INT 10 √ 0
authCookie VARCHAR 255 √ null
sessionId VARCHAR 255 √ null
externalId VARCHAR 255 √ null
ownerId INT UNSIGNED 10 √ null
clients.id smb_users_ibfk_2 R
additionalInfo TEXT 65535 √ null
imNumber VARCHAR 255 √ null
imType INT 10 √ null
isLegacyUser INT 10 √ 0
subscriptionDomainId INT UNSIGNED 10 √ 0
domains.id smb_users_ibfk_3 R
locale VARCHAR 17 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
isBuiltIn_idx Performance Asc isBuiltIn
login Must be unique Asc login
ownerId_idx Performance Asc ownerId
roleId Performance Asc roleId
subscriptionDomainId_idx Performance Asc subscriptionDomainId
uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation