model

type Activity struct {
	ID                 uuid.UUID `gorm:"type:uuid;primaryKey;default:uuid_generate_v4()"`
	ProviderID         uuid.UUID
	ResourceID         uuid.UUID
	ProviderActivityID string
	AccountType        string
	AccountID          string
	Timestamp          time.Time
	Authorizations     pq.StringArray `gorm:"type:text[]"`
	RelatedPermissions pq.StringArray `gorm:"type:text[]"`
	Type               string
	Metadata           datatypes.JSON
	CreatedAt          time.Time `gorm:"autoCreateTime"`

	Provider *Provider `gorm:"ForeignKey:ProviderID;References:ID"`
	Resource *Resource `gorm:"ForeignKey:ResourceID;References:ID"`
}

type Appeal struct {
	ID            uuid.UUID `gorm:"type:uuid;primaryKey;default:uuid_generate_v4()"`
	ResourceID    string
	PolicyID      string
	PolicyVersion uint
	Status        string
	AccountID     string
	AccountType   string
	GroupID       sql.NullString
	GroupType     sql.NullString
	CreatedBy     string
	Creator       datatypes.JSON
	Role          string
	Permissions   pq.StringArray `gorm:"type:text[]"`
	Options       datatypes.JSON
	Labels        datatypes.JSON
	Details       datatypes.JSON
	Description   string

	Resource  *Resource `gorm:"ForeignKey:ResourceID;References:ID"`
	Policy    Policy    `gorm:"ForeignKey:PolicyID,PolicyVersion;References:ID,Version"`
	Approvals []*Approval
	Grant     *Grant

	Revision uint

	CreatedAt time.Time      `gorm:"autoCreateTime"`
	UpdatedAt time.Time      `gorm:"autoUpdateTime"`
	DeletedAt gorm.DeletedAt `gorm:"index"`
}

type Approval struct {
	ID            uuid.UUID `gorm:"type:uuid;primaryKey;default:uuid_generate_v4()"`
	Name          string    `gorm:"index"`
	Index         int
	AppealID      string
	Status        string
	Actor         *string
	Reason        string
	PolicyID      string
	PolicyVersion uint

	Approvers []Approver
	Appeal    *Appeal

	IsStale        bool
	AppealRevision uint

	CreatedAt time.Time      `gorm:"autoCreateTime"`
	UpdatedAt time.Time      `gorm:"autoUpdateTime"`
	DeletedAt gorm.DeletedAt `gorm:"index"`
}

type Approver struct {
	ID         uuid.UUID `gorm:"type:uuid;primaryKey;default:uuid_generate_v4()"`
	ApprovalID string
	AppealID   string `gorm:"index"`
	Email      string `gorm:"index"`

	CreatedAt time.Time      `gorm:"autoCreateTime"`
	UpdatedAt time.Time      `gorm:"autoUpdateTime"`
	DeletedAt gorm.DeletedAt `gorm:"index"`
}

type Comment struct {
	ID         uuid.UUID `gorm:"type:uuid;primaryKey;default:uuid_generate_v4()"`
	ParentType string
	ParentID   string
	CreatedBy  string
	Body       string
	CreatedAt  time.Time      `gorm:"autoCreateTime"`
	UpdatedAt  time.Time      `gorm:"autoUpdateTime"`
	DeletedAt  gorm.DeletedAt `gorm:"index"`
}

type Grant struct {
	ID                      uuid.UUID `gorm:"type:uuid;primaryKey;default:uuid_generate_v4()"`
	Status                  string
	StatusInProvider        string
	AccountID               string
	AccountType             string
	GroupID                 sql.NullString
	GroupType               sql.NullString
	ResourceID              string
	Role                    string
	Permissions             pq.StringArray `gorm:"type:text[]"`
	IsPermanent             bool
	ExpirationDate          time.Time
	RequestedExpirationDate sql.NullTime
	ExpirationDateReason    sql.NullString
	AppealID                sql.NullString
	Source                  string
	RevokedBy               string
	RevokedAt               time.Time
	RevokeReason            string
	RestoredBy              sql.NullString
	RestoredAt              sql.NullTime
	RestoreReason           sql.NullString
	Owner                   string
	CreatedAt               time.Time      `gorm:"autoCreateTime"`
	UpdatedAt               time.Time      `gorm:"autoUpdateTime"`
	DeletedAt               gorm.DeletedAt `gorm:"index"`

	Resource *Resource `gorm:"ForeignKey:ResourceID;References:ID"`
	Appeal   *Appeal   `gorm:"ForeignKey:AppealID;References:ID"`
}

type Policy struct {
	ID           string `gorm:"primaryKey"`
	Version      uint   `gorm:"primaryKey"`
	Description  string
	Steps        datatypes.JSON
	AppealConfig datatypes.JSON
	Labels       datatypes.JSON
	Requirements datatypes.JSON
	IAM          datatypes.JSON
	CreatedAt    time.Time      `gorm:"autoCreateTime"`
	UpdatedAt    time.Time      `gorm:"autoUpdateTime"`
	DeletedAt    gorm.DeletedAt `gorm:"index"`
}

type Provider struct {
	ID        uuid.UUID `gorm:"type:uuid;primaryKey;default:uuid_generate_v4()"`
	Type      string    `gorm:"uniqueIndex:provider_index"`
	URN       string    `gorm:"uniqueIndex:provider_index"`
	Config    datatypes.JSON
	CreatedAt time.Time      `gorm:"autoCreateTime"`
	UpdatedAt time.Time      `gorm:"autoUpdateTime"`
	DeletedAt gorm.DeletedAt `gorm:"index"`
}

type Resource struct {
	ID           uuid.UUID `gorm:"type:uuid;primaryKey;default:uuid_generate_v4()"`
	ParentID     *string   `gorm:"type:uuid"`
	ProviderType string    `gorm:"uniqueIndex:resource_index"`
	ProviderURN  string    `gorm:"uniqueIndex:resource_index"`
	Type         string    `gorm:"uniqueIndex:resource_index"`
	URN          string    `gorm:"uniqueIndex:resource_index"`
	Name         string
	Details      datatypes.JSON
	Labels       datatypes.JSON
	GlobalURN    *string `gorm:"uniqueIndex:resource_global_urn"`
	GroupID      sql.NullString
	GroupType    sql.NullString

	Children []Resource `gorm:"ForeignKey:ParentID;References:ID"`
	Provider Provider   `gorm:"ForeignKey:ProviderType,ProviderURN;References:Type,URN"`

	CreatedAt time.Time      `gorm:"autoCreateTime"`
	UpdatedAt time.Time      `gorm:"autoUpdateTime"`
	DeletedAt gorm.DeletedAt `gorm:"index"`
	IsDeleted bool
}