class Schedule(db.Model):
__tablename__ = "Schedule"
id = db.Column(db.Integer, primary_key=True)
day = db.Column(db.String(30), nullable=False)
chet = db.Column(db.Boolean, nullable=False)
group_id = db.Column(db.Integer, db.ForeignKey('group.id'))
interval_id = db.Column(db.Integer, db.ForeignKey('Interval.id'))
subject_id = db.Column(db.Integer, db.ForeignKey('Subject.id'))
lecturer_id = db.Column(db.Integer, db.ForeignKey('Lecturer.id'))
class Test(db.Model):
__tablename__ = "Test"
id = db.Column(db.Integer, primary_key=True)
data = db.Column(db.String(30), unique=True, nullable=False)
class Subject(db.Model):
__tablename__ = "Subject"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(30), unique=True, nullable=False)
class Lecturer(db.Model):
__tablename__ = "Lecturer"
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(30), unique=False, nullable=False)
last_name = db.Column(db.String(30), unique=False, nullable=False)
patronymic = db.Column(db.String(30), unique=True, nullable=False)