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)