awesomemin.com

Tables (4)

Categories (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • parent_id (Key2) — Foreign key → Categories.id — NOT NULL
  • name (Field)
  • slug (Field2)

Comments (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → Posts.id — NOT NULL
  • author_id (Key3) — Foreign key → Users.id — NOT NULL
  • parent_id (Key4) — Foreign key → Comments.id — NOT NULL
  • guest_nickname (Field2)
  • guest_email (Field3)
  • guest_password_hash (Field4)
  • content (Field5)
  • created_at (Field6)
  • updated_at (Field7)
  • deleted_at (Field8)

Posts (Untitled)

  • id (Key) — Primary key — NOT NULL
  • author_id (Key2) — Foreign key → Users.id — NOT NULL
  • category_id (Key3) — Foreign key → Categories.id — NOT NULL
  • title (Field)
  • slug (Field2)
  • content (Field3)
  • status (Field4)
  • published_at (Field5)
  • created_at (Field6)
  • updated_at (Field7)

Users (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • username (Field)
  • password_hash (Field2)
  • role (Field3)
  • created_at (Field4)
  • updated_at (Field5)