数据库ER总图
2018-05-23 00:11:01 0 举报
Resource Order ER
作者其他创作
大纲/内容
Class_Teacher
ClassId(INT)TeacherId(INT)ClassTeacherId(INT)Price(INT)Credit(INT)
Teacher
Teacher_Id(INT)TeacherName(INT)
1-*
*-*
OrderWorks
OrderId(INT)WorksTitle(VARCHAR)PICTURE(BLOB) or other resolution to store pic
OrderComments
OrderId(INT)Comments(VARCHAR)Remark(VARCHAR)
AvailbleTime
ClassTeachId(INT)AvailableTime(DateTime)
Class
ClassId(INT)ClassType(VARCHAR)ClassName(VARCHAR)During(INT)
*-1
Order
WeixinId(Long)OrderId(INT)ClassTeacherId(INT)ScheduledTime(DateTime)OrderType(VARCHAR)OrderStatus(VARCHAR)
OrderType 表征是用积分购买还是用现金购买OrderStatus表征这个课程是已上还是未上
System_User
UserId(INT)Pwd(VARCHAR)UserName(VARCHAR)RoleId(INT)Credit(INT)UserInformation...
Wx_User
WeixinId(Long)SystemUserId(VARCHAR)
0 条评论
回复 删除
下一页
