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