1

Tables (9)

Cafeteria

  • cafeId — bigint(20) — Primary key — NOT NULL
  • name — varchar(255)

Cart

  • cartId — bigint(20) — Primary key — NOT NULL
  • userId — bigint(20) — NOT NULL
  • createdDate — timestamp
  • updatedDate — timestamp

CartItems

  • CartItemId — bigint(20) — Primary key — NOT NULL
  • cartId — bigint(20) — NOT NULL
  • menuId — bigint(20) — NOT NULL
  • quantity — int
  • menuPrice — int(11)

Menu

  • menuId — bigint(20) — Primary key — NOT NULL
  • cafeId — bigint(20) — NOT NULL
  • name — varchar(255)
  • price — int(11)
  • category — varchar(100)
  • menuPrictureUrl — text
  • status — varchar(255)

OrderItems

  • orderItemId — bigint(20) — Primary key — NOT NULL
  • orderId — bigint(20) — NOT NULL
  • menuId — bigint(20) — NOT NULL
  • quantity — int
  • menuPrice — int(11)

Orders

  • orderId — bigint(20) — Primary key — NOT NULL
  • userId — bigint(20) — NOT NULL
  • orderDate — timestamp
  • totalPrice — int(11)
  • status — varchar(20)

Payment

  • paymentId — bigint(20) — Primary key — NOT NULL
  • orderId — bigint(20) — NOT NULL
  • paymentMethod — varchar(255)
  • paymentAmount — bigint(20)
  • paymentStatus — varchar(20)

Users

  • userId — bigint(20) — Primary key — NOT NULL
  • password — varchar(255)
  • name — varchar(100)
  • phone — varchar(11)
  • email — varchar(100)
  • role — varchar(100)

review

  • reviewId — bigint(20) — Primary key — NOT NULL
  • userId — bigint(20) — NOT NULL
  • menuId — bigint(20) — NOT NULL
  • reviewScore — int
  • reviewComment — varchar(255)
  • createdDate — timestamp
  • updatedDate — timestamp