Compalex.net

Database schema compare tool

tables views procedures functions indexes triggers  all changed

batja_umrohappdev

Developer database

localhost:3306/batja_umrohappdev

batja_njbrdb

Production database

localhost:3306/batja_njbrdb

agen 15

engine: MyISAM
collation: latin1_swedish_ci
  • id smallint(6)
  • id_user int(15)
  • id_provinces char(2)
  • id_regencies char(4)
  • nama_agen varchar(50)
  • jenis_kelamin enum('pria','wanita')
  • alamat varchar(100)
  • telpon varchar(13)
  • no_rek varchar(100)
  • email varchar(100)
  • jenis_komisi enum('Rupiah','Dollar')
  • komisi_global int(12)
  • hak_akses_wholesaler tinyint(1)
  • hak_akses_pendaftaran tinyint(1)
  • filefotoprofile varchar(225)
Sample data (100 rows)

agen 15

engine: MyISAM
collation: latin1_swedish_ci
  • id smallint(6)
  • id_user int(15)
  • id_provinces char(2)
  • id_regencies char(4)
  • nama_agen varchar(50)
  • jenis_kelamin enum('pria','wanita')
  • alamat varchar(100)
  • telpon varchar(13)
  • no_rek varchar(100)
  • email varchar(100)
  • jenis_komisi enum('Rupiah','Dollar')
  • komisi_global int(12)
  • hak_akses_wholesaler tinyint(1)
  • hak_akses_pendaftaran tinyint(1)
  • filefotoprofile varchar(225)
Sample data (100 rows)

airports 11

engine: MyISAM
collation: utf8_turkish_ci
  • code varchar(50)
  • name varchar(200)
  • cityCode varchar(50)
  • cityName varchar(200)
  • countryName varchar(200)
  • countryCode varchar(200)
  • timezone varchar(8)
  • lat varchar(32)
  • lon varchar(32)
  • numAirports int(11)
  • city enum('true','false')
Sample data (100 rows)

airports 11

engine: MyISAM
collation: utf8_turkish_ci
  • code varchar(50)
  • name varchar(200)
  • cityCode varchar(50)
  • cityName varchar(200)
  • countryName varchar(200)
  • countryCode varchar(200)
  • timezone varchar(8)
  • lat varchar(32)
  • lon varchar(32)
  • numAirports int(11)
  • city enum('true','false')
Sample data (100 rows)

akun_data 10

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_asal int(11)
  • jenis_akun enum('Reguler','Agen')
  • nama_akun varchar(60)
  • alamat text
  • no_telp varchar(15)
  • email varchar(225)
  • status enum('Aktif','Tidak Aktif')
  • id_user int(12)
  • jk enum('L','P','','')
Sample data (100 rows)

akun_data 10

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_asal int(11)
  • jenis_akun enum('Reguler','Agen')
  • nama_akun varchar(60)
  • alamat text
  • no_telp varchar(15)
  • email varchar(225)
  • status enum('Aktif','Tidak Aktif')
  • id_user int(12)
  • jk enum('L','P','','')
Sample data (100 rows)

akun_keuangan 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • level int(2)
  • nama_akun varchar(225)
  • id_akun int(3)
  • kode_lv1 int(2)
  • kode_lv2 int(2)
  • kode_lv3 int(2)
  • jenis enum('labarugi','neraca','','')
  • opsi_hapus enum('ya','tidak','','')
Sample data (100 rows)

akun_keuangan 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • level int(2)
  • nama_akun varchar(225)
  • id_akun int(3)
  • kode_lv1 int(2)
  • kode_lv2 int(2)
  • kode_lv3 int(2)
  • jenis enum('labarugi','neraca','','')
  • opsi_hapus enum('ya','tidak','','')
Sample data (100 rows)

akun_keuangan_periode 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_periode varchar(225)
  • tgl_mulai date
  • tgl_selesai date
Sample data (100 rows)

akun_keuangan_periode 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_periode varchar(225)
  • tgl_mulai date
  • tgl_selesai date
Sample data (100 rows)

akun_travel 32

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_travel varchar(150)
  • alamat varchar(150)
  • no_telp varchar(150)
  • filefotologo varchar(225)
  • tentang text
  • user_fb varchar(225)
  • user_tw varchar(225)
  • user_ig varchar(225)
  • user_google varchar(225)
  • user_youtube varchar(225)
  • desc_filefoto text
  • meta_title varchar(69)
  • meta_description varchar(156)
  • keyword text
  • focus_keyword text
  • user_email varchar(225)
  • pass_email varchar(225)
  • user_fax varchar(225)
  • longitude varchar(25)
  • latitude varchar(25)
  • jadwal varchar(225)
  • script_header text
  • script_footer text
  • wa_popup_message varchar(225)
  • wa_header_title varchar(125)
  • wa_message varchar(125)
  • wa_phone varchar(20)
  • wa_color varchar(40)
  • wa_size int(10)
  • status_wa_gateway enum('Aktif','Tidak Aktif')
  • api_token varchar(225)
Sample data (100 rows)

akun_travel 32

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_travel varchar(150)
  • alamat varchar(150)
  • no_telp varchar(150)
  • filefotologo varchar(225)
  • tentang text
  • user_fb varchar(225)
  • user_tw varchar(225)
  • user_ig varchar(225)
  • user_google varchar(225)
  • user_youtube varchar(225)
  • desc_filefoto text
  • meta_title varchar(69)
  • meta_description varchar(156)
  • keyword text
  • focus_keyword text
  • user_email varchar(225)
  • pass_email varchar(225)
  • user_fax varchar(225)
  • longitude varchar(25)
  • latitude varchar(25)
  • jadwal varchar(225)
  • script_header text
  • script_footer text
  • wa_popup_message varchar(225)
  • wa_header_title varchar(125)
  • wa_message varchar(125)
  • wa_phone varchar(20)
  • wa_color varchar(40)
  • wa_size int(10)
  • status_wa_gateway enum('Aktif','Tidak Aktif')
  • api_token varchar(225)
Sample data (100 rows)

akun_travel_wagate 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(10)
  • nomor_whatsapp varchar(30)
  • nama_whatsapp varchar(225)
Sample data (100 rows)

akun_travel_wagate 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(10)
  • nomor_whatsapp varchar(30)
  • nama_whatsapp varchar(225)
Sample data (100 rows)

album 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • judul_album varchar(40)
  • filefoto varchar(225)
Sample data (100 rows)

album 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • judul_album varchar(40)
  • filefoto varchar(225)
Sample data (100 rows)

anggota 12

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • jabatan varchar(225)
  • nama varchar(40)
  • alamat varchar(40)
  • no_telp varchar(15)
  • filefoto varchar(100)
  • user_fb varchar(100)
  • user_tw varchar(100)
  • user_ig varchar(100)
  • status enum('Aktif','Tidak aktif')
  • email varchar(225)
  • kategori enum('Our Muthowif','Our Tour Leader','Our Tim','')
Sample data (100 rows)

anggota 12

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • jabatan varchar(225)
  • nama varchar(40)
  • alamat varchar(40)
  • no_telp varchar(15)
  • filefoto varchar(100)
  • user_fb varchar(100)
  • user_tw varchar(100)
  • user_ig varchar(100)
  • status enum('Aktif','Tidak aktif')
  • email varchar(225)
  • kategori enum('Our Muthowif','Our Tour Leader','Our Tim','')
Sample data (100 rows)

artikel 13

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_kategori int(4)
  • id_tags varchar(60)
  • judul_artikel varchar(225)
  • isi_artikel text
  • tgl_publish datetime
  • tampil enum('Ya','Tidak')
  • filefoto varchar(60)
  • meta_title varchar(69)
  • meta_description varchar(156)
  • keyword text
  • focus_keyword text
  • view int(10)
Sample data (100 rows)

