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