이게 진짜 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