Web PortPolio

Tables (4)

entry_audit (Untitled)

  • Key — BIGINT — Primary key — NOT NULL
  • id (Field) — BIGINT
  • entry_id (Field2) — VARCHAR
  • action (Field3) — VARCHARY
  • ip (Field4) — VARCHAR
  • user_agent (Field5) — VARCHAR
  • at (Field6) — DATETIME
  • Key (Key2) — BIGINT — Foreign key → guestbook_entry.Key — NOT NULL

entry_secret (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • entry_id (Field) — BIGINT
  • password_hash (Field2) — CHAR
  • rotated_at (Field3) — DATETIME
  • Key (Key2) — BIGINT — Foreign key → guestbook_entry.Key — NOT NULL

entry_version (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • entry_id (Field) — BIGINT
  • content_snapshot (Field2) — MEDIUMTEXT
  • versioned_at (Field3) — DATETIME
  • Key (Key2) — BIGINT — Foreign key → guestbook_entry.Key — NOT NULL

guestbook_entry (Untitled4)

  • Key — BIGINT — Primary key — NOT NULL
  • nickname (Field) — VARCHAR
  • content (Field2) — TEXT
  • is_public (Field3) — TINYINT
  • created_at (Field4) — DATETIME
  • updated-at (Field5) — DATETIME