artikel 13

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_kategori int(4)
  • id_tags varchar(60)
  • judul_artikel varchar(225)
  • isi_artikel text
  • tgl_publish datetime
  • tampil enum('Ya','Tidak')
  • filefoto varchar(60)
  • meta_title varchar(69)
  • meta_description varchar(156)
  • keyword text
  • focus_keyword text
  • view int(10)
Sample data (100 rows)

arus_kas 5

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • nama_kategori varchar(225)
  • kategori enum('Operasional','Investasi','Pendanaan','')
  • status enum('Aktif','Tidak Aktif','','')
  • jenis enum('default','tambahan','','')
Sample data (100 rows)

arus_kas 5

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • nama_kategori varchar(225)
  • kategori enum('Operasional','Investasi','Pendanaan','')
  • status enum('Aktif','Tidak Aktif','','')
  • jenis enum('default','tambahan','','')
Sample data (100 rows)

arus_kas_detail 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(10)
  • id_arus_kas int(11)
  • id_daftar_akun int(4)
Sample data (100 rows)

arus_kas_detail 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(10)
  • id_arus_kas int(11)
  • id_daftar_akun int(4)
Sample data (100 rows)

bank 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_bank varchar(50)
  • kode_bank char(4)
Sample data (100 rows)

bank 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_bank varchar(50)
  • kode_bank char(4)
Sample data (100 rows)

berkas_kelengkapan 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_berkas varchar(225)
  • status enum('Aktif','Tidak Aktif','','')
Sample data (100 rows)

berkas_kelengkapan 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_berkas varchar(225)
  • status enum('Aktif','Tidak Aktif','','')
Sample data (100 rows)

blast_wa_id 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • custom_id varchar(50)
  • time timestamp
Sample data (100 rows)

blast_wa_id 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • custom_id varchar(50)
  • time timestamp
Sample data (100 rows)

booking 16

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_user int(4)
  • id_akun int(12)
  • id_detail_group int(8)
  • id_program_keberangkatan int(8)
  • diskon_paket int(15)
  • keterangan_paket varchar(225)
  • keterangan varchar(225)
  • jumlah_dewasa int(2)
  • jumlah_anak_ranjang int(2)
  • jumlah_tampa_ranjang int(2)
  • kode_booking varchar(15)
  • tgl_registrasi date
  • status_booking enum('Entry','Cancel')
  • tgl_cancel varchar(40)
  • id_user_cancel int(12)
Sample data (100 rows)

booking 16

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_user int(4)
  • id_akun int(12)
  • id_detail_group int(8)
  • id_program_keberangkatan int(8)
  • diskon_paket int(15)
  • keterangan_paket varchar(225)
  • keterangan varchar(225)
  • jumlah_dewasa int(2)
  • jumlah_anak_ranjang int(2)
  • jumlah_tampa_ranjang int(2)
  • kode_booking varchar(15)
  • tgl_registrasi date
  • status_booking enum('Entry','Cancel')
  • tgl_cancel varchar(40)
  • id_user_cancel int(12)
Sample data (100 rows)

branch_office 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_provinsi varchar(2)
  • id_kabupaten varchar(4)
  • jenis_office enum('Pusat','Cabang')
  • alamat varchar(100)
  • no_telp varchar(20)
  • fax varchar(20)
  • keterangan text
Sample data (100 rows)

branch_office 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_provinsi varchar(2)
  • id_kabupaten varchar(4)
  • jenis_office enum('Pusat','Cabang')
  • alamat varchar(100)
  • no_telp varchar(20)
  • fax varchar(20)
  • keterangan text
Sample data (100 rows)

buku_tamu 17

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_input int(15)
  • id_pic int(15)
  • id_respon int(4)
  • id_referensi int(4)
  • id_detail_group int(8)
  • id_program_keberangkatan int(8)
  • tgl_bertamu date
  • nama varchar(25)
  • telepon varchar(25)
  • email varchar(225)
  • alamat varchar(225)
  • referensi varchar(225)
  • keterangan text
  • status_tamu enum('ya','tidak','daftar_akun','pending','booking_online','enquiry_wholesaler')
  • jk enum('L','P')
  • last_follow_up varchar(30)
Sample data (100 rows)

buku_tamu 17

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_input int(15)
  • id_pic int(15)
  • id_respon int(4)
  • id_referensi int(4)
  • id_detail_group int(8)
  • id_program_keberangkatan int(8)
  • tgl_bertamu date
  • nama varchar(25)
  • telepon varchar(25)
  • email varchar(225)
  • alamat varchar(225)
  • referensi varchar(225)
  • keterangan text
  • status_tamu enum('ya','tidak','daftar_akun','pending','booking_online','enquiry_wholesaler')
  • jk enum('L','P')
  • last_follow_up varchar(30)
Sample data (100 rows)

cash_flow 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_kasbank int(8)
  • keterangan varchar(225)
  • jenis enum('masuk','keluar','','')
  • tgl_transaksi date
  • nominal int(12)
  • currency enum('IDR','USD','','')
Sample data (100 rows)

cash_flow 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_kasbank int(8)
  • keterangan varchar(225)
  • jenis enum('masuk','keluar','','')
  • tgl_transaksi date
  • nominal int(12)
  • currency enum('IDR','USD','','')
Sample data (100 rows)

cities 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • country_code varchar(2)
  • city_name varchar(100)
  • city_photo varchar(100)
Sample data (100 rows)

cities 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • country_code varchar(2)
  • city_name varchar(100)
  • city_photo varchar(100)
Sample data (100 rows)

client 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama varchar(50)
  • alamat varchar(50)
  • email varchar(50)
  • no_telp varchar(15)
  • filefoto varchar(100)
  • status enum('Aktif','Tidak aktif')
  • link_web varchar(125)
Sample data (100 rows)

client 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama varchar(50)
  • alamat varchar(50)
  • email varchar(50)
  • no_telp varchar(15)
  • filefoto varchar(100)
  • status enum('Aktif','Tidak aktif')
  • link_web varchar(125)
Sample data (100 rows)

countries 3

engine: MyISAM
collation: utf8_general_ci
  • id int(11)
  • country_code varchar(2)
  • country_name varchar(100)
Sample data (100 rows)

countries 3

engine: MyISAM
collation: utf8_general_ci
  • id int(11)
  • country_code varchar(2)
  • country_name varchar(100)
Sample data (100 rows)

daftar_akun_keuangan 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_induk int(4)
  • kode_lv4 int(3)
  • nama_akun varchar(225)
  • saldo_normal enum('Debet','Kredit')
  • currency enum('IDR','USD')
Sample data (100 rows)

daftar_akun_keuangan 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_induk int(4)
  • kode_lv4 int(3)
  • nama_akun varchar(225)
  • saldo_normal enum('Debet','Kredit')
  • currency enum('IDR','USD')
Sample data (100 rows)

detail_group_keberangkatan 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_group_keberangkatan int(8)
  • tgl_berangkat date
  • tgl_pulang date
  • fileitinerary varchar(225)
  • type_file varchar(40)
  • status enum('Aktif','Tidak Aktif','Sudah berangkat')
Sample data (100 rows)

detail_group_keberangkatan 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_group_keberangkatan int(8)
  • tgl_berangkat date
  • tgl_pulang date
  • fileitinerary varchar(225)
  • type_file varchar(40)
  • status enum('Aktif','Tidak Aktif','Sudah berangkat')
Sample data (100 rows)

detail_gudang 4

engine: InnoDB
collation: latin1_swedish_ci
  • id int(8)
  • id_inventory_toolkit int(4)
  • id_gudang_toolkit int(4)
  • stock int(6)
Sample data (100 rows)

detail_gudang 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_inventory_toolkit int(4)
  • id_gudang_toolkit int(4)
  • stock int(6)
Sample data (100 rows)

fasilitas 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_fasilitas text
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

fasilitas 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_fasilitas text
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

file_jamaah 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_jamaah int(12)
  • filefotopaspor varchar(225)
