kali ini kita akan membahas tentang bagaimana memulai program baru bernama My SQL Postgree
untuk mendownload detailnya klik disini
berikut ini contoh script/sintaksnya:
create table barang
(
kdbarang character varying(5) not null,
nmbarang character varying(50),
satuan character varying(4),
hrg_beli_sat bigint,
hrg_jual_sat bigint,
stock integer,
Constraint pk_barang PRIMARY KEY (kdbarang)
)
create table pelanggan
(
idpelanggan varchar(5) not null,
nmpelanggan character varying(50),
almtpelanggan character varying(50),
kotapelanggan character varying(21),
telpelanggan character varying(20),
Constraint pk_pelanggan primary key (idpelanggan)
)
create table supplier
(
idsupplier varchar(5),
nmsupplier varchar(50),
almtsupplier varchar(50),
kotasupplier varchar(21),
telsupplier varchar(20),
Constraint pk_supplier Primary key (idsupplier)
)
create table pembelian
(
nmrnota character varying NOT NULL DEFAULT 7,
idsupplier character varying(5),
tglbeli date,
totalbeli bigint,
Constraint pk_pembelian PRIMARY KEY(nmrnota),
Constraint fk_supplier Foreign Key (idsupplier)
references supplier(idsupplier)
)
create table penjualan
(
nmrnota character varying not null default 7,
idpelanggan character varying(5),
tgljual date,
totaljual money,
Constraint pk_penjualan primary key(nmrnota),
Constraint fk_penjualan foreign key (idpelanggan)
References pelanggan (idpelanggan)
)