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