boy

Tables (3)

boyfriend

  • boyfriend_id — int — Primary key — NOT NULL
  • name — text — NOT NULL
  • age — int — NOT NULL
  • mbti — varchar — NOT NULL
  • charm_point — varchar — NOT NULL

place

  • place_id — int — Primary key — NOT NULL
  • business_name — varchar — NOT NULL
  • atmosphere — varchar — NOT NULL
  • is_reserved — boolean — NOT NULL

schedule

  • schedule_id — int — Primary key — NOT NULL
  • schedule_date — date — NOT NULL
  • satisfaction — int — NOT NULL
  • review — text
  • place_id — int — Foreign key → place.place_id — NOT NULL
  • boyfriend_id — int — Foreign key → boyfriend.boyfriend_id — NOT NULL