POWERDNS ERD
Tables (7)
Untitled (domains)
- Key (id) — SERIAL — Primary key — NOT NULL
- Field (name) — VARCHAR(255)
- Field2 (master) — VARCHAR(128)
- Field3 (last_check) — INT
- Field4 (type) — TEXT
- Field5 (notified_serial) — BIGINT
- Field6 (account) — VARCHAR(40)
- Field7 (options) — TEXT
- Field8 (catalog) — TEXT
Untitled (records)
- Key (id) — BIGSERIAL — Primary key — NOT NULL
- Key (domain_id) — INT — Foreign key → Untitled.Key — NOT NULL
- (name) — VARCHAR(255)
- Field2 (type) — VARCHAR(10)
- Field3 (content) — VARCHAR(65535)
- Field4 (ttl) — INT
- Field5 (prio) — INT
- Field6 (disabled) — BOOL
- Field7 (ordername) — VARCHAR(255)
- Field8 (auth) — BOOL
Untitled (comments)
- Key (id) — SERIAL — Primary key — NOT NULL
- Key (domain_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(255)
- Field2 (type) — VARCHAR(10)
- Field3 (modified_at) — INT
- Field4 (account) — VARCHAR(40)
- Field5 (comment) — VARCHAR(65535)
Untitled (cryptokeys)
- Key (id) — SERIAL — Primary key — NOT NULL
- Key (domain_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (flags) — INT
- Field2 (active) — BOOL
- Field3 (published) — BOOL
- Field4 (content) — TEXT
Untitled (domainmetadata)
- Key (id) — SERIAL — Primary key — NOT NULL
- Key (domain_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field2 (kind) — VARCHAR(32)
- Field3 (content) — TEXT
Untitled (tsigkeys)
- Key (id) — SERIAL — Primary key — NOT NULL
- Field (name) — VARCHAR(255)
- Field2 (algorithm) — VARCHAR(50)
- Field3 (secret) — VARCHAR(255)
Untitled (supermasters)
- Key (id) — INET — Primary key — NOT NULL
- Key2 (nameserver) — VARCHAR(255) — Primary key — NOT NULL
- Field (account) — VARCHAR(40)