首页 > 代码库 > 机房收费系统重构之E-R图设计
机房收费系统重构之E-R图设计
Student(StudentID,StudentName,Department,Grade,Class,Type)
Card(CardID,Cash,StudentID,Type,IsUsing)
BasicData(FixedRate,TempRate,UpTime,LeastTime,PerparTime,LimitCash,theDate,theTime,UserName)
SystemUser(UserName,Psw,Level,RealName,Creator)
SystemUserLoginRecords(UserName,theDate,theTime,ComputerName)
Register(CardID,StudentID,UserName,theDate,theTime,initialMoney)
Recharge(CardID,UserName,AddMoney,theDate,theTime)
BackCard(CardID,UserName,refundment,theDate,theTime)
StudentOnlineRecords(CardID,UserName,theDate,theTime,ComputerName)
StudentOnlineLog(CardID,UserName,OnlineDate,OnlineTime,OffLineDate,OffLineTime,Statu,ConsumeTime,ConsumeCash,ComputerName)
SystemUserWorkLog(UserName,OnDate,OnTime,OffDate,OffTime,ComputerName)
DayBill(AllCardCash,RechargeCash,OnlineCash,BackCardCash,AllGetCash,UserName,TheDate)
机房收费系统重构之E-R图设计