TYPE=VIEW
query=select `wmsdb`.`t_staff`.`staffId` AS `staffId`,`wmsdb`.`t_staff`.`jobNumber` AS `jobNumber`,`wmsdb`.`t_staff`.`staffName` AS `staffName`,`wmsdb`.`t_staff`.`deptId` AS `deptId`,`t_deptdict`.`dictName` AS `deptName`,`wmsdb`.`t_staff`.`rankId` AS `rankId`,`t_rankdict`.`dictName` AS `rankName`,`t_groupdict`.`dictName` AS `groupName`,`wmsdb`.`t_staff`.`tel` AS `tel`,`wmsdb`.`t_staff`.`entryTime` AS `entryTime`,`wmsdb`.`t_staff`.`workContent` AS `workContent`,`wmsdb`.`t_staff`.`leader` AS `leader`,`wmsdb`.`t_staff`.`status` AS `status`,`wmsdb`.`t_staff`.`groupId` AS `groupId`,`wmsdb`.`t_user`.`userId` AS `userId`,`wmsdb`.`t_user`.`lastLoginIP` AS `lastLoginIP`,`wmsdb`.`t_user`.`lastLoginTime` AS `lastLoginTime`,`wmsdb`.`t_user`.`userName` AS `userName`,`t_groupdict`.`status` AS `groupStatus`,`t_rankdict`.`status` AS `rankStatus`,`t_deptdict`.`status` AS `deptStatus` from ((((`wmsdb`.`t_staff` left join `wmsdb`.`t_dict` `t_deptdict` on(((`wmsdb`.`t_staff`.`deptId` = `t_deptdict`.`dictId`) and (`t_deptdict`.`dictType` = 8)))) left join `wmsdb`.`t_dict` `t_rankdict` on(((`wmsdb`.`t_staff`.`rankId` = `t_rankdict`.`dictId`) and (`t_rankdict`.`dictType` = 9)))) left join `wmsdb`.`t_dict` `t_groupdict` on(((`wmsdb`.`t_staff`.`groupId` = `t_groupdict`.`dictId`) and (`t_groupdict`.`dictType` = 10)))) left join `wmsdb`.`t_user` on((`wmsdb`.`t_user`.`userId` = `wmsdb`.`t_staff`.`staffId`)))
md5=89afec3964b59bc3655eb0e5c938cce6
updatable=0
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2016-01-12 06:01:00
create-version=1
source=select `t_staff`.`staffId` AS `staffId`,`t_staff`.`jobNumber` AS `jobNumber`,`t_staff`.`staffName` AS `staffName`,`t_staff`.`deptId` AS `deptId`,`t_deptdict`.`dictName` AS `deptName`,`t_staff`.`rankId` AS `rankId`,`t_rankdict`.`dictName` AS `rankName`,`t_groupdict`.`dictName` AS `groupName`,`t_staff`.`tel` AS `tel`,`t_staff`.`entryTime` AS `entryTime`,`t_staff`.`workContent` AS `workContent`,`t_staff`.`leader` AS `leader`,`t_staff`.`status` AS `status`,`t_staff`.`groupId` AS `groupId`,`t_user`.`userId` AS `userId`,`t_user`.`lastLoginIP` AS `lastLoginIP`,`t_user`.`lastLoginTime` AS `lastLoginTime`,`t_user`.`userName` AS `userName`,`t_groupdict`.`status` AS `groupStatus`,`t_rankdict`.`status` AS `rankStatus`,`t_deptdict`.`status` AS `deptStatus` from ((((`t_staff` left join `t_dict` `t_deptdict` on(((`t_staff`.`deptId` = `t_deptdict`.`dictId`) and (`t_deptdict`.`dictType` = 8)))) left join `t_dict` `t_rankdict` on(((`t_staff`.`rankId` = `t_rankdict`.`dictId`) and (`t_rankdict`.`dictType` = 9)))) left join `t_dict` `t_groupdict` on(((`t_staff`.`groupId` = `t_groupdict`.`dictId`) and (`t_groupdict`.`dictType` = 10)))) left join `t_user` on((`t_user`.`userId` = `t_staff`.`staffId`)))
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `wmsdb`.`t_staff`.`staffId` AS `staffId`,`wmsdb`.`t_staff`.`jobNumber` AS `jobNumber`,`wmsdb`.`t_staff`.`staffName` AS `staffName`,`wmsdb`.`t_staff`.`deptId` AS `deptId`,`t_deptdict`.`dictName` AS `deptName`,`wmsdb`.`t_staff`.`rankId` AS `rankId`,`t_rankdict`.`dictName` AS `rankName`,`t_groupdict`.`dictName` AS `groupName`,`wmsdb`.`t_staff`.`tel` AS `tel`,`wmsdb`.`t_staff`.`entryTime` AS `entryTime`,`wmsdb`.`t_staff`.`workContent` AS `workContent`,`wmsdb`.`t_staff`.`leader` AS `leader`,`wmsdb`.`t_staff`.`status` AS `status`,`wmsdb`.`t_staff`.`groupId` AS `groupId`,`wmsdb`.`t_user`.`userId` AS `userId`,`wmsdb`.`t_user`.`lastLoginIP` AS `lastLoginIP`,`wmsdb`.`t_user`.`lastLoginTime` AS `lastLoginTime`,`wmsdb`.`t_user`.`userName` AS `userName`,`t_groupdict`.`status` AS `groupStatus`,`t_rankdict`.`status` AS `rankStatus`,`t_deptdict`.`status` AS `deptStatus` from ((((`wmsdb`.`t_staff` left join `wmsdb`.`t_dict` `t_deptdict` on(((`wmsdb`.`t_staff`.`deptId` = `t_deptdict`.`dictId`) and (`t_deptdict`.`dictType` = 8)))) left join `wmsdb`.`t_dict` `t_rankdict` on(((`wmsdb`.`t_staff`.`rankId` = `t_rankdict`.`dictId`) and (`t_rankdict`.`dictType` = 9)))) left join `wmsdb`.`t_dict` `t_groupdict` on(((`wmsdb`.`t_staff`.`groupId` = `t_groupdict`.`dictId`) and (`t_groupdict`.`dictType` = 10)))) left join `wmsdb`.`t_user` on((`wmsdb`.`t_user`.`userId` = `wmsdb`.`t_staff`.`staffId`)))
