sql/Pg-upgrade2/add_emloyee_project_assignment_for_viewing_invoices.sql

   1 -- @tag: add_emloyee_project_assignment_for_viewing_invoices
   2 -- @description: Mitarbeiter*innen Projekten zuweisen können, damit diese Projektrechnungen anschauen dürfen
   3 -- @depends: release_3_5_3
   4 CREATE TABLE employee_project_invoices (
   5   employee_id INTEGER NOT NULL,
   6   project_id  INTEGER NOT NULL,
   7
   8   CONSTRAINT employee_project_invoices_pkey             PRIMARY KEY (employee_id, project_id),
   9   CONSTRAINT employee_project_invoices_employee_id_fkey FOREIGN KEY (employee_id) REFERENCES employee (id) ON DELETE CASCADE,
  10   CONSTRAINT employee_project_invoices_project_id_fkey  FOREIGN KEY (project_id)  REFERENCES project  (id) ON DELETE CASCADE
  11 );