/* You can update the columns, but you can not delete rows. reason: the column `family` refers to another table. */

DROP VIEW IF EXISTS update__map_danger;

CREATE VIEW update__map_danger AS
SELECT 
m.`id`,
t.`family`,
m.`genus`,
m.`species`,
m.`subspecies`,
m.`danger`,
m.`main`,
m.`dataquality`,
m.`description`,
m.`citation`,
m.`reference`
FROM `map__danger` AS m
INNER JOIN tax__genus AS t 
USING (genus);