Python Column示例

示例#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')

示例#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')

示例#3

文件： user.py 项目： 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)

示例#4

文件： user.py 项目： 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)

示例#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')

示例#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')

示例#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())

示例#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'))

示例#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))

示例#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)

示例#11

文件： user.py 项目： 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)

示例#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'))

示例#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')

示例#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')

示例#15

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

示例#16

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

示例#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')