Compalex.net

Database schema compare tool

tables views procedures functions indexes triggers  all changed

u647105626_test

Developer database

localhost:3306/u647105626_test

u647105626_aero

Production database

localhost:3306/u647105626_aero

cash_in_out [PRIMARY] 1

  • id (1)

cash_in_out [PRIMARY] 1

  • id (1)

cash_in_out [id_hutang_dibayar] 1

  • id_hutang_dibayar (1)

cash_in_out [id_hutang_dibayar] 1

  • id_hutang_dibayar (1)

cash_in_out [id_penjualan] 1

  • id_penjualan (1)

cash_in_out [id_penjualan] 1

  • id_penjualan (1)

cash_in_out [id_piutang_dibayar] 1

  • id_piutang_dibayar (1)

cash_in_out [id_piutang_dibayar] 1

  • id_piutang_dibayar (1)

cash_in_out [kode_rekening] 1

  • kode_rekening (1)

cash_in_out [kode_rekening] 1

  • kode_rekening (1)

cronjob_wa [PRIMARY] 1

  • id_cronjob (1)

cronjob_wa [PRIMARY] 1

  • id_cronjob (1)

data_order_tiktok [PRIMARY]

data_order_tiktok [PRIMARY] 1

  • id_order_tiktok (1)

data_order_tiktok_kickstart [PRIMARY]

data_order_tiktok_kickstart [PRIMARY] 1

  • id_order_tiktok (1)

detail_order_tiktok [PRIMARY]

detail_order_tiktok [PRIMARY] 1

  • id_detail_order_tiktok (1)

detail_order_tiktok_kickstart [PRIMARY]

detail_order_tiktok_kickstart [PRIMARY] 1

  • id_detail_order_tiktok (1)

detail_target [PRIMARY] 1

  • id (1)

detail_target [PRIMARY] 1

  • id (1)

dtl_hpp [PRIMARY] 1

  • id_dtl_hpp (1)

dtl_hpp [PRIMARY] 1

  • id_dtl_hpp (1)

dtl_keuangan_tiktok [PRIMARY]

dtl_keuangan_tiktok [PRIMARY] 1

  • id_dtl_tiktok (1)

dtl_keuangan_tiktok_kickstart [PRIMARY]

dtl_keuangan_tiktok_kickstart [PRIMARY] 1

  • id_dtl_tiktok (1)

history_revenue [PRIMARY] 1

  • id_history_revenue (1)

history_revenue [PRIMARY] 1

  • id_history_revenue (1)

hutang_dibayar_history [PRIMARY] 1

  • id (1)

hutang_dibayar_history [PRIMARY] 1

  • id (1)

hutang_dibayar_history [id_hutang] 1

  • id_hutang (1)

hutang_dibayar_history [id_hutang] 1

  • id_hutang (1)

hutang_history [PRIMARY] 1

  • id (1)

hutang_history [PRIMARY] 1

  • id (1)

hutang_history [id_supplier] 1

  • id_supplier (1)

hutang_history [id_supplier] 1

  • id_supplier (1)

hutang_history [nomor_faktur] 1

  • nomor_faktur (1)

hutang_history [nomor_faktur] 1

  • nomor_faktur (1)

jne_list_dst [PRIMARY] 1

  • id (1)

jne_list_dst [PRIMARY] 1

  • id (1)

kartu_stok [PRIMARY] 1

  • id (1)

kartu_stok [PRIMARY] 1

  • id (1)

kartu_stok [id_penjualan] 1

  • id_penjualan (1)

kartu_stok [id_penjualan] 1

  • id_penjualan (1)

kartu_stok [id_stok_adjustment] 1

  • id_utility (1)

kartu_stok [id_stok_adjustment] 1

  • id_utility (1)

kartu_stok [id_stok_keluar] 1

  • id_stok_keluar (1)

kartu_stok [id_stok_keluar] 1

  • id_stok_keluar (1)

kartu_stok [id_stok_opname] 1

  • id_stok_opname (1)

kartu_stok [id_stok_opname] 1

  • id_stok_opname (1)

kartu_stok [kode_item] 1

  • kode_item (1)

kartu_stok [kode_item] 1

  • kode_item (1)

kartu_stok [nomor_rec] 1

  • nomor_rec_penerimaan (1)

