20260622

Tables (3)

BOYFRIEND

  • BOYFRIEND_ID (Key) — INT — Primary key — NOT NULL
  • NAME (이름) — VARCHAR2
  • AGE (나이) — INT
  • MBTI — VARCHAR2
  • ATTRACT (매력포인트) — INT

PLACE

  • PLACE_ID — INT — Primary key — NOT NULL
  • BUNISS_NAME (상호명) — VARCHAR2
  • atomosphere (분위기) — VARCHAR2
  • RESVERATION (예약여부) — VARCHAR2

SCHDULE

  • schedule_id (Key) — INT — Primary key — NOT NULL
  • weather (날짜) — VARCHAR2
  • HAPPY (만족도) — VARCHAR2
  • REVIEW (후기) — VARCHAR2
  • BOYFRIEND_ID (Key2) — INT — Foreign key → BOYFRIEND.BOYFRIEND_ID — NOT NULL
  • PLACE_ID — INT — Foreign key → PLACE.PLACE_ID — NOT NULL