entity

type Model struct {
	ID        string `gorm:"type:varchar(256);primarykey"`
	CreatedAt time.Time
	UpdatedAt time.Time
}

type Organization struct {
	Model
	Name        string     `gorm:"type:varchar(256);UNIQUE"`
	Description string     `gorm:"type:varchar(256)"`
	Users       []User     `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
	UserRoles   []UserRole `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
}

type Permission struct {
	Model
	Name        string `gorm:"type:varchar(256);UNIQUE"`
	Description string `gorm:"type:varchar(256)"`
}

type Resource struct {
	Method       string      `gorm:"type:varchar(256);primaryKey"`
	URI          string      `gorm:"type:varchar(256);primaryKey"`
	PermissionID string      `gorm:"type:varchar(256);primaryKey"`
	Permission   *Permission `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
}

type Role struct {
	Model
	Name            string           `gorm:"type:varchar(256);UNIQUE"`
	Description     string           `gorm:"type:varchar(256)"`
	RolePermissions []RolePermission `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
	UserRoles       []UserRole       `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE"`
}

type RolePermission struct {
	RoleID       string      `gorm:"type:varchar(256);primaryKey"`
	PermissionID string      `gorm:"type:varchar(256);primaryKey"`
	Permission   *Permission `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
}

type User struct {
	Key            string       `gorm:"type:varchar(256);primaryKey"`
	OrganizationID string       `gorm:"type:varchar(256);primaryKey"`
	Organization   Organization `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
	UserRoles      []UserRole   `gorm:"foreignKey:UserKey,OrganizationID;references:Key,OrganizationID;constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
}

type UserRole struct {
	UserKey        string `gorm:"type:varchar(256);primaryKey"`
	OrganizationID string `gorm:"type:varchar(256);primaryKey"`
	RoleID         string `gorm:"type:varchar(256);primaryKey"`
	Organization   Organization
	Role           Role
}