< prev

Page 1Page 2Page 3Page 4Page 5Page 6Page 7Page 8Page 9Page 10Page 11Page 12Page 13Page 14Page 15

Page 11 of 15
next >

Majalah Ilmiah UNIKOM

Vol.13 No. 2

259

H a l a m a n

2. Tabel relasi

Gambar 6. Tabel Relasi ERP UKM

3. Implementasi Sql

No

Nama Tabel

Query Sql

1.

Barang

CREATE TABLE IF NOT EXISTS `barang` (

`no_ukm` varchar(24) NOT NULL,

`kode_barang` varchar(24) NOT NULL,

`nama_barang` varchar(24) NOT NULL,

`warna_barang` varchar(24) NOT NULL,

`jenis_barang` varchar(12) NOT NULL,

`harga_barang` int(12) NOT NULL,

`keterangan_barang` text NOT NULL,

`status_barang` varchar(24) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2.

Beban

CREATE TABLE IF NOT EXISTS `beban` (

`no_ukm` varchar(24) NOT NULL,

`no_beban` varchar(24) NOT NULL,

`tanggal_beban` date NOT NULL,

`tanggal_input` date NOT NULL,

`subtotal_beban` int(12) NOT NULL

) ENGINE

Sintya Sukarta, Lusi Melian

,

Rauf Fauzan