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 [PRIMARY] 1

  • id (1)

agen [PRIMARY] 1

  • id (1)

agen [email] 1

  • email (1)

agen [email] 1

  • email (1)

akun_data [PRIMARY] 1

  • id (1)

akun_data [PRIMARY] 1

  • id (1)

akun_keuangan [PRIMARY] 1

  • id (1)

akun_keuangan [PRIMARY] 1

  • id (1)

akun_keuangan_periode [PRIMARY] 1

  • id (1)

akun_keuangan_periode [PRIMARY] 1

  • id (1)

akun_travel [PRIMARY] 1

  • id (1)

akun_travel [PRIMARY] 1

  • id (1)

akun_travel_wagate [PRIMARY] 1

  • id (1)

akun_travel_wagate [PRIMARY] 1

  • id (1)

album [PRIMARY] 1

  • id (1)

album [PRIMARY] 1

  • id (1)

anggota [PRIMARY] 1

  • id (1)

anggota [PRIMARY] 1

  • id (1)

artikel [PRIMARY] 1

  • id (1)

artikel [PRIMARY] 1

  • id (1)

artikel [fk_id_artikel] 1

  • id_kategori (1)

artikel [fk_id_artikel] 1

  • id_kategori (1)

arus_kas [PRIMARY] 1

  • id (1)

arus_kas [PRIMARY] 1

  • id (1)

arus_kas_detail [PRIMARY] 1

  • id (1)

arus_kas_detail [PRIMARY] 1

  • id (1)

bank [PRIMARY] 1

  • id (1)

bank [PRIMARY] 1

  • id (1)

berkas_kelengkapan [PRIMARY] 1

  • id (1)

berkas_kelengkapan [PRIMARY] 1

  • id (1)

blast_wa_id [PRIMARY] 1

  • id (1)

blast_wa_id [PRIMARY] 1

  • id (1)

booking [PRIMARY] 1

  • id (1)

booking [PRIMARY] 1

  • id (1)

branch_office [PRIMARY] 1

  • id (1)

branch_office [PRIMARY] 1

  • id (1)

buku_tamu [PRIMARY] 1

  • id (1)

buku_tamu [PRIMARY] 1

  • id (1)

cash_flow [PRIMARY] 1

  • id (1)

cash_flow [PRIMARY] 1

  • id (1)

cities [PRIMARY] 1

  • id (1)

cities [PRIMARY] 1

  • id (1)

client [PRIMARY] 1

  • id (1)

client [PRIMARY] 1

  • id (1)

countries [PRIMARY] 1

  • id (1)

countries [PRIMARY] 1

  • id (1)

daftar_akun_keuangan [PRIMARY] 1

  • id (1)

daftar_akun_keuangan [PRIMARY] 1

  • id (1)

daftar_akun_keuangan [fk_id_induk] 1

  • id_induk (1)

daftar_akun_keuangan [fk_id_induk] 1

  • id_induk (1)

detail_group_keberangkatan [PRIMARY] 1

  • id (1)

detail_group_keberangkatan [PRIMARY] 1

  • id (1)

detail_gudang [PRIMARY] 1

  • id (1)

detail_gudang [PRIMARY] 1

  • id (1)

detail_gudang [fk_id_gudang] 1

  • id_gudang_toolkit (1)

detail_gudang [fk_id_gudang] 1

  • id_gudang_toolkit (1)

fasilitas [PRIMARY] 1

  • id (1)

fasilitas [PRIMARY] 1

  • id (1)

file_jamaah [PRIMARY] 1

  • id (1)

file_jamaah [PRIMARY] 1

  • id (1)

formatpesan [PRIMARY] 1

  • id (1)

formatpesan [PRIMARY] 1

  • id (1)

galeri [PRIMARY] 1

  • id (1)

galeri [PRIMARY] 1

  • id (1)

galeri [id_album] 1

  • id_album (1)

galeri [id_album] 1

  • id_album (1)

group_keberangkatan [PRIMARY] 1

  • id (1)

group_keberangkatan [PRIMARY] 1

  • id (1)

group_la [PRIMARY] 1

  • id (1)

group_la [PRIMARY] 1

  • id (1)

group_users [PRIMARY] 1

  • id (1)

group_users [PRIMARY] 1

  • id (1)

gudang_toolkit [PRIMARY] 1

  • id (1)

gudang_toolkit [PRIMARY] 1

  • id (1)

highlight [PRIMARY] 1

  • id (1)

highlight [PRIMARY] 1

  • id (1)

home_slider [PRIMARY] 1

  • id (1)

home_slider [PRIMARY] 1

  • id (1)

hotel [PRIMARY] 1

  • id (1)

