mysql-窗口多表连接视图view

 

 

 create VIEW view_comment
 as 

(select w.idStr,w.content,w.userID,w.wei_id,w.createTime,'01' as type FROM wei_comment_comment w)
UNION ALL
(select r.idStr,r.content,r.userID,r.reviewID wei_id,r.createTime,'07' as type from review_comment r )
UNION ALL
(select i.idStr,i.content,i.userID,i.insResRepID wei_id,i.createTime,'05' as type from institution_res_report_comment i)
UNION ALL
(select n.idStr,n.content,n.usrID userID,n.noticeID wei_id,n.createTime,'06' as type  from notice_comment n)
UNION ALL
(select f.idStr,f.content,f.usrID userID,f.firstDiscloseID wei_id,f.createTime,'08' as type  from first_disclose_comment f)