-- 企业注册监管归属地 create view vw_company_supervise as SELECT DOMAINID as domainId, ITEM_REGISTERADDRESSID as areaCode from baibaodunflow.tlk_setsupervise; alter table tenant_invite_attend_site add column area_code varchar(255) null; alter table tenant_invite_depart add column area_code varchar(255) null; -- 企业注册监管归属地 北京 不能编辑入离职日期 -- create view vw_is_hired_live_time_limited as -- SELECT ITEM_DOMAIN_ID as domainId, true as is_hired_date_limited,true as is_leave_date_limited -- from baibaodunflow.tlk_setsupervise where ITEM_REGISTERADDRESSID like '11%'