Python Column Examples

Example #1

class Group(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, unique=True)
    major = db.Column(db.Integer)
    teachers = db.relationship('Teachers_group', backref='group')
    subgroups = db.relationship('SubGroup', backref='group')
    schedule = db.relationship('Schedule', backref='group')

Example #2

class Discipline(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))
    credit = db.Column(db.Integer)
    academic_hours = db.Column(db.Integer)
    groups = db.relationship('Group_discipline', backref='discipline')
    attendance = db.relationship('Attendance', backref='Discipline')
    schedule = db.relationship('Schedule', backref='Discipline')

Example #3

File: user.py Project: akaevjumgal/ejj

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    public_id = db.Column(db.String, unique=True)
    name = db.Column(db.String(50))
    password = db.Column(db.String(50))
    admin = db.Column(db.Boolean)
    teacher = db.Column(db.Boolean)
    student = db.Column(db.Boolean)

Example #4

File: user.py Project: akaevjumgal/ejj

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)
    email = db.Column(db.String)

Example #5

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

Example #6

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    public_id = db.Column(db.String, unique=True)
    name = db.Column(db.String(50), unique=True)
    password = db.Column(db.String(50))
    admin = db.Column(db.Boolean)
    teacher = db.Column(db.Boolean)
    student = db.Column(db.Boolean)
    rteacher = db.relationship('Teacher', backref='user')
    rstudent = db.relationship('Student', backref='user')

Example #7

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

Example #8

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

Example #9

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

Example #10

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)

Example #11

File: user.py Project: akaevjumgal/ejj

class Group(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String, unique=True)
    major = db.Column(db.Integer)

Example #12

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

Example #13

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

Example #14

class ClassTime(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    begining = db.Column(db.String)
    end = db.Column(db.String)
    disciplines = db.relationship('Schedule', backref='Time')

Example #15

class FirstWeek(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    date = db.Column(db.String)

Example #16

class ExceptionDays(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    date = db.Column(db.String)
    todate = db.Column(db.String)

Example #17

class DisciplineType(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))
    short = db.Column(db.String(10))
    disciplines = db.relationship('Schedule', backref='DisciplineType')