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