Sample data (100 rows)

file_jamaah 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_jamaah int(12)
  • filefotopaspor varchar(225)
Sample data (100 rows)

formatpesan 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_pesan varchar(125)
  • subject varchar(225)
  • jenis enum('Tamu','Akun','Jamaah')
  • text_pesan text
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

formatpesan 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_pesan varchar(125)
  • subject varchar(225)
  • jenis enum('Tamu','Akun','Jamaah')
  • text_pesan text
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

galeri 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_album int(4)
  • judul_galeri varchar(100)
  • keterangan text
  • filefoto varchar(225)
  • tampil enum('Ya','Tidak')
  • tgl_publish datetime
Sample data (100 rows)

galeri 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_album int(4)
  • judul_galeri varchar(100)
  • keterangan text
  • filefoto varchar(225)
  • tampil enum('Ya','Tidak')
  • tgl_publish datetime
Sample data (100 rows)

group_keberangkatan 23

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_kategori_tour int(4)
  • kode_group varchar(100)
  • hari int(2)
  • kuota int(2)
  • dp_tempo date
  • batas_pendaftaran date
  • batas_kirim_passport date
  • batas_kirim_berkas date
  • jenis_dp enum('Nominal','Persentase')
  • dp_rp int(15)
  • dp_dr int(10)
  • dp_persen int(4)
  • pengurangan_kuota enum('Pemesanan','Pembayaran')
  • syarat_ketentuan text
  • informasi text
  • tgl_manasik date
  • waktu_mulai char(8)
  • waktu_selesai char(8)
  • tempat_manasik varchar(225)
  • keterangan_manasik text
  • status enum('Aktif','Tidak Aktif','Sudah Berangkat')
  • tampil enum('y','t')
Sample data (100 rows)

group_keberangkatan 23

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_kategori_tour int(4)
  • kode_group varchar(100)
  • hari int(2)
  • kuota int(2)
  • dp_tempo date
  • batas_pendaftaran date
  • batas_kirim_passport date
  • batas_kirim_berkas date
  • jenis_dp enum('Nominal','Persentase')
  • dp_rp int(15)
  • dp_dr int(10)
  • dp_persen int(4)
  • pengurangan_kuota enum('Pemesanan','Pembayaran')
  • syarat_ketentuan text
  • informasi text
  • tgl_manasik date
  • waktu_mulai char(8)
  • waktu_selesai char(8)
  • tempat_manasik varchar(225)
  • keterangan_manasik text
  • status enum('Aktif','Tidak Aktif','Sudah Berangkat')
  • tampil enum('y','t')
Sample data (100 rows)

group_la 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_negara char(4)
  • nama varchar(60)
  • jenis varchar(60)
  • no_telp varchar(20)
  • email varchar(100)
  • cp varchar(60)
  • alamat text
Sample data (100 rows)

group_la 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_negara char(4)
  • nama varchar(60)
  • jenis varchar(60)
  • no_telp varchar(20)
  • email varchar(100)
  • cp varchar(60)
  • alamat text
Sample data (100 rows)

group_users 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • level varchar(50)
  • deskripsi varchar(100)
Sample data (100 rows)

group_users 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • level varchar(50)
  • deskripsi varchar(100)
Sample data (100 rows)

gudang_toolkit 3

engine: InnoDB
collation: latin1_swedish_ci
  • id int(4)
  • cabang varchar(40)
  • alamat varchar(100)
Sample data (100 rows)

gudang_toolkit 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • cabang varchar(40)
  • alamat varchar(100)
Sample data (100 rows)

highlight 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • judul varchar(100)
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

highlight 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • judul varchar(100)
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

home_slider 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • filename varchar(100)
  • caption varchar(250)
  • url varchar(250)
  • active enum('yes','no')
  • pos_order int(11)
Sample data (100 rows)

home_slider 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • filename varchar(100)
  • caption varchar(250)
  • url varchar(250)
  • active enum('yes','no')
  • pos_order int(11)
Sample data (100 rows)

hotel 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_hotel varchar(50)
  • fasilitas text
  • kategori_hotel enum('Tour','Madinah','Mekkah')
  • id_kota int(11)
  • status enum('Aktif','Tidak Aktif')
  • nett int(11)
  • rating int(1)
Sample data (100 rows)

hotel 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_hotel varchar(50)
  • fasilitas text
  • kategori_hotel enum('Tour','Madinah','Mekkah')
  • id_kota int(11)
  • status enum('Aktif','Tidak Aktif')
  • nett int(11)
  • rating int(1)
Sample data (100 rows)

info_peringatan 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(2)
  • jenis enum('Toolkit','Group_keberangkatan','','')
  • num int(12)
Sample data (100 rows)

info_peringatan 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(2)
  • jenis enum('Toolkit','Group_keberangkatan','','')
  • num int(12)
Sample data (100 rows)

information_image 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • filename varchar(225)
  • fileimage varchar(225)
  • tampil enum('Ya','Tidak')
Sample data (100 rows)

information_image 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • filename varchar(225)
  • fileimage varchar(225)
  • tampil enum('Ya','Tidak')
Sample data (100 rows)

inspeksi 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • id_booking int(12)
  • jenis_inspeksi enum('file','toolkit','','')
  • tipe_inspeksi enum('jamaah','akun','','')
Sample data (100 rows)

inspeksi 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • id_booking int(12)
  • jenis_inspeksi enum('file','toolkit','','')
  • tipe_inspeksi enum('jamaah','akun','','')
Sample data (100 rows)

inspeksi_detail_toolkit 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_inspeksi int(12)
  • id_jamaah int(12)
  • status enum('Lengkap','Belum Lengkap','','')
Sample data (100 rows)

inspeksi_detail_toolkit 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_inspeksi int(12)
  • id_jamaah int(12)
  • status enum('Lengkap','Belum Lengkap','','')
Sample data (100 rows)

inspeksi_file 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_jamaah int(12)
  • status_pemeriksaan enum('Selesai','Belum Selesai','','')
  • status_pengembalian enum('Selesai','Belum Selesai','','')
Sample data (100 rows)

inspeksi_file 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_jamaah int(12)
  • status_pemeriksaan enum('Selesai','Belum Selesai','','')
  • status_pengembalian enum('Selesai','Belum Selesai','','')
Sample data (100 rows)

inspeksi_pemeriksaan 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_inspeksi_file int(8)
  • id_berkas_kelengkapan int(8)
  • ket_ambil enum('Ya','Tidak','','')
Sample data (100 rows)

inspeksi_pemeriksaan 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_inspeksi_file int(8)
  • id_berkas_kelengkapan int(8)
  • ket_ambil enum('Ya','Tidak','','')
Sample data (100 rows)

inspeksi_pengambilan 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_user int(12)
  • id_inspeksi_detail int(10)
  • id_inventory_toolkit int(4)
  • id_gudang int(6)
  • jumlah int(4)
  • tgl_ambil timestamp
Sample data (100 rows)

inspeksi_pengambilan 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_user int(12)
  • id_inspeksi_detail int(10)
  • id_inventory_toolkit int(4)
  • id_gudang int(6)
  • jumlah int(4)
  • tgl_ambil timestamp
Sample data (100 rows)

inspeksi_scan_berkas 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_berkas_kelengkapan int(8)
  • id_inspeksi_file int(12)
  • filefoto varchar(225)
Sample data (100 rows)

inspeksi_scan_berkas 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_berkas_kelengkapan int(8)
  • id_inspeksi_file int(12)
  • filefoto varchar(225)
Sample data (100 rows)

inventory_toolkit 5

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_jenis_toolkit int(4)
  • id_supplier tinyint(4)
  • ukuran varchar(30)
  • harga int(11)
Sample data (100 rows)

inventory_toolkit 5

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_jenis_toolkit int(4)
  • id_supplier tinyint(4)
  • ukuran varchar(30)
  • harga int(11)
