Database Tables

[ Home ]

Users

• UsrId
• FirstName
• LastName
• Email
• Phone
• Cell
• Password
• JoinDate
• ActiveStatus: Y/N
• Addr1, Addr2
• CtyId

City

• CtyId
• City
• State
• Country

Members

• MemId
• UsrId
• StartDate
• EndDate
• PaysOnline: Y/N

Tutors

• TutId
• UsrId
• StartDate
• EndDate

ContentCreators

• CreId
• UsrId
• StartDate
• EndDate

Skills

• SklId
• UsrId
• IsTutor: Y/N
• SubId
• Level: Beg/Int/Adv

TutEval

• TevId
• TutId
• MemId
• Date
• AttrNo
• Value: btwn 1 and 5

Sessions

• SsnId
• TutId
• MemId
• DayOfWeek
• Time
• Length: Default = 60 mins.

Meetings

• MtgId
• SsnId
• Date
• Time
• Length

Topics

• TopId
• SsnId
• SubId

Subjects

• SubId
• ParId
• NextId
• ChildId
• RefCount:  -ve: child = main record; +ve: main record
• Title

Lessons

• LsnId
• SubId
• CreId
• ParId
• NextId
• ChildId
• SrcId: input (raw) lesson text
• ObjId: output lesson text
• LsnNo
• Title
• Date

SrcCode

• SrcId
• LsnId
• NextId
• Text: line of CTML

ObjCode

• ObjId
• LsnId
• NextId
• Text: line of CTML

Marks

• MrkId
• MemId
• LsnId
• Grade
• Passed: Y/N