Tutorial jsf 2.2 hibernate postgreSQL

CREATE DATABASE sales_mart;
CREATE TABLE barang
(
kdbarang character varying(10) NOT NULL,
namabarang character varying(50),
pricebarang double precision,
CONSTRAINT barang_pkey PRIMARY KEY (kdbarang)
)
WITH (
OIDS=FALSE
);
ALTER TABLE barang
OWNER TO postgres;
CREATE TABLE customer
(
kdcustomer character varying NOT NULL,
namacustomer character varying(50),
almtcustomer character varying(50),
CONSTRAINT customer_pkey PRIMARY KEY (kdcustomer)
)
WITH (
OIDS=FALSE
);
ALTER TABLE customer
OWNER TO postgres;
CREATE TABLE d_penjualan
(
djual_serial character varying(10) NOT NULL,
djual_qty double precision,
djual_price double precision,
djual_kdbarang character varying(10),
CONSTRAINT d_penjualan_pkey PRIMARY KEY (djual_serial),
CONSTRAINT d_penjualan_djual_kdbarang_fkey FOREIGN KEY (djual_kdbarang)
REFERENCES barang (kdbarang) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
OIDS=FALSE
);
ALTER TABLE d_penjualan
OWNER TO postgres;
CREATE TABLE h_penjualan
(
hjual_customer character varying(10),
hjual_discrp double precision,
hjual_totalrp double precision,
hjual_tanggal date,
hjual_serial serial NOT NULL,
hjual_invoice character varying(10),
CONSTRAINT h_penjualan_pkey PRIMARY KEY (hjual_serial),
CONSTRAINT h_penjualan_hjual_customer_fkey FOREIGN KEY (hjual_customer)
REFERENCES customer (kdcustomer) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
OIDS=FALSE
);
ALTER TABLE h_penjualan
OWNER TO postgres;