test_1
Tables (3)
boyfriend
- boyfriend_id — int — Primary key — NOT NULL — auto increment
- name — char(30)
- age — int
- mbti — char(4)
- love_point — char(100)
place
- place_id — int — Primary key — NOT NULL — auto increment
- place_name — char(30)
- mood — char(30)
- is_reserved — boolean
schedule
- schedule_id — int — Primary key — NOT NULL — auto increment
- date — char(8)
- rating — int
- review — char(100)
- boyfriend_id (boyfriend_id2) — int — Foreign key → boyfriend.boyfriend_id — NOT NULL — auto increment
- place_id (place_id2) — int — Foreign key → place.place_id — NOT NULL — auto increment