Sample data (100 rows)

invoice 12

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_sumber varchar(15)
  • kuantitas int(11)
  • diskon int(11)
  • diskon_dollar int(12)
  • jumlah_tagihan int(11)
  • usd_tagihan int(11)
  • tanggal_diterbitkan varchar(10)
  • batas_pelunasan varchar(10)
  • jenis_invoice enum('paket','wholesaler','jasa')
  • status enum('lunas','belum lunas')
  • keterangan varchar(255)
Sample data (100 rows)

invoice 12

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_sumber varchar(15)
  • kuantitas int(11)
  • diskon int(11)
  • diskon_dollar int(12)
  • jumlah_tagihan int(11)
  • usd_tagihan int(11)
  • tanggal_diterbitkan varchar(10)
  • batas_pelunasan varchar(10)
  • jenis_invoice enum('paket','wholesaler','jasa')
  • status enum('lunas','belum lunas')
  • keterangan varchar(255)
Sample data (100 rows)

invoice_detail_jamaah 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_sumber varchar(15)
  • id_jamaah int(12)
Sample data (100 rows)

invoice_detail_jamaah 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_sumber varchar(15)
  • id_jamaah int(12)
Sample data (100 rows)

invoice_discount 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_sumber varchar(15)
  • id_jamaah varchar(15)
  • jumlah_idr int(11)
  • jumlah_usd int(11)
  • keterangan varchar(50)
Sample data (100 rows)

invoice_discount 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_sumber varchar(15)
  • id_jamaah varchar(15)
  • jumlah_idr int(11)
  • jumlah_usd int(11)
  • keterangan varchar(50)
Sample data (100 rows)

itinerary 2

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • id_detail_group int(8)
Sample data (100 rows)

itinerary 2

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • id_detail_group int(8)
Sample data (100 rows)

itinerary_detail 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • id_itenerary int(15)
  • kota varchar(120)
  • lokasi varchar(120)
  • waktu_mulai time
  • waktu_selesai time
  • keterangan text
Sample data (100 rows)

itinerary_detail 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • id_itenerary int(15)
  • kota varchar(120)
  • lokasi varchar(120)
  • waktu_mulai time
  • waktu_selesai time
  • keterangan text
Sample data (100 rows)

itinerary_template 2

engine: MyISAM
collation: latin1_swedish_ci
  • id int(2)
  • id_detail_group int(8)
Sample data (100 rows)

itinerary_template 2

engine: MyISAM
collation: latin1_swedish_ci
  • id int(2)
  • id_detail_group int(8)
Sample data (100 rows)

jamaah_umroh 41

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_booking int(8)
  • id_tipe_kamar varchar(60)
  • id_pelayanan_khusus varchar(60)
  • id_perihal_pribadi varchar(60)
  • id_kota varchar(4)
  • sumber_jamaah enum('paket','wholesaler')
  • kode_jamaah varchar(60)
  • status_umroh enum('Pernah','Belum Pernah')
  • status_nik enum('Ada','Tidak Ada')
  • nama_jamaah varchar(120)
  • no_ktp varchar(60)
  • nik varchar(60)
  • alamat text
  • alamat_domisili text
  • kode_pos varchar(8)
  • gol_darah char(2)
  • no_telp varchar(20)
  • no_hp varchar(20)
  • jk enum('L','P')
  • email varchar(60)
  • pekerjaan varchar(120)
  • pendidikan varchar(40)
  • tempat_lahir varchar(60)
  • tgl_lahir date
  • tipe_jamaah varchar(40)
  • warga_negara varchar(60)
  • no_paspor varchar(40)
  • nama_paspor varchar(120)
  • tempat_keluar varchar(80)
  • tgl_keluar date
  • masa_berlaku date
  • ukuran_baju char(4)
  • ukuran_sabuk char(4)
  • keterangan_kamar enum('Smooking','NonSmoking')
  • catatan text
  • filefotojamaah varchar(225)
  • status enum('Aktif','Cencel','sudah berangkat')
  • tgl_update date
  • kunjungan_terakhir date
  • nama_ayah varchar(125)
Sample data (100 rows)

jamaah_umroh 41

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_booking int(8)
  • id_tipe_kamar varchar(60)
  • id_pelayanan_khusus varchar(60)
  • id_perihal_pribadi varchar(60)
  • id_kota varchar(4)
  • sumber_jamaah enum('paket','wholesaler')
  • kode_jamaah varchar(60)
  • status_umroh enum('Pernah','Belum Pernah')
  • status_nik enum('Ada','Tidak Ada')
  • nama_jamaah varchar(120)
  • no_ktp varchar(60)
  • nik varchar(60)
  • alamat text
  • alamat_domisili text
  • kode_pos varchar(8)
  • gol_darah char(2)
  • no_telp varchar(20)
  • no_hp varchar(20)
  • jk enum('L','P')
  • email varchar(60)
  • pekerjaan varchar(120)
  • pendidikan varchar(40)
  • tempat_lahir varchar(60)
  • tgl_lahir date
  • tipe_jamaah varchar(40)
  • warga_negara varchar(60)
  • no_paspor varchar(40)
  • nama_paspor varchar(120)
  • tempat_keluar varchar(80)
  • tgl_keluar date
  • masa_berlaku date
  • ukuran_baju char(4)
  • ukuran_sabuk char(4)
  • keterangan_kamar enum('Smooking','NonSmoking')
  • catatan text
  • filefotojamaah varchar(225)
  • status enum('Aktif','Cencel','sudah berangkat')
  • tgl_update date
  • kunjungan_terakhir date
  • nama_ayah varchar(125)
Sample data (100 rows)

jasa_tambahan 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_jenis_jasa int(4)
  • jenis_harga enum('rupiah','dollar')
  • biaya int(15)
  • kode_akun varchar(20)
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

jasa_tambahan 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_jenis_jasa int(4)
  • jenis_harga enum('rupiah','dollar')
  • biaya int(15)
  • kode_akun varchar(20)
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

jenis_jasa 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • jasa varchar(100)
  • tampil enum('y','t')
Sample data (100 rows)

jenis_jasa 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • jasa varchar(100)
  • tampil enum('y','t')
Sample data (100 rows)

jenis_panduan 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_jenis_panduan varchar(125)
  • status enum('Aktif','Tidak Aktif','','')
Sample data (100 rows)

jenis_panduan 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_jenis_panduan varchar(125)
  • status enum('Aktif','Tidak Aktif','','')
Sample data (100 rows)

jurnal 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_program_keberangkatan int(8)
  • id_vendor int(4)
  • no_jurnal varchar(12)
  • keterangan text
  • tgl_transaksi date
  • tgl_posting date
  • currency enum('IDR','USD','','')
  • status enum('Posting','Unposting','','')
Sample data (100 rows)

jurnal 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_program_keberangkatan int(8)
  • id_vendor int(4)
  • no_jurnal varchar(12)
  • keterangan text
  • tgl_transaksi date
  • tgl_posting date
  • currency enum('IDR','USD','','')
  • status enum('Posting','Unposting','','')
Sample data (100 rows)

jurnal_detail 5

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_jurnal int(12)
  • nominal bigint(15)
  • id_akun int(4)
  • tipe enum('Debet','Kredit','','')
Sample data (100 rows)

jurnal_detail 5

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_jurnal int(12)
  • nominal bigint(15)
  • id_akun int(4)
  • tipe enum('Debet','Kredit','','')
Sample data (100 rows)

kas_bank 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_bank int(4)
  • nama_kas varchar(225)
  • nama_account varchar(225)
  • no_account varchar(225)
  • currency enum('IDR','USD','','')
  • jenis enum('Kas','Bank','','')
  • invoice enum('Ya','Tidak','','')
  • status enum('Aktif','Tidak Aktif','','')
Sample data (100 rows)

