LAMPIRAN – LAMPIRAN
CREATE TABLE Table ‘Biro’ CREATE TABLE `biro` ( `Id_Biro` char(4) collate latin1_general_ci NOT NULL, `Nama_Biro` varchar(50) collate latin1_general_ci NOT NULL, PRIMARY KEY (`Id_Biro`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Table `detaildokumentasisk` CREATE TABLE `detaildokumentasisk` ( `Id_Dokumentasi_SK` varchar(10) collate latin1_general_ci NOT NULL, `Id_SK` varchar(20) collate latin1_general_ci NOT NULL, PRIMARY KEY (`Id_Dokumentasi_SK`,`Id_SK`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Table `detaildokumentasism` CREATE TABLE `detaildokumentasism` ( `Id_Dokumentasi_SM` varchar(10) collate latin1_general_ci NOT NULL, `Id_SM` varchar(20) collate latin1_general_ci NOT NULL, PRIMARY KEY (`Id_Dokumentasi_SM`,`Id_SM`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
L1
Table `detailfiledokumen` CREATE TABLE `detailfiledokumen` ( `Id_File_Dokumen` varchar(10) collate latin1_general_ci NOT NULL, `Id_Karyawan` varchar(20) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`Id_File_Dokumen`,`Id_Karyawan`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Table `disposisi` CREATE TABLE `disposisi` ( `Id_Disposisi` varchar(10) collate latin1_general_ci NOT NULL, `Isi_Disposisi` varchar(100) collate latin1_general_ci NOT NULL, `Tgl_disposisi` text collate latin1_general_ci NOT NULL, `Id_Karyawan` varchar(10) collate latin1_general_ci NOT NULL, PRIMARY KEY (`Id_Disposisi`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Table `dokumentasisk` CREATE TABLE `dokumentasisk` ( `Id_Dokumentasi_SK` varchar(10) collate latin1_general_ci NOT NULL, `Tgl_Dokumentasi_SK` text collate latin1_general_ci NOT NULL, `Dokumentasi_SK` varchar(50) collate latin1_general_ci NOT NULL,
L2
`Id_Karyawan` varchar(20) collate latin1_general_ci NOT NULL, PRIMARY KEY (`Id_Dokumentasi_SK`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Table `dokumentasism` CREATE TABLE `dokumentasism` ( `Id_Dokumentasi_SM` varchar(10) collate latin1_general_ci NOT NULL, `Tgl_Dokumentasi_SM` text collate latin1_general_ci NOT NULL, `Dokumentasi_SM` varchar(50) collate latin1_general_ci NOT NULL, `Id_Karyawan` varchar(20) collate latin1_general_ci NOT NULL, PRIMARY KEY (`Id_Dokumentasi_SM`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Table `filedokumen` CREATE TABLE `filedokumen` ( `Id_File_Dokumen` varchar(10) collate latin1_general_ci NOT NULL, `Nama_File_Dokumen` varchar(50) collate latin1_general_ci NOT NULL, `Tgl_File_Dokumen` text collate latin1_general_ci NOT NULL, `Cek_Delete_Dokumen` int(1) NOT NULL, `Id_Klasifikasi` varchar(5) collate latin1_general_ci NOT NULL, PRIMARY KEY (`Id_File_Dokumen`)
L3
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Table `jabatan` CREATE TABLE `jabatan` ( `Id_Jabatan` char(4) collate latin1_general_ci NOT NULL, `Nama_Jabatan` varchar(50) collate latin1_general_ci NOT NULL, PRIMARY KEY (`Id_Jabatan`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Table `karyawan` CREATE TABLE `karyawan` ( `Id_Karyawan` varchar(10) collate latin1_general_ci NOT NULL, `Password` varchar(20) collate latin1_general_ci NOT NULL, `Status_Type` varchar(10) collate latin1_general_ci NOT NULL, `Nama_Karyawan` varchar(50) collate latin1_general_ci NOT NULL, `Tempat_Lahir` varchar(50) collate latin1_general_ci NOT NULL, `Tanggal_Lahir` text collate latin1_general_ci NOT NULL, `Email_Karyawan` varchar(50) collate latin1_general_ci default NULL, `Telp_Karyawan` varchar(30) collate latin1_general_ci default NULL, `Alamat_Karyawan` varchar(100) collate latin1_general_ci NOT NULL, `Jenis_Kelamin_Karyawan` varchar(20) collate latin1_general_ci NOT NULL, `Id_Jabatan` char(4) collate latin1_general_ci NOT NULL,
L4
`Id_Biro` char(4) collate latin1_general_ci NOT NULL, PRIMARY KEY (`Id_Karyawan`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Table `klasifikasi` CREATE TABLE `klasifikasi` ( `Id_Klasifikasi` varchar(5) collate latin1_general_ci NOT NULL, `Nama_Klasifikasi` varchar(50) collate latin1_general_ci NOT NULL, PRIMARY KEY (`Id_Klasifikasi`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Table `penerimaluar` CREATE TABLE `penerimaluar` ( `Id_Penerima_Luar` varchar(10) collate latin1_general_ci NOT NULL, `Nama_Penerima` varchar(50) collate latin1_general_ci NOT NULL, `Nama_Instansi_Penerima` varchar(50) collate latin1_general_ci default NULL, `Alamat_Penerima` varchar(100) collate latin1_general_ci NOT NULL, `Telp_Penerima` varchar(30) collate latin1_general_ci default NULL, `Email_Penerima` varchar(20) collate latin1_general_ci default NULL, PRIMARY KEY (`Id_Penerima_Luar`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
L5
Table `pengirimluar` CREATE TABLE `pengirimluar` ( `Id_Pengirim_Luar` varchar(10) collate latin1_general_ci NOT NULL, `Nama_Pengirim` varchar(50) collate latin1_general_ci NOT NULL, `Nama_Instansi_Pengirim` varchar(50) collate latin1_general_ci default NULL, `Alamat_Pengirim` varchar(100) collate latin1_general_ci NOT NULL, `Telp_Pengirim` varchar(30) collate latin1_general_ci default NULL, `Email_Pengirim` varchar(20) collate latin1_general_ci default NULL, PRIMARY KEY (`Id_Pengirim_Luar`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; Table `perihal` CREATE TABLE `perihal` ( `Id_Perihal` varchar(10) collate latin1_general_ci NOT NULL, `Nama_Perihal` varchar(20) collate latin1_general_ci NOT NULL, PRIMARY KEY (`Id_Perihal`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Table `suratkeluar` CREATE TABLE `suratkeluar` ( `Id_SK` varchar(10) collate latin1_general_ci NOT NULL, `Nama_SK` varchar(50) collate latin1_general_ci NOT NULL, `Nama_Jenis_SK` varchar(50) collate latin1_general_ci NOT NULL,
L6
`Tgl_Kirim_SK` text collate latin1_general_ci NOT NULL, `Sifat_Informasi_SK` varchar(50) collate latin1_general_ci NOT NULL, `Status_SK` varchar(50) collate latin1_general_ci NOT NULL, `Catatan_SK` varchar(100) collate latin1_general_ci default NULL, `Id_Karyawan` varchar(10) collate latin1_general_ci NOT NULL, `Id_Klasifikasi` varchar(5) collate latin1_general_ci NOT NULL, `Id_Perihal` varchar(10) collate latin1_general_ci NOT NULL, `Id_Penerima_Luar` varchar(10) collate latin1_general_ci NOT NULL, PRIMARY KEY (`Id_SK`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
Table `suratmasuk` CREATE TABLE `suratmasuk` ( `Id_SM` varchar(10) collate latin1_general_ci NOT NULL, `Nama_SM` varchar(50) collate latin1_general_ci NOT NULL, `Nama_Jenis_SM` varchar(50) collate latin1_general_ci NOT NULL, `Tgl_Terima_SM` text collate latin1_general_ci NOT NULL, `Sifat_Informasi_SM` varchar(50) collate latin1_general_ci NOT NULL, `Status_SM` varchar(20) collate latin1_general_ci NOT NULL, `Catatan_SM` varchar(100) collate latin1_general_ci default NULL, `Cek_Delete_SM` int(1) NOT NULL, `Id_Karyawan` varchar(10) collate latin1_general_ci NOT NULL, `Id_Pengirim_Luar` varchar(10) collate latin1_general_ci NOT NULL, `Id_Klasifikasi` varchar(5) collate latin1_general_ci NOT NULL, L7
`Id_Perihal` varchar(10) collate latin1_general_ci NOT NULL, PRIMARY KEY (`Id_SM`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
L8
LAMPIRAN - LAMPIRAN. KUISIONER Pertanyaan Bagaimana pendapat anda tentang informasi yang ada pada aplikasi ini ? Sangat tidak lengkap Kurang lengkap Biasa saja Lengkap Sangat lengkap Bagaimana pendapat anda tentang tampilan layar aplikasi ini ? Sangat tidak menarik Kurang menarik Biasa saja Menarik
L9
Apakah dengan adanya aplikasi ini dapat membantu dalam meningkatkan kinerja anda? Sangat tidak membantu Kurang membantu Biasa saja Membantu Bagaimana pendapat anda tentang pemahaman informasi pada aplikasi ini? Sangat tidak jelas Kurang jelas Biasa saja Sangat tidak jelas Apakah sistem navigasi pada aplikasi ini membantu dalam pencarian informasi yang dibutuhkan? Sangat tidak membantu Kurang membantu Biasa saja Membantu Sangat membantu
L10
Hal hal yang perlu diperhatikan atau ditingkatkan -
Tampilan yang sederhana dan mudah dimengerti
-
Penenganan kesalahan dalam pengisian form
Hal hal yang perlu diperbaiki -
Disediakan alat bantu pencarian data
-
Tampilan yang lebih menarik
-
Bentuk dari laporan laporan yang ada di perbaiki
L11