hotel [PRIMARY] 1

  • id (1)

info_peringatan [PRIMARY] 1

  • id (1)

info_peringatan [PRIMARY] 1

  • id (1)

information_image [PRIMARY] 1

  • id (1)

information_image [PRIMARY] 1

  • id (1)

inspeksi [PRIMARY] 1

  • id (1)

inspeksi [PRIMARY] 1

  • id (1)

inspeksi_detail_toolkit [PRIMARY] 1

  • id (1)

inspeksi_detail_toolkit [PRIMARY] 1

  • id (1)

inspeksi_file [PRIMARY] 1

  • id (1)

inspeksi_file [PRIMARY] 1

  • id (1)

inspeksi_pemeriksaan [PRIMARY] 1

  • id (1)

inspeksi_pemeriksaan [PRIMARY] 1

  • id (1)

inspeksi_pemeriksaan [id] 1

  • id (1)

inspeksi_pemeriksaan [id] 1

  • id (1)

inspeksi_pengambilan [PRIMARY] 1

  • id (1)

inspeksi_pengambilan [PRIMARY] 1

  • id (1)

inspeksi_scan_berkas [PRIMARY] 1

  • id (1)

inspeksi_scan_berkas [PRIMARY] 1

  • id (1)

inspeksi_scan_berkas [id] 1

  • id (1)

inspeksi_scan_berkas [id] 1

  • id (1)

inventory_toolkit [PRIMARY] 1

  • id (1)

inventory_toolkit [PRIMARY] 1

  • id (1)

invoice [PRIMARY] 1

  • id (1)

invoice [PRIMARY] 1

  • id (1)

invoice [id_sumber] 1

  • id_sumber (1)

invoice [id_sumber] 1

  • id_sumber (1)

invoice_detail_jamaah [PRIMARY] 1

  • id (1)

invoice_detail_jamaah [PRIMARY] 1

  • id (1)

invoice_discount [PRIMARY] 1

  • id (1)

invoice_discount [PRIMARY] 1

  • id (1)

itinerary [PRIMARY] 1

  • id (1)

itinerary [PRIMARY] 1

  • id (1)

itinerary_detail [PRIMARY] 1

  • id (1)

itinerary_detail [PRIMARY] 1

  • id (1)

itinerary_template [PRIMARY] 1

  • id (1)

itinerary_template [PRIMARY] 1

  • id (1)

jamaah_umroh [PRIMARY] 1

  • id (1)

jamaah_umroh [PRIMARY] 1

  • id (1)

jasa_tambahan [PRIMARY] 1

  • id (1)

jasa_tambahan [PRIMARY] 1

  • id (1)

jenis_jasa [PRIMARY] 1

  • id (1)

jenis_jasa [PRIMARY] 1

  • id (1)

jenis_panduan [PRIMARY] 1

  • id (1)

jenis_panduan [PRIMARY] 1

  • id (1)

jurnal [PRIMARY] 1

  • id (1)

jurnal [PRIMARY] 1

  • id (1)

jurnal_detail [PRIMARY] 1

  • id (1)

jurnal_detail [PRIMARY] 1

  • id (1)

jurnal_detail [fk_id_jurnal] 1

  • id_jurnal (1)

jurnal_detail [fk_id_jurnal] 1

  • id_jurnal (1)

kas_bank [PRIMARY] 1

  • id (1)

kas_bank [PRIMARY] 1

  • id (1)

kategori_artikel [PRIMARY] 1

  • id (1)

kategori_artikel [PRIMARY] 1

  • id (1)

kategori_tour [PRIMARY] 1

  • id (1)

kategori_tour [PRIMARY] 1

  • id (1)

kategori_video [PRIMARY] 1

  • id (1)

kategori_video [PRIMARY] 1

  • id (1)

kelas_program [PRIMARY] 1

  • id (1)

kelas_program [PRIMARY] 1

  • id (1)

keluarga_jamaah [PRIMARY] 1

  • id (1)

keluarga_jamaah [PRIMARY] 1

  • id (1)

kirim_email [PRIMARY] 1

  • id (1)

kirim_email [PRIMARY] 1

  • id (1)

kirim_pesan [PRIMARY] 1

  • id (1)

kirim_pesan [PRIMARY] 1

  • id (1)

komentar [PRIMARY] 1

  • id (1)

komentar [PRIMARY] 1

  • id (1)

komentar [fk_id_artikel_komentar] 1

  • id_artikel (1)

komentar [fk_id_artikel_komentar] 1

  • id_artikel (1)

komisi_agen [PRIMARY] 1

  • id (1)

komisi_agen [PRIMARY] 1

  • id (1)

kota_tujuan [PRIMARY] 1

  • id (1)