kas_bank 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_bank int(4)
  • nama_kas varchar(225)
  • nama_account varchar(225)
  • no_account varchar(225)
  • currency enum('IDR','USD','','')
  • jenis enum('Kas','Bank','','')
  • invoice enum('Ya','Tidak','','')
  • status enum('Aktif','Tidak Aktif','','')
Sample data (100 rows)

kategori_artikel 2

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • kategori varchar(225)
Sample data (100 rows)

kategori_artikel 2

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • kategori varchar(225)
Sample data (100 rows)

kategori_tour 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • kategori varchar(50)
  • haji enum('ya','tidak')
  • wisata_muslim enum('ya','tidak')
Sample data (100 rows)

kategori_tour 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • kategori varchar(50)
  • haji enum('ya','tidak')
  • wisata_muslim enum('ya','tidak')
Sample data (100 rows)

kategori_video 2

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • kategori varchar(100)
Sample data (100 rows)

kategori_video 2

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • kategori varchar(100)
Sample data (100 rows)

kelas_program 35

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_detail_group int(8)
  • id_hotel_mekkah varchar(60)
  • id_hotel_madinah varchar(60)
  • id_hotel_tour varchar(60)
  • id_maskapai varchar(60)
  • id_rute_berangkat varchar(60)
  • id_rute_pulang varchar(60)
  • id_highlight varchar(60)
  • id_fasilitas_termasuk text
  • id_fasilitas_tdktermasuk text
  • id_tags varchar(225)
  • id_pembimbing varchar(60)
  • id_muthawif varchar(60)
  • id_country varchar(60)
  • nama_program varchar(50)
  • filefoto varchar(100)
  • desc_filefoto text
  • filefoto2 varchar(100)
  • desc_filefoto2 text
  • filefoto3 varchar(100)
  • desc_filefoto3 text
  • keterangan text
  • status enum('Aktif','Tidak Aktif')
  • batas_pemesanan int(24)
  • pagu int(4)
  • rating int(1)
  • komisi_agen int(12)
  • jenis_komisi enum('Rupiah','Dollar')
  • meta_title varchar(69)
  • meta_description varchar(156)
  • keyword text
  • focus_keyword text
  • fileitinerary varchar(225)
  • fileitinerary_2 varchar(225)
Sample data (100 rows)

kelas_program 35

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_detail_group int(8)
  • id_hotel_mekkah varchar(60)
  • id_hotel_madinah varchar(60)
  • id_hotel_tour varchar(60)
  • id_maskapai varchar(60)
  • id_rute_berangkat varchar(60)
  • id_rute_pulang varchar(60)
  • id_highlight varchar(60)
  • id_fasilitas_termasuk text
  • id_fasilitas_tdktermasuk text
  • id_tags varchar(60)
  • id_pembimbing varchar(60)
  • id_muthawif varchar(60)
  • id_country varchar(60)
  • nama_program varchar(50)
  • filefoto varchar(100)
  • desc_filefoto text
  • filefoto2 varchar(100)
  • desc_filefoto2 text
  • filefoto3 varchar(100)
  • desc_filefoto3 text
  • keterangan text
  • status enum('Aktif','Tidak Aktif')
  • batas_pemesanan int(24)
  • pagu int(4)
  • rating int(1)
  • komisi_agen int(12)
  • jenis_komisi enum('Rupiah','Dollar')
  • meta_title varchar(69)
  • meta_description varchar(156)
  • keyword text
  • focus_keyword text
  • fileitinerary varchar(225)
  • fileitinerary_2 varchar(225)
Sample data (100 rows)

keluarga_jamaah 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_jamaah int(12)
  • status enum('ikut','tinggal')
  • nama varchar(60)
  • hubungan varchar(60)
  • no_telp varchar(20)
  • alamat text
  • keterangan text
Sample data (100 rows)

keluarga_jamaah 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_jamaah int(12)
  • status enum('ikut','tinggal')
  • nama varchar(60)
  • hubungan varchar(60)
  • no_telp varchar(20)
  • alamat text
  • keterangan text
Sample data (100 rows)

kirim_email 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_pesan int(12)
  • id_format int(4)
  • jenis enum('Tamu','Akun','Jamaah')
Sample data (100 rows)

kirim_email 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_pesan int(12)
  • id_format int(4)
  • jenis enum('Tamu','Akun','Jamaah')
Sample data (100 rows)

kirim_pesan 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_pesan int(12)
  • id_format int(4)
  • jenis enum('Tamu','Akun','Jamaah')
Sample data (100 rows)

kirim_pesan 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_pesan int(12)
  • id_format int(4)
  • jenis enum('Tamu','Akun','Jamaah')
Sample data (100 rows)

komentar 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_artikel int(4)
  • nama varchar(40)
  • email varchar(40)
  • komentar text
  • tanggal date
  • jam time
  • status enum('Menunggu','Diterima')
Sample data (100 rows)

komentar 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_artikel int(4)
  • nama varchar(40)
  • email varchar(40)
  • komentar text
  • tanggal date
  • jam time
  • status enum('Menunggu','Diterima')
Sample data (100 rows)

komisi_agen 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_agen int(6)
  • id_booking int(8)
  • komisi int(12)
  • currency enum('Rupiah','Dollar')
  • status enum('Belum dibayar','Sudah dibayar','','')
Sample data (100 rows)

komisi_agen 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_agen int(6)
  • id_booking int(8)
  • komisi int(12)
  • currency enum('Rupiah','Dollar')
  • status enum('Belum dibayar','Sudah dibayar','','')
Sample data (100 rows)

kota_tujuan 3

engine: MyISAM
collation: utf8_unicode_ci
  • id int(11)
  • id_program_keberangkatan int(11)
  • id_kota int(11)
Sample data (100 rows)

kota_tujuan 3

engine: MyISAM
collation: utf8_unicode_ci
  • id int(11)
  • id_program_keberangkatan int(11)
  • id_kota int(11)
Sample data (100 rows)

log_activity 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_user int(12)
  • keterangan text
  • waktu datetime
Sample data (100 rows)

log_activity 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_user int(12)
  • keterangan text
  • waktu datetime
Sample data (100 rows)

log_inventory_jamaah 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_inventory_toolkit int(4)
  • id_gudang int(4)
  • id_jamaah int(12)
  • id_user int(15)
  • jml_ambil_barang int(8)
  • jml_kembali_barang int(12)
Sample data (100 rows)

log_inventory_jamaah 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_inventory_toolkit int(4)
  • id_gudang int(4)
  • id_jamaah int(12)
  • id_user int(15)
  • jml_ambil_barang int(8)
  • jml_kembali_barang int(12)
Sample data (100 rows)

log_toolkit 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_inventory_toolkit int(4)
  • id_gudang_toolkit int(4)
  • jenis_log enum('masuk','keluar')
  • kuantitas int(11)
  • keterangan varchar(225)
  • id_user int(15)
  • tanggal datetime
Sample data (100 rows)

log_toolkit 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_inventory_toolkit int(4)
  • id_gudang_toolkit int(4)
  • jenis_log enum('masuk','keluar')
  • kuantitas int(11)
  • keterangan varchar(100)
  • id_user int(15)
  • tanggal datetime
Sample data (100 rows)

log_toolkit_pembelian 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_pembelian_toolkit int(11)
  • id_inventory_toolkit int(4)
  • id_gudang_toolkit int(4)
  • kuantitas int(11)
  • harga int(12)
Sample data (100 rows)

log_toolkit_pembelian 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_pembelian_toolkit int(11)
  • id_inventory_toolkit int(4)
  • id_gudang_toolkit int(4)
  • kuantitas int(11)
  • harga int(12)
Sample data (100 rows)

maskapai 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_maskapai varchar(50)
  • kode_penerbangan varchar(20)
  • fasilitas text
  • kategori_penerbangan enum('Internasional','Domestik')
  • harga_tiket int(11)
Sample data (100 rows)

