Ejemplo n.º 1
0
class CallSchedule(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    school_id = db.Column(db.Integer,
                          db.ForeignKey("school.id"),
                          nullable=False)
    subject_number = db.Column(db.Integer, nullable=False, unique=False)
    start = db.Column(db.String(5), nullable=False, unique=False)
    end = db.Column(db.String(5), nullable=False, unique=False)
Ejemplo n.º 2
0
class Message(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    sender_id = db.Column(db.Integer, nullable=False, unique=False)
    sender_role = db.Column(db.String(11), nullable=False, unique=False)
    recipient_role = db.Column(db.String(11), nullable=False, unique=False)
    recipient_id = db.Column(db.Integer, nullable=False, unique=False)
    text = db.Column(db.Text, unique=False, nullable=False)
    date = db.Column(db.DateTime,
                     nullable=False,
                     default=lambda: datetime.now())
    read = db.Column(db.Boolean, nullable=False, default=False)
Ejemplo n.º 3
0
class Announcement(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    school_id = db.Column(db.Integer,
                          db.ForeignKey("school.id"),
                          nullable=False)
    author_id = db.Column(db.Integer, nullable=False, unique=False)
    author_role = db.Column(db.String(11), nullable=False, unique=False)
    header = db.Column(db.String(80), nullable=False, unique=False)
    text = db.Column(db.Text, unique=False, nullable=False)
    for_users = db.Column(db.String(34), unique=False, nullable=False)
    date = db.Column(db.DateTime,
                     nullable=False,
                     default=lambda: datetime.now())
Ejemplo n.º 4
0
class Grade(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    number = db.Column(db.Integer, unique=False, nullable=False)
    letter = db.Column(db.String(1), unique=False, nullable=False)
    school_id = db.Column(db.Integer,
                          db.ForeignKey("school.id"),
                          nullable=False)
Ejemplo n.º 5
0
class Request(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    region = db.Column(db.String(50), unique=False, nullable=False)
    city = db.Column(db.String(50), unique=False, nullable=False)
    school = db.Column(db.String(80), unique=False, nullable=False)
    name = db.Column(db.String(30), unique=False, nullable=False)
    surname = db.Column(db.String(30), unique=False, nullable=False)
    patronymic = db.Column(db.String(30), unique=False, nullable=False)
    email = db.Column(db.String(50), unique=True, nullable=False)
    password_hash = db.Column(db.String(128), unique=True, nullable=False)
Ejemplo n.º 6
0
class User:
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(30), unique=False, nullable=False)
    surname = db.Column(db.String(30), unique=False, nullable=False)
    patronymic = db.Column(db.String(30), unique=False, nullable=False)
    email = db.Column(db.String(50), unique=True, nullable=False)
    login = db.Column(db.String(31), unique=True, nullable=False)
    password_hash = db.Column(db.String(128), unique=False, nullable=False)
    throwaway_password = db.Column(db.Boolean, default=True)
Ejemplo n.º 7
0
class Subject(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(25), unique=False, nullable=False)
    school_id = db.Column(db.Integer,
                          db.ForeignKey("school.id"),
                          nullable=False)
Ejemplo n.º 8
0
class School(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    region = db.Column(db.String(50), unique=False, nullable=False)
    city = db.Column(db.String(50), unique=False, nullable=False)
    school = db.Column(db.String(80), unique=False, nullable=False)