1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
# coding: utf-8
from sqlalchemy import Column, DateTime, Float, Index, String, TIMESTAMP, Text, text
from sqlalchemy.dialects.mysql import BIGINT, INTEGER, VARCHAR
from sqlalchemy.ext.declarative import declarative_base
from app.model.base import Base, BaseModel
class ZhiboTheme(Base, BaseModel):
__tablename__ = 'zhibo_theme'
__table_args__ = {'comment': '直播间信息表'}
id = Column(String(64), primary_key=True, comment='唯一主键')
zt_name = Column(String(150), comment='主题名称')
zt_starttime = Column(DateTime, comment='开播时间')
zt_endtime = Column(DateTime, comment='结束时间')
zt_desc = Column(String(512), comment='描述')
zt_roomnum = Column(String(32), comment='（废弃）')
create_time = Column(DateTime, nullable=False, comment='创建时间')
create_by = Column(String(64), comment='创建人')
update_time = Column(DateTime, comment='修改时间')
update_by = Column(String(64), comment='修改人')
deletetag = Column(String(3), comment='删除标识 0:正常，1： 删除 2：草稿')
zt_status = Column(String(2), server_default=text("'1'"), comment='直播间状态 1未开始，2直播中，3已结束')
zt_backimg = Column(String(128), comment='直播背景图（废弃）')
share_pattern = Column(INTEGER(3), comment='分享模式')
zt_img = Column(String(128), comment='直播封面')
zt_iszhibo = Column(String(3), comment='是否含直播')
zt_proid = Column(String(64), comment='关联产品')
zt_uname = Column(String(128), comment='培训人')
zt_flag = Column(String(3), comment='参与人开放标识')
org_id = Column(String(64), comment='机构ID')
zt_password = Column(String(64), comment='密码')
zt_label = Column(String(1024), comment='直播标签')
zt_userids = Column(Text, comment='参与人')
zt_mute = Column(String(3), comment='是否禁言 0：否 1：是')
zt_type = Column(String(64), server_default=text("'1'"), comment='直播类型 1探普之夜，2探普八点半')
zt_appointment_nums = Column(INTEGER(8), server_default=text("'0'"))
zt_info = Column(Text)
zt_qrcode = Column(String(256))
zt_fuli = Column(Text)
zt_cardinal = Column(INTEGER(11), server_default=text("'0'"), comment='直播基数')
zt_isshare = Column(String(3), server_default=text("'0'"), comment='是否可分享')
zt_iscollect_userinfo = Column(String(3), server_default=text("'0'"), comment='是否收集用户信息,1收集,0不收集')
zt_isverification_phone = Column(String(3), server_default=text("'0'"), comment='是否开启手机号验证')
zt_examid = Column(String(128))
parent_id = Column(String(64), index=True, comment='母直播间id')
room_type = Column(INTEGER(5), server_default=text("'1'"), comment='直播间类型 1母直播间，2子直播间')
video_type = Column(INTEGER(5), server_default=text("'1'"), comment='视屏类型 1视频，2音频')
duration_second_show = Column(Float(11, True), server_default=text("'0.00'"), comment='直播时长 显示 单位小时')
real_start_time = Column(DateTime, comment='实际开始时间')
real_end_time = Column(DateTime, comment='真实结束时间')
real_duration_second = Column(INTEGER(11), comment='直播实际时长')
reservation = Column(INTEGER(5), server_default=text("'0'"), comment='是否可预约 1：需要预约 0：不需要预约')
can_broadcast = Column(INTEGER(5), server_default=text("'0'"), comment='可转播设置 1：可转播 0：不可转播')
broadcast_score = Column(INTEGER(11), server_default=text("'0'"), comment='转播积分')
broadcast_num = Column(INTEGER(11), server_default=text("'0'"), comment='转播数量')
participation_rigth = Column(INTEGER(5), server_default=text("'0'"), comment='探普云参与权限0：所有人，1仅注册用户，2仅探普会员可进入，3需要密码')
replay = Column(INTEGER(5), server_default=text("'0'"), comment='回放设置 0：不录制 1：录制')
opening_remarks = Column(String(200), comment='开场白')
user_title = Column(String(20), comment='直播间头衔')
guest_greetings = Column(String(200), comment='访客问候语')
guest_card = Column(String(2), nullable=False, server_default=text("'0'"), comment='是否给访客发送名片（0不发送 1发送） （-针对理财师）')
guest_we_shop = Column(String(2), nullable=False, server_default=text("'0'"), comment='是否给访客发送微店（0不发送 1发送） （-针对理财师）')
friend_greetings = Column(String(200), comment='一级好友问候语')
friend_card = Column(String(2), nullable=False, server_default=text("'0'"), comment='是否给好友发送微店（0不发送 1发送） （-针对理财师）')
friend_we_shop = Column(String(2), nullable=False, server_default=text("'0'"), comment='是否给好友发送微店（0不发送 1发送） （-针对理财师）')
recommend_home_page = Column(INTEGER(5), server_default=text("'0'"), comment='推荐到微店首页 1：可推荐 0：不可推荐')
recommend_time = Column(DateTime, comment='推荐到首页的时间')
participants_num = Column(INTEGER(11), server_default=text("'0'"), comment='参与人数')
online_num = Column(INTEGER(11), server_default=text("'0'"), comment='在线人数')
reservation_num = Column(INTEGER(11), server_default=text("'0'"), comment='预约人数')
information_sheet_num = Column(INTEGER(11), server_default=text("'0'"), comment='已填信息表人数')
replay_num = Column(INTEGER(11), server_default=text("'0'"), comment='回放人数')
sms_template_id = Column(String(32), comment='短信模板id')
manager_name = Column(String(100), comment='主讲人描述，用于直播间主讲人描述')
recommend_home_tanpu = Column(INTEGER(5), server_default=text("'0'"), comment='推荐到探普学堂首页 1：推荐 0：不推荐')
recommend_time_tanpu = Column(DateTime, comment='推荐首页（探普学堂）推荐时间')
participants_pv = Column(INTEGER(11), comment='参数人次 统计pv')
participants_child_pv = Column(INTEGER(11), server_default=text("'0'"), comment='子直播间参与人数总计')
isPrivacy = Column(INTEGER(3), comment='是否隐私直播间0否1是')
iscreate_group_success = Column(INTEGER(3), server_default=text("'0'"), comment='是否已创建群组 0:否 1:是')
max_online_num = Column(INTEGER(11), server_default=text("'0'"), comment='在线人数峰值')
tags = Column(String(255), comment='标签')