kota_tujuan [PRIMARY] 1

  • id (1)

log_activity [PRIMARY] 1

  • id (1)

log_activity [PRIMARY] 1

  • id (1)

log_inventory_jamaah [PRIMARY] 1

  • id (1)

log_inventory_jamaah [PRIMARY] 1

  • id (1)

log_toolkit [PRIMARY] 1

  • id (1)

log_toolkit [PRIMARY] 1

  • id (1)

log_toolkit_pembelian [PRIMARY] 1

  • id (1)

log_toolkit_pembelian [PRIMARY] 1

  • id (1)

log_toolkit_pembelian [fk_id_pembelian_toolkit] 1

  • id_pembelian_toolkit (1)

log_toolkit_pembelian [fk_id_pembelian_toolkit] 1

  • id_pembelian_toolkit (1)

maskapai [PRIMARY] 1

  • id (1)

maskapai [PRIMARY] 1

  • id (1)

muthawif [PRIMARY] 1

  • id (1)

muthawif [PRIMARY] 1

  • id (1)

negara [PRIMARY] 1

  • id (1)

negara [PRIMARY] 1

  • id (1)

panduan_ibadah [PRIMARY] 1

  • id (1)

panduan_ibadah [PRIMARY] 1

  • id (1)

payment [PRIMARY] 1

  • id (1)

payment [PRIMARY] 1

  • id (1)

payment [id_invoice] 1

  • id_sumber (1)

payment [id_invoice] 1

  • id_sumber (1)

payment [id_user] 1

  • id_user (1)

payment [id_user] 1

  • id_user (1)

payment [kode_jamaah] 1

  • kode_jamaah (1)

payment [kode_jamaah] 1

  • kode_jamaah (1)

payment_fee [PRIMARY] 1

  • id (1)

payment_fee [PRIMARY] 1

  • id (1)

payment_fee [fk_id_komisi] 1

  • id_komisi (1)

payment_fee [fk_id_komisi] 1

  • id_komisi (1)

pelayanan_khusus [PRIMARY] 1

  • id (1)

pelayanan_khusus [PRIMARY] 1

  • id (1)

pembayaran_vendor [PRIMARY] 1

  • id (1)

pembayaran_vendor [PRIMARY] 1

  • id (1)

pembelian_toolkit [PRIMARY] 1

  • id (1)

pembelian_toolkit [PRIMARY] 1

  • id (1)

pembimbing [PRIMARY] 1

  • id (1)

pembimbing [PRIMARY] 1

  • id (1)

perihal_pribadi [PRIMARY] 1

  • id (1)

perihal_pribadi [PRIMARY] 1

  • id (1)

pesan [PRIMARY] 1

  • id (1)

pesan [PRIMARY] 1

  • id (1)

pilih_kamar [PRIMARY] 1

  • id (1)

pilih_kamar [PRIMARY] 1

  • id (1)

program_keberangkatan [PRIMARY] 1

  • id (1)

program_keberangkatan [PRIMARY] 1

  • id (1)

provinces [PRIMARY] 1

  • id (1)

provinces [PRIMARY] 1

  • id (1)

rab [PRIMARY] 1

  • id (1)

rab [PRIMARY] 1

  • id (1)

rab_detail [PRIMARY] 1

  • id (1)

rab_detail [PRIMARY] 1

  • id (1)

referensi_bukutamu [PRIMARY] 1

  • id (1)

referensi_bukutamu [PRIMARY] 1

  • id (1)

regencies [PRIMARY] 1

  • id (1)

regencies [PRIMARY] 1

  • id (1)

regencies [regencies_province_id_index] 1

  • province_id (1)

regencies [regencies_province_id_index] 1

  • province_id (1)

respon_tamu [PRIMARY] 1

  • id (1)

respon_tamu [PRIMARY] 1

  • id (1)

rooming_list [PRIMARY] 1

  • id (1)

rooming_list [PRIMARY] 1

  • id (1)

ruangan [PRIMARY] 1

  • id (1)

ruangan [PRIMARY] 1

  • id (1)

sms_center [PRIMARY] 1

  • id (1)

sms_center [PRIMARY] 1

  • id (1)

supplier [PRIMARY] 1

  • id (1)

supplier [PRIMARY] 1

  • id (1)

t_pengunjung [PRIMARY] 1

  • id (1)

t_pengunjung [PRIMARY] 1

  • id (1)

t_wilayah_kabupaten [PRIMARY] 1

  • id (1)

t_wilayah_kabupaten [PRIMARY] 1

  • id (1)

t_wilayah_provinsi [PRIMARY] 1

  • id (1)

t_wilayah_provinsi [PRIMARY] 1

  • id (1)

