CREATE OR REPLACE VIEW SEM_VYPSANI_UZIVATELU
AS
SELECT id, username, jmeno, prijmeni, email, sem_role.nazev AS ROLE, sem_staty.meny_kod
 AS MENA
FROM sem_users
JOIN sem_role ON sem_users.role_id = sem_role.id
JOIN sem_staty ON sem_users.staty_id = sem_staty.id;

CREATE OR REPLACE VIEW SEM_VYPSANI_OBEDNAVEK
AS
SELECT sem_objednavky.id, datum, stav, obsah, produkty_id, users_id, jmeno, prijmeni, email
FROM sem_objednavky
JOIN sem_users ON sem_objednavky.users_id = sem_users.id;

CREATE OR REPLACE VIEW SEM_VYPSANI_PRODUKTU
AS
SELECT sem_produkty.id, nazev, popis, upozorneni, schnuti, obsah, cena
FROM sem_produkty
JOIN "SEM_Produkty-parametry" ON sem_produkty.id = "SEM_Produkty-parametry".PRODUKTY_ID;

CREATE OR REPLACE VIEW SEM_PRODUKTY_foto
AS
SELECT * FROM "SEM_Produkty-foto" join sem_produkty using (ID)
ORDER BY id ASC;