dbModel

type Account struct {
	ID                     uint64 `gorm:"primaryKey"`
	GroupId                uint64 `gorm:"not null"`
	Username               string `gorm:"not null"`
	KeyHash                *string
	HomeDirectory          string `gorm:"not null"`
	IsSuperAdmin           bool   `gorm:"not null"`
	SecureAccessPublicKeys []SecureAccessPublicKey
	CreatedAt              time.Time
	UpdatedAt              time.Time
}

type ActivityRecord struct {
	ID                uint64 `gorm:"primaryKey"`
	RecordLevel       string `gorm:"not null"`
	RecordCode        string `gorm:"not null"`
	AffectedResources []ActivityRecordAffectedResource
	RecordDetails     *string
	OperatorAccountId *uint64
	OperatorIpAddress *string
	CreatedAt         time.Time `gorm:"not null"`
}

type ActivityRecordAffectedResource struct {
	ID                       uint64 `gorm:"primaryKey"`
	SystemResourceIdentifier string `gorm:"not null"`
	ActivityRecordID         uint64 `gorm:"not null"`
}

type InstalledService struct {
	Name                 string `gorm:"primarykey;not null"`
	Nature               string `gorm:"not null"`
	Type                 string `gorm:"not null"`
	Version              string `gorm:"not null"`
	StartCmd             string `gorm:"not null"`
	Envs                 *string
	PortBindings         *string
	StopTimeoutSecs      int64
	StopCmdSteps         *string
	PreStartTimeoutSecs  int64
	PreStartCmdSteps     *string
	PostStartTimeoutSecs int64
	PostStartCmdSteps    *string
	PreStopTimeoutSecs   int64
	PreStopCmdSteps      *string
	PostStopTimeoutSecs  int64
	PostStopCmdSteps     *string
	ExecUser             *string
	WorkingDirectory     *string
	StartupFile          *string
	AutoStart            *bool
	AutoRestart          *bool
	TimeoutStartSecs     *uint
	MaxStartRetries      *uint
	LogOutputPath        *string
	LogErrorPath         *string
	AvatarUrl            *string
	CreatedAt            time.Time `gorm:"not null"`
	UpdatedAt            time.Time `gorm:"not null"`
}

type Mapping struct {
	ID                            uint64 `gorm:"primaryKey"`
	Hostname                      string `gorm:"not null"`
	Path                          string `gorm:"not null"`
	MatchPattern                  string `gorm:"not null"`
	TargetType                    string `gorm:"not null"`
	TargetValue                   *string
	TargetHttpResponseCode        *string
	ShouldUpgradeInsecureRequests *bool
	MarketplaceInstalledItemID    *uint
	MarketplaceInstalledItemName  *string
	MappingSecurityRuleID         *uint64
	CreatedAt                     time.Time `gorm:"not null"`
	UpdatedAt                     time.Time `gorm:"not null"`
}

type MappingSecurityRule struct {
	ID                             uint64 `gorm:"primaryKey"`
	Name                           string `gorm:"not null"`
	Description                    *string
	AllowedIps                     []string `gorm:"serializer:json"`
	BlockedIps                     []string `gorm:"serializer:json"`
	RpsSoftLimitPerIp              *uint
	RpsHardLimitPerIp              *uint
	ResponseCodeOnMaxRequests      *uint
	MaxConnectionsPerIp            *uint
	BandwidthBpsLimitPerConnection *uint64
	BandwidthLimitOnlyAfterBytes   *uint64
	ResponseCodeOnMaxConnections   *uint
	CreatedAt                      time.Time `gorm:"not null"`
	UpdatedAt                      time.Time `gorm:"not null"`
}

type MarketplaceInstalledItem struct {
	ID               uint16 `gorm:"primaryKey"`
	Name             string `gorm:"not null"`
	Hostname         string `gorm:"not null"`
	Type             string `gorm:"not null"`
	UrlPath          string `gorm:"not null"`
	InstallDirectory string `gorm:"not null"`
	InstallUuid      string `gorm:"not null"`
	Services         string
	Mappings         []Mapping
	AvatarUrl        string    `gorm:"not null"`
	Slug             string    `gorm:"not null"`
	CreatedAt        time.Time `gorm:"not null"`
	UpdatedAt        time.Time `gorm:"not null"`
}

type ScheduledTask struct {
	ID          uint64 `gorm:"primaryKey"`
	Name        string `gorm:"not null"`
	Status      string `gorm:"not null,index"`
	Command     string `gorm:"not null"`
	Tags        []ScheduledTaskTag
	TimeoutSecs *uint16
	RunAt       *time.Time
	Output      *string
	Error       *string
	StartedAt   *time.Time
	FinishedAt  *time.Time
	ElapsedSecs *uint32
	CreatedAt   time.Time `gorm:"not null"`
	UpdatedAt   time.Time `gorm:"not null"`
}

type ScheduledTaskTag struct {
	ID              uint64 `gorm:"primaryKey"`
	Tag             string `gorm:"not null"`
	ScheduledTaskID uint64 `gorm:"not null"`
}

type SecureAccessPublicKey struct {
	ID        uint16 `gorm:"primaryKey"`
	AccountID uint64 `gorm:"not null"`
	Name      string `gorm:"not null"`
	Content   string `gorm:"not null"`
	CreatedAt time.Time
	UpdatedAt time.Time
}

type VirtualHost struct {
	Hostname       string        `gorm:"primaryKey"`
	Type           string        `gorm:"not null"`
	RootDirectory  string        `gorm:"not null"`
	ParentHostname *string       `gorm:"index"`
	IsPrimary      bool          `gorm:"not null;default:false"`
	IsWildcard     bool          `gorm:"not null;default:false"`
	Aliases        []VirtualHost `gorm:"foreignKey:ParentHostname"`
	CreatedAt      time.Time     `gorm:"not null"`
	UpdatedAt      time.Time     `gorm:"not null"`
}