CREATE OR REPLACE VIEW `person_view` AS select `person`.`uuid` AS `uuid`,`person`.`aindex` AS `aindex`,`person`.`company` AS `company`,`person`.`migration` AS `migration`,`person`.`migration_target` AS `migration_target`,`person`.`company_role` AS `company_role`,`person`.`name` AS `name`,`person`.`firstname` AS `firstname`,`person`.`surname` AS `surname`,`person`.`shorthand` AS `shorthand`,`person`.`email` AS `email`,`person`.`phonenumber_cc` AS `phonenumber_cc`,`person`.`phonenumber` AS `phonenumber`,`person`.`jobtitle` AS `jobtitle`,`person`.`qualification` AS `qualification`,`person`.`qualification_code` AS `qualification_code`,`person`.`role` AS `role`,`person`.`role_code` AS `role_code`,`person`.`delivery_address` AS `delivery_address`,`person`.`InsertTime` AS `InsertTime`,`person`.`UpdateTime` AS `UpdateTime`,`person`.`migrated` AS `migrated`,`person`.`competence_lpg_supervisor` AS `competence_lpg_supervisor`,`person`.`competence_lpg_operator` AS `competence_lpg_operator`,`person`.`enabled` AS `enabled`,`person`.`birth_date` AS `birth_date`,`person`.`birth_place` AS `birth_place`,`company`.`name` AS `company_name` from (`person` left join `company` on((`person`.`company` = `company`.`uuid`)));