DB수행
테이블 (17)
CAFE
- cafe_id — INT — 기본 키 — NOT NULL
- cafe_name — VARCHAR(100) — NOT NULL
- location — VARCHAR(100)
- phone — VARCHAR(20)
CHAT_MEMBER
- chat_member_id — INT — 기본 키 — NOT NULL
- chat_room_id — INT — 외래 키 → CHAT_ROOM.chat_room_id — NOT NULL
- user_id — INT — 외래 키 → USER.user_id — NOT NULL
- last_read_at — DATETIME
CHAT_ROOM
- chat_room_id — INT — 기본 키 — NOT NULL
- room_name — VARCHAR(100)
CUSTOMER
- customer_id — INT — 기본 키 — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
FOLLOW
- stream_follow_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → USER.user_id — NOT NULL
- stream_id — INT — 외래 키 → STREAM.stream_id — NOT NULL
- followed_at — DATETIME
FRIENDSHIP
- friendship_id — INT — 기본 키 — NOT NULL
- requester_id — INT — 외래 키 → USER.user_id — NOT NULL
- receiver_id — INT — 외래 키 → USER.user_id — NOT NULL
- status — VARCHAR(10)
- requested_at — DATETIME
GAME
- game_id — INT — 기본 키 — NOT NULL
- game_name — VARCHAR(100) — NOT NULL
- price — INT
- publisher — VARCHAR(100)
GAME_GENRE
- game_genre_id — INT — 기본 키 — NOT NULL
- game_id — INT — 외래 키 → GAME.game_id — NOT NULL
- genre_id — INT — 외래 키 → GENRE.genre_id — NOT NULL
GENRE
- genre_id — INT — 기본 키 — NOT NULL
- genre_name — VARCHAR(50) — NOT NULL
MESSAGE
- message_id — INT — 기본 키 — NOT NULL
- chat_room_id — INT — 외래 키 → CHAT_ROOM.chat_room_id — NOT NULL
- user_id — INT — 외래 키 → USER.user_id — NOT NULL
- content — TEXT
- sent_at — DATETIME
PLAY_RECORD
- play_record_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → USER.user_id — NOT NULL
- game_id — INT — 외래 키 → GAME.game_id — NOT NULL
- start_time — DATETIME
- end_time — DATETIME
- total_play_time — INT
PURCHASE
- purchase_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → USER.user_id — NOT NULL
- game_id — INT — 외래 키 → GAME.game_id — NOT NULL
- purchase_date — DATE — NOT NULL
- purchase_price — INT
RESERVATION
- reservation_id — INT — 기본 키 — NOT NULL
- customer_id — INT — NOT NULL
- theme_id — INT — NOT NULL
- reserved_at — DATETIME — NOT NULL
- participant_count — INT
- is_success — BOOLEAN
- escape_time — INT
- hint_count — INT
REVIEW
- review_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → USER.user_id — NOT NULL
- game_id — INT — 외래 키 → GAME.game_id — NOT NULL
- content — TEXT
- rating — INT
STREAM
- stream_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → USER.user_id — NOT NULL
- channel_name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50)
THEME
- theme_id — INT — 기본 키 — NOT NULL
- cafe_id — INT — NOT NULL
- theme_name — VARCHAR(100) — NOT NULL
- difficulty — VARCHAR(10)
- genre — VARCHAR(20)
- time_limit — INT
- max_capacity — INT
USER
- user_id — INT — 기본 키 — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- joined_at — DATETIME — NOT NULL