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