example
Tables (3)
boyfriend
- boyfriend_id (Key) — int — Primary key — NOT NULL
- name — varchar — NOT NULL
- age — int — NOT NULL
- mbti — char(4)
- attraction_point — int
place
- place_id (Key) — int — Primary key — NOT NULL
- Field (name) — varchar — NOT NULL
- Field (atmosphere) — varchar
- Field (reservation_required) — bool — NOT NULL
schedule (Untitled)
- schedule_id (Key) — int — Primary key — NOT NULL
- Field (boyfriend_id) — int — NOT NULL
- Field (place_id) — int — NOT NULL
- Field (date) — datetime — NOT NULL
- Field (satisfaction_rate) — int
- Field (review) — varchar
- boyfriend_id (Key2) — int — Foreign key → boyfriend.boyfriend_id — NOT NULL