model

type AccessToken struct {
	AccessTokenID     uint32 `gorm:"primary_key"`
	TokenHash         string
	Name              string
	Description       string
	ProjectID         uint32
	ExpiredAt         time.Time
	LastUpdatedUserID uint32
	CreatedAt         time.Time
	UpdatedAt         time.Time
}

type AccessTokenRole struct {
	AccessTokenID uint32
	RoleID        uint32
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type Alert struct {
	AlertID          uint32 `gorm:"primary_key"`
	AlertConditionID uint32
	Description      string
	Severity         string
	ProjectID        uint32
	Status           string
	FirstViewedAt    *time.Time
	CreatedAt        time.Time
	UpdatedAt        time.Time
}

type AlertCondNotification struct {
	AlertConditionID uint32
	NotificationID   uint32
	ProjectID        uint32
	CacheSecond      uint32
	NotifiedAt       time.Time
	CreatedAt        time.Time
	UpdatedAt        time.Time
}

type AlertCondRule struct {
	AlertConditionID uint32
	AlertRuleID      uint32
	ProjectID        uint32
	CreatedAt        time.Time
	UpdatedAt        time.Time
}

type AlertCondition struct {
	AlertConditionID uint32 `gorm:"primary_key"`
	Description      string
	Severity         string
	ProjectID        uint32
	AndOr            string
	Enabled          bool
	CreatedAt        time.Time
	UpdatedAt        time.Time
}

type AlertHistory struct {
	AlertHistoryID uint32 `gorm:"primary_key"`
	HistoryType    string
	FindingHistory string
	AlertID        uint32
	Description    string
	Severity       string
	ProjectID      uint32
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type AlertRule struct {
	AlertRuleID  uint32 `gorm:"primary_key"`
	Name         string
	ProjectID    uint32
	Score        float32
	ResourceName string
	Tag          string
	FindingCnt   uint32
	CreatedAt    time.Time
	UpdatedAt    time.Time
}

type Finding struct {
	FindingID     uint64 `gorm:"primary_key"`
	Description   string
	DataSource    string
	DataSourceID  string
	ResourceName  string
	ProjectID     uint32
	OriginalScore float32
	Score         float32
	Data          string
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type FindingSetting struct {
	FindingSettingID uint32 `gorm:"primary_key"`
	ProjectID        uint32
	ResourceName     string
	Setting          string
	Status           string
	CreatedAt        time.Time
	UpdatedAt        time.Time
}

type FindingTag struct {
	FindingTagID uint64 `gorm:"primary_key"`
	FindingID    uint64
	ProjectID    uint32
	Tag          string
	CreatedAt    time.Time
	UpdatedAt    time.Time
}

type Notification struct {
	NotificationID uint32 `gorm:"primary_key"`
	Name           string
	ProjectID      uint32
	Type           string
	NotifySetting  string
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type Organization struct {
	OrganizationID uint32
	Name           string
	Description    string
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type OrganizationInvitation struct {
	OrganizationID uint32
	ProjectID      uint32
	Status         string
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type OrganizationPolicy struct {
	PolicyID       uint32 `gorm:"primary_key"`
	OrganizationID uint32
	Name           string
	ActionPtn      string
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type OrganizationProject struct {
	OrganizationID uint32
	ProjectID      uint32
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type OrganizationRole struct {
	RoleID         uint32 `gorm:"primary_key"`
	OrganizationID uint32
	Name           string
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type OrganizationRolePolicy struct {
	RoleID    uint32
	PolicyID  uint32
	CreatedAt time.Time
	UpdatedAt time.Time
}

type PendFinding struct {
	FindingID  uint64 `gorm:"primary_key"`
	ProjectID  uint32
	PendUserID uint32
	Note       string
	Reason     string
	ExpiredAt  time.Time
	CreatedAt  time.Time
	UpdatedAt  time.Time
}

type Policy struct {
	PolicyID    uint32 `gorm:"primary_key"`
	Name        string
	ProjectID   uint32
	ActionPtn   string
	ResourcePtn string
	CreatedAt   time.Time
	UpdatedAt   time.Time
}

type Project struct {
	ProjectID uint32
	Name      string
	CreatedAt time.Time
	UpdatedAt time.Time
}

type ProjectTag struct {
	ProjectID uint32
	Tag       string
	Color     string
	CreatedAt time.Time
	UpdatedAt time.Time
}

type Recommend struct {
	RecommendID    uint32 `gorm:"primary_key"`
	DataSource     string
	Type           string
	Risk           string
	Recommendation string
	CreatedAt      time.Time
	UpdatedAt      time.Time
}

type RecommendFinding struct {
	FindingID   uint64 `gorm:"primary_key"`
	RecommendID uint32
	ProjectID   uint32
	CreatedAt   time.Time
	UpdatedAt   time.Time
}

type RelAlertFinding struct {
	AlertID   uint32
	FindingID uint64
	ProjectID uint32
	CreatedAt time.Time
	UpdatedAt time.Time
}

type ReportFinding struct {
	ReportFindingID uint32 `gorm:"primary_key"`
	ReportDate      string
	ProjectID       uint32
	ProjectName     string
	DataSource      string
	Score           float32
	Count           uint32
	CreatedAt       time.Time
	UpdatedAt       time.Time
}

type Resource struct {
	ResourceID   uint64 `gorm:"primary_key"`
	ResourceName string
	ProjectID    uint32
	CreatedAt    time.Time
	UpdatedAt    time.Time
}

type ResourceTag struct {
	ResourceTagID uint64 `gorm:"primary_key"`
	ResourceID    uint64
	ProjectID     uint32
	Tag           string
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type Role struct {
	RoleID    uint32 `gorm:"primary_key"`
	Name      string
	ProjectID uint32
	CreatedAt time.Time
	UpdatedAt time.Time
}

type RolePolicy struct {
	RoleID    uint32
	PolicyID  uint32
	ProjectID uint32
	CreatedAt time.Time
	UpdatedAt time.Time
}

type User struct {
	UserID     uint32 `gorm:"primary_key"`
	Sub        string
	Name       string
	UserIdpKey string
	Activated  bool
	IsAdmin    bool
	CreatedAt  time.Time
	UpdatedAt  time.Time
}

type UserOrganizationRole struct {
	RoleID    uint32
	UserID    uint32
	CreatedAt time.Time
	UpdatedAt time.Time
}

type UserReserved struct {
	ReservedID uint32 `gorm:"primary_key"`
	UserIdpKey string
	RoleID     uint32
	CreatedAt  time.Time
	UpdatedAt  time.Time
}

type UserRole struct {
	UserID    uint32
	RoleID    uint32
	ProjectID uint32
	CreatedAt time.Time
	UpdatedAt time.Time
}