maskapai 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_maskapai varchar(50)
  • kode_penerbangan varchar(20)
  • fasilitas text
  • kategori_penerbangan enum('Internasional','Domestik')
  • harga_tiket int(11)
Sample data (100 rows)

muthawif 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_muthawif varchar(60)
  • no_telp varchar(15)
  • asal_kota varchar(60)
  • group_la varchar(50)
  • status enum('Aktif','Tidak Aktif')
  • jk enum('L','P')
Sample data (100 rows)

muthawif 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_muthawif varchar(60)
  • no_telp varchar(15)
  • asal_kota varchar(60)
  • group_la varchar(50)
  • status enum('Aktif','Tidak Aktif')
  • jk enum('L','P')
Sample data (100 rows)

negara 3

engine: MyISAM
collation: utf8_general_ci
  • id int(11)
  • country_code varchar(2)
  • country_name varchar(100)
Sample data (100 rows)

negara 3

engine: MyISAM
collation: utf8_general_ci
  • id int(11)
  • country_code varchar(2)
  • country_name varchar(100)
Sample data (100 rows)

panduan_ibadah 5

engine: MyISAM
collation: utf8_general_ci
  • id int(6)
  • id_jenis_panduan int(4)
  • nama_panduan varchar(125)
  • deskripsi text
  • status enum('Aktif','Tidak Aktif','','')
Sample data (100 rows)

panduan_ibadah 5

engine: MyISAM
collation: utf8_general_ci
  • id int(6)
  • id_jenis_panduan int(4)
  • nama_panduan varchar(125)
  • deskripsi text
  • status enum('Aktif','Tidak Aktif','','')
Sample data (100 rows)

payment 12

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_sumber varchar(15)
  • id_user int(11)
  • kode_jamaah varchar(60)
  • tanggal_bayar date
  • catatan varchar(255)
  • jumlah bigint(11)
  • jumlah_usd int(11)
  • diskon int(11)
  • bukti_transfer varchar(50)
  • id_kasbank int(11)
  • status enum('sukses','gagal','refund')
Sample data (100 rows)

payment 12

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_sumber varchar(15)
  • id_user int(11)
  • kode_jamaah varchar(60)
  • tanggal_bayar date
  • catatan varchar(255)
  • jumlah bigint(11)
  • jumlah_usd int(11)
  • diskon int(11)
  • bukti_transfer varchar(50)
  • id_kasbank int(11)
  • status enum('sukses','gagal','refund')
Sample data (100 rows)

payment_fee 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_komisi int(12)
  • tanggal_bayar date
  • bukti_transfer varchar(100)
  • jumlah_komisi int(12)
  • id_kasbank int(11)
  • status enum('sukses','gagal')
Sample data (100 rows)

payment_fee 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_komisi int(12)
  • tanggal_bayar date
  • bukti_transfer varchar(100)
  • jumlah_komisi int(12)
  • id_kasbank int(11)
  • status enum('sukses','gagal')
Sample data (100 rows)

pelayanan_khusus 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_pelayanan varchar(60)
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

pelayanan_khusus 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_pelayanan varchar(60)
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

pembayaran_vendor 15

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_program_keberangkatan int(8)
  • id_kasbank int(4)
  • id_vendor int(8)
  • id_biaya_vendor int(4)
  • id_input int(8)
  • no_bukti varchar(25)
  • tgl_transaksi date
  • tgl_posting date
  • kuantitas int(4)
  • harga int(12)
  • currency enum('IDR','USD','','')
  • jumlah_bayar int(12)
  • keterangan text
  • status enum('Posting','Unposting','','')
Sample data (100 rows)

pembayaran_vendor 15

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_program_keberangkatan int(8)
  • id_kasbank int(4)
  • id_vendor int(8)
  • id_biaya_vendor int(4)
  • id_input int(8)
  • no_bukti varchar(25)
  • tgl_transaksi date
  • tgl_posting date
  • kuantitas int(4)
  • harga int(12)
  • currency enum('IDR','USD','','')
  • jumlah_bayar int(12)
  • keterangan text
  • status enum('Posting','Unposting','','')
Sample data (100 rows)

pembelian_toolkit 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • kode_pembelian varchar(12)
  • id_vendor int(4)
  • id_kasbank int(4)
  • id_user int(12)
  • tgl_transaksi date
  • tgl_posting date
  • keterangan text
  • status enum('Posting','Unposting','','')
Sample data (100 rows)

pembelian_toolkit 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • kode_pembelian varchar(12)
  • id_vendor int(4)
  • id_kasbank int(4)
  • id_user int(12)
  • tgl_transaksi date
  • tgl_posting date
  • keterangan text
  • status enum('Posting','Unposting','','')
Sample data (100 rows)

pembimbing 11

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_pembimbing varchar(50)
  • jk enum('L','P')
  • tempat_lahir varchar(30)
  • tgl_lahir date
  • no_passport varchar(15)
  • nama_passport varchar(40)
  • tempat_keluar varchar(25)
  • tgl_keluar date
  • masa_berlaku date
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

pembimbing 11

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_pembimbing varchar(50)
  • jk enum('L','P')
  • tempat_lahir varchar(30)
  • tgl_lahir date
  • no_passport varchar(15)
  • nama_passport varchar(40)
  • tempat_keluar varchar(25)
  • tgl_keluar date
  • masa_berlaku date
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

perihal_pribadi 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_perihal varchar(60)
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

perihal_pribadi 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_perihal varchar(60)
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

pesan 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_pengirim varchar(40)
  • email_pengirim varchar(40)
  • nohp_pengirim varchar(15)
  • subjek varchar(30)
  • pesan text
  • tanggal date
  • status_pesan enum('Baru','Sudah dibaca')
Sample data (100 rows)

pesan 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_pengirim varchar(40)
  • email_pengirim varchar(40)
  • nohp_pengirim varchar(15)
  • subjek varchar(30)
  • pesan text
  • tanggal date
  • status_pesan enum('Baru','Sudah dibaca')
Sample data (100 rows)

pilih_kamar 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • id_booking int(8)
  • id_tipe_kamar int(8)
  • jumlah_booking int(4)
Sample data (100 rows)

pilih_kamar 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • id_booking int(8)
  • id_tipe_kamar int(8)
  • jumlah_booking int(4)
Sample data (100 rows)

program_keberangkatan 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_kelas_program int(8)
  • id_detail_group int(8)
  • jenis_paket enum('Favorit','Tambahan','','')
Sample data (100 rows)

program_keberangkatan 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • id_kelas_program int(8)
  • id_detail_group int(8)
  • jenis_paket enum('Favorit','Tambahan','','')
Sample data (100 rows)

provinces 2

engine: MyISAM
collation: utf8_unicode_ci
  • id char(2)
  • name varchar(255)
Sample data (100 rows)

provinces 2

engine: MyISAM
collation: utf8_unicode_ci
  • id char(2)
  • name varchar(255)
Sample data (100 rows)

rab 3

engine: MyISAM
collation: utf8_general_ci
  • id int(6)
  • id_program_keberangkatan int(8)
  • id_detail_group int(8)
Sample data (100 rows)

rab 3

engine: MyISAM
collation: utf8_general_ci
  • id int(6)
  • id_program_keberangkatan int(8)
  • id_detail_group int(8)
Sample data (100 rows)

rab_detail 6

engine: MyISAM
collation: utf8_general_ci
  • id int(11)
  • id_rab int(6)
  • nama_rab varchar(125)
  • currency enum('IDR','USD')
  • nominal bigint(11)
  • diskon bigint(11)
Sample data (100 rows)

rab_detail 6

engine: MyISAM
collation: utf8_general_ci
  • id int(11)
  • id_rab int(6)
  • nama_rab varchar(125)
  • currency enum('IDR','USD')
  • nominal bigint(11)
  • diskon bigint(11)
Sample data (100 rows)

referensi_bukutamu 3

