example

Tables (3)

boyfriend

  • boyfriend_id (Key) — int — Primary key — NOT NULL
  • name — varchar — NOT NULL
  • age — int — NOT NULL
  • mbti — char(4)
  • attraction_point — int

place

  • place_id (Key) — int — Primary key — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (atmosphere) — varchar
  • Field (reservation_required) — bool — NOT NULL

schedule (Untitled)

  • schedule_id (Key) — int — Primary key — NOT NULL
  • Field (boyfriend_id) — int — NOT NULL
  • Field (place_id) — int — NOT NULL
  • Field (date) — datetime — NOT NULL
  • Field (satisfaction_rate) — int
  • Field (review) — varchar
  • boyfriend_id (Key2) — int — Foreign key → boyfriend.boyfriend_id — NOT NULL