배달의민족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