教务系统表结构
2016-12-12 09:42:43 0 举报
教务系统表结构
作者其他创作
大纲/内容
1 to n
学员
n To n
m_lesson_group_rel
groupuidsignupTimesstudyStatusisActive
n to 1
m_lesson_course_goods
+ insType+ link+ price+ orderIdx
班级
体验课报名
m_lesson_group_seat_pos
+ group+ posInfo
m_user
+ contactPhone:string+ forceChangePwd:boolean+ insTypes:int (bit flag based)+ contactDetails+ sourceAccount
n to n
1 to 1
座位位置
课件
m_school_try_lesson
+ account+ name+ phone+ details+ signupDate
m_lesson_bought_settlement
yearseasonaccountsummaryratesettlementSummarylastOperatorprocessStateprocessDatetransferAccountNametransferRanktransferProcessId
m_school_account
uidshcoolName:stringschoolAddress:stringschoolPhoneNo:stringstudentNum:int...
m_lesson_bought_log
+ uid+ account+ instype:tinyint+ courseId+ courseName+ payType(支付宝/微信/Apple)+ payLink+ payDate+ settlementId
m_lesson_student_rel
accountIduidcreateDate
m_lesson_group
+ account+ title+ teacher:int+ day+ startTime+ endTime+ insType+ classType: 1 V 4 ...+ courseCount: 总课时+ isActive+ courseGoodsId
购买记录
机构
m_lesson_group_progress
+ group+ lessonPackage+ lastTeach
老师
m_school_teacher
+ account+ name+ gender+ phone+ pwd+ details
0 条评论
回复 删除
下一页