entity

type Client struct {
	Id        string     `db:"id"`
	Name      string     `db:"name"`
	Icon      *string    `db:"icon"`
	Secret    string     `db:"secret"`
	Callback  string     `db:"callback"`
	IsSystem  bool       `db:"is_system"`
	CreatedAt time.Time  `db:"created_at"`
	UpdatedAt time.Time  `db:"updated_at"`
	DeletedAt *time.Time `db:"deleted_at"`
}

type ClientRole struct {
	*Client `db:""`
	Role    string
}

type Payload map[string]string

type Role struct {
	ClientId string `db:"client_id"`
	UserId   string `db:"user_id"`
	Role     string `db:"role"`
}

type Session struct {
	Id        string    `db:"id"`
	UserId    string    `db:"user_id"`
	Ip        string    `db:"ip"`
	Agent     string    `db:"agent"`
	CreatedAt time.Time `db:"created_at"`
	UpdatedAt time.Time `db:"updated_at"`
}

type SessionUser struct {
	*Session
	*User
}

type Token struct {
	Id         string    `db:"id"`
	Class      string    `db:"class"`
	Hash       string    `db:"hash"`
	SessionId  *string   `db:"session_id"`
	UserId     *string   `db:"user_id"`
	ClientId   *string   `db:"client_id"`
	Payload    Payload   `db:"payload"`
	NotBefore  time.Time `db:"not_before"`
	Expiration time.Time `db:"expiration"`
	CreatedAt  time.Time `db:"created_at"`
	UpdatedAt  time.Time `db:"updated_at"`
}

type User struct {
	Id        string     `db:"id"`
	Name      string     `db:"name"`
	Email     string     `db:"email"`
	Password  string     `db:"password"`
	CreatedAt time.Time  `db:"created_at"`
	UpdatedAt time.Time  `db:"updated_at"`
	DeletedAt *time.Time `db:"deleted_at"`
}