class UserInvitation(Base):
"""用户邀请记录表"""
__tablename__ = 'UserInvitation'
UINid = Column(String(64), primary_key=True)
USInviter = Column(String(64), comment='邀请人')
USInvitee = Column(String(64), comment='被邀请人')
UINapi = Column(String(100), comment='触发此次记录的api')
class Setting(Base):
"""setting"""
__tablename__ = "Setting"
STid = Column(String(64), primary_key=True)
STname = Column(String(128), nullable=False)
STvalue = Column(LONGTEXT)
STtype = Column(Integer, nullable=False, comment="{1:客服,2：关于我们}")
class UserActivity(Base):
"""用户参加的活动"""
__tablename__ = 'UserActivity'
UAid = Column(String(64), primary_key=True)
USid = Column(String(64))
ACid = Column(String(64), comment='活动id')
UAstatus = Column(Integer, default=0, comment='用户活动状态 0:待开始， 10：待评价， 20：已评价')
class Series(Base):
"""系列"""
__tablename__ = 'Series'
SEid = Column(String(64), primary_key=True)
SEname = Column(String(255), comment='系列名')
DOid = Column(String(64), comment='医生id')
SEsort = Column(Integer, default=0, comment='排序')
class AssistancePicture(Base):
"""证明图片"""
__tablename__ = 'AssistancePicture'
APid = Column(String(64), primary_key=True)
ATid = Column(String(64))
APtype = Column(Integer, comment='图片类型， 1：诊断证明 2：特困证明')
APimg = Column(Text, url=True, comment='图片地址')
class Characteristicteam(Base):
"""特色团队"""
__tablename__ = "Characteristicteam"
CTid = Column(String(64), primary_key=True)
CTpicture = Column(Text, nullable=False, comment='图片', url=True)
CTname = Column(String(128), nullable=False, comment="姓名")
CTposition = Column(String(128), nullable=False, comment='职位')
CToffice = Column(String(128), nullable=False, comment='科室')
class Evaluation(Base):
"""
问卷
"""
__tablename__ = "Evaluation"
EVid = Column(String(64), primary_key=True)
EVname = Column(String(128), comment="问卷名称", nullable=False)
EVpicture = Column(Text, url=True, comment="问卷图", nullable=False)
class Banner(Base):
"""banner"""
__tablename__ = 'Banner'
BNid = Column(String(64), primary_key=True)
ADid = Column(String(64), comment='创建者id')
BNpicture = Column(Text, nullable=False, comment='图片', url=True)
BNsort = Column(Integer, comment='顺序')
contentlink = Column(LONGTEXT, comment='跳转链接')
class UserHour(Base):
"""用户购买的课时"""
__tablename__ = "UserHour"
UHid = Column(String(64), primary_key=True)
USid = Column(String(64), comment='用户ID')
CLid = Column(String(64), comment='课程ID')
SMnum = Column(Integer, default=0, comment='课时')
UHnum = Column(Integer, default=0, comment='可用课时')
class ReviewPicture(Base):
"""
评论关联图
"""
__tablename__ = "ReviewPicture"
RPid = Column(String(64), primary_key=True)
RVid = Column(String(64), comment="评论id")
RPpicture = Column(Text, url=True, comment="图片")
class DoctorMedia(Base):
"""医生图片"""
__tablename__ = 'DoctorMedia'
DMid = Column(String(64), primary_key=True)
DOid = Column(String(64), comment='医生ID')
DMtype = Column(Integer, default=0, comment='0 医生主图 1 医生列表图 2 医生二维码')
DMmedia = Column(Text, url=True, comment='图片链接')
DMsort = Column(Integer, default=0, comment='图片顺序')
class WalletRecord(Base):
"""余额变动记录"""
__tablename__ = "WalletRecord"
WRid = Column(String(64), primary_key=True)
USid = Column(String(64), comment='用户id')
WRcash = Column(DECIMAL(precision=28, scale=2), comment='变动金额')
WRtype = Column(Integer, default=0, comment='1:充值 2:消费')
ContentId = Column(String(128), comment='关联id, 充值时: OPayid， 消费时: OMid')
class EvaluationItem(Base):
"""
问题
"""
__tablename__ = "EvaluationItem"
EIid = Column(String(64), primary_key=True)
EIname = Column(String(128), comment="题目内容", nullable=False)
EIindex = Column(Integer, comment="标号", nullable=False)
EVid = Column(String(64), comment="问卷id", nullable=False)
class EvaluationAnswer(Base):
"""
问题选项
"""
__tablename__ = "EvaluationAnswer"
EAid = Column(String(64), primary_key=True)
EIid = Column(String(64), comment="问题id", nullable=False)
EAindex = Column(String(8), comment="选项标号", nullable=False)
EAname = Column(Text, comment="选项内容", nullable=False)
EApoint = Column(DECIMAL(scale=2), comment="选项分值", nullable=False)
class SharingParameters(Base):
"""短分享参数"""
__tablename__ = 'SharingParameters'
SPSid = Column(Integer,
autoincrement=True,
primary_key=True,
comment='主键，同时作为缩短的参数')
USid = Column(String(64), comment='用户id')
SPScontent = Column(Text, comment='分享的原参数')
SPSname = Column(String(30), comment='分享的参数名 如: secret_usid, plid')
class Enroll(Base):
"""
报名
"""
__tablename__ = 'Enroll'
ENid = Column(String(64), primary_key=True)
CONid = Column(String(64), comment='会诊ID')
USid = Column(String(64), comment='用户id')
USname = Column(String(255), comment='用户姓名')
UStelphone = Column(String(13), comment='用户手机号')
class Setmeal(Base):
"""
课程套餐
"""
__tablename__ = "Setmeal"
SMid = Column(String(64), primary_key=True)
CLid = Column(String(64), comment="课程id")
CLname = Column(String(128), comment="课程名称")
SMnum = Column(Integer, nullable=False, comment="课时数")
SMprice = Column(Float, nullable=False, comment="套餐价格")
class Video(Base):
"""视频"""
__tablename__ = 'Video'
VIid = Column(String(64), primary_key=True)
VImedia = Column(Text, url=True, comment='视频路由')
VIname = Column(String(255), comment='视频名')
VIthumbnail = Column(Text, url=True, comment='视频缩略图')
SEid = Column(String(64), comment='系列ID')
DOid = Column(String(64), comment='医生id')
VIdur = Column(String(64), comment='时长')
VIsort = Column(Integer, default=0, comment='排序')
VIbriefIntroduction = Column(Text, comment='简介')
class Subscribe(Base):
"""
课程预约
"""
__tablename__ = "Subscribe"
SUid = Column(String(64), primary_key=True)
COid = Column(String(64), comment="排班id")
CLname = Column(String(128), comment="课程名称")
COstarttime = Column(DateTime, comment="课程开始时间，即预约课程时间")
DOid = Column(String(64), comment="医生id")
DOname = Column(String(255), comment="医生名称")
USname = Column(String(255), comment="用户名")
USid = Column(String(64), comment="用户id")
UStelphone = Column(String(16), comment="用户手机号")
SUstatus = Column(Integer,
default=201,
comment="预约状态{201：已预约，202：已上课，203：已评价}")
class Review(Base):
"""
评论
"""
__tablename__ = "Review"
RVid = Column(String(64), primary_key=True)
USid = Column(String(64), comment="评价人id", nullable=False)
USname = Column(String(255), comment="用户名")
USavatar = Column(Text, url=True, comment='用户头像')
RVcontent = Column(Text, comment="评论内容", nullable=False)
DOid = Column(String(64), comment="医生id")
RVtype = Column(Integer, nullable=False, comment="401课程， 402挂诊， 403活动， 404案例， 405视频")
RVtypeid = Column(String(64), comment="关联id")
RVnum = Column(DECIMAL(scale=2), default=5)
class CouponUser(Base):
"""用户的优惠券"""
__tablename__ = 'CouponUser'
UCid = Column(String(64), primary_key=True)
COid = Column(String(64), nullable=False, comment='优惠券id')
USid = Column(String(64), nullable=False, comment='用户id')
COsubtration = Column(DECIMAL(scale=2), default=0, comment='优惠价格')
COstarttime = Column(DateTime, comment='有效起始时间')
COendtime = Column(DateTime, comment='有效期结束时间')
COdownline = Column(DECIMAL(scale=2), comment='使用最低金额限制,0 为无限制')
UCalreadyuse = Column(Integer,
default=602,
comment='是否已经使用 601已使用602未使用603已过期')
OMid = Column(String(64), comment='订单ID')
class Activity(Base):
"""活动"""
__tablename__ = 'Activity'
ACid = Column(String(64), primary_key=True)
ADid = Column(String(64), comment='创建人id')
ACname = Column(String(255), comment='活动名称')
ACbanner = Column(Text, url=True, comment='活动主图')
ACorganizer = Column(String(255), comment='举办人')
ACstartTime = Column(DateTime, comment='活动时间')
AClocation = Column(String(255), comment='活动地点')
ACdetail = Column(Text, comment='活动介绍')
ACnumber = Column(Integer, comment='活动人数')
ACstatus = Column(Integer, default=0, comment='活动状态 0：未开始， 10：已结束')
@orm.reconstructor
def __init__(self):
super(Activity, self).__init__()
self.hide('ADid')
class Coupon(Base):
"""优惠券"""
__tablename__ = 'Coupon'
COid = Column(String(64), primary_key=True)
COstatus = Column(Integer, default=501, comment='状态501可领取502已结束')
COstarttime = Column(DateTime, comment='有效起始时间')
COendtime = Column(DateTime, comment='有效期结束时间')
COdownline = Column(DECIMAL(scale=2), comment='使用最低金额限制,0 为无限制')
COsubtration = Column(DECIMAL(scale=2), default=0, comment='优惠价格')
COlimitnum = Column(Integer, default=0, comment='发放数量')
COgetnum = Column(Integer, default=0, comment='已领数量')
class Doctor(Base):
"""医生"""
__tablename__ = 'Doctor'
DOid = Column(String(64), primary_key=True)
DOname = Column(String(255), nullable=False, comment='医生名')
DOtel = Column(String(13), default=0, comment='医生电话')
DOtitle = Column(String(255), comment='医生职称')
DOdetails = Column(Text, comment='医生简介')
DOwxid = Column(String(255), comment='微信ID')
DOskilledIn = Column(Text, comment='擅长方向')
DOsort = Column(Integer, default=0, comment='科室医生排序')
DOpassword = Column(String(255), comment='医生登录密码')
# DOshift = Column(DateTime, comment='会诊时间')
DEid = Column(String(64), comment='科室id')
@orm.reconstructor
def __init__(self):
super(Doctor, self).__init__()
self.fields = ['DEid', 'DOname', 'DOid', 'DOtitle', 'createtime']
class Course(Base):
"""
课程排班
"""
__tablename__ = "Course"
COid = Column(String(64), primary_key=True)
CLid = Column(String(64), comment="课程id")
CLname = Column(String(128), comment="课程名称")
DOid = Column(String(64), comment="医生id")
DOname = Column(String(255), comment="医生名称")
COstarttime = Column(DateTime, nullable=False, comment="开始时间")
COendtime = Column(DateTime, nullable=False, comment="结束时间")
COnum = Column(Integer, default=0, comment="限制人数")
COstatus = Column(Integer,
default=101,
comment="课程状态 {101: 未开始 102: 已开始 103：已结束}")
class Classes(Base):
"""
课程
"""
__tablename__ = "Classes"
CLid = Column(String(64), primary_key=True)
CLname = Column(String(128), nullable=False, comment="课程名称")
CLpicture = Column(Text, url=True, comment="课程图")
DEid = Column(String(64), comment="科室id")
DEname = Column(String(255), nullable=False, comment="科室名称")
CLintroduction = Column(Text, comment="详细介绍")
CLindex = Column(Integer, default=1, comment="权重")
CLprice = Column(Float, comment="课时价格")
class OrderPay(Base):
"""
付款流水
"""
__tablename__ = 'OrderPay'
OPayid = Column(String(64), primary_key=True)
OPayno = Column(String(64), index=True, comment='交易号, 自己生成') # 即out_trade_no
OPayType = Column(Integer, default=0, comment='支付方式 0 微信 10 积分')
OPaytime = Column(DateTime, comment='付款时间')
OPayMount = Column(DECIMAL(precision=28, scale=2), comment='付款金额')
OPaysn = Column(String(64), comment='第三方支付流水')
OPayJson = Column(Text, comment='回调原文')
OPaymarks = Column(String(255), comment='备注')
class Symptom(Base):
"""症状"""
__tablename__ = 'Symptom'
SYid = Column(String(64), primary_key=True)
SYname = Column(String(255), nullable=False, comment='症状名')
SYsort = Column(Integer, default=0, comment='症状排序')
DEid = Column(String(64), comment='科室id')
SYage = Column(String(16), comment='发病年龄')
SYdt = Column(String(255), comment='病种')
SYtime = Column(String(255), comment='治疗时间')
SYcommon = Column(Text, comment='常见症状')
SYreason = Column(Text, comment='发病原因')
SYattention = Column(Text, comment='注意事项')
@orm.reconstructor
def __init__(self):
super(Symptom, self).__init__()
self.fields = [
'SYid', 'SYname', 'DEid', 'SYage', 'SYdt', 'SYtime', 'SYcommon',
'SYreason', 'SYattention'
]
class UserAddress(Base):
"""用户地址"""
__tablename__ = 'UserAddress'
UAid = Column(String(64), primary_key=True)
USid = Column(String(64), comment='用户id')
UAname = Column(String(16), nullable=False, comment='收货人姓名')
UAtel = Column(String(16), nullable=False, comment='收货人电话')
UAtext = Column(String(255), nullable=False, comment='具体地址')
UAdefault = Column(Boolean, default=False, comment='默认收货地址')
AAid = Column(String(8), nullable=False, comment='关联的区域id')
class AnswerItem(Base):
"""
用户答案填写项
"""
__tablename__ = "AnswerItem"
AIid = Column(String(64), primary_key=True)
EIname = Column(String(128), comment="题目内容", nullable=False)
EAindex = Column(String(8), comment="选项标号", nullable=False)
EAname = Column(Text, comment="选项内容", nullable=False)
EApoint = Column(DECIMAL(scale=2), comment="选项分值", nullable=False)
USid = Column(String(64), comment="用户id", nullable=False)
ANid = Column(String(64), comment="用户答案填写id", nullable=False)
