create view sync_securityman_view
as
select `tlk_securityman`.`ID` AS `id`,(case when (`tlk_securityman`.`ITEM_shiming` = '未认证') then 0 when (`tlk_securityman`.`ITEM_shiming` = '认证中') then 1 when (`tlk_securityman`.`ITEM_shiming` = '认证失败') then 2 when (`tlk_securityman`.`ITEM_shiming` = '已认证') then 3 else 0 end) AS `authenticated_status`,`tlk_securityman`.`ITEM_beizhu` AS `authenticated_result`,`tlk_securityman`.`ITEM_LastAuthTime` AS `authenticated_time`,(case when (`tlk_securityman`.`ITEM_screening` = '0') then 1 when (`tlk_securityman`.`ITEM_screening` = '1') then 2 else 0 end) AS `background_screening_status`,`tlk_securityman`.`item_lastcomparetime` AS `last_background_screening_time`,
`tlk_securityman`.`LASTMODIFIED` AS `lastmodified` from `tlk_securityman`