Database Tables

• UsrId
• FirstName
• LastName
• Email
• Phone
• Cell
• Password
• StartDate
• ^EndDate
• ^IsActive: Y/N
• Addr1, Addr2
• CtyId

Tutors

• TutId
• UsrId
• MentorId
• Intersection
• Rate: $ amt.
• PayPal info
• StartDate
• ^EndDate
• IsPartner: Y/N

ContentCreators

• CreId
• UsrId
• Rate: $ amt.
• PayPal info
• StartDate
• ^EndDate
• ^IsEmp: Y/N
• ^IsAdmin: Y/N

Skills

• SklId
• UsrId
• SubId
• StartDate
• EndDate
• Rating: percent
• Exper: hours

TutEval

• TevId
• TutId
• UsrId
• MtgId
• AttrNo
• Value: btwn 1 and 5

Sessions

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

Meetings

• MtgId
• SsnId
• Date
• Time
• Length

Items

• ItmId
• MtgId
• LsnId
• Length

Subjects

• SubId: body = <SubId>.SUB
• ParId
• NextId
• ChildId: zero for courses (leaf subjects)
• RefCount:  -ve: child = main record; +ve: main record
• Name: folder name/course no.
• Title
• IsDept: Y/N

Lessons

• LsnId: body = <LsnId>.LSN
• SubId: folder name
• CreId
• ParId
• NextId
• ChildId
• LsnNo
• Title
• Length: +ve: test length (minutes)
• AnsKey: Y/N
• Date
• ModifId
• ModifDate

City

• CtyId
• ParId
• City
• State
• Country

Prereqs

• PreId
• SubId
• PreSubId: zero for OR group
• ParId: PreId of OR group

Marks

• MrkId
• UsrId
• SubId
• LsnId
• Grade: percent
• Passed: Y/N

Edits

• EdtId
• UsrId
• EmpId
• EditDate
• EditTime
• Date
• Flag
• EditType:  Dates/Flags preceded by caret (^)