engine: MyISAM
collation: utf8_general_ci
  • id int(4)
  • ket_reff varchar(225)
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

referensi_bukutamu 3

engine: MyISAM
collation: utf8_general_ci
  • id int(4)
  • ket_reff varchar(225)
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

regencies 3

engine: MyISAM
collation: utf8_unicode_ci
  • id char(4)
  • province_id char(2)
  • name varchar(255)
Sample data (100 rows)

regencies 3

engine: MyISAM
collation: utf8_unicode_ci
  • id char(4)
  • province_id char(2)
  • name varchar(255)
Sample data (100 rows)

respon_tamu 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • ket_respon varchar(125)
  • warna varchar(40)
  • kode_warna varchar(20)
Sample data (100 rows)

respon_tamu 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • ket_respon varchar(125)
  • warna varchar(40)
  • kode_warna varchar(20)
Sample data (100 rows)

rooming_list 5

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • id_jamaah int(12)
  • id_program_keberangkatan int(8)
  • kode_kamar varchar(12)
  • id_tipe_kamar varchar(60)
Sample data (100 rows)

rooming_list 5

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • id_jamaah int(12)
  • id_program_keberangkatan int(8)
  • kode_kamar varchar(12)
  • id_tipe_kamar varchar(60)
Sample data (100 rows)

ruangan 12

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • id_program int(8)
  • id_tipe_kamar int(2)
  • harga int(15)
  • jenis_currency enum('Dollar','Rupiah')
  • jenis_diskon enum('Nominal','Persentase')
  • disc_mar int(4)
  • disc_no_bed int(4)
  • disc_child int(4)
  • pagu int(4)
  • dics_costum int(4)
  • nama_disc_costum varchar(60)
Sample data (100 rows)

ruangan 12

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • id_program int(8)
  • id_tipe_kamar int(2)
  • harga int(15)
  • jenis_currency enum('Dollar','Rupiah')
  • jenis_diskon enum('Nominal','Persentase')
  • disc_mar int(4)
  • disc_no_bed int(4)
  • disc_child int(4)
  • pagu int(4)
  • dics_costum int(4)
  • nama_disc_costum varchar(60)
Sample data (100 rows)

sms_center 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • destination varchar(14)
  • message_id varchar(25)
  • status int(11)
  • content text
  • time_created time
  • date_created date
Sample data (100 rows)

sms_center 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • destination varchar(14)
  • message_id varchar(25)
  • status int(11)
  • content text
  • time_created time
  • date_created date
Sample data (100 rows)

supplier 6

engine: MyISAM
collation: latin1_swedish_ci
  • id tinyint(4)
  • nama_supplier varchar(100)
  • pic varchar(50)
  • alamat varchar(150)
  • kontak varchar(13)
  • spesialisasi varchar(50)
Sample data (100 rows)

supplier 6

engine: MyISAM
collation: latin1_swedish_ci
  • id tinyint(4)
  • nama_supplier varchar(100)
  • pic varchar(50)
  • alamat varchar(150)
  • kontak varchar(13)
  • spesialisasi varchar(50)
Sample data (100 rows)

t_pengunjung 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • location varchar(100)
  • ip varchar(100)
  • date date
Sample data (100 rows)

t_pengunjung 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • location varchar(100)
  • ip varchar(100)
  • date date
Sample data (100 rows)

t_wilayah_kabupaten 3

engine: MyISAM
collation: latin1_swedish_ci
  • id varchar(4)
  • provinsi_id varchar(2)
  • nama varchar(30)
Sample data (100 rows)

t_wilayah_kabupaten 3

engine: MyISAM
collation: latin1_swedish_ci
  • id varchar(4)
  • provinsi_id varchar(2)
  • nama varchar(30)
Sample data (100 rows)

t_wilayah_provinsi 2

engine: MyISAM
collation: latin1_swedish_ci
  • id varchar(2)
  • nama varchar(30)
Sample data (100 rows)

t_wilayah_provinsi 2

engine: MyISAM
collation: latin1_swedish_ci
  • id varchar(2)
  • nama varchar(30)
Sample data (100 rows)

tabungan_jamaah 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_booking int(12)
  • total_tabungan int(15)
  • status enum('Kredit','Debet','')
  • tanggal date
  • keterangan varchar(225)
Sample data (100 rows)

tabungan_jamaah 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_booking int(12)
  • total_tabungan int(15)
  • status enum('Kredit','Debet','')
  • tanggal date
  • keterangan varchar(225)
Sample data (100 rows)

tagihan_jasa_tambahan 5

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_jamaah int(12)
  • id_jasa_tambahan int(4)
  • biaya int(15)
  • biaya_dollar int(12)
Sample data (100 rows)

tagihan_jasa_tambahan 5

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_jamaah int(12)
  • id_jasa_tambahan int(4)
  • biaya int(15)
  • biaya_dollar int(12)
Sample data (100 rows)

tags 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • judul varchar(100)
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

tags 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • judul varchar(100)
  • status enum('Aktif','Tidak Aktif')
Sample data (100 rows)

testimoni 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • nama varchar(100)
  • jabatan varchar(225)
  • kota varchar(100)
  • negara varchar(100)
  • testimoni text
  • status enum('Aktif','Tidak aktif')
  • filefoto varchar(100)
Sample data (100 rows)

testimoni 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • nama varchar(100)
  • jabatan varchar(225)
  • kota varchar(100)
  • negara varchar(100)
  • testimoni text
  • status enum('Aktif','Tidak aktif')
  • filefoto varchar(100)
Sample data (100 rows)

tipe_kamar 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(2)
  • jenis_kamar varchar(20)
  • kapasitas int(2)
Sample data (100 rows)

tipe_kamar 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(2)
  • jenis_kamar varchar(20)
  • kapasitas int(2)
Sample data (100 rows)

toolkit 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • jenis_toolkit varchar(100)
  • ukuran varchar(60)
  • satuan varchar(40)
  • keterangan text
  • peruntuk enum('Laki-laki','Perempuan','Semua')
  • status_inspeksi enum('Aktif','Tidak Aktif')
Sample data (100 rows)

toolkit 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • jenis_toolkit varchar(100)
  • ukuran varchar(60)
  • satuan varchar(40)
  • keterangan text
  • peruntuk enum('Laki-laki','Perempuan','Semua')
  • status_inspeksi enum('Aktif','Tidak Aktif')
Sample data (100 rows)

tools_marketing 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • filename varchar(225)
  • fileupload varchar(225)
  • filetipe varchar(15)
  • total_download int(8)
  • tampil enum('Ya','Tidak')
Sample data (100 rows)

tools_marketing 6

engine: MyISAM
collation: latin1_swedish_ci
  • id int(8)
  • filename varchar(225)
  • fileupload varchar(225)
  • filetipe varchar(15)
  • total_download int(8)
  • tampil enum('Ya','Tidak')
Sample data (100 rows)

tracking 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • tracking_name enum('pixel_id','pixel_event','gtm_id')
  • content_data varchar(225)
  • id_program int(11)
Sample data (100 rows)

tracking 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • tracking_name enum('pixel_id','pixel_event','gtm_id')
  • content_data varchar(225)
  • id_program int(11)
Sample data (100 rows)

transaksi_kasbank 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_kasbank int(8)
  • kategori enum('jamaah','agen','pembayaran_vendor','pembelian_toolkit')
  • id_kategori int(12)
  • currency enum('IDR','USD','','')
  • jenis enum('debet','kredit','')
  • jumlah int(12)
  • keterangan text
  • tgl_transaksi timestamp
Sample data (100 rows)

transaksi_kasbank 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(12)
  • id_kasbank int(8)
  • kategori enum('jamaah','agen','pembayaran_vendor','pembelian_toolkit')
  • id_kategori int(12)
  • currency enum('IDR','USD','','')
  • jenis enum('debet','kredit','')
  • jumlah int(12)
  • keterangan text
  • tgl_transaksi timestamp
