이게 진짜 ERD
테이블 (8)
Untitled (city)
- Key (city_id) — bigint — 기본 키 — NOT NULL
- Field (city_kor_name) — varchar(20) — NOT NULL
- Field (city_eng_name) — varchar(30) — NOT NULL
- Field (city_pic) — varchar(50) — NOT NULL
- Field (color) — varchar(6) — NOT NULL — 도시표기색상
Untitled (city_place)
- Key (place_id) — bigint — 기본 키 — NOT NULL
- Key (city_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (place_pic) — varchar(50)
- Field (place_address) — varchar(150) — NOT NULL
- Field (place_name) — varchar(50) — NOT NULL
- Field (place_star) — double — NOT NULL
- Field (category) — varchar(20) — NOT NULL
- Field (lat) — double — NOT NULL
- Field2 (lng) — double — NOT NULL
Untitled (feed)
- Key (plan_master_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (title) — varchar(30) — NOT NULL
- Field (content) — varchar(150) — NOT NULL
- Field2 (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime
Untitled (plan_detail)
- Key (plan_id) — bigint — 기본 키 — NOT NULL
- Key (plan_master_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Key (place_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (price) — Integer
- Field (memo) — varchar(300)
- Field (start_time) — time — NOT NULL
- Field (end_time) — time — NOT NULL
- Field (date) — int — NOT NULL
Untitled (feed_like)
- Key (user_id) — bigint — 외래 키 → user.Key — NOT NULL
- Key (plan_master_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
Untitled (plan_master)
- Key (plan_master_id) — bigint — 기본 키 — NOT NULL
- Key (user_id) — bigint — 외래 키 → user.Key — NOT NULL
- Key (city_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (start_date) — date — NOT NULL
- Field2 (end_date) — date — NOT NULL
- Field (people_cnt) — int — NOT NULL
Untitled (user_auth)
- Key (email) — varchar(30) — 기본 키 — NOT NULL — 복합키
- Key (created_at) — datetime — 기본 키 — NOT NULL — 복합키
- Field (expired_time) — datetime — NOT NULL — 5분
- Field (auth_code) — varchar(10) — NOT NULL
- Field (auth_check) — int — NOT NULL
user
- Key (user_id) — bigint — 기본 키 — NOT NULL
- Field (email) — varchar(30) — NOT NULL
- Field (upw) — varchar(100) — NOT NULL
- Field (nick_name) — varchar(30) — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime
- Field (name) — varchar(10) — NOT NULL