User

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
UserId BIGINT UNSIGNED 20 √ null
FirstName VARCHAR 200 √ null
LastName VARCHAR 200 √ null
Id VARCHAR 200 null
email VARCHAR 255 null
api_token VARCHAR 200 √ null
EmailConfirmed TINYINT 3 null
EmailVerifiedAt TIMESTAMP 19 √ null
password VARCHAR 255 null
SecurityStamp LONGTEXT 2147483647 √ null
PhoneNumber INT 10 √ null
PhoneNumberConfirmed TINYINT 3 null
TwoFactorEnabled TINYINT 3 null
LockoutEndDateUtc DATETIME 19 √ null
LockoutEnabled TINYINT 3 null
AccessFailedCount INT 10 null
UserName VARCHAR 250 null
Admin TINYINT 3 null
OrganisationID INT 10 √ null
Organisation.OrganisationID Implied Constraint R
CatalogID INT 10 √ null
VerifyCode VARCHAR 50 √ null
remember_token VARCHAR 100 √ null
IsActive INT 10 √ 1
SetupComplete INT 10 0
created_at DATETIME 19 √ CURRENT_TIMESTAMP
updated_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc UserId
email Must be unique Asc email

Relationships

Close relationships within degrees of separation