실습1
테이블 (20)
BOYFRIEND
- boyfriend_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- age — INT
- mbti — VARCHAR(4)
- charm_point — TEXT
CAFE
- cafe_id — INT — 기본 키 — NOT NULL
- cafe_name — VARCHAR(100) — NOT NULL
- location — VARCHAR(255)
- phone — VARCHAR(20)
CHATROOM
- chatroom_id — INT — 기본 키 — NOT NULL
- room_name — VARCHAR(100) — NOT NULL
CHATROOM_MEMBER
- member_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → USER.user_id — NOT NULL
- chatroom_id — INT — 외래 키 → CHATROOM.chatroom_id — NOT NULL
- last_read_at — TIMESTAMP
CUSTOMER
- customer_id — INT — 기본 키 — NOT NULL
- nickname — VARCHAR(50)
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
FRIENDSHIP
- friendship_id — INT — 기본 키 — NOT NULL
- requester_id — INT — 외래 키 → USER.user_id — NOT NULL
- receiver_id — INT — 외래 키 → USER.user_id — NOT NULL
- status — VARCHAR(20)
- requested_at — TIMESTAMP
GAME
- game_id — INT — 기본 키 — NOT NULL
- title — VARCHAR(150) — NOT NULL
- price — INT
- publisher — VARCHAR(100)
GAME_GENRE
- 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
- chatroom_id — INT — 외래 키 → CHATROOM.chatroom_id — NOT NULL
- user_id — INT — 외래 키 → USER.user_id — NOT NULL
- content — TEXT — NOT NULL
- sent_at — TIMESTAMP
PLACE
- place_id — INT — 기본 키 — NOT NULL
- place_name — VARCHAR(100) — NOT NULL
- atmosphere — VARCHAR(50)
- is_reserved — BOOLEAN
PLAY_HISTORY
- history_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
- 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 — DATETIME — NOT NULL
- purchase_price — INT — NOT NULL
RESERVATION
- reservation_id — INT — 기본 키 — NOT NULL
- customer_id — INT — 외래 키 → CUSTOMER.customer_id — NOT NULL
- theme_id — INT — 외래 키 → THEME.theme_id — NOT NULL
- reservation_date — DATE — NOT NULL
- reservation_time — TIME — NOT NULL
- player_cnt — INT — NOT NULL
- is_success — BOOLEAN
- escape_time — TIME
- hint_cnt — INT
REVIEW
- review_id — INT — 기본 키 — NOT NULL
- reservation_id — INT — 외래 키 → RESERVATION.reservation_id — NOT NULL
- rating — INT — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
SCHEDULE
- schedule_id — INT — 기본 키 — NOT NULL
- boyfriend_id — INT — 외래 키 → BOYFRIEND.boyfriend_id — NOT NULL
- place_id — INT — 외래 키 → PLACE.place_id — NOT NULL
- schedule_date — DATE — NOT NULL
- satisfaction — INT
- review — TEXT
STREAM
- stream_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → USER.user_id — NOT NULL
- channel_name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50)
STREAM_FOLLOW
- follow_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → USER.user_id — NOT NULL
- stream_id — INT — 외래 키 → STREAM.stream_id — NOT NULL
- followed_at — TIMESTAMP
THEME
- theme_id — INT — 기본 키 — NOT NULL
- cafe_id — INT — 외래 키 → CAFE.cafe_id — NOT NULL
- theme_name — VARCHAR(100) — NOT NULL
- difficulty — INT
- genre — VARCHAR(50)
- time_limit — INT
- max_players — INT
USER
- user_id — INT — 기본 키 — NOT NULL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50)
- created_at — TIMESTAMP