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')