certlab

Tables (5)

ApiKey

  • no — bigint(20) — Primary key — NOT NULL
  • value — varchar(64)
  • system — varchar(64)
  • manager — varchar(512)
  • created_time — datetime
  • updated_time — datetime

Cert

  • id — bigint(20) — Primary key — NOT NULL
  • issuer — varchar(128)
  • serial_number — varchar(128)
  • domain_type — char(3)
  • not_before — datetime
  • not_after — datetime
  • active — char(1)
  • fingerprint — varchar(256)
  • description — varchar(255)
  • created_time — datetime
  • updated_time — datetime
  • deleted_time — datetime

CertBody

  • id — bigint(20) — Primary key — NOT NULL
  • cert_id — bigint(20) — Foreign key → Cert.id — NOT NULL
  • type — bigint(20)
  • value — text

Domain

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(50)

DomainCertMap

  • id — bigint(20) — Primary key — NOT NULL
  • cert_id — bigint(20) — Foreign key → Cert.id — NOT NULL
  • domain_id — bigint(20) — Foreign key → Domain.id — NOT NULL