course management.md

Contacts

• Id
• Name
• Email
• Personal HP
• Office Hp
• Company
• Address

Enquiry

• Contact Id
• When
• Source
• Follow By
• Status
• Pax of Student
• Chinese Level
• Details

Courses

• Name
• Hours
• minimal number of students
• maximum number of students
• target level
• details
• number of classes

Teachers

• Id
• Contact Id
• Comments

Students

• Id
• Contact Id

Student Tracking

• student id
• when
• updates

TeacherLessionTracking

• Lesson Id
• Comments
• Listener Id

Classes

• Id
• Course Id
• Teacher Id
• start time

Rooms

• Id
• Room Name
• Address

Lessons

• Id
• Class Id
• hours
• when
• when end
• Room id
• Address (Contact Id) // this is for one 2 one lesson
• lesson type (trial lesson, make up, normal, one 2 one)
• Teacher ID
• Cancelled?
• Status (planned, cancelled, taught)

Lession Attendance

• Student Id
• Lesson Id
• state ( attended, missed)
• reason
• Feedback