ERD 공부
테이블 (21)
BOYFRIEND (boyfriend)
- PK (boyfriend_id) — int — 기본 키 — NOT NULL
- Field (name) — varchar
- Field2 (age) — varchar
- Field3 (MBTI) — varchar
- Field (point) — varchar
CHATROOM (chatroom)
- PK (chatroom_id) — int — 기본 키 — NOT NULL
- Field (room_name) — varchar
CHATROOM_MEMBER (chatroom_member)
- PK (member_id) — int — 기본 키 — NOT NULL
- Field (last_read_at) — datetime
- PK (user_id) — int — 외래 키 → User.PK — NOT NULL
- PK (chatroom_id) — int — 외래 키 → CHATROOM.PK — NOT NULL
FRIENDSHIP (friendship)
- PK (friendship_id) — int — 기본 키 — NOT NULL
- Field (status) — varchar
- Field (requested_at) — varchar
- PK (requester_id) — int — 외래 키 → User.PK — NOT NULL
- PK (receiver_id) — int — 외래 키 → User.PK — NOT NULL
GAME (game)
- PK (game_id) — int — 기본 키 — NOT NULL
- Field (title) — varchar
- Field2 (price) — int
- Field (publisher)
GAME_GENRE (game_genre)
- PK (game_id) — int — 외래 키 → GAME.PK — NOT NULL
- PK (genre_id) — int — 외래 키 → GENRE.PK — NOT NULL
GENRE (genre)
- PK (genre_id) — int — 기본 키 — NOT NULL
- Field (genre_name) — varchar
MESSAGE (message)
- PK (message_id) — int — 기본 키 — NOT NULL
- Field (content) — varchar
- Field (sent_at) — datetime
- PK (chatroom_id) — int — 외래 키 → CHATROOM.PK — NOT NULL
- PK (user_id) — int — 외래 키 → User.PK — NOT NULL
PLACE (place)
- PK (place_id) — int — 기본 키 — NOT NULL
- Field (name) — varchar
- Field2 (mood) — varchar
- Field3 (reservation) — varchar
PLAY_HISTORY (play_history)
- PK (history_id) — int — 기본 키 — NOT NULL
- Field (start_time) — varchar
- Field (end_time) — varchar
- Field (play_time) — varchar
- PK (user_id) — int — 외래 키 → User.PK — NOT NULL
- PK (game_id) — int — 외래 키 → GAME.PK — NOT NULL
PURCHASE (purchase)
- PK (purchase_id) — int — 기본 키 — NOT NULL
- Field (purchase_date) — date
- Field (purchase_price) — int
- PK (user_id) — int — 외래 키 → User.PK — NOT NULL
- PK (game_id) — int — 외래 키 → GAME.PK — NOT NULL
RESERVATION (CopyOfCopyOfUntitled)
- PK (reservation_id) — int — 기본 키 — NOT NULL
- Field (date) — varchar
- Field2 (time) — varchar
- Field3 (player_cnt) — int
- Field (is_success) — varchar
- Field (escape_time) — varchar
- Field (hint_cnt)
- PK (theme_id) — int — 외래 키 → theme.PK — NOT NULL
- PK (cafe_id) — int — 외래 키 → cafe.PK — NOT NULL
- PK (customer_id) — int — 외래 키 → customer.PK — NOT NULL
REVIEW (CopyOfCopyOfUntitled2)
- PK (review_id) — int — 기본 키 — NOT NULL
- Field (rating) — int
- Field2 (content) — varchar
- Field3 (created_at) — date
- PK (reservation_id) — int — 외래 키 → RESERVATION.PK — NOT NULL
REVIEW (review)
- PK (review_id) — int — 기본 키 — NOT NULL
- Field (content) — varchar
- Field (rating) — int
SCHEDULE (schedule)
- PK (schedule_id) — int — 기본 키 — NOT NULL
- Field (date) — date
- Field2 (satisfaction) — int
- Field3 (review) — varchar
- PK (boyfriend_id) — int — 외래 키 → BOYFRIEND.PK — NOT NULL
- PK (place_id) — int — 외래 키 → PLACE.PK — NOT NULL
STEAM (steam)
- PK (stream_id) — int — 기본 키 — NOT NULL
- Field (channel_name) — varchar
- Field2 (category) — varchar
- PK (user_id) — int — 외래 키 → User.PK — NOT NULL
STREAM_FOLLOW (steam_follow)
- PK (follow_id) — int — 기본 키 — NOT NULL
- Field (followed_at) — date
- PK (user_id) — int — 외래 키 → User.PK — NOT NULL
- PK (stream_id) — int — 외래 키 → STEAM.PK — NOT NULL
User (user)
- PK (user_id) — int — 기본 키 — NOT NULL
- Field (username) — varchar
- Field2 (email) — varchar
- Field3 (nickname) — varchar
- Field (created_at) — date
cafe (Untitled)
- PK (cafe_id) — int — 기본 키 — NOT NULL
- Field (cafe_name) — varchar
- Field2 (location) — varchar
- Field3 (phone) — varchar
customer (CopyOfUntitled)
- PK (customer_id) — int — 기본 키 — NOT NULL
- Field (nickname) — varchar
- Field2 (name) — varchar
- Field3 (phone) — varchar
theme (Untitled2)
- PK (theme_id) — int — 기본 키 — NOT NULL
- Field (theme_name) — varchar
- Field (difficulty) — int
- Field (genre) — varchar
- Field (time_limit) — varchar
- Field (max_players) — int
- PK (cafe_id) — int — 외래 키 → cafe.PK — NOT NULL