kartu_stok [nomor_rec] 1

  • nomor_rec_penerimaan (1)

kartu_stok_hpp [PRIMARY] 1

  • id_kartu_stok_hpp (1)

kartu_stok_hpp [PRIMARY] 1

  • id_kartu_stok_hpp (1)

kartu_stok_hpp [idx_id_penjualan] 1

  • id_penjualan (1)

kartu_stok_hpp [idx_id_penjualan] 1

  • id_penjualan (1)

kategori_harga [PRIMARY] 1

  • id_kategori_harga (1)

kategori_harga [PRIMARY] 1

  • id_kategori_harga (1)

kategori_user [PRIMARY] 1

  • id (1)

kategori_user [PRIMARY] 1

  • id (1)

kategori_user [beranda] 1

  • beranda (1)

kategori_user [beranda] 1

  • beranda (1)

kategori_user [kategori_user] 1

  • kategori_user (1)

kategori_user [kategori_user] 1

  • kategori_user (1)

kategori_user_modul [PRIMARY] 1

  • id (1)

kategori_user_modul [PRIMARY] 1

  • id (1)

kategori_user_modul [kategori_user] 1

  • kategori_user (1)

kategori_user_modul [kategori_user] 1

  • kategori_user (1)

kategori_user_modul [modul] 1

  • modul (1)

kategori_user_modul [modul] 1

  • modul (1)

keranjang [PRIMARY] 1

  • id (1)

keranjang [PRIMARY] 1

  • id (1)

keranjang_detail [PRIMARY] 1

  • id (1)

keranjang_detail [PRIMARY] 1

  • id (1)

keranjang_detail [id_keranjang] 1

  • id_keranjang (1)

keranjang_detail [id_keranjang] 1

  • id_keranjang (1)

keranjang_detail [kode_item] 1

  • kode_item (1)

keranjang_detail [kode_item] 1

  • kode_item (1)

keranjang_variasi_detail [PRIMARY] 1

  • id_variasi (1)

keranjang_variasi_detail [PRIMARY] 1

  • id_variasi (1)

komisi_detail [PRIMARY] 1

  • idd (1)

komisi_detail [PRIMARY] 1

  • idd (1)

list_provinsi_leaflet [PRIMARY] 1

  • id_leaflet (1)

list_provinsi_leaflet [PRIMARY] 1

  • id_leaflet (1)

log_resi_jne [PRIMARY] 1

  • id (1)

log_resi_jne [PRIMARY] 1

  • id (1)

log_resi_jnt [PRIMARY] 1

  • id (1)

log_resi_jnt [PRIMARY] 1

  • id (1)

log_shopee [PRIMARY]

log_shopee [PRIMARY] 1

  • id (1)

log_wa [PRIMARY] 1

  • id_log (1)

log_wa [PRIMARY] 1

  • id_log (1)

master_admin [PRIMARY] 1

  • id (1)

master_admin [PRIMARY] 1

  • id (1)

master_admin [kategori] 1

  • kategori (1)

master_admin [kategori] 1

  • kategori (1)

master_admin [username] 1

  • username (1)

master_admin [username] 1

  • username (1)

master_biaya_ads [PRIMARY] 1

  • id_master_biaya_ads (1)

master_biaya_ads [PRIMARY] 1

  • id_master_biaya_ads (1)

master_diskon_kelipatan [PRIMARY] 1

  • id (1)

master_diskon_kelipatan [PRIMARY] 1

  • id (1)

master_diskon_ongkir [PRIMARY] 1

  • id_diskon_ongkir (1)

master_diskon_ongkir [PRIMARY] 1

  • id_diskon_ongkir (1)

master_ekspedisi [PRIMARY] 1

  • id_ekspedisi (1)

master_ekspedisi [PRIMARY] 1

  • id_ekspedisi (1)

master_harga_jual [PRIMARY] 1

  • id_master_harga_jual (1)

master_harga_jual [PRIMARY] 1

  • id_master_harga_jual (1)

master_hpp [PRIMARY] 1

  • id_master_hpp (1)

master_hpp [PRIMARY] 1

  • id_master_hpp (1)

master_item [PRIMARY] 1

  • kode_item (1)

master_item [PRIMARY] 1

  • kode_item (1)

master_kat_operasional [PRIMARY] 1

  • id_kat_operasional (1)

