2024-08-20 08:06:10 +00:00
|
|
|
CREATE OR REPLACE DEFINER=`vn`@`localhost`
|
2024-01-15 11:31:03 +00:00
|
|
|
SQL SECURITY DEFINER
|
|
|
|
|
VIEW `vn`.`ediGenus`
|
|
|
|
|
AS SELECT `g`.`genus_id` AS `id`,
|
|
|
|
|
`g`.`latin_genus_name` AS `latinGenusName`,
|
|
|
|
|
`g`.`entry_date` AS `entried`,
|
|
|
|
|
`g`.`expiry_date` AS `dued`,
|
|
|
|
|
`g`.`change_date_time` AS `modified`
|
|
|
|
|
FROM `edi`.`genus` `g`
|
