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