master_kat_operasional [PRIMARY] 1

  • id_kat_operasional (1)

master_kategori [PRIMARY] 1

  • id (1)

master_kategori [PRIMARY] 1

  • id (1)

master_kecamatan [PRIMARY] 1

  • id_kecamatan (1)

master_kecamatan [PRIMARY] 1

  • id_kecamatan (1)

master_kode_promosi [PRIMARY] 1

  • id_kode_promosi (1)

master_kode_promosi [PRIMARY] 1

  • id_kode_promosi (1)

master_komisi [PRIMARY] 1

  • id_komisi (1)

master_komisi [PRIMARY] 1

  • id_komisi (1)

master_komisi_influencer [PRIMARY] 1

  • id_komisi_influencer (1)

master_komisi_influencer [PRIMARY] 1

  • id_komisi_influencer (1)

master_komisi_influencer [id_penjualan] 1

  • id_penjualan (1)

master_komisi_influencer [id_penjualan] 1

  • id_penjualan (1)

master_marketing [PRIMARY] 1

  • id_marketing (1)

master_marketing [PRIMARY] 1

  • id_marketing (1)

master_operasional [PRIMARY] 1

  • id (1)

master_operasional [PRIMARY] 1

  • id (1)

master_pelanggan [PRIMARY] 1

  • id_pembeli (1)

master_pelanggan [PRIMARY] 1

  • id_pembeli (1)

master_promosi [PRIMARY] 1

  • id_promosi (1)

master_promosi [PRIMARY] 1

  • id_promosi (1)

master_rekening [PRIMARY] 1

  • id_rekening (1)

master_rekening [PRIMARY] 1

  • id_rekening (1)

master_supplier [PRIMARY] 1

  • id (1)

master_supplier [PRIMARY] 1

  • id (1)

master_supplier [kode] 1

  • kode (1)

master_supplier [kode] 1

  • kode (1)

master_target [PRIMARY] 1

  • id_master_target (1)

master_target [PRIMARY] 1

  • id_master_target (1)

master_utility [PRIMARY] 1

  • id_utility (1)

master_utility [PRIMARY] 1

  • id_utility (1)

modul [PRIMARY] 1

  • id (1)

modul [PRIMARY] 1

  • id (1)

notes [PRIMARY] 1

  • id (1)

notes [PRIMARY] 1

  • id (1)

pembelian [PRIMARY] 1

  • id_pembelian (1)

pembelian [PRIMARY] 1

  • id_pembelian (1)

pembelian_detail [PRIMARY] 1

  • id_pembelian_detail (1)

pembelian_detail [PRIMARY] 1

  • id_pembelian_detail (1)

pembelian_langsung [PRIMARY] 1

  • nomor_faktur (1)

pembelian_langsung [PRIMARY] 1

  • nomor_faktur (1)

pembelian_langsung [nomor_rec] 1

  • nomor_rec (1)

pembelian_langsung [nomor_rec] 1

  • nomor_rec (1)

pembelian_langsung [supplier] 1

  • supplier (1)

pembelian_langsung [supplier] 1

  • supplier (1)

pembelian_langsung_detail [PRIMARY] 1

  • idd (1)

pembelian_langsung_detail [PRIMARY] 1

  • idd (1)

pembelian_langsung_detail [kode_item] 1

  • kode_item (1)

pembelian_langsung_detail [kode_item] 1

  • kode_item (1)

pembelian_langsung_detail [nomor_po] 1

  • nomor_faktur (1)

pembelian_langsung_detail [nomor_po] 1

  • nomor_faktur (1)

penerimaan_barang [PRIMARY] 1

  • nomor_rec (1)

penerimaan_barang [PRIMARY] 1

  • nomor_rec (1)

penerimaan_barang_detail [PRIMARY] 1

  • idd (1)

penerimaan_barang_detail [PRIMARY] 1

  • idd (1)

penerimaan_barang_detail [nomor_rec] 1

  • nomor_rec (1)

penerimaan_barang_detail [nomor_rec] 1

  • nomor_rec (1)

penjualan [PRIMARY] 1

  • id (1)

penjualan [PRIMARY] 1

  • id (1)

penjualan [admin_retur] 1

  • admin_retur (1)

penjualan [admin_retur] 1

  • admin_retur (1)

