class User(db.Model, UserMixin):
__tablename__ = 'User'
id = db.Column(db.Integer, primary_key=True)
user_type = db.Column(
db.Integer, nullable=False) #user_type 0 for student and 1 for faculty
password = db.Column(db.String(20), nullable=False)
email = db.Column(db.String(150), unique=True, nullable=False)
def get_id(self):
return (self.id)
def __repr__(self):
return '<user %r>' % self.email
class Department(db.Model):
__tablename__ = 'Department'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), nullable=False)
hod_id = db.Column(db.Integer, db.ForeignKey('Faculty.id'), unique=True)
hod = db.relationship('Faculty', uselist=False, backref='hod')
def __repr__(self):
return '<%r>' % self.name
class Student(db.Model):
__tablename__ = 'Student'
id = db.Column(db.Integer, nullable=False, primary_key=True)
name = db.Column(db.String(50), nullable=False)
email = db.Column(db.String(150), unique=True, nullable=False)
phone = db.Column(db.Integer, unique=True, nullable=True)
address = db.Column(db.String(200), nullable=False)
city = db.Column(db.String(20), nullable=False)
course = db.Column(db.String(10), nullable=False)
semester = db.Column(db.Integer, nullable=False)
batch = db.Column(db.String(10), nullable=False)
pincode = db.Column(db.Integer, nullable=False)
country = db.Column(db.String(10), nullable=False)
department = db.Column(db.String(20), nullable=False)
dateofbirth = db.Column(db.String(20), nullable=False)
dateofjoining = db.Column(db.String(20), nullable=False)
def __repr__(self):
return '<%r>' % self.name
class Marks(db.Model):
__tablename__ = 'Marks'
id = db.Column(db.Integer, primary_key=True)
marks = db.Column(db.Integer, nullable=True)
semester = db.Column(db.Integer, nullable=False)
student_id = db.Column(db.Integer, db.ForeignKey("Student.id"))
sub_code = db.Column(db.String(50), db.ForeignKey("Subjects.id"))
obtained_by = db.relationship('Student')
obtained_in = db.relationship('Subjects')
def __repr__(self):
return '<%r>' % self.sub_code
class Subjects(db.Model):
__tablename__ = 'Subjects'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), nullable=False)
semester = db.Column(db.Integer, nullable=False)
department_id = db.Column(db.Integer, db.ForeignKey("Department.id"))
faculty_id = db.Column(db.Integer, db.ForeignKey("Faculty.id"))
taught_by_department = db.relationship('Department')
taught_by_faculty = db.relationship('Faculty')
def __repr__(self):
return '<%r>' % self.name