class Attendance(db.Model):
id = db.Column(db.Integer, primary_key=True)
student_id = db.Column(db.Integer, db.ForeignKey('student.id'))
discipline_id = db.Column(db.Integer, db.ForeignKey('discipline.id'))
dis_type = db.Column(db.Integer, db.ForeignKey('discipline_type.id'))
status = db.Column(db.Boolean)
date = db.Column(db.DateTime, default=datetime.utcnow())
class Group_discipline(db.Model):
id = db.Column(db.Integer, primary_key=True)
group_id = db.Column(db.Integer, db.ForeignKey('group.id'))
sub_id = db.Column(db.Integer)
discipline_id = db.Column(db.Integer, db.ForeignKey('discipline.id'))
dis_type = db.Column(db.Integer, db.ForeignKey('discipline_type.id'))
teacher_id = db.Column(db.Integer, db.ForeignKey('teacher.id'))
class Schedule(db.Model):
id = db.Column(db.Integer, primary_key=True)
teacher_id = db.Column(db.Integer, db.ForeignKey('teacher.id'))
group_id = db.Column(db.Integer, db.ForeignKey('group.id'))
discipline_id = db.Column(db.Integer, db.ForeignKey('discipline.id'))
sub_id = db.Column(db.Integer)
dis_type = db.Column(db.Integer, db.ForeignKey('discipline_type.id'))
time = db.Column(db.Integer, db.ForeignKey('class_time.id'))
week_day = db.Column(db.Integer)
weeks = db.Column(db.Integer)
week_type = db.Column(db.Integer)
auditory = db.Column(db.String(10))
class Student(db.Model):
id = db.Column(db.Integer, primary_key=True)
full_name = db.Column(db.String, unique=True)
group_id = db.Column(db.Integer)
status_id = db.Column(db.Integer)
phone = db.Column(db.String)
auth_num = db.Column(db.Integer, db.ForeignKey('user.id'))
email = db.Column(db.String)
attendance = db.relationship('Attendance', backref='student')
class SubGroup(db.Model):
id = db.Column(db.Integer, primary_key=True)
group_id = db.Column(db.Integer, db.ForeignKey('group.id'))
teacher_id = db.Column(db.Integer)
sub = db.Column(db.Integer)
student_id = db.Column(db.Integer)
class Teachers_group(db.Model):
id = db.Column(db.Integer, primary_key=True)
teacher_id = db.Column(db.Integer, db.ForeignKey('teacher.id'))
group_id = db.Column(db.Integer, db.ForeignKey('group.id'))
class Teacher(db.Model):
id = db.Column(db.Integer, primary_key=True)
full_name = db.Column(db.String(50), unique=True)
auth_num = db.Column(db.Integer, db.ForeignKey('user.id'))
groups = db.relationship('Teachers_group', backref='teacher')
disciplines = db.relationship('Group_discipline', backref='teacher')