-- phpMyAdmin SQL Dump
-- version 3.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Waktu pembuatan: 17. Maret 2009 jam 00:21
-- Versi Server: 5.1.30
-- Versi PHP: 5.2.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `lpkjakarta`
--

-- --------------------------------------------------------

--
-- Struktur dari tabel `jns_pendidikan`
--

CREATE TABLE IF NOT EXISTS `jns_pendidikan` (
  `jns_pendidikan_id` int(11) NOT NULL AUTO_INCREMENT,
  `jns_pendidikan` varchar(20) NOT NULL,
  PRIMARY KEY (`jns_pendidikan_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data untuk tabel `jns_pendidikan`
--

INSERT INTO `jns_pendidikan` (`jns_pendidikan_id`, `jns_pendidikan`) VALUES
(1, 'SD'),
(2, 'SMP'),
(3, 'SMA'),
(4, 'D1'),
(5, 'D3'),
(6, 'S1');

-- --------------------------------------------------------

--
-- Struktur dari tabel `jns_rekening`
--

CREATE TABLE IF NOT EXISTS `jns_rekening` (
  `jns_rekening_id` int(11) NOT NULL AUTO_INCREMENT,
  `jns_rekening` varchar(20) NOT NULL,
  PRIMARY KEY (`jns_rekening_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data untuk tabel `jns_rekening`
--

INSERT INTO `jns_rekening` (`jns_rekening_id`, `jns_rekening`) VALUES
(1, 'BCA'),
(2, 'Mandiri');

-- --------------------------------------------------------

--
-- Struktur dari tabel `majikan`
--

CREATE TABLE IF NOT EXISTS `majikan` (
  `m_id` int(11) NOT NULL AUTO_INCREMENT,
  `m_nama` varchar(50) NOT NULL,
  `m_tgl_lahir` date NOT NULL,
  `m_ktp` varchar(30) NOT NULL,
  `m_alamat_rmh` varchar(200) NOT NULL,
  `m_telp_rmh` varchar(20) NOT NULL,
  `m_hp` varchar(30) NOT NULL,
  `m_alamat_kntr` varchar(150) NOT NULL,
  `m_telp_kntr` varchar(30) NOT NULL,
  `m_sdr_nama` varchar(30) NOT NULL,
  `m_sdr_hubungan` varchar(20) NOT NULL DEFAULT '',
  `m_sdr_alamat` varchar(200) NOT NULL DEFAULT '',
  `m_sdr_telp` varchar(30) NOT NULL DEFAULT '',
  `m_sdr_hp` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`m_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data untuk tabel `majikan`
--


-- --------------------------------------------------------

--
-- Struktur dari tabel `penyalur`
--

CREATE TABLE IF NOT EXISTS `penyalur` (
  `p_id` int(11) NOT NULL AUTO_INCREMENT,
  `p_nama` varchar(35) NOT NULL,
  `p_alamat` varchar(200) NOT NULL,
  `p_kecamatan` varchar(30) NOT NULL,
  `p_kelurahan` varchar(30) NOT NULL,
  `p_telp` varchar(20) NOT NULL,
  `p_hp` varchar(20) NOT NULL,
  `p_pj` varchar(30) NOT NULL,
  `jns_rekening_id` int(11) NOT NULL,
  `p_norek` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`p_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

--
-- Dumping data untuk tabel `penyalur`
--


-- --------------------------------------------------------

--
-- Struktur dari tabel `sewa`
--

CREATE TABLE IF NOT EXISTS `sewa` (
  `sewa_id` int(11) NOT NULL AUTO_INCREMENT,
  `m_id` int(11) NOT NULL,
  `s_id` int(11) NOT NULL,
  `s_gaji` float NOT NULL,
  `s_cuti` float NOT NULL,
  `tgl_kerja` date NOT NULL,
  `tgl_diproses` datetime NOT NULL,
  PRIMARY KEY (`sewa_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data untuk tabel `sewa`
--


-- --------------------------------------------------------

--
-- Struktur dari tabel `suster`
--

CREATE TABLE IF NOT EXISTS `suster` (
  `s_id` varchar(8) NOT NULL DEFAULT '',
  `s_nama` varchar(50) NOT NULL,
  `s_tgl_lahir` date NOT NULL,
  `s_ktp` varchar(30) NOT NULL,
  `s_ortu` varchar(50) NOT NULL,
  `s_alamat` varchar(250) NOT NULL,
  `s_kecamatan` varchar(30) NOT NULL,
  `s_kelurahan` varchar(30) NOT NULL,
  `s_hp` varchar(25) NOT NULL,
  `s_foto` varchar(100) NOT NULL,
  `jns_rekening_id` int(11) NOT NULL,
  `s_norek` varchar(20) NOT NULL,
  `s_sdr_nama` varchar(30) NOT NULL,
  `s_sdr_hubungan` varchar(40) NOT NULL,
  `s_sdr_alamat` varchar(250) NOT NULL,
  `s_sdr_telp` varchar(20) NOT NULL,
  `s_sdr_hp` varchar(30) NOT NULL,
  `jns_pendidikan_id` int(11) NOT NULL,
  `s_thn_lulus` varchar(4) NOT NULL DEFAULT '',
  `s_ijazah` varchar(50) NOT NULL DEFAULT '',
  `s_tgl_masuk` date NOT NULL,
  PRIMARY KEY (`s_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `suster`
--

INSERT INTO `suster` (`s_id`, `s_nama`, `s_tgl_lahir`, `s_ktp`, `s_ortu`, `s_alamat`, `s_kecamatan`, `s_kelurahan`, `s_hp`, `s_foto`, `jns_rekening_id`, `s_norek`, `s_sdr_nama`, `s_sdr_hubungan`, `s_sdr_alamat`, `s_sdr_telp`, `s_sdr_hp`, `jns_pendidikan_id`, `s_thn_lulus`, `s_ijazah`, `s_tgl_masuk`) VALUES
('S0903001', 'Muhamad Ridwan Salahudin', '1981-08-13', '5007.130881', 'Sri Suharti', 'Gang Kabin No.12', 'Tanah Abang', 'Bendungan Hilir', '081310208779', '_upload/suster/photo/S0903001.jpg', 1, '3011416100', 'Suhartadi Widi Santoso', 'Kakak Kandung', 'Bukit Golf', '0215742344', '08158715551', 3, '1999', '_upload/suster/ijazah/S0903001.jpg', '2009-03-15');