ppppppp!@!!Jh

Tables (3)

boyfriend (남친들)

  • id (남친 ID) — int — Primary key — NOT NULL
  • name (이름) — varchar(100)
  • age (나이) — smallint
  • mbti (MBTI) — char(4)
  • mearyeack (매력포인트) — text

place (장소)

  • id (장소 ID) — int — Primary key — NOT NULL
  • name (상호명) — varchar(100)
  • atmosphere (분위기) — varchar(100)
  • booked (예약여부) — bool

schedule (스케줄)

  • id (일정 ID) — int — Primary key — NOT NULL
  • boyfriend_id (남친 ID2) — int — Foreign key → boyfriend.id — NOT NULL
  • place_id (장소 ID2) — int — Foreign key → place.id — NOT NULL
  • at (날짜) — date
  • grade (만족도) — smallint
  • review (후기) — text