attendance attendancereport classroom exam
aid int(10) * 1 aid int(20) * hno varchar(50) * id int(11)
sid int(10) 1 sid varchar(50) 1 title varchar(50) 1 subject varchar(50)
date date status varchar(50) location varchar(50) teacher varchar(50) 1
capacity int(3) 1 classroom varchar(50)
date date
examresult notice
stime time
exam int(11) id int(11) parent
etime time
student varchar(50) 1 notice varchar(1500) * pid int(11)
marks int(10) odience varchar(100) fname varchar(50)
grade varchar(10) date datetime lname varchar(50) payment
contact varchar(20) id int(11)
job varchar(50) 1 sid varchar(30)
schedule student
address varchar(250) month enum
* sid varchar(25) *
id int(11)
gender varchar(25) fee varchar(20)
subject varchar(50) 1 fname varchar(50)
nic varchar(50) creationDate timestamp
teacher varchar(50) 1 lname varchar(50)
* email varchar(50)
day varchar(50) bday date
stime time address varchar(250) teacher
parent int(10) 1 * tid *
class varchar(50) subject varchar(50)
etime time gender varchar(10) * sid varchar(50) * fname varchar(50)
classroom varchar(25) 1
title varchar(200) lname varchar(50)
* email varchar(50) description varchar(500) address varchar(50)
user
contact varchar(50)
role varchar(50)
bday date
email varchar(50) 1
skill varchar(500)
password varchar(50)
gender varchar(25)
* email varchar(50)
attendance attendancereport classroom exam
aid int(10) * 1 aid int(20) * hno varchar(50) * id int(11)
sid int(10) 1 sid varchar(50) 1 title varchar(50) 1 subject varchar(50)
date date status varchar(50) location varchar(50) teacher varchar(50) 1
capacity int(3) 1 classroom varchar(50)
date date
examresult notice
stime time
exam int(11) id int(11) parent
etime time
student varchar(50) 1 notice varchar(1500) * pid int(11)
marks int(10) odience varchar(100) fname varchar(50)
grade varchar(10) date datetime lname varchar(50) payment
contact varchar(20) id int(11)
job varchar(50) 1 sid varchar(30)
schedule student
address varchar(250) month enum
* sid varchar(25) *
id int(11)
gender varchar(25) fee varchar(20)
subject varchar(50) 1 fname varchar(50)
nic varchar(50) creationDate timestamp
teacher varchar(50) 1 lname varchar(50)
* email varchar(50)
day varchar(50) bday date
stime time address varchar(250) teacher
parent int(10) 1 * tid *
class varchar(50) subject varchar(50)
etime time gender varchar(10) * sid varchar(50) * fname varchar(50)
classroom varchar(25) 1
title varchar(200) lname varchar(50)
* email varchar(50) description varchar(500) address varchar(50)
user
contact varchar(50)
role varchar(50)
bday date
email varchar(50) 1
skill varchar(500)
password varchar(50)
gender varchar(25)
* email varchar(50)