Definition

Diagram

Application

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
ID	uint64	id	bigint(20) unsigned	true
ApplicationKey	string	application_key	varchar(127)	true
ApplicationName	string	application_name	varchar(127)	true
ApplicationDescription	*string	application_description	varchar(255)	false
ClientID	string	client_id	varchar(64)	true
ClientSecret	string	client_secret	varchar(127)	true
RedirectUri	string	redirect_uri	varchar(255)	true
Status	int	status	int(10)	true	lt 0 deleted, 0 pendding, 1 valid
CreatedAt	*time.Time	created_at	timestamp	false
UpdatedAt	*time.Time	updated_at	timestamp	false

Role

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
ID	uint64	id	bigint(20) unsigned	true
RoleName	string	role_name	varchar(127)	true
RoleDescription	*string	role_description	varchar(255)	false
Status	int	status	int(10)	true	-1 deleted 0 pendding 1 valid
CreatedAt	*time.Time	created_at	timestamp	false
UpdatedAt	*time.Time	updated_at	timestamp	false

User

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
ID	uint64	id	bigint(20) unsigned	true
Ref	uint64	ref	bigint(20) unsigned	true	ref to userID who invited this user
OutKey	*string	out_key	varchar(255)	false	outer system's key
FirstName	string	first_name	varchar(127)	true
LastName	string	last_name	varchar(127)	true
AvatarUrl	*string	avatar_url	varchar(255)	false
PhotoUrl	*string	photo_url	varchar(255)	false
Password	string	password	varchar(255)	true
RememberToken	*string	remember_token	varchar(255)	false
Status	int	status	int(10)	true	-1 deleted 0 pendding 1 valid
CreatedAt	*time.Time	created_at	timestamp	false
UpdatedAt	*time.Time	updated_at	timestamp	false

ApplicationRole

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
ApplicationID	uint64	application_id	bigint(20) unsigned	true
RoleID	uint64	role_id	bigint(20) unsigned	true
Right	int64	right	bigint(20)	true
CreatedAt	*time.Time	created_at	timestamp	false
UpdatedAt	*time.Time	updated_at	timestamp	false

ApplicationUser

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
ApplicationID	uint64	application_id	bigint(20) unsigned	true
UserID	uint64	user_id	bigint(20) unsigned	true
Right	int64	right	bigint(20)	true
CreatedAt	*time.Time	created_at	timestamp	false
UpdatedAt	*time.Time	updated_at	timestamp	false

Email

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
ID	uint64	id	bigint(20) unsigned	true
UserID	uint64	user_id	bigint(20) unsigned	true
EmailAddress	string	email_address	varchar(127)	true
EmailVerifiedAt	*time.Time	email_verified_at	timestamp	false
Status	int	status	int(10)	true	-1 deleted 0 pendding 1 valid
CreatedAt	*time.Time	created_at	timestamp	false
UpdatedAt	*time.Time	updated_at	timestamp	false

Phone

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
ID	uint64	id	bigint(20) unsigned	true
UserID	uint64	user_id	bigint(20) unsigned	true
PhoneNumber	string	phone_number	varchar(16)	true
PhoneVerifiedAt	*time.Time	phone_verified_at	timestamp	false
Status	int	status	int(10)	true	lt 0 deleted, 0 pendding, 1 valid
CreatedAt	*time.Time	created_at	timestamp	false
UpdatedAt	*time.Time	updated_at	timestamp	false

RoleUser

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
RoleID	uint64	role_id	bigint(20) unsigned	true
UserID	uint64	user_id	bigint(20) unsigned	true

Token

AttributeName	AttributeType	ColumnName	DataType	NotNull	Comment
ID	uint64	id	bigint(20) unsigned	true
UserID	uint64	user_id	bigint(20) unsigned	true
AccessToken	string	access_token	varchar(255)	true
RefreshToken	string	refresh_token	varchar(255)	true
Scope	string	scope	varchar(255)	true
Code	string	code	varchar(32)	true	use in oauth2 code
CodeChallenge	*string	code_challenge	varchar(64)	false	oauth2 PKCE
TokenType	string	token_type	varchar(255)	true	Bearer
ExpireAt	*time.Time	expire_at	timestamp	false
Client	string	client	varchar(255)	true
Version	string	version	varchar(255)	true
CreatedAt	*time.Time	created_at	timestamp	false
UpdatedAt	*time.Time	updated_at	timestamp	false