BEGIN;
CREATE OR REPLACE VIEW "view_report_lines_by_user" AS
SELECT report_lines.id,
    reports.id AS report_id,
    market_configs.market_name,
    users.id AS user_id,
    users.email AS user_email,
    reports.date AS report_date,
    report_lines.date,
    report_lines.payload
   FROM report_lines
     JOIN reports ON (reports.id = report_lines.report_id)
     JOIN market_configs ON (reports.market_config_id = market_configs.id)
     JOIN users ON (market_configs.user_id = users.id);
COMMIT;