models

type CertNames struct {
	ID            uint `json:"id" gorm:"primarykey"`
	CertificateID uint `json:"cert_id" gorm:"index:idx_cert"`

	Hash string `json:"hash" gorm:"index:,unique;"`
	Type string `json:"type"`
	Name string `json:"name"`
}

type Certificate struct {
	ID uint `json:"id" gorm:"primarykey, TYPE:integer"`

	Hash        string    `json:"hash" gorm:"index:,unique;"`
	Fingerprint string    `json:"fingerprint" gorm:"index:,unique;"`
	Subject     string    `json:"subject"`
	Issuer      string    `json:"issuer"`
	NotBefore   time.Time `json:"not_before"`
	NotAfter    time.Time `json:"not_after"`
	ProbedAt    time.Time `json:"probe_at"`

	IsRootCA   bool `json:"root_ca"`
	IsCA       bool `json:"ca"`
	SelfSigned bool `json:"self_signed"`

	RawData string `json:"raw_data"`

	Names []*CertNames `json:"names" gorm:"constraint:OnDelete:CASCADE"`

	Hosts []*Host `gorm:"many2many:hosts_certs;"`
}

type FQDN struct {
	ID uint `json:"id" gorm:"primarykey"`
	//HostID   uint `json:"host_id"`
	Hash string `json:"hash" gorm:"index:,unique;"`

	FQDN string `json:"fqdn"`
}

type Host struct {
	ID   uint   `json:"id" gorm:"primarykey"`
	Hash string `json:"hash" gorm:"index:,unique;"`

	Ip    string `json:"ip"`
	Port  uint   `json:"port"`
	Cloud string `json:"cloud"`
	Ptr   string `json:"ptr"`

	Certificates []*Certificate `gorm:"many2many:hosts_certs;"`
	FQDNs        []*FQDN        `gorm:"many2many:hosts_fqdns;"`
}

type TestCtrl struct {
	ID uint `json:"id" gorm:"primarykey"`

	Hash string `json:"hash" gorm:"index:,unique;"`
	Ip   string `json:"ip"`
	Port uint   `json:"port"`
	FQDN string `json:"fqdn"`

	ProbedAt time.Time `json:"probe_at"`
}