Please enable JavaScript.
Coggle requires JavaScript to display documents.
Coffee shop system - Coggle Diagram
Coffee shop system
tbProducts
describe - text
categoryId - char(5)
price - money
quantity - int
name - nvarchar(50)
supplierId - char(10)
id - char(10) not null
status - bit
createAt - date
updateAt - date
tbOrders
voucherId - char(5)
totalMoney - money
id - char(10) not null
discountMoney - money
CustomerId - char(10)
mustReturn - money
staffId - char(10)
createAt - date
note - text
delivery - char(10)
tbUsers
phoneNumber - char(10) unique
Address - varchar(200)
email - varchar(100) unique
fullName - nvarchar(50)
Id - char(10) not null
Status - bit
createAt - date
updateAt - date
birthDate - date
tbPost
thumnail - varchar(250)
createAt - date
content - text
updateAt - date
title - varchar(150)
createBy - char(10)
id - char(5) not null
status - bit
tbIntroduction
title - varchar(150)
content - text
id - char(5) not null
thumnail - varchar(250)
createAt - date
updateAt - date
createBy - char(10)
status - bit
tbCategorys
id - char(5) not null
status - bit
parentId - char(5)
describe - text
name - nvarchar(50)
createAt - date
updateAt - date
tbAccounts
passWord - char(40)
email - varchar(100) unique
id - char(10) not null
createAt - date
updateAt - date
role - char(5) not null
tbSuppliers
id - char(10) not null
email - varchar(100)
address - nvarchar(200)
hotline - char(15)
name - nvarchar(50)
tbVoucher
id - char(5) not null
name - nvarchar(100)
startDate - date
discountPercent - int
finishDate - date
tbDelivery
id - char(10) not null
name - nvarchar(50)
address - nvarchar(200)
email - varchar(200)
hotline - char(15)
tbCompany
Acronyms - char(10)
name - nvarchar(50)
email - varchar(100)
hotline - char(15)
address - nvarchar(200)
tbDetailOrders
id - char(10) not null
productId - char(10) not null
price - money
quantity - int
tbRoles
name - nvarchar(50)
status - bit
id - char(5) not null
describe - nvarchar(100)
tbProductGallerys
id - char(10) not null
status - bit
productId - char(10)
link - varchar(250)
tbFeedback
id - char(10) not null
userId - char(10)
content - text
status - bit
tbPostGallerys
postId - char(5)
status - bit
thumnail - varchar(250)
id - char(5)
tbComment
content - text
postId - char(5)
id - char(5)
status - bit
tbIntroGallerys
id - char(5)
thumnail - varchar(250)
introId - char(5)
status - bit