db resc

review of relationships

https://www.tutorialspoint.com/dbms/er_model_basic_concepts.htm

https://www.postgresqltutorial.com/postgresql-alter-table/

https://www.postgresqltutorial.com/postgresql-foreign-key/

---

done

ALTER TABLE company 
RENAME COLUMN financial_notes 
TO financial;

ALTER TABLE company 
RENAME COLUMN summary 
TO description;

ALTER TABLE company 
ADD COLUMN purpose VARCHAR (1024);

ALTER TABLE company 
ADD COLUMN user_guid VARCHAR (64);

ALTER TABLE company
ADD CONSTRAINT company_user_guid_fk
FOREIGN KEY (user_guid)
REFERENCES job_tracker_user(guid);

todo (can be done after testing all other changes)

ALTER TABLE job 
DROP COLUMN company_name;