Please enable JavaScript.
Coggle requires JavaScript to display documents.
資料庫專題(電商平台), 課程評價, 系統功能分析, 課程評價系統 - Coggle Diagram
資料庫專題(電商平台)
Table
User
UserId , nickname ,Email, password , birthdate , department , grade , verified , banned, seller_status
Seller
SellerID(PK),ShopName ,IsValid , Credit , ShopIntroduction
Product
ProductID(PK),SellerID(PK),Name,Introduction,Rate, Price
Order
OrderID(PK), UserId(FK),Generated_time, Status,SellerAgree,BuyerAgree
OrderProduct
OrderProductID(PK), OrderID(FK), ProductID(PK), Quantity, SinglePrice, TotalPrice
Comment
CommentId(PK), UserID(FK), ProductID(FK) , Rate, Content
Cart
CartID(PK), UserID(FK), ProductID(FK) , Quantity
Plan
PlanID,ProductId,BeginTime,EndTime,Ratio
課程評價
課程
評價內容
使用者
系統功能分析
使用政大信箱(g.nccu.edu.tw)
閱覽課程
評價課程(涼甜度、收穫)
收藏課程
使用非政大信箱
課程評價系統
Table
Course
CourseID, Name ,
Comment
CommentID, CourseID(FK), UserID(FK), Loading, Score
Department
DepartmentID(PK), Name , Introduction , LeaderID (FK), CollegeID(FK),
College
CollegeID, Name
Member
MemberID(PK), Name, Email , Password , birthdate , department