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)