
-- 企业注册监管归属地
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%'
