SQL Database Penggajian Format MySQL 5

Tabel Daftar Hadir Karyawan / Pegawai

CREATE TABLE `daftar hadir` (
`id` int(11) unsigned NOT NULL auto_increment,
`karyawan` int(11) unsigned default NULL,
`tanggal` date default NULL,
`masuk` time default NULL,
`pulang` time default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Tabel Gaji Detil

CREATE TABLE `gaji detil` (
`id` int(11) unsigned NOT NULL auto_increment,
`gaji` int(11) unsigned default NULL,
`nomor` int(11) unsigned default NULL,
`komponen gaji` int(11) unsigned default NULL,
`nilai` decimal(12,2) unsigned default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Tabel Gaji Karyawan/Pegawai

CREATE TABLE `gaji` (
`id` int(11) unsigned NOT NULL auto_increment,
`waktu entri` datetime default NULL,
`tanggal` date default NULL,
`kode` varchar(11) default NULL,
`karyawan` int(11) unsigned default NULL,
`bulan` varchar(30) default NULL,
`sub total` decimal(12,2) unsigned default NULL,
`persen pph` decimal(10,2) unsigned default NULL,
`nilai pph` decimal(12,2) unsigned default NULL,
`diterima` decimal(12,2) unsigned default NULL,
`pembayaran` tinyint(3) unsigned default NULL,
`catatan` tinytext,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Tabel Pegawai / Karyawan

CREATE TABLE `karyawan` (
`id` int(11) unsigned NOT NULL auto_increment,
`nama` varchar(40) default NULL,
`nik` char(10) default NULL,
`jabatan` varchar(60) default NULL,
`masuk` date default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Tabel Komponen Gaji

CREATE TABLE `komponen gaji` (
`id` int(11) unsigned NOT NULL auto_increment,
`nama` varchar(40) default NULL,
`nilai` decimal(10,2) unsigned default NULL,
`akumulasi` char(1) NOT NULL default ‘+’,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Tabel Pembayaran

CREATE TABLE `pembayaran` (
`id` tinyint(3) unsigned NOT NULL auto_increment,
`nama` varchar(40) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

==
Salam bahagia