Scribd
Upload
28 views5 pages

Demo Database

The document describes the database tables and columns for an online food ordering system. It includes tables for reviews, bills, bill details, order statuses, review visibility settings, cart details, products, product pictures, tastes, origins, product types, and more. The tables store information like user and product IDs, names, descriptions, prices, statuses, addresses and other attributes needed to place and track food orders.

Uploaded by

minhdbce170224
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
28 views5 pages

Demo Database

The document describes the database tables and columns for an online food ordering system. It includes tables for reviews, bills, bill details, order statuses, review visibility settings, cart details, products, product pictures, tastes, origins, product types, and more. The tables store information like user and product IDs, names, descriptions, prices, statuses, addresses and other attributes needed to place and track food orders.

Uploaded by

minhdbce170224
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Reviews Type

Reviews_ID float
User_ID float
Product_ID float
Reviews_Rate int
Reviews_Comment nchar(1000)
ReviewsPicture_ID nchar(1000)
Review_Date int
ReviewsShow_ID int
ReviewsEdit_ID int

Bill Type
Bill_ID float
User_ID float
Bill_Address nchar(1000)
Bill_Total float
Bill_Date date
Bill_PaymentMethods nchar(500)
BillStatus_ID int
Bill_QuantityProduct int
Bill_NoteProduct nchar(1000)

BillDetail Type
BillDetail_ID float
Bill_ID float
CartDetails_ID float

BillStatus_ID Type
BillStatus_ID int
BillStatus_Detail nchar(100)

ReviewsShow Type
ReviewsShow_ID int
ReviewsShow_Detail nchar(100)

ReviewsEdit Type
ReviewsEdit_ID int
ReviewsEdit_Detail nchar(100)
CartDetails
CartDetails_ID
Cart_ID
Product_ID
CartDetails_QuantityProduct
CartDetails_Total

Đã mua thành công hay chưa để được đánh giá món ăn


Ẩn hoặc hiện trên trang chủ
Được quyền sửa đánh giá 1 lần Carts
Carts_ID
User_ID

Users
User_ID
User_Account
User_Password
User_Name
User_Gender
User_DateOfBirth
User_PhoneNumber
User_Address
Yêu cầu thêm của khách khi đặt món ăn(vd: không rau. thêm thịt ) TypeOfUser_ID
User_Avatar
User_Email
User_Note

TypeOfUser
TypeOfUser_ID
Gồm 1: Đang Xử Lí, 2: Đơn đã hoàn thành món ăn, TypeUser_Detail
3: Đang Giao Hàng, 4: Đã Giao Hàng, 5: Đã Huỷ, 6: Khách bom
Type Products
float Product_ID
float Product_Name
float Product_Cost
int Product_Description
float Product_Star
ProductStatus_ID
Origin_ID
Type_ID
Type TypeDescription_ID
float
float

Type
float
char(30)
char(30)
nchar(50)
char(10)
date
char(12) ReviewsPicture
nchar(100) ReviewsPicture_ID
int Picture_Link
nchar(1000) Reviews_ID
nchar(50)
nchar(1000) Khách hàng thân thiện,...........................
ProductStatus
ProductStatus_ID
ProductStatus_Detail

Type
int 0 is admin,1 is staff, 2 is customer.
nchar(50)
Type Types
float Type_ID
nchar(50) Type_KindOfProduct
float
nchar(2000)
float
int 0: hết hàng, 1: còn hàng Pictures
int Picture_ID
int Product_ID
int Picture_Link

Tastes
Taste_ID
Taste_Detail
Product_ID

Origin
Origin_ID
Origin_Detail

TypeDescription
TypeDescription_ID
Type TypeDescription_Detail
float
nchar(1000)

Type
int
nchar(100)
Type
int
nchar(50) Ăn Vặt, Món Chính, Tráng Miệng, Ăn Kiêng

float
float
nchar(1000)

Type Cay, Chua, Mặn, Lạc, Ngọt


int
nchar(50)
float

Type Quốc Gia


int
nchar(50)

Type Dạng Nước, Khô


int
nchar(50)

You might also like