Sample data (100 rows)

user 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • nama_user varchar(50)
  • email varchar(50)
  • username varchar(50)
  • password varchar(50)
  • id_group int(11)
  • status enum('aktif','blokir')
  • filefotoprofile varchar(225)
  • last_login datetime
Sample data (100 rows)

user 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(15)
  • nama_user varchar(50)
  • email varchar(50)
  • username varchar(50)
  • password varchar(50)
  • id_group int(11)
  • status enum('aktif','blokir')
  • filefotoprofile varchar(225)
  • last_login datetime
Sample data (100 rows)

vendor 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_vendor varchar(225)
  • keterangan text
  • status enum('Aktif','Tidak Aktif','','')
Sample data (100 rows)

vendor 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_vendor varchar(225)
  • keterangan text
  • status enum('Aktif','Tidak Aktif','','')
Sample data (100 rows)

vendor_biaya 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_biaya varchar(225)
  • unit enum('Pieces','Room','Seats','Package')
  • status enum('Aktif','Tidak Aktif','','')
Sample data (100 rows)

vendor_biaya 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • nama_biaya varchar(225)
  • unit enum('Pieces','Room','Seats','Package')
  • status enum('Aktif','Tidak Aktif','','')
Sample data (100 rows)

video 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_kategori int(4)
  • judul_video varchar(50)
  • link varchar(225)
  • tampil enum('Tidak','Ya')
  • tgl_publish datetime
  • tampil_homepage enum('Ya','Tidak','','')
Sample data (100 rows)

video 7

engine: MyISAM
collation: latin1_swedish_ci
  • id int(4)
  • id_kategori int(4)
  • judul_video varchar(50)
  • link varchar(225)
  • tampil enum('Tidak','Ya')
  • tgl_publish datetime
  • tampil_homepage enum('Ya','Tidak','','')
Sample data (100 rows)

wholesaler 29

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • codename varchar(15)
  • id_agen smallint(6)
  • id_pembimbing int(4)
  • id_user int(15)
  • id_akun int(11)
  • kode_group varchar(100)
  • request varchar(100)
  • adult int(11)
  • child int(11)
  • total_visa int(11)
  • total_passport int(11)
  • total_catering int(11)
  • jenis_catering varchar(100)
  • catering varchar(100)
  • catatan_catering varchar(100)
  • handler_saudi varchar(50)
  • handler_saudi_kontak varchar(14)
  • tanggal_manasik varchar(10)
  • waktu_manasik time
  • lokasi_manasik varchar(100)
  • pax_manasik int(11)
  • performer_manasik varchar(50)
  • asuransi int(11)
  • manifest varchar(50)
  • keterangan varchar(100)
  • tanggal varchar(10)
  • pilihan varchar(100)
  • status enum('review','process','finish','failed')
Sample data (100 rows)

wholesaler 29

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • codename varchar(15)
  • id_agen smallint(6)
  • id_pembimbing int(4)
  • id_user int(15)
  • id_akun int(11)
  • kode_group varchar(100)
  • request varchar(100)
  • adult int(11)
  • child int(11)
  • total_visa int(11)
  • total_passport int(11)
  • total_catering int(11)
  • jenis_catering varchar(100)
  • catering varchar(100)
  • catatan_catering varchar(100)
  • handler_saudi varchar(50)
  • handler_saudi_kontak varchar(14)
  • tanggal_manasik varchar(10)
  • waktu_manasik time
  • lokasi_manasik varchar(100)
  • pax_manasik int(11)
  • performer_manasik varchar(50)
  • asuransi int(11)
  • manifest varchar(50)
  • keterangan varchar(100)
  • tanggal varchar(10)
  • pilihan varchar(100)
  • status enum('review','process','finish','failed')
Sample data (100 rows)

wholesaler_bus 10

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler int(11)
  • no_bus varchar(11)
  • tipe_bus enum('Hiace','Coaster','Busa','GMC')
  • company_bus varchar(50)
  • booked_bus varchar(50)
  • contact_bus varchar(14)
  • hotel_bus varchar(50)
  • flight_bus varchar(50)
  • leader_bus varchar(20)
Sample data (100 rows)

wholesaler_bus 10

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler int(11)
  • no_bus varchar(11)
  • tipe_bus enum('Hiace','Coaster','Busa','GMC')
  • company_bus varchar(50)
  • booked_bus varchar(50)
  • contact_bus varchar(14)
  • hotel_bus varchar(50)
  • flight_bus varchar(50)
  • leader_bus varchar(20)
Sample data (100 rows)

wholesaler_hotel 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler int(11)
  • id_hotel int(11)
  • checkin varchar(10)
  • checkout varchar(10)
  • double_room int(11)
  • triple_room int(11)
  • quad_room int(11)
  • remark varchar(100)
Sample data (100 rows)

wholesaler_hotel 9

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler int(11)
  • id_hotel int(11)
  • checkin varchar(10)
  • checkout varchar(10)
  • double_room int(11)
  • triple_room int(11)
  • quad_room int(11)
  • remark varchar(100)
Sample data (100 rows)

wholesaler_manifest 12

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler int(11)
  • nama_jamaah varchar(100)
  • jenis_kelamin enum('pria','wanita')
  • no_passport varchar(15)
  • no_hp varchar(13)
  • tempat_lahir varchar(20)
  • tanggal_lahir varchar(10)
  • tanggal_pembuatan varchar(10)
  • tanggal_kadaluarsa varchar(10)
  • kantor varchar(10)
  • hubungan_keluarga varchar(10)
Sample data (100 rows)

wholesaler_manifest 12

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler int(11)
  • nama_jamaah varchar(100)
  • jenis_kelamin enum('pria','wanita')
  • no_passport varchar(15)
  • no_hp varchar(13)
  • tempat_lahir varchar(20)
  • tanggal_lahir varchar(10)
  • tanggal_pembuatan varchar(10)
  • tanggal_kadaluarsa varchar(10)
  • kantor varchar(10)
  • hubungan_keluarga varchar(10)
Sample data (100 rows)

wholesaler_notes 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler_status int(11)
  • notes varchar(255)
  • tanggal date
Sample data (100 rows)

wholesaler_notes 4

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler_status int(11)
  • notes varchar(255)
  • tanggal date
Sample data (100 rows)

wholesaler_pesawat 11

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler int(11)
  • asal varchar(3)
  • tujuan varchar(3)
  • tanggal varchar(10)
  • etd time
  • eta time
  • flight_no varchar(50)
  • carier int(4)
  • remarks varchar(100)
  • jenis_penerbangan enum('Arrival','Departure')
Sample data (100 rows)

wholesaler_pesawat 11

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler int(11)
  • asal varchar(3)
  • tujuan varchar(3)
  • tanggal varchar(10)
  • etd time
  • eta time
  • flight_no varchar(50)
  • carier int(4)
  • remarks varchar(100)
  • jenis_penerbangan enum('Arrival','Departure')
Sample data (100 rows)

wholesaler_status 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler int(11)
  • status enum('review','process','finish','failed')
Sample data (100 rows)

wholesaler_status 3

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler int(11)
  • status enum('review','process','finish','failed')
Sample data (100 rows)

wholesaler_travel 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler int(11)
  • jenis enum('Arrival','Departure')
  • waktu time
  • tanggal varchar(10)
  • asal varchar(50)
  • tujuan varchar(50)
  • remarks varchar(100)
Sample data (100 rows)

wholesaler_travel 8

engine: MyISAM
collation: latin1_swedish_ci
  • id int(11)
  • id_wholesaler int(11)
  • jenis enum('Arrival','Departure')
  • waktu time
  • tanggal varchar(10)
  • asal varchar(50)
  • tujuan varchar(50)
  • remarks varchar(100)
Sample data (100 rows)

 

For more information go to compalex.net