< prev

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

Page 12 of 15
next >

Majalah Ilmiah UNIKOM

Vol.13 No. 2

260

H a l a m a n

No

Nama Tabel

Query Sql

3.

Karyawan

CREATE TABLE IF NOT EXISTS `karyawan` (

`no_ukm` varchar(24) NOT NULL,

`kode_karyawan` varchar(24) NOT NULL,

`nama_karyawan` varchar(24) NOT NULL,

`alamat_karyawan` text NOT NULL,

`no_telepon_karyawan` varchar(24) NOT NULL DE-

FAULT '',

`jabatan_karyawan` varchar(24) NOT NULL DEFAULT ''

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

4.

Pemasok

CREATE TABLE IF NOT EXISTS `pemasok` (

`no_ukm` varchar(24) NOT NULL,

`no_pemasok` varchar(24) NOT NULL,

`nama_pemasok` varchar(24) NOT NULL,

`alamat_pemasok` text NOT NULL,

`no_telepon_pemasok` varchar(24) NOT NULL DE-

FAULT ''

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

5.

Pembelian

CREATE TABLE IF NOT EXISTS `pembelian` (

`no_ukm` varchar(24) NOT NULL,

`no_pembelian` varchar(24) NOT NULL,

`no_pemasok` varchar(24) NOT NULL,

`tanggal_pembelian` date NOT NULL,

`tanggal_input` date NOT NULL,

`potongan_pembelian` int(12) NOT NULL,

`subtotal_pembelian` int(12) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

6.

Penggajian

CREATE TABLE IF NOT EXISTS `penggajian` (

`no_ukm` varchar(24) NOT NULL,

`no_penggajian` varchar(24) NOT NULL,

`tanggal_penggajian` date NOT NULL,

`tanggal_input` date NOT NULL,

`subtotal_penggajian` int(12) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

7.

Penjualan

CREATE TABLE IF NOT EXISTS `penjualan` (

`no_ukm` varchar(24) NOT NULL,

`no_penjualan` varchar(24) NOT NULL,

`tanggal_penjualan` date NOT NULL,

`tanggal_input` date NOT NULL,

`potongan_penjualan` int(12) NOT NULL,

`subtotal_penjualan` int(12) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

8

Retur Penjualan

CREATE TABLE IF NOT EXISTS `retur_penjualan` (

`no_ukm` varchar(24) NOT NULL,

`no_penjualan` varchar(24) NOT NULL,

`no_retur_penjualan` varchar(24) NOT NULL,

`tanggal_retur_penjualan` date NOT NULL,

`subtotal_retur_penjualan` int(12) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Sintya Sukarta, Lusi Melian

,

Rauf Fauzan