Student TimeTable fields

Question

i m working on school management system i m developing student timetable but im totally stuck what field required in data table  any one who have idea what type of field required for time table.

Manoj Kumar Mandal · Answer

Structure which I'm using as i'm also working on similar king of application Id int(11) NO PRI  auto_increment ClassTestId int(11) // Expecting you have a table which contain detail of exam along with uniqueId SubjectId int(11) //Expacting you have a table with subjectname and uniqueId Examdate date FromTime time ToTime time IsPractical int(11) CreatedBy int(11) CreatedOn datetime IsActive int(1)

hasan abbas · Answer

hello can u tell me class diagram of timetable table fields structure. it is honor for me if you guide me about this

hasan abbas · Answer

subject_timetable id (auto_increment) subject_id location_id teacher_id alt_teacher_id (eg substitute teacher) duration period (number 1-however many periods in a day. 6 if I remember correctly) week (number 1-2 or even perhaps 1-52) weekday (number 1-5) notes i create these fields for table is it right

hasan abbas · Answer

thanks

Anurag Sarkar · Answer

You can check data types here please visit this:- http://www.tutorialspoint.com/sql/sql-data-types.htm Datatypes means what type of data do you want to store. T hanks