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