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