class Courses(mixins.CustomizingMixin, db.Model): __tablename__ = 'v_subjects' id = db.Column('id_subjects', db.Integer, primary_key=True, key='id') sport = db.Column(db.Integer, db.ForeignKey('v_sports.id')) shortcut = db.Column(db.String) day = db.Column(db.Integer) starts_at = db.Column('begin', db.String, key='starts_at') ends_at = db.Column('end', db.String, key='ends_at') hall = db.Column(db.Integer, db.ForeignKey('v_hall.id')) teacher = db.Column('lector', db.Integer, db.ForeignKey('v_lectors.id'), key='teacher') notice = db.Column(db.String) semester = db.Column(db.Integer)
class Blog(db.Model): """An online weblog.""" __tablename__ = 'blog' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String) subheader = db.Column(db.String, nullable=True) creator_id = db.Column(db.Integer, db.ForeignKey('user.id')) creator = db.relationship(User)
class Post(db.Model): """An individual blog post.""" __tablename__ = 'post' id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String) content = db.Column(db.String) posted_at = db.Column(db.DateTime, default=datetime.datetime.now) author_id = db.Column(db.Integer, db.ForeignKey('user.id')) author = db.relationship(User)
class Enrollments(mixins.CustomizingMixin, db.Model): __tablename__ = 'v_students' id = db.Column('id_student', db.Integer, primary_key=True, key='id') personal_number = db.Column(db.Integer) kos_course_code = db.Column('kos_kod', db.String, key='kos_course_code') course = db.Column('utvs', db.Integer, db.ForeignKey('v_subjects.id'), key='course') semester = db.Column(db.String) registration_date = db.Column(db.DateTime) tour = db.Column(db.Boolean) _kos_code = db.Column('kos_code', db.Boolean, key='_kos_code')