//MEMBUAT TABEL PROJECT

CREATE TABLE Project(
    projectId serial PRIMARY KEY,
    categoryId varchar (50) NOT NULL,
    projectName varchar(50) NOT NULL,
    projectDate date NOT NULL,
    projectCost bigint NOT NULL
);


//MENGINPUTKAN DAN MENYIMPAN DATA KE DALAM TABEL PROJECT

INSERT INTO Project (categoryId, projectName, projectDate, projectCost)  VALUES ('1,2,3,4', 'A', '2017-06-19', '100000'), ('5', 'B', '2017-07-20', '200000'), ('4,6', 'C', '2017-08-21', '300000');