API tools faq
paste
Advertisement
Chemod

dpd.go.id

Chemod
Oct 10th, 2020
343
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.91 KB | None | 0 0
raw download clone embed print report
  1. --
  2. -- Table structure for table `data_pegawai`
  3. --
  4.  
  5. CREATE TABLE `data_pegawai` (
  6. `id_pegawai` int(50) NOT NULL,
  7. `nip` varchar(30) DEFAULT NULL,
  8. `no_perbantuan` varchar(30) DEFAULT NULL,
  9. `gelar_depan` varchar(45) DEFAULT NULL,
  10. `nama_pegawai` varchar(75) DEFAULT NULL,
  11. `gelar_belakang` varchar(45) DEFAULT NULL,
  12. `tempat_lahir` varchar(150) DEFAULT NULL,
  13. `tanggal_lahir` date DEFAULT NULL,
  14. `id_jns_kelamin` char(3) DEFAULT NULL,
  15. `id_agama` char(3) DEFAULT NULL,
  16. `handphone` char(20) DEFAULT NULL,
  17. `alamat` text,
  18. `no_kartu_pegawai` char(20) DEFAULT NULL,
  19. `email_pegawai` varchar(50) DEFAULT NULL,
  20. `tmt_cpns` date DEFAULT NULL,
  21. `tmt_pns` date DEFAULT NULL,
  22. `foto` text,
  23. `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  24. `last_update_by` varchar(30) DEFAULT NULL
  25. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  26.  
  27. --
  28. -- Dumping data for table `data_pegawai`
  29. --
  30.  
  31. INSERT INTO `data_pegawai` (`id_pegawai`, `nip`, `no_perbantuan`, `gelar_depan`, `nama_pegawai`, `gelar_belakang`, `tempat_lahir`, `tanggal_lahir`, `id_jns_kelamin`, `id_agama`, `handphone`, `alamat`, `no_kartu_pegawai`, `email_pegawai`, `tmt_cpns`, `tmt_pns`, `foto`, `last_update`, `last_update_by`) VALUES
  32. (1, '195711251983031001', '', 'Prof. Dr.', 'SUDARSONO HARDJOSOEKARTO', '', 'Brebes', '1957-11-25', '1', '1', '', 'JL. ALAMANDA KAV DKI BLOK L/8 RT 004/ RW 008, KELURAHAN CIPAYUNG. KECAMATAN CIPAYUNG, JAKARTA TIMUR ', 'C. 847115', '', '1983-03-01', '1984-03-01', 'ESSELON I (Cokelat)/SUDARSONO HARDJOSOEKARTO.JPG', '2016-06-23 22:03:11', 'yosha.admin'),
  33. (2, '195607271986031006', '', '', 'ZUL EVI ASTAR', ', SH.', 'Agam', '1956-07-27', '1', '1', '', 'JL. LEGISLATIF NO 37 RT.005/06 KAMPUNG LAPAI NANGGALO, PADANG', 'E.021878', '', '1986-03-01', '1987-05-01', 'ESSELON I (Cokelat)/ZUL EVI ASTAR.JPG', '2018-01-02 03:41:34', 'pegawai1'),
  34. (3, '196012311988021001', '', '', 'R. WIWEKO', ', SH., M.Si.', 'Jakarta', '1960-12-31', '1', '1', '081908173810', 'Perumahan Dasana Indah Blok SD 2 No. 4', 'E 432902', '', '1988-02-01', '1989-04-01', 'ESSELON II (Merah)/WIWEKO.jpg', '2016-04-14 15:09:37', 'import'),
  35. (4, '196011161988021001', '', '', 'ADAM BACHTIAR', 'SH., MH.', 'Semarang', '1960-11-16', '1', '1', '08129445399', 'PERUMAHAN SEKRETARIAT NEGARA BLOK E. 19 CIDODOL BARU KEL. GROGOL SELATAN. KEC. KEBAYORAN LAMA - JAKARTA SELATAN', 'E 432908', '', '1988-02-01', '1989-04-01', 'ESSELON II (Merah)/ADAM BACHTIAR.jpg', '2017-03-27 00:44:35', 'yosha.admin'),
  36. (5, '196607211988021002', '', '', 'NANA SUTISNA', 'S.IP., M.Si.', 'Bandung', '1966-07-21', '1', '1', '08121355626', 'Perum Binong Permai Blok F29 No. 10, Curug', 'L 035053', '', '1988-02-01', '1989-04-01', 'NANA_SUTISNA.jpg', '2016-08-08 23:03:42', 'yosha.admin'),
  37. (6, '196804291997031001', '', '', 'ONI CHOIRUDDIN', ', SH. MM.', 'Ponorogo', '1968-04-29', '1', '1', '08164849568', 'Jl. H. Goden III No. 19 RT. 019 RW. 004 Pondok Pinang, Kebayoran Lama, Jakarta Selatan', 'G 386640', '', '1997-03-01', '1998-04-01', 'ONI_CHOIRUDDIN.jpg', '2016-05-30 23:10:34', 'rvsln'),
  38. (7, '196302141990032001', '', 'Ir.', 'SEFTI RAMSIATY', 'MM.', 'Jakarta', '1963-02-14', '2', '1', '081289029291', 'Jl. Kayumanis IV (Lama) No. 22 RT. 009 RW.01 Jatinegara', 'E 852208', '', '1990-03-01', '1991-07-01', 'ESSELON II (Merah)/SEFTI RAMSIATY.JPG', '2016-08-30 23:12:48', 'yosha.admin'),
  39. (8, '196212041992031001', '', '', 'PURWANTO', 'SH.', 'Wonogiri', '1962-12-04', '1', '1', '', 'JL GAJAH I BLOK G/71 PTI JATI MULYA', 'F 248986', '', '1992-03-01', '1993-06-01', 'PURWANTO.jpg', '2016-08-07 23:39:18', 'yosha.admin'),
  40. (9, '195809011983011002', '', 'Drs. ', 'SADARIELI ZEBUA', ', M.Si.', 'Hilinawalo', '1958-09-01', '1', '2', '0811868752', 'Villa Bintaro Indah Blok C XX No. 30 Jombang', 'C 0834483', '', '1983-01-01', '1984-05-01', 'ESSELON II (Merah)/SADARIELI ZEBUA.JPG', '2016-04-14 15:09:38', 'import'),
  41. (10, '196801051988031001', '', '', 'LALU NIQMAN ZAHIR', ', S.Sos., M.Si.', 'Prapen', '1968-01-05', '1', '1', '', 'JL. MASJID AL AKBAR NOMOR 1 A RT 08/)1 MUNJUL CIPAYUNG JAKARTA TIMUR', 'E 534855', '', '1988-03-01', '1990-03-01', 'ESSELON II (Merah)/LALU NIQMAN ZAHIR.JPG', '2017-02-19 23:53:06', 'yosha.admin'),
  42. (11, '196909141990031004', '', 'Dr.', 'RAHMAN HADI', 'M.Si.', 'Cokohnau (OKU)', '1969-09-14', '1', '1', '08151875621', ' JLN. CIKINI VII NO.16 RT.04 RW.01 KEL CIKINI MENTENG JAKARTA PUSAT', 'E 922778', '', '1990-03-01', '1991-09-01', 'ESSELON II (Merah)/RAHMAN HADI.JPG', '2016-08-09 23:47:29', 'yosha.admin'),
  43. (12, '196201221991032001', '', 'Dra.', 'SRI SUSILOWATI', '', 'Magetan', '1962-01-22', '2', '1', '', 'Perumahan Dasana Indah Blok SL 5/11 A Tangerang', 'F 206869', '', '1991-03-01', '1992-07-01', 'ESSELON III (Biru)/SRI SUSILOWATI.JPG', '2017-01-09 05:11:04', 'yosha.admin'),
  44. (13, '196312171988021001', '', 'Drs.', 'RINO BASKORO', '', 'Jakarta', '1963-12-17', '1', '1', '082113181499', 'Perum Dasana Indah Blok S04 No. 12 RT. 004 RW. 016 Kelapa Dua', 'E 432918', '', '1988-02-01', '1989-04-01', 'ESSELON III (Biru)/RINO BASKORO.JPG', '2017-01-09 02:07:12', 'yosha.admin'),
  45. (14, '196301301992031002', '', '', 'MAHFUT', ', SH.,MH.', 'Magetan', '1963-01-30', '1', '1', '0811173197', 'PERUM. BINONG PERMAI BLOK BB VII NO. 10 KEL. BINONG CURUG TANGERANG ', 'F 248987', '', '1992-03-01', '1993-06-01', 'ESSELON III (Biru)/MAHFUT.JPG', '2017-02-20 01:13:54', 'haekal.admin'),
  46. (15, '196211031992032001', '', 'Dra.', 'EULIS WATIDIHATI', ', M.Si.', 'Bandung', '1962-11-03', '2', '1', '081314333700', 'Jl. Sayur Asem 6A Raya Joglo', 'F 248985', '', '1992-03-01', '1993-06-01', 'ESSELON III (Biru)/EULIS WATIHDIHATI.JPG', '2017-02-15 20:43:11', 'anto.admin'),
  47. (16, '196407051990032001', '', 'Dra.', 'NENE DEDEH', ', M.Si.', 'Ciamis', '1964-07-05', '2', '1', '081377725888', 'Jl. Kemuning Gg. G No. 26 Kelurahan Utan Kayu Utara', 'E 763563', '', '1990-03-01', '1991-08-03', 'ESSELON III (Biru)/NENE DEDEH.JPG', '2016-04-14 15:11:59', 'import'),
  48. (17, '196407101992032001', '', 'Dra.', 'MESRANIAN', ', M.Dev.Plg.', 'Medan', '1964-07-10', '2', '1', '', 'JATI BENING II BLOK J 91 NO.91 PONDOK GEDE', 'F.316714', '', '1992-03-01', '1993-10-01', 'ESSELON III (Biru)/MESRANIAN.JPG', '2016-04-14 15:12:00', 'import'),
  49. (18, '196002161993031001', '', 'Drs. ', 'IRDAM IMRAN', ', M.Si.', 'Kemangmudik', '1960-02-16', '1', '1', '', 'Jl. VILLA PERTIWI ESTATE BLOK A 3 NO. 12 DEPOK', 'G 120324', '', '1993-03-01', '1994-11-01', 'ESSELON III (Biru)/IRDAM IMRAN.JPG', '2017-01-18 03:49:53', 'yosha.admin'),
  50. (19, '196010191991031001', '', '', 'NURSALIM', ', SH.', 'Palopo', '1960-10-19', '1', '1', '', 'JL. WARAKAS III GG 16/13 RT.07/14 KEL.WARAKAS', 'F 206867', '', '1991-03-01', '1992-07-01', 'ESSELON III (Biru)/NURSALIM.jpg', '2017-03-17 01:16:30', 'yosha.admin'),
  51. (20, '195902191985032001', '', '', 'RISWANTI', ', S.Sos., M.AP.', 'Bangka', '1959-02-19', '2', '1', '08161837903', 'Perum Pondok Hijau, Jl. Pondok Hijau Raya B2/12, Ciputat', 'D 249738', '', '1985-03-01', '1986-05-01', 'ESSELON III (Biru)/RISWANTI.JPG', '2017-03-17 01:26:29', 'yosha.admin'),
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!