실습1

테이블 (5)

CAFE (Untitled)

  • cafe_id (카페ID) — char(3) — 기본 키 — NOT NULL
  • cafe_name (카페이름) — varchar2(50)
  • location (지역) — varchar2(50)
  • phone (휴대폰번호) — varchar2(15)

CUSTOMER (Untitled2)

  • customer_id (소비자ID) — varchar2(20) — 기본 키 — NOT NULL
  • nickname (닉네임) — varchar2(50)
  • name (이름) — varchar2(50)
  • phone (휴대폰번호) — varchar2(20)

RESERVATION (Untitled4)

  • reservation_id (예약_id) — varchar2(20) — 기본 키 — NOT NULL
  • 날짜 — varchar2(20)
  • 시간 — varchar2(20)
  • player_cnt (플레이어수) — char(100)
  • is_success (성공여부) — char(1)
  • escape_time (탈출시간) — date
  • hint_cnt (힌트 갯수) — char(10)
  • customer_id (소비자ID) — varchar2(20) — 외래 키 → CUSTOMER.customer_id — NOT NULL
  • theme_id (테마_id2) — varchar2(20) — 외래 키 → THEME.theme_id — NOT NULL

REVIEW (Untitled5)

  • review_id (리뷰_id) — varchar2(20) — 기본 키 — NOT NULL
  • rating (평가) — varchar2(50)
  • content (콘텐츠) — varchar2(20)
  • created_at (쓴 날짜) — date
  • reservation_id (예약_id2) — varchar2(20) — 외래 키 → RESERVATION.reservation_id — NOT NULL

THEME (Untitled3)

  • theme_id (테마_id) — varchar2(20) — 기본 키 — NOT NULL
  • theme_name (테마_이름) — varchar2(30)
  • difficulty (어려움) — varchar2(30)
  • genre (장르) — varchar2(30)
  • time_limit (제한시간) — varchar2(30)
  • max_player (최대_인원수) — char(100)
  • cafe_id (카페ID) — char(3) — 외래 키 → CAFE.cafe_id — NOT NULL