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