class userModel(db.Model):
__tablename__ = "zzjg_user"
username = db.Column(db.String(600)) # 用户名
pwd = db.Column(db.String(600)) # 密码
def __init__(self, **kwargs):
for v, m in kwargs.items():
self.__setattr__(v, m)
def to_dict(self):
return {c.name: getattr(self, c.name) for c in self.__table__.columns}
class yxxxUploadModel(db.Model):
__tablename__ = "zzjg_yxxx_upload"
yxsdm = db.Column(db.String(600), primary_key=True) # 院系所代码
yxsmc = db.Column(db.String(600)) # 院系所名称
xqdm = db.Column(db.String(600)) # 校区代码 默认值01
isok = db.Column(db.String(600)) # 启用标志 T:启用 F:为启用
sjzc = db.Column(db.String(600)) # 1:新增2:修改
def __init__(self, **kwargs):
for v, m in kwargs.items():
self.__setattr__(v, m)
def to_dict(self):
return {c.name: getattr(self, c.name) for c in self.__table__.columns}
class xsxxUploadModel(db.Model):
__tablename__ = "zzjg_xsxx_upload"
flsh = db.Column(db.String(600), primary_key=True)
xh = db.Column(db.String(600))
xm = db.Column(db.String(600))
xb = db.Column(db.String(600))
csrq = db.Column(db.String(600))
csd = db.Column(db.String(600))
jg = db.Column(db.String(600))
mzm = db.Column(db.String(600))
gjdq = db.Column(db.String(600))
sfzjlxm = db.Column(db.String(600))
sfzjlxmc = db.Column(db.String(600))
sfzjh = db.Column(db.String(600))
xjzt = db.Column(db.String(600))
xslbm = db.Column(db.String(600))
xslbmc = db.Column(db.String(600))
szbh = db.Column(db.String(600))
sznj = db.Column(db.String(600))
yxsh = db.Column(db.String(600))
zyh = db.Column(db.String(600))
xz = db.Column(db.String(600))
frxnd = db.Column(db.String(600))
flxnd = db.Column(db.String(600))
xkml = db.Column(db.String(600))
xsdqzt = db.Column(db.String(600))
xqdm = db.Column(db.String(600))
qyzt = db.Column(db.String(600))
fzsbs = db.Column(db.String(600))
bdtime = db.Column(db.String(600))
bz = db.Column(db.String(600))
sjcz = db.Column(db.String(600))
def __init__(self, **kwargs):
for v, m in kwargs.items():
self.__setattr__(v, m)
def to_dict(self):
return {c.name: getattr(self, c.name) for c in self.__table__.columns}
class bjxxUploadModel(db.Model):
__tablename__ = "zzjg_bjxx_upload"
nj = db.Column(db.String(600)) # 入学年级
bh = db.Column(db.String(600), primary_key=True) # 班号
bjmc = db.Column(db.String(600)) # 班级名称
zyh = db.Column(db.String(600)) # 专业号
xqdm = db.Column(db.String(600)) # 校区代码 默认值 01
bjrs = db.Column(db.String(600)) # 预设人数
fdygh = db.Column(db.String(600)) # 辅导员工号
fdysfzjh = db.Column(db.String(600)) # 辅导员身份证件号
xz = db.Column(db.String(600)) # 学制
frxnd = db.Column(db.String(600)) # 入学年度
flxnd = db.Column(db.String(600)) # 离校年度
yxsh = db.Column(db.String(600)) # 院系所号
sjzc = db.Column(db.String(600)) # 1:新增2:修改
qyzt = db.Column(db.String(600)) # T:启动 F:停用
def __init__(self, **kwargs):
for v, m in kwargs.items():
self.__setattr__(v, m)
def to_dict(self):
return {c.name: getattr(self, c.name) for c in self.__table__.columns}
class zyxxUploadModel(db.Model):
__tablename__ = "zzjg_zyxx_upload"
zyh = db.Column(db.String(600), primary_key=True) # 专业号
zwmc = db.Column(db.String(600)) # 专业中文名称
ywmc = db.Column(db.String(600))
zyfxh = db.Column(db.String(600))
bzkzym = db.Column(db.String(600))
yjszym = db.Column(db.String(600))
ssxkdl = db.Column(db.String(600))
ssxk = db.Column(db.String(600))
xz = db.Column(db.String(600))
pycc = db.Column(db.String(600))
zylxdm = db.Column(db.String(600))
yxsh = db.Column(db.String(600))
xqdm = db.Column(db.String(600))
sjzc = db.Column(db.String(600))
qyzt = db.Column(db.String(600))
def __init__(self, **kwargs):
for v, m in kwargs.items():
self.__setattr__(v, m)
def to_dict(self):
return {c.name: getattr(self, c.name) for c in self.__table__.columns}
class zyxxModel(db.Model):
__tablename__ = "zzjg_zyxx"
zyh = db.Column(db.String(600), primary_key=True) # 专业号
zwmc = db.Column(db.String(600)) # 专业中文名称
ywmc = db.Column(db.String(600)) # 专业英文名称
zyfxh = db.Column(db.String(600)) # 专业方向
bzkzym = db.Column(db.String(600)) # 本专科专业码
yjszym = db.Column(db.String(600)) # 研究生专业码
ssxkdl = db.Column(db.String(600)) # 所属学科大类
ssxk = db.Column(db.String(600)) # 所属学科
xz = db.Column(db.String(600)) # 学制
pycc = db.Column(db.String(600)) # 培养层次
zylxdm = db.Column(db.String(600)) # 专业类型
yxsh = db.Column(db.String(600)) # 院系所号
xqdm = db.Column(db.String(600)) # 校区代码 默认值 01
sjzc = db.Column(db.String(600)) # 1:新增2:修改
qyzt = db.Column(db.String(600)) # T:启动 F:停用
is_changed = db.Column(db.String(600)) # 是否改变 0，1
def __init__(self, **kwargs):
for v, m in kwargs.items():
self.__setattr__(v, m)
def to_dict(self):
return {c.name: getattr(self, c.name) for c in self.__table__.columns}