실습2

테이블 (3)

BOYFREND (Untitled)

  • bf_id — int — 기본 키 — NOT NULL
  • name — int
  • age — int
  • mbti — varchar
  • charm_point — varchar

PLACE (Untitled3)

  • place_id — int — 기본 키 — NOT NULL
  • place_name
  • mood — varchar
  • is_reserved (id_reserved) — boolean

SCHEDULE (Untitled2)

  • Key (schedult_id) — int — 기본 키 — NOT NULL
  • bf_id — int — 외래 키 → BOYFREND.bf_id — NOT NULL
  • Field (schedual_date) — date
  • Field (rating) — int
  • Field (review) — text
  • place_id — int — 외래 키 → PLACE.place_id — NOT NULL