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,
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