Practice
Tables (3)
BOYFRIEND (000)
- Primary key (bf_id) — int — Primary key — NOT NULL
- Field (name) — varchar
- Field2 (age) — int
- Field3 (mbti) — varchar
- Field4 (charm_point) — varchar
- Field
PLACE (0)
- Primary key (place_id) — int — Primary key — NOT NULL
- Field (place_name) — varchar
- Field2 (mood) — varchar
- Field3 (is_reserved) — boolean
SCHEDULE (00)
- Primary key (schedule_id) — int — Primary key — NOT NULL
- Foriegn key (bf_id) — int — Foreign key → BOYFRIEND.Primary key — NOT NULL
- Foriegn key (place_id) — int — Foreign key → PLACE.Primary key — NOT NULL
- Field (schedule_date) — date
- Field2 (rating) — int
- Field3 (review) — text