dev/常用SQL语句/dcp对接文档/王欢/会议服务常用SQL.sql

-- 会议方案
SELECT * FROM sys_attachment_info WHERE attachment_business_type = 'meeting_plan'
-- 工作进展(材料)
SELECT * FROM sys_attachment_info WHERE attachment_business_type = 'meeting_make'
-- 嘉宾观点(文本)
SELECT * FROM meeting_out_info WHERE out_type = 'GUANDIAN'
-- 嘉宾观点(文件)
SELECT * FROM meeting_out_info WHERE out_type = 'GUANDIAN_FILE'
-- 嘉宾观点(视频)
SELECT * FROM meeting_out_info WHERE out_type = 'GUANDIAN_VIDEO'
-- 媒体报道
SELECT * FROM meeting_out_info WHERE out_type = 'NEWS'
-- 会议视频
SELECT * FROM meeting_out_info WHERE out_type = 'VIDEO'
-- 会议议程(文件/图片)
SELECT * FROM sys_attachment_info WHERE attachment_business_type = 'img_file'
-- 会议成果
SELECT * FROM meeting_out_info WHERE out_type = 'file'
-- 发言材料
SELECT * FROM sys_attachment_info WHERE attachment_business_type = 'meetingMaterial_annex'
-- 感谢信
SELECT * FROM sys_attachment_info WHERE attachment_business_type = 'meetingThank_annex'
-- 嘉宾邀请函
SELECT * FROM sys_attachment_info WHERE attachment_business_type = 'meetingInvite_annex'
-- 签证邀请函
SELECT * FROM sys_attachment_info WHERE attachment_business_type = 'meetingVisa_annex'
-- 主办会议嘉宾
SELECT * FROM meeting_apply WHERE meeting_yearplan_type_dict = 'main_meeting'
-- 网络会议嘉宾
SELECT * FROM meeting_apply_online