records

type Accounts struct {
	gorm.Model
	Username string   `gorm:"type:varchar(200);unique;"` // unique
	Password string   `gorm:"type:varchar(200);"`
	Email    string   `gorm:"type:varchar(200);unique;"` // unique
	Roles    []*Roles `gorm:"many2many:account_roles;"`
}

type Authorizations struct {
	gorm.Model
	ID          uint     `gorm:"primaryKey;autoIncrement;"`
	Name        string   `gorm:"type:varchar(200);"`
	Description string   `gorm:"type:varchar(200);"`
	Roles       []*Roles `gorm:"many2many:role_authorizations;"`
}

type Products struct {
	gorm.Model
	ID          int    `gorm:"primaryKey;autoIncrement;"`
	Name        string `gorm:"type:varchar(200);"`
	Description string `gorm:"type:varchar(200);"`
}

type RoleAuthorizations struct {
	RolesID          int `gorm:"primaryKey;autoIncrement:false;"`
	AuthorizationsID int `gorm:"primaryKey;autoIncrement:false;"`
}

type Roles struct {
	gorm.Model
	ID             int               `gorm:"primaryKey;autoIncrement;"`
	Name           string            `gorm:"type:varchar(200);unique;"`
	Description    string            `gorm:"type:varchar(200);"`
	Accounts       []*Accounts       `gorm:"many2many:account_roles;"`
	Authorizations []*Authorizations `gorm:"many2many:role_authorizations;"`
}

type Users struct {
	gorm.Model
	ID       string `gorm:"type:uuid;default:uuid_generate_v4();primaryKey;"`
	Username string `json:"username" gorm:"type:varchar(200);"`
	Email    string `json:"email" gorm:"type:varchar(200);"`
	Password string `json:"password" gorm:"type:varchar(200);"`
	Active   bool   `json:"active" gorm:"type:boolean;"`
	RoleId   int    `json:"role_id" gorm:"type:integer;"`
}