Practice

Tables (3)

BOYFRIEND (000)

  • Primary key (bf_id) — int — Primary key — NOT NULL
  • Field (name) — varchar
  • Field2 (age) — int
  • Field3 (mbti) — varchar
  • Field4 (charm_point) — varchar
  • Field

PLACE (0)

  • Primary key (place_id) — int — Primary key — NOT NULL
  • Field (place_name) — varchar
  • Field2 (mood) — varchar
  • Field3 (is_reserved) — boolean

SCHEDULE (00)

  • Primary key (schedule_id) — int — Primary key — NOT NULL
  • Foriegn key (bf_id) — int — Foreign key → BOYFRIEND.Primary key — NOT NULL
  • Foriegn key (place_id) — int — Foreign key → PLACE.Primary key — NOT NULL
  • Field (schedule_date) — date
  • Field2 (rating) — int
  • Field3 (review) — text