tabungan_jamaah [PRIMARY] 1

  • id (1)

tabungan_jamaah [PRIMARY] 1

  • id (1)

tagihan_jasa_tambahan [PRIMARY] 1

  • id (1)

tagihan_jasa_tambahan [PRIMARY] 1

  • id (1)

tags [PRIMARY] 1

  • id (1)

tags [PRIMARY] 1

  • id (1)

testimoni [PRIMARY] 1

  • id (1)

testimoni [PRIMARY] 1

  • id (1)

tipe_kamar [PRIMARY] 1

  • id (1)

tipe_kamar [PRIMARY] 1

  • id (1)

toolkit [PRIMARY] 1

  • id (1)

toolkit [PRIMARY] 1

  • id (1)

tools_marketing [PRIMARY] 1

  • id (1)

tools_marketing [PRIMARY] 1

  • id (1)

tracking [PRIMARY] 1

  • id (1)

tracking [PRIMARY] 1

  • id (1)

transaksi_kasbank [PRIMARY] 1

  • id (1)

transaksi_kasbank [PRIMARY] 1

  • id (1)

transaksi_kasbank [transaksi_kasbank_ibfk_1] 1

  • id_kasbank (1)

transaksi_kasbank [transaksi_kasbank_ibfk_1] 1

  • id_kasbank (1)

user [FK_sys_users_sys_group_users] 1

  • id_group (1)

user [FK_sys_users_sys_group_users] 1

  • id_group (1)

user [PRIMARY] 1

  • id (1)

user [PRIMARY] 1

  • id (1)

user [email] 1

  • email (1)

user [email] 1

  • email (1)

user [password] 1

  • password (1)

user [password] 1

  • password (1)

user [username] 1

  • username (1)

user [username] 1

  • username (1)

vendor [PRIMARY] 1

  • id (1)

vendor [PRIMARY] 1

  • id (1)

vendor_biaya [PRIMARY] 1

  • id (1)

vendor_biaya [PRIMARY] 1

  • id (1)

video [PRIMARY] 1

  • id (1)

video [PRIMARY] 1

  • id (1)

video [fk_id_kategori_video] 1

  • id_kategori (1)

video [fk_id_kategori_video] 1

  • id_kategori (1)

wholesaler [PRIMARY] 1

  • id (1)

wholesaler [PRIMARY] 1

  • id (1)

wholesaler_bus [PRIMARY] 1

  • id (1)

wholesaler_bus [PRIMARY] 1

  • id (1)

wholesaler_bus [id_wholesaler] 1

  • id_wholesaler (1)

wholesaler_bus [id_wholesaler] 1

  • id_wholesaler (1)

wholesaler_hotel [PRIMARY] 1

  • id (1)

wholesaler_hotel [PRIMARY] 1

  • id (1)

wholesaler_hotel [id_wholesaler] 1

  • id_wholesaler (1)

wholesaler_hotel [id_wholesaler] 1

  • id_wholesaler (1)

wholesaler_manifest [PRIMARY] 1

  • id (1)

wholesaler_manifest [PRIMARY] 1

  • id (1)

wholesaler_manifest [id_wholesaler] 1

  • id_wholesaler (1)

wholesaler_manifest [id_wholesaler] 1

  • id_wholesaler (1)

wholesaler_notes [PRIMARY] 1

  • id (1)

wholesaler_notes [PRIMARY] 1

  • id (1)

wholesaler_notes [id_wholesaler_status] 1

  • id_wholesaler_status (1)

wholesaler_notes [id_wholesaler_status] 1

  • id_wholesaler_status (1)

wholesaler_pesawat [PRIMARY] 1

  • id (1)

wholesaler_pesawat [PRIMARY] 1

  • id (1)

wholesaler_pesawat [id_wholesaler] 1

  • id_wholesaler (1)

wholesaler_pesawat [id_wholesaler] 1

  • id_wholesaler (1)

wholesaler_status [PRIMARY] 1

  • id (1)

wholesaler_status [PRIMARY] 1

  • id (1)

wholesaler_status [id_wholesaler] 1

  • id_wholesaler (1)

wholesaler_status [id_wholesaler] 1

  • id_wholesaler (1)

wholesaler_status [id_wholesaler_2] 2

  • id_wholesaler (1)
  • status (2)

wholesaler_status [id_wholesaler_2] 2

  • id_wholesaler (1)
  • status (2)

wholesaler_travel [PRIMARY] 1

  • id (1)

wholesaler_travel [PRIMARY] 1

  • id (1)

wholesaler_travel [id_wholesaler] 1

  • id_wholesaler (1)

wholesaler_travel [id_wholesaler] 1

  • id_wholesaler (1)

 

For more information go to compalex.net