tp

Tables (6)

Cart

  • id — INT — Primary key — NOT NULL
  • date
  • time
  • cno

Category

  • categoryName — VARCHAR(45) — Primary key — NOT NULL
  • noOfFoods — VARCHAR(45)

Contains

  • foodName — VARCHAR(45) — Primary key — NOT NULL
  • categoryName (cateogoryName) — VARCARH(45) — Primary key — NOT NULL

Customer

  • cno — INT — Primary key — NOT NULL
  • name — VARCHAR(45)
  • password — VARCHAR(45)
  • phoneNumber — VARCHAR(45)

Food

  • foodName — VARCARH(45) — Primary key — NOT NULL
  • price — BIGINT

OrderDetail

  • itemNo — INT — Primary key — NOT NULL
  • id — INT — Primary key — NOT NULL
  • quantity — BIGINT
  • totalPrice (totlaPrice) — BIGINT
  • foodName — VARCHAR(45)