배달의민족ERD

테이블 (13)

Copy Of Copy Of Copy Of Copy Of Copy Of user22 (store_image)

  • user_id (store_image_id) — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • status — enum
  • Field (url) — varchar
  • Field (type) — enum(main, notice)
  • user_id (store_id) — bigint — 외래 키 → Copy Of user.user_id — NOT NULL

Copy Of Copy Of Copy Of Copy Of Copy Of user222 (menu_image_id)

  • user_id (menu_image_id) — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • status — enum
  • Field (url) — varchar
  • user_id (menu_id) — bigint — 외래 키 → Copy Of Copy Of user2.user_id — NOT NULL

Copy Of Copy Of Copy Of Copy Of user2 (review_comment)

  • user_id (review_comment_id) — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • status — enum
  • Field (content) — varchar
  • user_id (review_id) — bigint — 외래 키 → Copy Of Copy Of Copy Of user2.user_id — NOT NULL

Copy Of Copy Of Copy Of Copy Of user22 (review_image)

  • user_id (review_image_id) — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • status — enum
  • Field (url) — varchar
  • user_id (review_id) — bigint — 외래 키 → Copy Of Copy Of Copy Of user2.user_id — NOT NULL

Copy Of Copy Of Copy Of user2 (review)

  • user_id (review_id) — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • status — enum
  • Field (star) — int
  • Field (content) — varchar
  • user_id (store_id) — bigint — 외래 키 → Copy Of user.user_id — NOT NULL

Copy Of Copy Of Copy Of user22 (ordered_menu)

  • user_id (ordered_menu_id) — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • status — enum
  • Field (amount) — int
  • user_id (menu_id) — bigint — 외래 키 → Copy Of Copy Of user2.user_id — NOT NULL
  • user_id (order_id) — bigint — 외래 키 → Copy Of user3.user_id — NOT NULL

Copy Of Copy Of user2 (menu)

  • user_id (menu_id) — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • status — enum
  • Field (name) — varchar
  • Field (description) — varchar
  • Field (price) — int
  • user_id (store_id) — bigint — 외래 키 → Copy Of user.user_id — NOT NULL

Copy Of Copy Of user32 (menu_option)

  • user_id (menu_option_id) — bigint — 기본 키 — NOT NULL
  • Field (category) — enum(선택, 필수, 다중선택)
  • created_at — datetime
  • updated_at — datetime
  • status — enum
  • Field (name) — varchar
  • Field (price) — int
  • user_id (menu_id) — bigint — 외래 키 → Copy Of Copy Of user2.user_id — NOT NULL

Copy Of user (store)

  • user_id (store_id) — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • status — enum
  • Field (name) — varchar
  • Field (open_time) — time
  • Field (close_time) — time
  • Field (notice_content) — varchar
  • Field (descriptioin) — varchar
  • Field (business_number) — varchar
  • Field (origin_label) — varchar
  • Field (min_order_amount) — int
  • Field (lattitude) — float
  • Field (longitude) — float
  • Field (street_address) — varchar
  • Field (address_detail) — varchar

Copy Of user2 (store_category)

  • user_id (store_category_id) — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • status — enum
  • Field (name) — varchar
  • user_id (store_id) — bigint — 외래 키 → Copy Of user.user_id — NOT NULL

Copy Of user3 (order)

  • user_id (order_id) — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • status — enum
  • user_id — bigint — 외래 키 → user.user_id — NOT NULL
  • user_id (store_id) — bigint — 외래 키 → Copy Of user.user_id — NOT NULL

user

  • user_id — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • status — enum
  • Field (nickname) — varchar
  • Field (name) — varchar
  • Field (password) — varchar
  • Field (phone) — varchar
  • Field (profile_image) — varchar
  • Field (current_address_id) — bigint

user_address

  • user_address_id — bigint — 기본 키 — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • status — enum
  • category — enum(집, 회사, 기타)
  • Field (category_details) — varchar — NOT NULL
  • delivery_request_message — varchar
  • door_password — varchar
  • direction_message — varchar
  • Field (lattitude) — float
  • Field (longitude) — float
  • Field (street_address) — varchar
  • Field (address_detail) — varchar
  • user_id — bigint — 외래 키 → user.user_id — NOT NULL