model

type Device struct {
	Name string `gorm:"primaryKey" json:"name"`
}

type DyldSharedCache struct {
	UUID      string `gorm:"primaryKey" json:"uuid"`
	CreatedAt time.Time
	UpdatedAt time.Time
	DeletedAt gorm.DeletedAt `gorm:"index"`

	SharedRegionStart uint64   `json:"shared_region_start,omitempty"`
	Images            []*Macho `gorm:"many2many:dsc_images;" json:"images,omitempty"`
}

type Entitlement struct {
	ID      uint64 `gorm:"primaryKey" json:"id"`
	IpswID  string `gorm:"uniqueIndex:idx_unique_entitlement,priority:1;not null" json:"ipsw_id"`
	PathID  uint   `gorm:"uniqueIndex:idx_unique_entitlement,priority:2;not null" json:"path_id"`
	KeyID   uint   `gorm:"uniqueIndex:idx_unique_entitlement,priority:3;not null" json:"key_id"`
	ValueID uint   `gorm:"uniqueIndex:idx_unique_entitlement,priority:4;not null" json:"value_id"`

	// Foreign key relationships
	Ipsw  *Ipsw             `gorm:"foreignKey:IpswID" json:"ipsw,omitempty"`
	Path  *Path             `gorm:"foreignKey:PathID" json:"path,omitempty"`
	Key   *EntitlementKey   `gorm:"foreignKey:KeyID" json:"key,omitempty"`
	Value *EntitlementValue `gorm:"foreignKey:ValueID" json:"value,omitempty"`
}

type EntitlementKey struct {
	ID  uint   `gorm:"primaryKey" json:"id"`
	Key string `gorm:"type:text;uniqueIndex;not null" json:"key"`
}

type EntitlementQuery struct {
	Version      string
	Build        string
	Device       string
	KeyPattern   string
	ValuePattern string
	FilePath     string
}

type EntitlementValue struct {
	ID        uint   `gorm:"primaryKey" json:"id"`
	Value     string `gorm:"type:text;not null" json:"value"`
	ValueType string `gorm:"type:varchar(10);not null;check:value_type IN ('bool','string','array','dict','number')" json:"value_type"`
	ValueHash string `gorm:"type:char(16);uniqueIndex;not null" json:"value_hash"` // Shortened hash for uniqueness
}

type Ipsw struct {
	ID         string             `gorm:"primaryKey" json:"id"`
	Name       string             `json:"name,omitempty"`
	Version    string             `gorm:"index:idx_platform_version,priority:2" json:"version,omitempty"`
	BuildID    string             `gorm:"column:buildid" json:"buildid,omitempty"`
	Platform   Platform           `gorm:"type:varchar(20);index:idx_platform_version,priority:1" json:"platform,omitempty"`
	Devices    []*Device          `gorm:"many2many:ipsw_devices;" json:"devices,omitempty"`
	Kernels    []*Kernelcache     `gorm:"many2many:ipsw_kernels;" json:"kernels,omitempty"`
	DSCs       []*DyldSharedCache `gorm:"many2many:ipsw_dscs;" json:"dscs,omitempty"`
	FileSystem []*Macho           `gorm:"many2many:ipsw_files;" json:"file_system,omitempty"`

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

type Kernelcache struct {
	UUID      string         `gorm:"primaryKey" json:"uuid"`
	CreatedAt time.Time      `json:"created_at"`
	UpdatedAt time.Time      `json:"updated_at"`
	DeletedAt gorm.DeletedAt `gorm:"index" json:"deleted_at"`

	Version string   `json:"version,omitempty"`
	Kexts   []*Macho `gorm:"many2many:kernelcache_kexts;" json:"kexts,omitempty"`
}

type Macho struct {
	UUID string `gorm:"primaryKey" json:"uuid"`
	// swagger:ignore
	PathID    uint
	Path      Path      `gorm:"foreignKey:PathID"`
	TextStart uint64    `gorm:"type:bigint" json:"text_start,omitempty"`
	TextEnd   uint64    `gorm:"type:bigint" json:"text_end,omitempty"`
	Symbols   []*Symbol `gorm:"many2many:macho_syms;"`
}

type Name struct {
	// swagger:ignore
	ID   uint   `gorm:"primaryKey"`
	Name string `gorm:"uniqueIndex" json:"name,omitempty"`
}

type Path struct {
	// swagger:ignore
	ID   uint   `gorm:"primaryKey" json:"id"`
	Path string `gorm:"uniqueIndex;not null" json:"path"`
}

type Platform string

type Symbol struct {
	// swagger:ignore
	ID uint `gorm:"primaryKey"`
	// swagger:ignore
	NameID uint
	Name   Name   `gorm:"foreignKey:NameID"`
	Start  uint64 `gorm:"type:bigint" json:"start"`
	End    uint64 `gorm:"type:bigint" json:"end"`
}