baedal_minjok
Tables (12)
Address (임베디드 타입)
- address_id — Long — Primary key — NOT NULL
- city — VARCHAR
- street — VARCHAR
- zipcode — VARCHAR
Coupon
- coupon_id — Long — Primary key — NOT NULL
- shop_id (shop_id2) — Long — Foreign key → Shop.shop_id — NOT NULL
- policy — VARCHAR
- discount — int
Delivery
- delivery_id — Long — Primary key — NOT NULL
- city — VARCHAR
- street — VARCHAR
- zipcode — VARCHAR
- status — VARCHAR
Food
- food_id — Long — Primary key — NOT NULL
- shop_id (shop_id2) — Long — Foreign key → Shop.shop_id — NOT NULL
- name — VARCHAR
- price — int
Order
- order_id — Long — Primary key — NOT NULL
- delivery_id — Long — Foreign key → Delivery.delivery_id — NOT NULL
- orderTime — datetime
- orderStatus — VARCHAR
Shop
- shop_id — Long — Primary key — NOT NULL
- name — VARCHAR
- image — VARCHAR
User
- user_id — Long — Primary key — NOT NULL
- name — VARCHAR
- age — int
- city — VARCHAR
- street — VARCHAR
- zipcode — VARCHAR
User_Coupon
- user_coupon_id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → User.user_id — NOT NULL
- coupon_id (coupon_id2) — Long — Foreign key → Coupon.coupon_id — NOT NULL
category
- category_id — Long — Primary key — NOT NULL
- name — VARCHAR
category_shop
- category_food_id — Long — Primary key — NOT NULL
- category_id — Long — Foreign key → category.category_id — NOT NULL
- shop_id — Long — Foreign key → Shop.shop_id — NOT NULL
order_food
- order_food_id — Long — Primary key — NOT NULL
- food_id (food_id2) — Long — Foreign key → Food.food_id — NOT NULL
- order_id (order_id2) — Long — Foreign key → Order.order_id — NOT NULL
- orderPrice — int
- count — int
order_user
- order_user_id — Long — Primary key — NOT NULL
- order_id (order_id2) — Long — Foreign key → Order.order_id — NOT NULL
- user_id (user_id2) — Long — Foreign key → User.user_id — NOT NULL