assignment1

Tables (5)

CAFE (Untitled)

  • CAFE_ID (Key) — INT — Primary key — NOT NULL
  • CAFE_NAME (Field) — VARCHAR2
  • LOCATION (Field2) — VARCHAR2
  • PHONE (Field3) — VARCHAR2

CUSTOMER (Untitled2)

  • customer_id (Key) — INT — Primary key — NOT NULL
  • nickname (Field) — VARCHAR2
  • name (Field2) — VARCHAR2
  • phone (Field3) — VARCHAR2

RESERVATION (Untitled4)

  • RESERVATION_ID (Key) — INT — Primary key — NOT NULL
  • date (Field) — VARCHAR2
  • time (Field2) — VARCHAR2
  • player_cnt (Field3) — INT
  • is_success (Field4) — BOOLEAN
  • escape_time (Field5) — VARCHAR2
  • HINT_CNT (Field6) — INT
  • customer_id (Key2) — INT — Foreign key → CUSTOMER.customer_id — NOT NULL
  • THEME_ID (Key3) — INT — Foreign key → THEME.THEME_ID — NOT NULL

REVIEW (Untitled5)

  • review_id (Key) — INT — Primary key — NOT NULL
  • RESERVATION_ID (Key2) — INT — Foreign key → RESERVATION.RESERVATION_ID — NOT NULL
  • rating (Field) — VARCHAR2
  • contnent (Field2) — VARCHAR2
  • created_at (Field3) — VARCHAR2

THEME (Untitled3)

  • THEME_ID (Key) — INT — Primary key — NOT NULL
  • theme_name (Field) — VARCHAR2
  • difficulty (Field2) — VARCHAR2
  • genre (Field3) — VARCHAR2
  • TIME_LIMIT (Field4) — VARCHAR2
  • MAX_PLAYERS (Field5) — INT
  • CAFE_ID (Key2) — INT — Foreign key → CAFE.CAFE_ID — NOT NULL