 ---
 CREATE TABLE aidb.project (
     id INTEGER PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
-    proj_contact INTEGER REFERENCES aidb.employee (id),
-    proj_name TEXT,
-    proj_descr TEXT);
+    contact INTEGER REFERENCES aidb.employee (id),
+    name TEXT,
+    descr TEXT);
 
 COMMENT ON TABLE aidb.location IS 'Project of team in department';
 

CREATE TABLE aidb.employee (
    id INTEGER PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, 
    dept_id INTEGER REFERENCES aidb.department (id),
    dept_contact INTEGER REFERENCES aidb.contact (id),
    descr TEXT);

COMMENT ON TABLE aidb.location IS 'Employee of company';

    contact INTEGER REFERENCES aidb.contact (id)
    );


---
--- LICENSE OWNERSHIP