penjualan [id_admin] 1

  • id_admin (1)

penjualan [id_admin] 1

  • id_admin (1)

penjualan [idx_batal_transaksi] 1

  • batal_transaksi (1)

penjualan [idx_batal_transaksi] 1

  • batal_transaksi (1)

penjualan [idx_tgl_pesanan] 1

  • tgl_pesanan (1)

penjualan [idx_tgl_pesanan] 1

  • tgl_pesanan (1)

penjualan_detail [PRIMARY] 1

  • id (1)

penjualan_detail [PRIMARY] 1

  • id (1)

penjualan_detail [id_penjualan] 1

  • id_penjualan (1)

penjualan_detail [id_penjualan] 1

  • id_penjualan (1)

penjualan_detail [kode_item] 1

  • kode_item (1)

penjualan_detail [kode_item] 1

  • kode_item (1)

penjualan_pembayaran [PRIMARY] 1

  • id (1)

penjualan_pembayaran [PRIMARY] 1

  • id (1)

penjualan_pembayaran [id_penjualan] 1

  • id_penjualan (1)

penjualan_pembayaran [id_penjualan] 1

  • id_penjualan (1)

penjualan_variasi_detail [PRIMARY] 1

  • id_variasi (1)

penjualan_variasi_detail [PRIMARY] 1

  • id_variasi (1)

piutang_dibayar_history [PRIMARY] 1

  • id (1)

piutang_dibayar_history [PRIMARY] 1

  • id (1)

piutang_dibayar_history [id_piutang] 1

  • id_piutang (1)

piutang_dibayar_history [id_piutang] 1

  • id_piutang (1)

piutang_history [PRIMARY] 1

  • id (1)

piutang_history [PRIMARY] 1

  • id (1)

piutang_history [id_penjualan] 1

  • id_penjualan (1)

piutang_history [id_penjualan] 1

  • id_penjualan (1)

profil_apotek [PRIMARY] 1

  • id (1)

profil_apotek [PRIMARY] 1

  • id (1)

purchase_order [PRIMARY] 1

  • nomor_po (1)

purchase_order [PRIMARY] 1

  • nomor_po (1)

purchase_order [supplier] 1

  • supplier (1)

purchase_order [supplier] 1

  • supplier (1)

purchase_order_detail [PRIMARY] 1

  • idd (1)

purchase_order_detail [PRIMARY] 1

  • idd (1)

purchase_order_detail [kode_item] 1

  • kode_item (1)

purchase_order_detail [kode_item] 1

  • kode_item (1)

purchase_order_detail [nomor_po] 1

  • nomor_po (1)

purchase_order_detail [nomor_po] 1

  • nomor_po (1)

rekening_kode [PRIMARY] 1

  • kode_rekening (1)

rekening_kode [PRIMARY] 1

  • kode_rekening (1)

setting [PRIMARY]

setting [PRIMARY] 1

  • id (1)

stok_adjustment [PRIMARY] 1

  • id (1)

stok_adjustment [PRIMARY] 1

  • id (1)

stok_adjustment [kode_item] 1

  • kode_item (1)

stok_adjustment [kode_item] 1

  • kode_item (1)

stok_adjustment [nomor_ref] 1

  • nomor_ref (1)

stok_adjustment [nomor_ref] 1

  • nomor_ref (1)

stok_keluar [PRIMARY] 1

  • id (1)

stok_keluar [PRIMARY] 1

  • id (1)

stok_keluar [kode_item] 1

  • kode_item (1)

stok_keluar [kode_item] 1

  • kode_item (1)

stok_keluar [nomor_ref] 1

  • nomor_ref (1)

stok_keluar [nomor_ref] 1

  • nomor_ref (1)

stok_keluar [stok_keluar_ibfk_2] 1

  • nomor_retur_pembelian (1)

stok_keluar [stok_keluar_ibfk_2] 1

  • nomor_retur_pembelian (1)

stok_opname [PRIMARY] 1

  • id (1)

stok_opname [PRIMARY] 1

  • id (1)

stok_opname [kode_item] 1

  • kode_item (1)

stok_opname [kode_item] 1

  • kode_item (1)

stok_opname [nomor_ref] 1

  • nomor_ref (1)

stok_opname [nomor_ref] 1

  • nomor_ref (1)

 

For more information go to compalex.net