sql

type ACL struct {
	ID          int64      `gorm:"primaryKey;column:id;autoIncrement;"`
	ActionName  string     `gorm:"column:action_name;type:varchar(500);index:,unique,composite:acls_u1"`
	ActionValue string     `gorm:"column:action_value;type:varchar(500)"`
	RoleID      int        `gorm:"column:role_id;default:-1;index:,unique,composite:acls_u1"`
	WorkspaceID int        `gorm:"column:workspace_id; default:-1;index:,unique,composite:acls_u1"`
	NodeID      int        `gorm:"column:node_id; default:-1;index:,unique,composite:acls_u1"`
	Role        Role       `gorm:"foreignKey:RoleID"`
	Workspace   Workspace  `gorm:"foreignKey:WorkspaceID"`
	Node        Node       `gorm:"foreignKey:NodeID"`
	Creation    time.Time  `gorm:"column:created_at;type:timestamp;default:current_timestamp;"`
	Expiry      *time.Time `gorm:"column:expires_at;type:TIMESTAMP NULL DEFAULT NULL"`
}

type Node struct {
	ID   int    `gorm:"primaryKey; column:id; autoIncrement;"`
	UUID string `gorm:"column:uuid; unique; type:varchar(500)"`
}

type Role struct {
	ID   int    `gorm:"primaryKey; column:id; autoIncrement;"`
	UUID string `gorm:"column:uuid; unique; type:varchar(500)"`
}

type Workspace struct {
	ID   int    `gorm:"primaryKey; column:id; autoIncrement;"`
	UUID string `gorm:"column:name; unique; type:varchar(500)"`
}