exchange_diary

Tables (6)

diaries

  • diary_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • mood — VARCHAR(50)
  • content — TEXT — NOT NULL
  • question — VARCHAR(255)
  • diary_date — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL

room_members

  • room_member_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

rooms

  • room_id — BIGINT — Primary key — NOT NULL
  • room_name — VARCHAR(100) — NOT NULL
  • invite_code — VARCHAR(6) — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id — NOT NULL

tmi

  • tmi_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • writer_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content — TEXT — NOT NULL

tmi_guess

  • guess_id — BIGINT — Primary key — NOT NULL
  • tmi_id — BIGINT — Foreign key → tmi.tmi_id — NOT NULL
  • guesser_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • guessed_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • is_correct — BOOLEAN — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL