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)