delivery

Tables (6)

Menu

  • menuId — bigint(20) — Primary key — NOT NULL
  • category — varchar(100) — NOT NULL
  • name — varchar(255) — NOT NULL
  • price — int(11) — NOT NULL
  • createdAt — timestamp — NOT NULL
  • modifiedAt — timestamp — NOT NULL
  • deletedAt — timestamp — NOT NULL
  • storeId (storeId2) — bigint(20) — Foreign key → Stores.storeId — NOT NULL

OrderMenu (Untitled)

  • id — bigint — Primary key — NOT NULL
  • quantity — int
  • createdAt — timestamp
  • modifiedAt — timestamp
  • deletedAt — timestamp
  • menuId — bigint(20) — Foreign key → Menu.menuId — NOT NULL
  • orderId — bigint(20) — Foreign key → Orders.orderId — NOT NULL

Orders

  • orderId — bigint(20) — Primary key — NOT NULL
  • totalPrice — int(11) — NOT NULL
  • requests — varchar(255)
  • createdAt — timestamp — NOT NULL
  • modifiedAt — timestamp — NOT NULL
  • status — varchar — NOT NULL
  • userId (userId2) — bigint(20) — Foreign key → Users.user_Id — NOT NULL
  • storeId (storeId2) — bigint(20) — Foreign key → Stores.storeId — NOT NULL

Reviews

  • reviewId — bigint(20) — Primary key — NOT NULL
  • rating — int(1) — NOT NULL
  • content — varchar(255)
  • createdAt — timestamp — NOT NULL
  • modifiedAt — timestamp — NOT NULL
  • deletedAt — timestamp — NOT NULL
  • userId (userId2) — bigint(20) — Foreign key → Users.user_Id — NOT NULL
  • storeId (storeId2) — bigint(20) — Foreign key → Stores.storeId — NOT NULL
  • orderId — bigint(20) — Foreign key → Orders.orderId — NOT NULL

Stores

  • storeId — bigint(20) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • category — varchar(20) — NOT NULL
  • address — varchar(255) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • content — varchar(255)
  • minDeliveryPrice — int(11) — NOT NULL
  • deliveryTip — int(11) — NOT NULL
  • rating — int — NOT NULL
  • reviewCount — int(11) — NOT NULL
  • openTime — varchar(255)
  • closeTime — varchar(255)
  • createdAt — timestamp — NOT NULL
  • modifiedAt — timestamp — NOT NULL
  • deletedAt — timestamp — NOT NULL
  • user_Id (id) — bigint(20) — Foreign key → Users.user_Id — NOT NULL

Users

  • user_Id (id) — bigint(20) — Primary key — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(100) — NOT NULL
  • phone — varchar(11) — NOT NULL
  • email — varchar(100) — NOT NULL
  • role — varchar(100) — NOT NULL
  • address — varchar(255)
  • createdAt — timestamp — NOT NULL
  • modifiedAt — timestamp — NOT NULL
  • deletedAt — timestamp — NOT NULL