There are three tables in our database: teacher, teacher_credential and school_teacher_relation
- teacher table: teacher_id, teacher_name, teacher_dob, teacher_gender, teacher_address, teacher_address_pincode, school_board, teacher_email, teacher_phone_number, teacher_alternate_phone_number
required columns: teacher_name, teacher_dob, teacher_gender, teacher_address, teacher_address_pincode, school_board, teacher_email, teacher_phone_number
optional columns: teacher_alternate_phone_number
default columns: school_id, teacher_alternate_phone_number
- teacher_credential table: teacher_id, teacher_phone_number, teacher_password
required columns: teacher_phone_number, teacher_password
optional columns:
default columns: teacher_id
- school_teacher_relation table: school_id, teacher_id, teacher_role, teacher_from_class_id, teacher_to_class_id, teacher_joining_date
required columns: teacher_role, teacher_from_class_id, teacher_to_class_id
optional columns: teacher_joining_date
default columns: school_id, teacher_id
Based on these table details we are have to create three APIs one for signing, second for signup, third to connect teachers and schools, fouth to show profile details and fifth for update profile.
@sonu-ind-dev
There are three tables in our database: teacher, teacher_credential and school_teacher_relation
required columns: teacher_name, teacher_dob, teacher_gender, teacher_address, teacher_address_pincode, school_board, teacher_email, teacher_phone_number
optional columns: teacher_alternate_phone_number
default columns: school_id, teacher_alternate_phone_number
required columns: teacher_phone_number, teacher_password
optional columns:
default columns: teacher_id
required columns: teacher_role, teacher_from_class_id, teacher_to_class_id
optional columns: teacher_joining_date
default columns: school_id, teacher_id
Based on these table details we are have to create three APIs one for signing, second for signup, third to connect teachers and schools, fouth to show profile details and fifth for update profile.
@sonu-ind-dev