Journie Moment
Tables (3)
comments (Untitled3)
- comment_id — NOT NULL, AUTO_INCREMENT, UNIQUE — Primary key — NOT NULL
- post_id — NOT NULL, AUTO_INCREMENT — Foreign key → posts.post_id — NOT NULL — ON DELETE CASCADE
- user_id — NOT NULL, AUTO_INCREMENT — Foreign key → users.user_id — NOT NULL
- content — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- group_id
- level
- is_deleted — DEFAULT FALSE
posts (Untitled)
- post_id — NOT NULL, AUTO_INCREMENT, UNIQUE — Primary key — NOT NULL
- user_id — NOT NULL, AUTO_INCREMENT — Foreign key → users.user_id — NOT NULL
- title — NOT NULL
- content — NULL
- image — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- is_locked — DEFAULT FALSE
- views — NOT NULL
- is_time_capsule — DEFAULT FALSE
- release_date
users (Untitled2)
- user_id — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
- email — NOT NULL, UNIQUE
- user — NOT NULL, UNIQUE
- password — NOT NULL
- nickname — NOT NULL, UNIQUE
- created_at — NOT NULL
- question — NOT NULL
- answer — NOT NULL