Board
Tables (5)
Untitled (post)
- post_id — NOT NULL — Primary key — NOT NULL
- category_id — NOT NULL — Foreign key → Untitled.category_id — NOT NULL
- Key (user_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (content_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Field (title) — NOT NULL
- Field (created_date) — NULL
- Field (updated_date) — NULL
- Field (deleted_date) — NULL
- Field (likes) — 0
- Field (hates) — 0
- Field (views) — 0
- Field (enabled) — NOT NULL
Untitled (user)
- Key (user_id) — NOT NULL — Primary key — NOT NULL
- Field (email) — NOT NULL
- Field (password) — NOT NULL
- Field (profile_picture) — NOT NULL
- Field (name) — NOT NULL
- Field (role) — NOT NULL
- Field (created_date) — NOT NULL
- Field (last_modified_date)
- Field (deleted_date)
- Field (enabled) — NOT NULL
Untitled (category)
- category_id — NOT NULL — Primary key — NOT NULL
- Field (name) — NOT NULL
- Field (enabled) — NOT NULL
Untitled (reply)
- Key (reply_id) — NOT NULL — Primary key — NOT NULL
- post_id — NOT NULL — Foreign key → Untitled.post_id — NOT NULL
- Key (user_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Field (comment) — NOT NULL
- Field (created_date) — NOT NULL
- Field (updated_date) — NULL
- Field (deleted_date) — NULL
- Field (likes) — 0
- Field (hates) — 0
- Field (enabled) — NOT NULL
Untitled (content)
- Key (content_id) — NOT NULL — Primary key — NOT NULL
- Field (content) — NOT NULL