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)