실습2
테이블 (3)
BOYFREND (Untitled)
- bf_id — int — 기본 키 — NOT NULL
- name — int
- age — int
- mbti — varchar
- charm_point — varchar
PLACE (Untitled3)
- place_id — int — 기본 키 — NOT NULL
- place_name
- mood — varchar
- is_reserved (id_reserved) — boolean
SCHEDULE (Untitled2)
- Key (schedult_id) — int — 기본 키 — NOT NULL
- bf_id — int — 외래 키 → BOYFREND.bf_id — NOT NULL
- Field (schedual_date) — date
- Field (rating) — int
- Field (review) — text
- place_id — int — 외래 키 → PLACE.place_id — NOT NULL