Constraints

718 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
nota_retur_pajak_detail_id_nota_retur_pajak_id_fk
nota_retur_pajak_detail.id
nota_retur_pajak.id
Restrict delete
nota_retur_pajak_detail_id_barang_barang_id_fk
nota_retur_pajak_detail.id_barang
barang.id
Restrict delete
program_pembelian_updated_by_pegawai_id_fk
program_pembelian.updated_by
pegawai.id
Restrict delete
program_pembelian_created_by_pegawai_id_fk
program_pembelian.created_by
pegawai.id
Restrict delete
proposal_ap_persetujuan_id_proposal_ap_id_fk
proposal_ap_persetujuan.id
proposal_ap.id
Restrict delete
ekspedisi_resi_id_ekspedisi_ekspedisi_id_fk
ekspedisi_resi.id_ekspedisi
ekspedisi.id
Restrict delete
ekspedisi_resi_updated_by_pegawai_id_fk
ekspedisi_resi.updated_by
pegawai.id
Restrict delete
ekspedisi_resi_created_by_pegawai_id_fk
ekspedisi_resi.created_by
pegawai.id
Restrict delete
pengajuan_kenaikan_harga_persetujuan_id_pengajuan_kenaikan_harg
pengajuan_kenaikan_harga_persetujuan.id
pengajuan_kenaikan_harga.id
Restrict delete
invoice_persetujuan_id_invoice_id_fk
invoice_persetujuan.id
invoice.id
Restrict delete
kelas_barang_id_kelas_kelas_id_fk
kelas_barang.id_kelas
kelas.id
Cascade on delete
kelas_barang_id_barang_barang_id_fk
kelas_barang.id_barang
barang.id
Cascade on delete
klaim_program_pembelian_created_by_pegawai_id_fk
klaim_program_pembelian.created_by
pegawai.id
Restrict delete
klaim_program_pembelian_id_program_pembelian_program_pembelian_
klaim_program_pembelian.id_program_pembelian
program_pembelian.id
Restrict delete
klaim_program_pembelian_updated_by_pegawai_id_fk
klaim_program_pembelian.updated_by
pegawai.id
Restrict delete
reg_regencies_province_id_reg_provinces_id_fk
reg_regencies.province_id
reg_provinces.id
Restrict delete
invoice_retur_id_invoice_invoice_id_fk
invoice_retur.id_invoice
invoice.id
Restrict delete
invoice_retur_updated_by_pegawai_id_fk
invoice_retur.updated_by
pegawai.id
Restrict delete
invoice_retur_id_pengajuan_retur_penjualan_pengajuan_retur_penj
invoice_retur.id_pengajuan_retur_penjualan
pengajuan_retur_penjualan.id
Restrict delete
invoice_retur_id_gudang_gudang_id_fk
invoice_retur.id_gudang
gudang.id
Restrict delete
invoice_retur_created_by_pegawai_id_fk
invoice_retur.created_by
pegawai.id
Restrict delete
invoice_retur_id_rak_barang_rak_barang_id_fk
invoice_retur.id_rak_barang
rak_barang.id
Restrict delete
customer_jenis_updated_by_pegawai_id_fk
customer_jenis.updated_by
pegawai.id
Restrict delete
customer_jenis_created_by_pegawai_id_fk
customer_jenis.created_by
pegawai.id
Restrict delete
program_reward_created_by_pegawai_id_fk
program_reward.created_by
pegawai.id
Restrict delete
program_reward_updated_by_pegawai_id_fk
program_reward.updated_by
pegawai.id
Restrict delete
proposal_ar_persetujuan_id_proposal_ar_id_fk
proposal_ar_persetujuan.id
proposal_ar.id
Restrict delete
sales_order_updated_by_pegawai_id_fk
sales_order.updated_by
pegawai.id
Restrict delete
sales_order_id_area_area_id_fk
sales_order.id_area
area.id
Restrict delete
sales_order_id_penawaran_tender_penawaran_tender_id_fk
sales_order.id_penawaran_tender
penawaran_tender.id
Restrict delete
sales_order_reject_by_pegawai_id_fk
sales_order.reject_by
pegawai.id
Restrict delete
sales_order_created_by_pegawai_id_fk
sales_order.created_by
pegawai.id
Restrict delete
sales_order_id_sebelumnya_sales_order_id_fk
sales_order.id_sebelumnya
sales_order.id
Restrict delete
sales_order_id_verifikasi_pegawai_id_fk
sales_order.id_verifikasi
pegawai.id
Restrict delete
target_penjualan_persetujuan_id_target_penjualan_id_fk
target_penjualan_persetujuan.id
target_penjualan.id
Restrict delete
divisi_channel_id_divisi_divisi_id_fk
divisi_channel.id_divisi
divisi.id
Restrict delete
divisi_channel_id_channel_divisi_sales_id_fk
divisi_channel.id_channel
divisi_sales.id
Restrict delete
agama_created_by_pegawai_id_fk
agama.created_by
pegawai.id
Restrict delete
agama_updated_by_pegawai_id_fk
agama.updated_by
pegawai.id
Restrict delete
target_penjualan_detail_id_area_area_id_fk
target_penjualan_detail.id_area
area.id
Restrict delete
target_penjualan_detail_id_divisi_sales_divisi_sales_id_fk
target_penjualan_detail.id_divisi_sales
divisi_sales.id
Restrict delete
target_penjualan_detail_id_divisi_divisi_id_fk
target_penjualan_detail.id_divisi
divisi.id
Restrict delete
barang_dekat_ed_updated_by_pegawai_id_fk
barang_dekat_ed.updated_by
pegawai.id
Restrict delete
barang_dekat_ed_id_gudang_gudang_id_fk
barang_dekat_ed.id_gudang
gudang.id
Restrict delete
barang_dekat_ed_id_supplier_supplier_id_fk
barang_dekat_ed.id_supplier
supplier.id
Restrict delete
barang_dekat_ed_created_by_pegawai_id_fk
barang_dekat_ed.created_by
pegawai.id
Restrict delete
jenis_barang_updated_by_pegawai_id_fk
jenis_barang.updated_by
pegawai.id
Restrict delete
jenis_barang_created_by_pegawai_id_fk
jenis_barang.created_by
pegawai.id
Restrict delete
retur_pembelian_persetujuan_id_retur_pembelian_id_fk
retur_pembelian_persetujuan.id
retur_pembelian.id
Restrict delete
payment_ap_updated_by_pegawai_id_fk
payment_ap.updated_by
pegawai.id
Restrict delete
payment_ap_id_supplier_supplier_id_fk
payment_ap.id_supplier
supplier.id
Restrict delete
payment_ap_id_tipe_pembayaran_tipe_pembayaran_id_fk
payment_ap.id_tipe_pembayaran
tipe_pembayaran.id
Restrict delete
payment_ap_bank_account_account_id_fk
payment_ap.bank_account
account.id
Restrict delete
payment_ap_created_by_pegawai_id_fk
payment_ap.created_by
pegawai.id
Restrict delete
invoice_revisi_created_by_pegawai_id_fk
invoice_revisi.created_by
pegawai.id
Restrict delete
invoice_revisi_updated_by_pegawai_id_fk
invoice_revisi.updated_by
pegawai.id
Restrict delete
payment_ar_id_tipe_pembayaran_tipe_pembayaran_id_fk
payment_ar.id_tipe_pembayaran
tipe_pembayaran.id
Restrict delete
payment_ar_created_by_pegawai_id_fk
payment_ar.created_by
pegawai.id
Restrict delete
fk_payment_ar_id_proposal
payment_ar.id_proposal
proposal_ar.id
Restrict delete
payment_ar_id_customer_customer_id_fk
payment_ar.id_customer
customer.id
Restrict delete
payment_ar_id_rejected_pegawai_id_fk
payment_ar.id_rejected
pegawai.id
Restrict delete
payment_ar_id_account_account_id_fk
payment_ar.id_account
account.id
Restrict delete
payment_ar_id_verifikasi_pegawai_id_fk
payment_ar.id_verifikasi
pegawai.id
Restrict delete
payment_ar_updated_by_pegawai_id_fk
payment_ar.updated_by
pegawai.id
Restrict delete
permintaan_penawaran_detail_id_tipe_diskon_tipe_diskon_id_fk
permintaan_penawaran_detail.id_tipe_diskon
tipe_diskon.id
Restrict delete
permintaan_penawaran_detail_id_barang_barang_id_fk
permintaan_penawaran_detail.id_barang
barang.id
Restrict delete
permintaan_penawaran_detail_id_program_program_pembelian_id_fk
permintaan_penawaran_detail.id_program
program_pembelian.id
Restrict delete
permintaan_penawaran_detail_id_permintaan_penawaran_id_fk
permintaan_penawaran_detail.id
permintaan_penawaran.id
Restrict delete
permintaan_penawaran_detail_id_satuan_satuan_id_fk
permintaan_penawaran_detail.id_satuan
satuan.id
Restrict delete
pengajuan_kenaikan_harga_updated_by_pegawai_id_fk
pengajuan_kenaikan_harga.updated_by
pegawai.id
Restrict delete
pengajuan_kenaikan_harga_created_by_pegawai_id_fk
pengajuan_kenaikan_harga.created_by
pegawai.id
Restrict delete
stok_opname_invoice_persetujuan_id_stok_opname_invoice_id_fk
stok_opname_invoice_persetujuan.id
stok_opname_invoice.id
Restrict delete
checking_persetujuan_id_checking_id_fk
checking_persetujuan.id
checking.id
Restrict delete
mapping_salesman_created_by_pegawai_id_fk
mapping_salesman.created_by
pegawai.id
Restrict delete
mapping_salesman_updated_by_pegawai_id_fk
mapping_salesman.updated_by
pegawai.id
Restrict delete
mapping_salesman_id_salesman_pegawai_id_fk
mapping_salesman.id_salesman
pegawai.id
Restrict delete
mapping_salesman_id_spv_pegawai_id_fk
mapping_salesman.id_spv
pegawai.id
Restrict delete
coretax_detail_id_coretax_id_fk
coretax_detail.id
coretax.id
Restrict delete
coretax_updated_by_pegawai_id_fk
coretax.updated_by
pegawai.id
Restrict delete
coretax_created_by_pegawai_id_fk
coretax.created_by
pegawai.id
Restrict delete
coretax_id_kota_reg_regencies_id_fk
coretax.id_kota
reg_regencies.id
Restrict delete
stok_opname_stok_barang_id_barang_fkey
stok_opname_stok_barang.id_barang
barang.id
Restrict delete
stok_opname_stok_barang_id_stok_fkey
stok_opname_stok_barang.id_stok
stok_barang.id
Restrict delete
stok_opname_stok_barang_id_satuan_fkey
stok_opname_stok_barang.id_satuan
satuan.id
Restrict delete
stok_opname_stok_barang_id_gudang_fkey
stok_opname_stok_barang.id_gudang
gudang.id
Restrict delete
stok_opname_stok_barang_id_fkey
stok_opname_stok_barang.id
stok_opname.id
Restrict delete
retur_pembelian_detail_id_bukti_barang_masuk_bukti_barang_masuk
retur_pembelian_detail.id_bukti_barang_masuk_detail
bukti_barang_masuk.id
Restrict delete
retur_pembelian_detail_id_barang_barang_id_fk
retur_pembelian_detail.id_barang
barang.id
Restrict delete
retur_pembelian_detail_id_retur_pembelian_id_fk
retur_pembelian_detail.id
retur_pembelian.id
Restrict delete
retur_pembelian_detail_id_tipe_diskon_tipe_diskon_id_fk
retur_pembelian_detail.id_tipe_diskon
tipe_diskon.id
Restrict delete
rencana_kunjungan_salesman_detail_id_customer_customer_id_fk
rencana_kunjungan_salesman_detail.id_customer
customer.id
Restrict delete
rencana_kunjungan_salesman_detail_id_rencana_kunjungan_salesman
rencana_kunjungan_salesman_detail.id
rencana_kunjungan_salesman.id
Restrict delete
rencana_kunjungan_salesman_detail_id_tipe_kunjungan_tipe_kunjun
rencana_kunjungan_salesman_detail.id_tipe_kunjungan
tipe_kunjungan.id
Restrict delete
tanda_terima_ceklist_id_tanda_terima_invoice_id_fk
tanda_terima_ceklist.id
tanda_terima_invoice.id
Restrict delete
penerimaan_barang_persetujuan_id_penerimaan_barang_id_fk
penerimaan_barang_persetujuan.id
penerimaan_barang.id
Restrict delete
pengguna_permission_id_permission_permission_id_fk
pengguna_permission.id_permission
permission.id
Cascade on delete
pengguna_permission_id_pengguna_id_fk
pengguna_permission.id
pengguna.id
Cascade on delete
tipe_diskon_updated_by_pegawai_id_fk
tipe_diskon.updated_by
pegawai.id
Restrict delete
tipe_diskon_created_by_pegawai_id_fk
tipe_diskon.created_by
pegawai.id
Restrict delete
stok_opname_invoice_area_id_area_area_id_fk
stok_opname_invoice_area.id_area
area.id
Restrict delete
stok_opname_invoice_area_id_stok_opname_invoice_id_fk
stok_opname_invoice_area.id
stok_opname_invoice.id
Restrict delete
payment_ap_detail_id_proposal_ap_detail_proposal_ap_id_fk
payment_ap_detail.id_proposal_ap_detail
proposal_ap.id
Restrict delete
payment_ap_detail_id_payment_ap_id_fk
payment_ap_detail.id
payment_ap.id
Restrict delete
supplier_id_biaya_expedisi_biaya_expedisi_id_fk
supplier.id_biaya_expedisi
biaya_expedisi.id
Restrict delete
supplier_created_by_pegawai_id_fk
supplier.created_by
pegawai.id
Restrict delete
supplier_updated_by_pegawai_id_fk
supplier.updated_by
pegawai.id
Restrict delete
supplier_id_province_reg_provinces_id_fk
supplier.id_province
reg_provinces.id
Restrict delete
supplier_id_type_supplier_type_supplier_id_fk
supplier.id_type_supplier
type_supplier.id
Restrict delete
supplier_id_location_supplier_location_supplier_id_fk
supplier.id_location_supplier
location_supplier.id
Restrict delete
supplier_id_regency_reg_regencies_id_fk
supplier.id_regency
reg_regencies.id
Restrict delete
supplier_id_group_supplier_group_supplier_id_fk
supplier.id_group_supplier
group_supplier.id
Restrict delete
cetakan_request_created_by_pegawai_id_fk
cetakan_request.created_by
pegawai.id
Restrict delete
cetakan_request_request_to_pegawai_id_fk
cetakan_request.request_to
pegawai.id
Restrict delete
cetakan_request_id_cetakan_id_fk
cetakan_request.id
cetakan.id
Restrict delete
cetakan_request_updated_by_pegawai_id_fk
cetakan_request.updated_by
pegawai.id
Restrict delete
mapping_kolektor_created_by_pegawai_id_fk
mapping_kolektor.created_by
pegawai.id
Restrict delete
mapping_kolektor_updated_by_pegawai_id_fk
mapping_kolektor.updated_by
pegawai.id
Restrict delete
mapping_kolektor_id_spv_pegawai_id_fk
mapping_kolektor.id_spv
pegawai.id
Restrict delete
mapping_kolektor_id_kolektor_pegawai_id_fk
mapping_kolektor.id_kolektor
pegawai.id
Restrict delete
ap_value_updated_by_pegawai_id_fk
ap_value.updated_by
pegawai.id
Restrict delete
ap_value_created_by_pegawai_id_fk
ap_value.created_by
pegawai.id
Restrict delete
ap_value_id_supplier_supplier_id_fk
ap_value.id_supplier
supplier.id
Restrict delete
urut_pengantaran_id_customer_customer_id_fk
urut_pengantaran.id_customer
customer.id
Restrict delete
tipe_kunjungan_updated_by_pegawai_id_fk
tipe_kunjungan.updated_by
pegawai.id
Restrict delete
tipe_kunjungan_created_by_pegawai_id_fk
tipe_kunjungan.created_by
pegawai.id
Restrict delete
surat_pesanan_persetujuan_id_surat_pesanan_id_fk
surat_pesanan_persetujuan.id
surat_pesanan.id
Restrict delete
area_rencana_kunjungan_salesman_id_area_area_id_fk
area_rencana_kunjungan_salesman.id_area
area.id
Restrict delete
area_rencana_kunjungan_salesman_id_rencana_kunjungan_salesman_r
area_rencana_kunjungan_salesman.id_rencana_kunjungan_salesman
rencana_kunjungan_salesman.id
Restrict delete
mapping_target_salesman_id_pegawai_pegawai_id_fk
mapping_target_salesman.id_pegawai
pegawai.id
Restrict delete
mapping_target_salesman_created_by_pegawai_id_fk
mapping_target_salesman.created_by
pegawai.id
Restrict delete
mapping_target_salesman_updated_by_pegawai_id_fk
mapping_target_salesman.updated_by
pegawai.id
Restrict delete
noo_detail_id_noo_id_fk
noo_detail.id
noo.id
Restrict delete
noo_detail_id_pegawai_pegawai_id_fk
noo_detail.id_pegawai
pegawai.id
Restrict delete
top_per_kota_created_by_pegawai_id_fk
top_per_kota.created_by
pegawai.id
Restrict delete
top_per_kota_updated_by_pegawai_id_fk
top_per_kota.updated_by
pegawai.id
Restrict delete
rencana_kunjungan_salesman_id_salesman_pegawai_id_fk
rencana_kunjungan_salesman.id_salesman
pegawai.id
Restrict delete
rencana_kunjungan_salesman_created_by_pegawai_id_fk
rencana_kunjungan_salesman.created_by
pegawai.id
Restrict delete
rencana_kunjungan_salesman_updated_by_pegawai_id_fk
rencana_kunjungan_salesman.updated_by
pegawai.id
Restrict delete
sales_order_log_updated_by_pegawai_id_fk
sales_order_log.updated_by
pegawai.id
Restrict delete
sales_order_log_created_by_pegawai_id_fk
sales_order_log.created_by
pegawai.id
Restrict delete
divisi_id_golongan_barang_golongan_barang_id_fk
divisi.id_golongan_barang
golongan_barang.id
Restrict delete
acc_kas_updated_by_pegawai_id_fk
acc_kas.updated_by
pegawai.id
Restrict delete
acc_kas_canceled_by_pegawai_id_fk
acc_kas.canceled_by
pegawai.id
Restrict delete
acc_kas_created_by_pegawai_id_fk
acc_kas.created_by
pegawai.id
Restrict delete
acc_kas_akun_account_id_fk
acc_kas.akun
account.id
Restrict delete
pengajuan_retur_penjualan_persetujuan_id_pengajuan_retur_penjua
pengajuan_retur_penjualan_persetujuan.id
pengajuan_retur_penjualan.id
Restrict delete
noo_persetujuan_id_noo_id_fk
noo_persetujuan.id
noo.id
Restrict delete
faktur_bbm_id_bukti_barang_masuk_bukti_barang_masuk_id_fk
faktur_bbm.id_bukti_barang_masuk
bukti_barang_masuk.id
Restrict delete
faktur_bbm_id_penerimaan_barang_penerimaan_barang_id_fk
faktur_bbm.id_penerimaan_barang
penerimaan_barang.id
Restrict delete
cetakan_password_created_by_pegawai_id_fk
cetakan_password.created_by
pegawai.id
Restrict delete
cetakan_password_id_cetakan_id_fk
cetakan_password.id
cetakan.id
Restrict delete
cetakan_password_updated_by_pegawai_id_fk
cetakan_password.updated_by
pegawai.id
Restrict delete
proposal_ap_created_by_pegawai_id_fk
proposal_ap.created_by
pegawai.id
Restrict delete
proposal_ap_updated_by_pegawai_id_fk
proposal_ap.updated_by
pegawai.id
Restrict delete
proposal_ap_id_location_supplier_location_supplier_id_fk
proposal_ap.id_location_supplier
location_supplier.id
Restrict delete
proposal_ap_id_tipe_transaksi_tipe_transaksi_id_fk
proposal_ap.id_tipe_transaksi
tipe_transaksi.id
Restrict delete
cetakan_setting_created_by_pegawai_id_fk
cetakan_setting.created_by
pegawai.id
Restrict delete
cetakan_setting_updated_by_pegawai_id_fk
cetakan_setting.updated_by
pegawai.id
Restrict delete
proposal_ar_id_terima_berkas_pegawai_id_fk
proposal_ar.id_terima_berkas
pegawai.id
Restrict delete
proposal_ar_created_by_pegawai_id_fk
proposal_ar.created_by
pegawai.id
Restrict delete
proposal_ar_updated_by_pegawai_id_fk
proposal_ar.updated_by
pegawai.id
Restrict delete
proposal_ar_id_area_area_id_fk
proposal_ar.id_area
area.id
Restrict delete
klaim_loyalty_updated_by_pegawai_id_fk
klaim_loyalty.updated_by
pegawai.id
Restrict delete
klaim_loyalty_id_kontrak_loyalty_kontrak_loyalty_id_fk
klaim_loyalty.id_kontrak_loyalty
kontrak_loyalty.id
Restrict delete
klaim_loyalty_created_by_pegawai_id_fk
klaim_loyalty.created_by
pegawai.id
Restrict delete
surat_jalan_id_sales_order_sales_order_id_fk
surat_jalan.id_sales_order
sales_order.id
Restrict delete
surat_jalan_created_by_pegawai_id_fk
surat_jalan.created_by
pegawai.id
Restrict delete
surat_jalan_updated_by_pegawai_id_fk
surat_jalan.updated_by
pegawai.id
Restrict delete
surat_jalan_id_tipe_transaksi_tipe_transaksi_id_fk
surat_jalan.id_tipe_transaksi
tipe_transaksi.id
Restrict delete
surat_jalan_id_penawaran_tender_penawaran_tender_id_fk
surat_jalan.id_penawaran_tender
penawaran_tender.id
Restrict delete
surat_jalan_id_picking_pegawai_id_fk
surat_jalan.id_picking
pegawai.id
Restrict delete
surat_jalan_id_area_area_id_fk
surat_jalan.id_area
area.id
Restrict delete
surat_jalan_id_kategori_surat_pesanan_kategori_surat_pesanan_id
surat_jalan.id_kategori_surat_pesanan
kategori_surat_pesanan.id
Restrict delete
surat_jalan_id_area_delivery_area_id_fk
surat_jalan.id_area_delivery
area.id
Restrict delete
acc_ap_faktur_updated_by_pegawai_id_fk
acc_ap_faktur.updated_by
pegawai.id
Restrict delete
acc_ap_faktur_created_by_pegawai_id_fk
acc_ap_faktur.created_by
pegawai.id
Restrict delete
acc_ap_faktur_id_tipe_transaksi_tipe_transaksi_id_fk
acc_ap_faktur.id_tipe_transaksi
tipe_transaksi.id
Restrict delete
acc_ap_faktur_id_supplier_supplier_id_fk
acc_ap_faktur.id_supplier
supplier.id
Restrict delete
program_penjualan_persetujuan_id_program_penjualan_id_fk
program_penjualan_persetujuan.id
program_penjualan.id
Restrict delete
penerimaan_pemindahan_barang_persetujuan_id_penerimaan_pemindah
penerimaan_pemindahan_barang_persetujuan.id
penerimaan_pemindahan_barang.id
Restrict delete
pemindahan_barang_detail_id_satuan_satuan_id_fk
pemindahan_barang_detail.id_satuan
satuan.id
Restrict delete
pemindahan_barang_detail_id_stok_stok_barang_id_fk
pemindahan_barang_detail.id_stok
stok_barang.id
Restrict delete
pemindahan_barang_detail_id_pemindahan_barang_id_fk
pemindahan_barang_detail.id
pemindahan_barang.id
Restrict delete
pemindahan_barang_detail_id_barang_barang_id_fk
pemindahan_barang_detail.id_barang
barang.id
Restrict delete
printer_device_updated_by_pegawai_id_fk
printer_device.updated_by
pegawai.id
Restrict delete
printer_device_id_pegawai_id_fk
printer_device.id
pegawai.id
Restrict delete
printer_device_created_by_pegawai_id_fk
printer_device.created_by
pegawai.id
Restrict delete
account_id_category_account_id_fk
account.id_category
account.id
Restrict delete
account_parent_account_id_fk
account.parent
account.id
Restrict delete
area_created_by_pegawai_id_fk
area.created_by
pegawai.id
Restrict delete
area_updated_by_pegawai_id_fk
area.updated_by
pegawai.id
Restrict delete
payment_ap_tambahan_diskon_id_payment_ap_id_fk
payment_ap_tambahan_diskon.id
payment_ap.id
Restrict delete
berita_acara_id_barang_barang_id_fk
berita_acara.id_barang
barang.id
Restrict delete
berita_acara_id_keterangan_alasan_penolakan_id_fk
berita_acara.id_keterangan
alasan_penolakan.id
Restrict delete
berita_acara_id_penerimaan_barang_id_fk
berita_acara.id
penerimaan_barang.id
Restrict delete
berita_acara_id_satuan_satuan_id_fk
berita_acara.id_satuan
satuan.id
Restrict delete
pengajuan_pembayaran_ekspedisi_detail_id_pengajuan_pembayaran_e
pengajuan_pembayaran_ekspedisi_detail.id
pengajuan_pembayaran_ekspedisi.id
Restrict delete
pengajuan_pembayaran_ekspedisi_detail_id_centang_pegawai_id_fk
pengajuan_pembayaran_ekspedisi_detail.id_centang
pegawai.id
Restrict delete
internal_perusahaan_bank_id_internal_perusahaan_id_fk
internal_perusahaan_bank.id
internal_perusahaan.id
Restrict delete
estimasi_order_detail_id_satuan_satuan_id_fk
estimasi_order_detail.id_satuan
satuan.id
Restrict delete
estimasi_order_detail_id_estimasi_order_id_fk
estimasi_order_detail.id
estimasi_order.id
Restrict delete
estimasi_order_detail_id_program_program_pembelian_id_fk
estimasi_order_detail.id_program
program_pembelian.id
Restrict delete
estimasi_order_detail_id_barang_barang_id_fk
estimasi_order_detail.id_barang
barang.id
Restrict delete
mapping_salesman_area_id_area_area_id_fk
mapping_salesman_area.id_area
area.id
Restrict delete
mapping_salesman_area_id_divisi_sales_divisi_sales_id_fk
mapping_salesman_area.id_divisi_sales
divisi_sales.id
Restrict delete
mapping_salesman_area_id_mapping_salesman_id_fk
mapping_salesman_area.id
mapping_salesman.id
Restrict delete
permintaan_penawaran_persetujuan_id_permintaan_penawaran_id_fk
permintaan_penawaran_persetujuan.id
permintaan_penawaran.id
Restrict delete
bukti_barang_masuk_updated_by_pegawai_id_fk
bukti_barang_masuk.updated_by
pegawai.id
Restrict delete
bukti_barang_masuk_id_penerima_pegawai_id_fk
bukti_barang_masuk.id_penerima
pegawai.id
Restrict delete
bukti_barang_masuk_id_area_area_id_fk
bukti_barang_masuk.id_area
area.id
Restrict delete
bukti_barang_masuk_id_ekspedisi_ekspedisi_id_fk
bukti_barang_masuk.id_ekspedisi
ekspedisi.id
Restrict delete
bukti_barang_masuk_id_supplier_supplier_id_fk
bukti_barang_masuk.id_supplier
supplier.id
Restrict delete
bukti_barang_masuk_created_by_pegawai_id_fk
bukti_barang_masuk.created_by
pegawai.id
Restrict delete
bukti_barang_masuk_id_tipe_transaksi_tipe_transaksi_id_fk
bukti_barang_masuk.id_tipe_transaksi
tipe_transaksi.id
Restrict delete
mapping_target_salesman_detail_id_customer_customer_id_fk
mapping_target_salesman_detail.id_customer
customer.id
Restrict delete
mapping_target_salesman_detail_id_divisi_divisi_id_fk
mapping_target_salesman_detail.id_divisi
divisi.id
Restrict delete
surat_penolakan_penjualan_id_sales_order_sales_order_id_fk
surat_penolakan_penjualan.id_sales_order
sales_order.id
Restrict delete
surat_penolakan_penjualan_created_by_pegawai_id_fk
surat_penolakan_penjualan.created_by
pegawai.id
Restrict delete
surat_penolakan_penjualan_id_customer_customer_id_fk
surat_penolakan_penjualan.id_customer
customer.id
Restrict delete
surat_penolakan_penjualan_updated_by_pegawai_id_fk
surat_penolakan_penjualan.updated_by
pegawai.id
Restrict delete
invoice_id_serah_terima_1_pegawai_id_fk
invoice.id_serah_terima_1
pegawai.id
Restrict delete
invoice_updated_by_pegawai_id_fk
invoice.updated_by
pegawai.id
Restrict delete
invoice_id_area_area_id_fk
invoice.id_area
area.id
Restrict delete
invoice_id_no_faktur_no_faktur_id_fk
invoice.id_no_faktur
no_faktur.id
Restrict delete
invoice_id_customer_customer_id_fk
invoice.id_customer
customer.id
Restrict delete
invoice_id_serah_terima_2_pegawai_id_fk
invoice.id_serah_terima_2
pegawai.id
Restrict delete
invoice_exported_by_pegawai_id_fk
invoice.exported_by
pegawai.id
Restrict delete
invoice_created_by_pegawai_id_fk
invoice.created_by
pegawai.id
Restrict delete
invoice_id_tipe_transaksi_tipe_transaksi_id_fk
invoice.id_tipe_transaksi
tipe_transaksi.id
Restrict delete
kode_obat_created_by_pegawai_id_fk
kode_obat.created_by
pegawai.id
Restrict delete
kode_obat_updated_by_pegawai_id_fk
kode_obat.updated_by
pegawai.id
Restrict delete
noo_id_verif_pegawai_id_fk
noo.id_verif
pegawai.id
Restrict delete
noo_created_by_pegawai_id_fk
noo.created_by
pegawai.id
Restrict delete
noo_updated_by_pegawai_id_fk
noo.updated_by
pegawai.id
Restrict delete
verifikasi_persetujuan_id_sales_order_id_fk
verifikasi_persetujuan.id
sales_order.id
Restrict delete
divisi_sales_updated_by_pegawai_id_fk
divisi_sales.updated_by
pegawai.id
Restrict delete
divisi_sales_created_by_pegawai_id_fk
divisi_sales.created_by
pegawai.id
Restrict delete
ekspedisi_harga_created_by_pegawai_id_fk
ekspedisi_harga.created_by
pegawai.id
Restrict delete
ekspedisi_harga_id_ekspedisi_ekspedisi_id_fk
ekspedisi_harga.id_ekspedisi
ekspedisi.id
Restrict delete
ekspedisi_harga_id_area_area_id_fk
ekspedisi_harga.id_area
area.id
Restrict delete
ekspedisi_harga_updated_by_pegawai_id_fk
ekspedisi_harga.updated_by
pegawai.id
Restrict delete
status_pernikahan_updated_by_pegawai_id_fk
status_pernikahan.updated_by
pegawai.id
Restrict delete
status_pernikahan_created_by_pegawai_id_fk
status_pernikahan.created_by
pegawai.id
Restrict delete
surat_pesanan_program_id_surat_pesanan_id_fk
surat_pesanan_program.id
surat_pesanan.id
Restrict delete
surat_pesanan_program_id_program_program_pembelian_id_fk
surat_pesanan_program.id_program
program_pembelian.id
Restrict delete
biaya_expedisi_created_by_pegawai_id_fk
biaya_expedisi.created_by
pegawai.id
Restrict delete
biaya_expedisi_updated_by_pegawai_id_fk
biaya_expedisi.updated_by
pegawai.id
Restrict delete
barang_id_satuan_satuan_id_fk
barang.id_satuan
satuan.id
Restrict delete
barang_id_logo_obat_logo_obat_id_fk
barang.id_logo_obat
logo_obat.id
Restrict delete
barang_id_rak_barang_rak_barang_id_fk
barang.id_rak_barang
rak_barang.id
Restrict delete
barang_updated_by_pegawai_id_fk
barang.updated_by
pegawai.id
Restrict delete
barang_id_divisi_divisi_id_fk
barang.id_divisi
divisi.id
Restrict delete
barang_id_brand_brand_id_fk
barang.id_brand
brand.id
Restrict delete
barang_id_suhu_suhu_id_fk
barang.id_suhu
suhu.id
Restrict delete
barang_id_bentuk_persediaan_bentuk_persediaan_id_fk
barang.id_bentuk_persediaan
bentuk_persediaan.id
Restrict delete
barang_id_zat_aktif_zat_aktif_id_fk
barang.id_zat_aktif
zat_aktif.id
Restrict delete
barang_id_grup_grup_id_fk
barang.id_grup
grup.id
Restrict delete
barang_id_satuan_tender_satuan_id_fk
barang.id_satuan_tender
satuan.id
Restrict delete
barang_created_by_pegawai_id_fk
barang.created_by
pegawai.id
Restrict delete
barang_id_satuan_beli_satuan_id_fk
barang.id_satuan_beli
satuan.id
Restrict delete
barang_id_kategori_barang_kategori_id_fk
barang.id_kategori
barang_kategori.id
Restrict delete
barang_id_pabrik_pabrik_id_fk
barang.id_pabrik
pabrik.id
Restrict delete
faktur_pajak_pembelian_id_verified_pegawai_id_fk
faktur_pajak_pembelian.id_verified
pegawai.id
Restrict delete
faktur_pajak_pembelian_id_bukti_barang_masuk_bukti_barang_masuk
faktur_pajak_pembelian.id_bukti_barang_masuk
bukti_barang_masuk.id
Restrict delete
faktur_pajak_pembelian_created_by_pegawai_id_fk
faktur_pajak_pembelian.created_by
pegawai.id
Restrict delete
faktur_pajak_pembelian_updated_by_pegawai_id_fk
faktur_pajak_pembelian.updated_by
pegawai.id
Restrict delete
retur_konsinyasi_id_surat_jalan_surat_jalan_id_fk
retur_konsinyasi.id_surat_jalan
surat_jalan.id
Restrict delete
retur_konsinyasi_created_by_pegawai_id_fk
retur_konsinyasi.created_by
pegawai.id
Restrict delete
retur_konsinyasi_updated_by_pegawai_id_fk
retur_konsinyasi.updated_by
pegawai.id
Restrict delete
rak_barang_level_id_rak_barang_id_fk
rak_barang_level.id
rak_barang.id
Restrict delete
barang_dekat_ed_persetujuan_id_barang_dekat_ed_id_fk
barang_dekat_ed_persetujuan.id
barang_dekat_ed.id
Restrict delete
program_loyalty_id_brand_brand_id_fk
program_loyalty.id_brand
brand.id
Restrict delete
program_loyalty_created_by_pegawai_id_fk
program_loyalty.created_by
pegawai.id
Restrict delete
program_loyalty_updated_by_pegawai_id_fk
program_loyalty.updated_by
pegawai.id
Restrict delete
tipe_hari_libur_created_by_pegawai_id_fk
tipe_hari_libur.created_by
pegawai.id
Restrict delete
tipe_hari_libur_updated_by_pegawai_id_fk
tipe_hari_libur.updated_by
pegawai.id
Restrict delete
golongan_darah_created_by_pegawai_id_fk
golongan_darah.created_by
pegawai.id
Restrict delete
golongan_darah_updated_by_pegawai_id_fk
golongan_darah.updated_by
pegawai.id
Restrict delete
barang_supplier_updated_by_pegawai_id_fk
barang_supplier.updated_by
pegawai.id
Restrict delete
barang_supplier_id_supplier_supplier_id_fk
barang_supplier.id_supplier
supplier.id
Restrict delete
barang_supplier_id_tipe_diskon_tipe_diskon_id_fk
barang_supplier.id_tipe_diskon
tipe_diskon.id
Restrict delete
barang_supplier_id_ketentuan_retur_ketentuan_retur_id_fk
barang_supplier.id_ketentuan_retur
ketentuan_retur.id
Restrict delete
barang_supplier_created_by_pegawai_id_fk
barang_supplier.created_by
pegawai.id
Restrict delete
barang_supplier_id_barang_barang_id_fk
barang_supplier.id_barang
barang.id
Restrict delete
no_faktur_updated_by_pegawai_id_fk
no_faktur.updated_by
pegawai.id
Restrict delete
no_faktur_created_by_pegawai_id_fk
no_faktur.created_by
pegawai.id
Restrict delete
program_pembelian_persetujuan_id_program_pembelian_id_fk
program_pembelian_persetujuan.id
program_pembelian.id
Restrict delete
pabrik_created_by_pegawai_id_fk
pabrik.created_by
pegawai.id
Restrict delete
pabrik_updated_by_pegawai_id_fk
pabrik.updated_by
pegawai.id
Restrict delete
barang_harga_created_by_pegawai_id_fk
barang_harga.created_by
pegawai.id
Restrict delete
barang_harga_updated_by_pegawai_id_fk
barang_harga.updated_by
pegawai.id
Restrict delete
barang_harga_id_barang_barang_id_fk
barang_harga.id_barang
barang.id
Cascade on delete
stok_awal_barang_id_gudang_gudang_id_fk
stok_awal_barang.id_gudang
gudang.id
Restrict delete
stok_awal_barang_id_rak_barang_rak_barang_id_fk
stok_awal_barang.id_rak_barang
rak_barang.id
Restrict delete
stok_awal_barang_id_ketentuan_retur_ketentuan_retur_id_fk
stok_awal_barang.id_ketentuan_retur
ketentuan_retur.id
Restrict delete
stok_awal_barang_id_satuan_satuan_id_fk
stok_awal_barang.id_satuan
satuan.id
Restrict delete
stok_awal_barang_id_supplier_supplier_id_fk
stok_awal_barang.id_supplier
supplier.id
Restrict delete
stok_awal_barang_id_tipe_diskon_tipe_diskon_id_fk
stok_awal_barang.id_tipe_diskon
tipe_diskon.id
Restrict delete
stok_awal_barang_id_barang_barang_id_fk
stok_awal_barang.id_barang
barang.id
Restrict delete
stok_awal_barang_created_by_pegawai_id_fk
stok_awal_barang.created_by
pegawai.id
Restrict delete
stok_awal_barang_updated_by_pegawai_id_fk
stok_awal_barang.updated_by
pegawai.id
Restrict delete
permintaan_penawaran_id_estimasi_order_estimasi_order_id_fk
permintaan_penawaran.id_estimasi_order
estimasi_order.id
Restrict delete
permintaan_penawaran_created_by_pegawai_id_fk
permintaan_penawaran.created_by
pegawai.id
Restrict delete
permintaan_penawaran_updated_by_pegawai_id_fk
permintaan_penawaran.updated_by
pegawai.id
Restrict delete
permintaan_penawaran_id_supplier_supplier_id_fk
permintaan_penawaran.id_supplier
supplier.id
Restrict delete
stok_opname_detail_id_gudang_gudang_id_fk
stok_opname_detail.id_gudang
gudang.id
Restrict delete
stok_opname_detail_id_barang_barang_id_fk
stok_opname_detail.id_barang
barang.id
Restrict delete
pengajuan_retur_penjualan_detail_id_satuan_satuan_id_fk
pengajuan_retur_penjualan_detail.id_satuan
satuan.id
Restrict delete
pengajuan_retur_penjualan_detail_id_pengajuan_retur_penjualan_i
pengajuan_retur_penjualan_detail.id
pengajuan_retur_penjualan.id
Restrict delete
pengajuan_retur_penjualan_detail_id_barang_barang_id_fk
pengajuan_retur_penjualan_detail.id_barang
barang.id
Restrict delete
fk_pengajuan_retur_penjualan_detail_id_ketentuan_retur
pengajuan_retur_penjualan_detail.id_ketentuan_retur
ketentuan_retur.id
Restrict delete
penawaran_tender_persetujuan_id_penawaran_tender_id_fk
penawaran_tender_persetujuan.id
penawaran_tender.id
Restrict delete
titip_faktur_persetujuan_id_titip_faktur_id_fk
titip_faktur_persetujuan.id
titip_faktur.id
Restrict delete
kategori_surat_pesanan_created_by_pegawai_id_fk
kategori_surat_pesanan.created_by
pegawai.id
Restrict delete
kategori_surat_pesanan_updated_by_pegawai_id_fk
kategori_surat_pesanan.updated_by
pegawai.id
Restrict delete
payment_ap_persetujuan_id_payment_ap_id_fk
payment_ap_persetujuan.id
payment_ap.id
Restrict delete
pajak_akun_penjualan_account_id_fk
pajak.akun_penjualan
account.id
Restrict delete
pajak_akun_pembelian_account_id_fk
pajak.akun_pembelian
account.id
Restrict delete
pengajuan_pembayaran_ekspedisi_persetujuan_id_pengajuan_pembaya
pengajuan_pembayaran_ekspedisi_persetujuan.id
pengajuan_pembayaran_ekspedisi.id
Restrict delete
payment_ar_persetujuan_id_payment_ar_id_fk
payment_ar_persetujuan.id
payment_ar.id
Restrict delete
uang_muka_pembelian_id_surat_pesanan_surat_pesanan_id_fk
uang_muka_pembelian.id_surat_pesanan
surat_pesanan.id
Restrict delete
uang_muka_pembelian_id_akun_account_id_fk
uang_muka_pembelian.id_akun
account.id
Restrict delete
uang_muka_pembelian_created_by_pegawai_id_fk
uang_muka_pembelian.created_by
pegawai.id
Restrict delete
uang_muka_pembelian_updated_by_pegawai_id_fk
uang_muka_pembelian.updated_by
pegawai.id
Restrict delete
barang_satuan_id_barang_barang_id_fk
barang_satuan.id_barang
barang.id
Cascade on delete
barang_satuan_id_satuan_satuan_id_fk
barang_satuan.id_satuan
satuan.id
Cascade on delete
program_loyalty_detail_id_jenis_barang_jenis_barang_id_fk
program_loyalty_detail.id_jenis_barang
jenis_barang.id
Restrict delete
program_loyalty_detail_id_program_loyalty_id_fk
program_loyalty_detail.id
program_loyalty.id
Restrict delete
program_penjualan_created_by_pegawai_id_fk
program_penjualan.created_by
pegawai.id
Restrict delete
program_penjualan_updated_by_pegawai_id_fk
program_penjualan.updated_by
pegawai.id
Restrict delete
retur_konsinyasi_detail_id_alasan_retur_alasan_retur_id_fk
retur_konsinyasi_detail.id_alasan_retur
alasan_retur.id
Restrict delete
realisasi_stt_detail_id_expense_type_expense_type_id_fk
realisasi_stt_detail.id_expense_type
expense_type.id
Restrict delete
area_delivery_id_area_area_id_fk
area_delivery.id_area
area.id
Restrict delete
pemindahan_barang_id_gudang_tujuan_gudang_id_fk
pemindahan_barang.id_gudang_tujuan
gudang.id
Restrict delete
pemindahan_barang_id_gudang_asal_gudang_id_fk
pemindahan_barang.id_gudang_asal
gudang.id
Restrict delete
pemindahan_barang_created_by_pegawai_id_fk
pemindahan_barang.created_by
pegawai.id
Restrict delete
pemindahan_barang_updated_by_pegawai_id_fk
pemindahan_barang.updated_by
pegawai.id
Restrict delete
permintaan_penawaran_program_id_permintaan_penawaran_id_fk
permintaan_penawaran_program.id
permintaan_penawaran.id
Restrict delete
permintaan_penawaran_program_id_program_program_pembelian_id_fk
permintaan_penawaran_program.id_program
program_pembelian.id
Restrict delete
surat_pesanan_detail_id_barang_barang_id_fk
surat_pesanan_detail.id_barang
barang.id
Restrict delete
surat_pesanan_detail_id_surat_pesanan_id_fk
surat_pesanan_detail.id
surat_pesanan.id
Restrict delete
surat_pesanan_detail_id_tipe_diskon_tipe_diskon_id_fk
surat_pesanan_detail.id_tipe_diskon
tipe_diskon.id
Restrict delete
surat_pesanan_detail_id_satuan_satuan_id_fk
surat_pesanan_detail.id_satuan
satuan.id
Restrict delete
kontrak_loyalty_persetujuan_id_kontrak_loyalty_id_fk
kontrak_loyalty_persetujuan.id
kontrak_loyalty.id
Restrict delete
surat_pesanan_id_tipe_transaksi_tipe_transaksi_id_fk
surat_pesanan.id_tipe_transaksi
tipe_transaksi.id
Restrict delete
surat_pesanan_id_ekspedisi_ekspedisi_id_fk
surat_pesanan.id_ekspedisi
ekspedisi.id
Restrict delete
surat_pesanan_id_yang_menyerahkan_pegawai_id_fk
surat_pesanan.id_yang_menyerahkan
pegawai.id
Restrict delete
surat_pesanan_id_permintaan_penawaran_permintaan_penawaran_id_f
surat_pesanan.id_permintaan_penawaran
permintaan_penawaran.id
Restrict delete
surat_pesanan_created_by_pegawai_id_fk
surat_pesanan.created_by
pegawai.id
Restrict delete
surat_pesanan_updated_by_pegawai_id_fk
surat_pesanan.updated_by
pegawai.id
Restrict delete
surat_pesanan_id_area_area_id_fk
surat_pesanan.id_area
area.id
Restrict delete
surat_pesanan_id_supplier_supplier_id_fk
surat_pesanan.id_supplier
supplier.id
Restrict delete
target_penjualan_created_by_pegawai_id_fk
target_penjualan.created_by
pegawai.id
Restrict delete
target_penjualan_id_target_penjualan_target_penjualan_id_fk
target_penjualan.id_target_penjualan
target_penjualan.id
Restrict delete
target_penjualan_id_pengganti_fkey
target_penjualan.id_pengganti
pegawai.id
Restrict delete
target_penjualan_id_atasan_pegawai_id_fk
target_penjualan.id_atasan
pegawai.id
Restrict delete
target_penjualan_updated_by_pegawai_id_fk
target_penjualan.updated_by
pegawai.id
Restrict delete
alasan_retur_created_by_pegawai_id_fk
alasan_retur.created_by
pegawai.id
Restrict delete
alasan_retur_updated_by_pegawai_id_fk
alasan_retur.updated_by
pegawai.id
Restrict delete
estimasi_order_id_kategori_barang_kategori_id_fk
estimasi_order.id_kategori
barang_kategori.id
Restrict delete
estimasi_order_id_divisi_divisi_id_fk
estimasi_order.id_divisi
divisi.id
Restrict delete
estimasi_order_id_brand_brand_id_fk
estimasi_order.id_brand
brand.id
Restrict delete
estimasi_order_created_by_pegawai_id_fk
estimasi_order.created_by
pegawai.id
Restrict delete
estimasi_order_updated_by_pegawai_id_fk
estimasi_order.updated_by
pegawai.id
Restrict delete
retur_pembelian_hpp_id_stok_fkey
retur_pembelian_hpp.id_stok
stok_barang.id
Restrict delete
retur_pembelian_hpp_id_fkey
retur_pembelian_hpp.id
retur_pembelian.id
Restrict delete
sales_order_detail_id_sales_order_id_fk
sales_order_detail.id
sales_order.id
Restrict delete
sales_order_detail_id_barang_barang_id_fk
sales_order_detail.id_barang
barang.id
Restrict delete
sales_order_detail_id_satuan_bonus_satuan_id_fk
sales_order_detail.id_satuan_bonus
satuan.id
Restrict delete
sales_order_detail_id_program_urut_program_program_penjualan_de
sales_order_detail.id_program
sales_order_detail.urut_program
program_penjualan_detail.id
program_penjualan_detail.urut
Restrict delete
sales_order_detail_id_satuan_satuan_id_fk
sales_order_detail.id_satuan
satuan.id
Restrict delete
setting_persetujuan_updated_by_pegawai_id_fk
setting_persetujuan.updated_by
pegawai.id
Restrict delete
setting_persetujuan_created_by_pegawai_id_fk
setting_persetujuan.created_by
pegawai.id
Restrict delete
setting_persetujuan_id_pegawai_3_pegawai_id_fk
setting_persetujuan.id_pegawai_3
pegawai.id
Restrict delete
setting_persetujuan_id_pegawai_1_pegawai_id_fk
setting_persetujuan.id_pegawai_1
pegawai.id
Restrict delete
setting_persetujuan_id_pegawai_2_pegawai_id_fk
setting_persetujuan.id_pegawai_2
pegawai.id
Restrict delete
tipe_pembayaran_created_by_pegawai_id_fk
tipe_pembayaran.created_by
pegawai.id
Restrict delete
tipe_pembayaran_updated_by_pegawai_id_fk
tipe_pembayaran.updated_by
pegawai.id
Restrict delete
printer_paper_id_printer_name_printer_device_id_name_fk
printer_paper.id
printer_paper.printer_name
printer_device.id
printer_device.name
Restrict delete
printer_paper_id_pegawai_id_fk
printer_paper.id
pegawai.id
Restrict delete
surat_tanda_terima_persetujuan_id_surat_tanda_terima_id_fk
surat_tanda_terima_persetujuan.id
surat_tanda_terima.id
Restrict delete
gudang_account_persediaan_account_id_fk
gudang.account_persediaan
account.id
Restrict delete
invoice_retur_detail_id_barang_barang_id_fk
invoice_retur_detail.id_barang
barang.id
Restrict delete
invoice_retur_detail_id_invoice_retur_id_fk
invoice_retur_detail.id
invoice_retur.id
Restrict delete
invoice_retur_detail_id_satuan_satuan_id_fk
invoice_retur_detail.id_satuan
satuan.id
Restrict delete
invoice_retur_detail_id_stok_baru_stok_barang_id_fk
invoice_retur_detail.id_stok_baru
stok_barang.id
Restrict delete
invoice_retur_detail_id_stok_stok_barang_id_fk
invoice_retur_detail.id_stok
stok_barang.id
Restrict delete
biaya_transfer_updated_by_pegawai_id_fk
biaya_transfer.updated_by
pegawai.id
Restrict delete
biaya_transfer_id_account_tipe_pembayaran_id_fk
biaya_transfer.id_account
tipe_pembayaran.id
Restrict delete
biaya_transfer_id_account_bank_account_id_fk
biaya_transfer.id_account_bank
account.id
Restrict delete
biaya_transfer_created_by_pegawai_id_fk
biaya_transfer.created_by
pegawai.id
Restrict delete
customer_id_divisi_sales_divisi_sales_id_fk
customer.id_divisi_sales
divisi_sales.id
Restrict delete
customer_updated_by_pegawai_id_fk
customer.updated_by
pegawai.id
Restrict delete
customer_id_area_penagihan_area_id_fk
customer.id_area_penagihan
area.id
Restrict delete
customer_id_kolektor_pegawai_id_fk
customer.id_kolektor
pegawai.id
Restrict delete
customer_id_area_delivery_area_id_fk
customer.id_area_delivery
area.id
Restrict delete
customer_id_customer_jenis_customer_jenis_id_fk
customer.id_customer_jenis
customer_jenis.id
Restrict delete
customer_created_by_pegawai_id_fk
customer.created_by
pegawai.id
Restrict delete
customer_id_area_area_id_fk
customer.id_area
area.id
Restrict delete
customer_id_salesman_pegawai_id_fk
customer.id_salesman
pegawai.id
Restrict delete
customer_id_customer_kategori_customer_kategori_id_fk
customer.id_customer_kategori
customer_kategori.id
Restrict delete
customer_id_status_pajak_status_pajak_id_fk
customer.id_status_pajak
status_pajak.id
Restrict delete
ongkos_updated_by_pegawai_id_fk
ongkos.updated_by
pegawai.id
Restrict delete
ongkos_created_by_pegawai_id_fk
ongkos.created_by
pegawai.id
Restrict delete
checking_detail_id_keterangan_alasan_penolakan_id_fk
checking_detail.id_keterangan
alasan_penolakan.id
Restrict delete
checking_detail_id_satuan_satuan_id_fk
checking_detail.id_satuan
satuan.id
Restrict delete
checking_detail_id_checking_id_fk
checking_detail.id
checking.id
Restrict delete
checking_detail_id_barang_barang_id_fk
checking_detail.id_barang
barang.id
Restrict delete
checking_detail_id_stok_stok_barang_id_fk
checking_detail.id_stok
stok_barang.id
Restrict delete
ar_value_id_customer_customer_id_fk
ar_value.id_customer
customer.id
Restrict delete
ar_value_created_by_pegawai_id_fk
ar_value.created_by
pegawai.id
Restrict delete
ar_value_updated_by_pegawai_id_fk
ar_value.updated_by
pegawai.id
Restrict delete
rak_barang_id_penanggung_jawab_pegawai_id_fk
rak_barang.id_penanggung_jawab
pegawai.id
Restrict delete
rak_barang_id_gudang_gudang_id_fk
rak_barang.id_gudang
gudang.id
Restrict delete
invoice_retur_persetujuan_id_invoice_retur_id_fk
invoice_retur_persetujuan.id
invoice_retur.id
Restrict delete
supplier_kontak_created_by_pegawai_id_fk
supplier_kontak.created_by
pegawai.id
Restrict delete
supplier_kontak_updated_by_pegawai_id_fk
supplier_kontak.updated_by
pegawai.id
Restrict delete
supplier_kontak_id_supplier_id_fk
supplier_kontak.id
supplier.id
Restrict delete
tanda_terima_invoice_id_customer_customer_id_fk
tanda_terima_invoice.id_customer
customer.id
Restrict delete
tanda_terima_invoice_updated_by_pegawai_id_fk
tanda_terima_invoice.updated_by
pegawai.id
Restrict delete
tanda_terima_invoice_created_by_pegawai_id_fk
tanda_terima_invoice.created_by
pegawai.id
Restrict delete
reg_villages_district_id_reg_districts_id_fk
reg_villages.district_id
reg_districts.id
Restrict delete
klaim_diskon_3_persetujuan_id_klaim_diskon_3_id_fk
klaim_diskon_3_persetujuan.id
klaim_diskon_3.id
Restrict delete
bukti_barang_masuk_program_id_program_program_pembelian_id_fk
bukti_barang_masuk_program.id_program
program_pembelian.id
Restrict delete
bukti_barang_masuk_program_id_bukti_barang_masuk_id_fk
bukti_barang_masuk_program.id
bukti_barang_masuk.id
Restrict delete
jabatan_updated_by_pegawai_id_fk
jabatan.updated_by
pegawai.id
Restrict delete
jabatan_created_by_pegawai_id_fk
jabatan.created_by
pegawai.id
Restrict delete
jabatan_atasan_jabatan_id_fk
jabatan.atasan
jabatan.id
Null on delete
penerimaan_pemindahan_barang_detail_penerimaan_pemindahan_baran
penerimaan_pemindahan_barang_detail.id_pemindahan_barang_detail
penerimaan_pemindahan_barang_detail.urut_pemindahan_barang_detail
pemindahan_barang_detail.id
pemindahan_barang_detail.urut
Restrict delete
penawaran_tender_detail_id_barang_barang_id_fk
penawaran_tender_detail.id_barang
barang.id
Restrict delete
penawaran_tender_detail_id_supplier_supplier_id_fk
penawaran_tender_detail.id_supplier
supplier.id
Restrict delete
nota_retur_pajak_created_by_pegawai_id_fk
nota_retur_pajak.created_by
pegawai.id
Restrict delete
nota_retur_pajak_updated_by_pegawai_id_fk
nota_retur_pajak.updated_by
pegawai.id
Restrict delete
nota_retur_pajak_id_retur_pembelian_retur_pembelian_id_fk
nota_retur_pajak.id_retur_pembelian
retur_pembelian.id
Restrict delete
nota_retur_pajak_id_bukti_barang_masuk_bukti_barang_masuk_id_fk
nota_retur_pajak.id_bukti_barang_masuk
bukti_barang_masuk.id
Restrict delete
nota_retur_pajak_id_supplier_supplier_id_fk
nota_retur_pajak.id_supplier
supplier.id
Restrict delete
pengajuan_perubahan_limit_persetujuan_id_pengajuan_perubahan_li
pengajuan_perubahan_limit_persetujuan.id
pengajuan_perubahan_limit.id
Restrict delete
pengajuan_perubahan_limit_updated_by_pegawai_id_fk
pengajuan_perubahan_limit.updated_by
pegawai.id
Restrict delete
pengajuan_perubahan_limit_id_customer_customer_id_fk
pengajuan_perubahan_limit.id_customer
customer.id
Restrict delete
pengajuan_perubahan_limit_id_salesman_pegawai_id_fk
pengajuan_perubahan_limit.id_salesman
pegawai.id
Restrict delete
pengajuan_perubahan_limit_created_by_pegawai_id_fk
pengajuan_perubahan_limit.created_by
pegawai.id
Restrict delete
pengajuan_perubahan_limit_id_spv_pegawai_id_fk
pengajuan_perubahan_limit.id_spv
pegawai.id
Restrict delete
uang_muka_pembelian_persetujuan_id_uang_muka_pembelian_id_fk
uang_muka_pembelian_persetujuan.id
uang_muka_pembelian.id
Restrict delete
program_loyalty_persetujuan_id_program_loyalty_id_fk
program_loyalty_persetujuan.id
program_loyalty.id
Restrict delete
cetakan_token_id_cetakan_id_fk
cetakan_token.id
cetakan.id
Restrict delete
cetakan_token_updated_by_pegawai_id_fk
cetakan_token.updated_by
pegawai.id
Restrict delete
cetakan_token_created_by_pegawai_id_fk
cetakan_token.created_by
pegawai.id
Restrict delete
bukti_barang_masuk_detail_id_tipe_diskon_tipe_diskon_id_fk
bukti_barang_masuk_detail.id_tipe_diskon
tipe_diskon.id
Restrict delete
bukti_barang_masuk_detail_id_stok_stok_barang_id_fk
bukti_barang_masuk_detail.id_stok
stok_barang.id
Restrict delete
bukti_barang_masuk_detail_id_satuan_satuan_id_fk
bukti_barang_masuk_detail.id_satuan
satuan.id
Restrict delete
bukti_barang_masuk_detail_id_bukti_barang_masuk_id_fk
bukti_barang_masuk_detail.id
bukti_barang_masuk.id
Restrict delete
bukti_barang_masuk_detail_id_barang_barang_id_fk
bukti_barang_masuk_detail.id_barang
barang.id
Restrict delete
verifikasi_tagihan_updated_by_pegawai_id_fk
verifikasi_tagihan.updated_by
pegawai.id
Restrict delete
verifikasi_tagihan_id_proposal_ar_proposal_ar_id_fk
verifikasi_tagihan.id_proposal_ar
proposal_ar.id
Restrict delete
verifikasi_tagihan_created_by_pegawai_id_fk
verifikasi_tagihan.created_by
pegawai.id
Restrict delete
pegawai_account_id_pegawai_id_fk
pegawai_account.id
pegawai.id
Cascade on delete
pegawai_account_id_account_account_id_fk
pegawai_account.id_account
account.id
Cascade on delete
program_penjualan_detail_id_brand_brand_id_fk
program_penjualan_detail.id_brand
brand.id
Restrict delete
penerimaan_pemindahan_barang_created_by_pegawai_id_fk
penerimaan_pemindahan_barang.created_by
pegawai.id
Restrict delete
penerimaan_pemindahan_barang_updated_by_pegawai_id_fk
penerimaan_pemindahan_barang.updated_by
pegawai.id
Restrict delete
penerimaan_pemindahan_barang_id_pemindahan_barang_pemindahan_ba
penerimaan_pemindahan_barang.id_pemindahan_barang
pemindahan_barang.id
Restrict delete
stok_opname_created_by_pegawai_id_fk
stok_opname.created_by
pegawai.id
Restrict delete
stok_opname_id_rak_barang_rak_barang_id_fk
stok_opname.id_rak_barang
rak_barang.id
Restrict delete
stok_opname_updated_by_pegawai_id_fk
stok_opname.updated_by
pegawai.id
Restrict delete
stok_opname_id_barang_barang_id_fk
stok_opname.id_barang
barang.id
Restrict delete
stok_opname_id_petugas_pegawai_id_fk
stok_opname.id_petugas
pegawai.id
Restrict delete
stok_opname_id_gudang_fkey
stok_opname.id_gudang
gudang.id
Restrict delete
surat_penolakan_penjualan_detail_id_keterangan_alasan_penolakan
surat_penolakan_penjualan_detail.id_keterangan
alasan_penolakan.id
Restrict delete
surat_penolakan_penjualan_detail_id_surat_penolakan_penjualan_i
surat_penolakan_penjualan_detail.id
surat_penolakan_penjualan.id
Restrict delete
surat_penolakan_penjualan_detail_id_barang_barang_id_fk
surat_penolakan_penjualan_detail.id_barang
barang.id
Restrict delete
surat_penolakan_penjualan_detail_id_sales_order_hpp_urut_sales_
surat_penolakan_penjualan_detail.id_sales_order_hpp
surat_penolakan_penjualan_detail.urut_sales_order_hpp
sales_order_hpp.id
sales_order_hpp.urut
Restrict delete
sales_order_hpp_id_stok_stok_barang_id_fk
sales_order_hpp.id_stok
stok_barang.id
Restrict delete
sales_order_hpp_id_barang_barang_id_fk
sales_order_hpp.id_barang
barang.id
Restrict delete
sales_order_hpp_sales_order_detail
sales_order_hpp.id
sales_order_hpp.id_barang
sales_order_detail.id
sales_order_detail.id_barang
Cascade on delete
sales_order_hpp_id_alasan_penolakan_alasan_penolakan_id_fk
sales_order_hpp.id_alasan_penolakan
alasan_penolakan.id
Restrict delete
stok_opname_invoice_detail_id_tanda_terima_invoice_tanda_terima
stok_opname_invoice_detail.id_tanda_terima_invoice
tanda_terima_invoice.id
Restrict delete
stok_opname_invoice_detail_id_stok_opname_invoice_id_fk
stok_opname_invoice_detail.id
stok_opname_invoice.id
Restrict delete
stok_opname_invoice_detail_scanned_by_pegawai_id_fk
stok_opname_invoice_detail.scanned_by
pegawai.id
Restrict delete
klaim_program_pembelian_persetujuan_id_klaim_program_pembelian_
klaim_program_pembelian_persetujuan.id
klaim_program_pembelian.id
Restrict delete
role_permission_id_permission_permission_id_fk
role_permission.id_permission
permission.id
Restrict delete
role_permission_id_role_role_id_fk
role_permission.id_role
role.id
Restrict delete
verifikasi_tagihan_detail_id_verifikasi_tagihan_id_fk
verifikasi_tagihan_detail.id
verifikasi_tagihan.id
Restrict delete
verifikasi_tagihan_detail_id_terima_uang_pegawai_id_fk
verifikasi_tagihan_detail.id_terima_uang
pegawai.id
Restrict delete
verifikasi_tagihan_detail_id_terima_kembali_pegawai_id_fk
verifikasi_tagihan_detail.id_terima_kembali
pegawai.id
Restrict delete
insentif_noo_created_by_pegawai_id_fk
insentif_noo.created_by
pegawai.id
Restrict delete
insentif_noo_updated_by_pegawai_id_fk
insentif_noo.updated_by
pegawai.id
Restrict delete
stok_opname_persetujuan_id_stok_opname_id_fk
stok_opname_persetujuan.id
stok_opname.id
Restrict delete
realisasi_stt_updated_by_pegawai_id_fk
realisasi_stt.updated_by
pegawai.id
Restrict delete
realisasi_stt_created_by_pegawai_id_fk
realisasi_stt.created_by
pegawai.id
Restrict delete
realisasi_stt_id_stt_surat_tanda_terima_id_fk
realisasi_stt.id_stt
surat_tanda_terima.id
Restrict delete
status_kerja_updated_by_pegawai_id_fk
status_kerja.updated_by
pegawai.id
Restrict delete
status_kerja_created_by_pegawai_id_fk
status_kerja.created_by
pegawai.id
Restrict delete
penolakan_penawaran_tender_detail_id_penolakan_penawaran_tender
penolakan_penawaran_tender_detail.id
penolakan_penawaran_tender.id
Restrict delete
penolakan_penawaran_tender_detail_id_barang_barang_id_fk
penolakan_penawaran_tender_detail.id_barang
barang.id
Restrict delete
pegawai_deleted_by_pegawai_id_fk
pegawai.deleted_by
pegawai.id
Restrict delete
pegawai_updated_by_pegawai_id_fk
pegawai.updated_by
pegawai.id
Restrict delete
pegawai_created_by_pegawai_id_fk
pegawai.created_by
pegawai.id
Restrict delete
surat_penolakan_pembelian_detail_id_barang_barang_id_fk
surat_penolakan_pembelian_detail.id_barang
barang.id
Restrict delete
surat_penolakan_pembelian_detail_id_keterangan_alasan_penolakan
surat_penolakan_pembelian_detail.id_keterangan
alasan_penolakan.id
Restrict delete
surat_penolakan_pembelian_detail_id_satuan_satuan_id_fk
surat_penolakan_pembelian_detail.id_satuan
satuan.id
Restrict delete
surat_penolakan_pembelian_detail_id_surat_penolakan_pembelian_i
surat_penolakan_pembelian_detail.id
surat_penolakan_pembelian.id
Restrict delete
retur_pembelian_id_bukti_barang_masuk_bukti_barang_masuk_id_fk
retur_pembelian.id_bukti_barang_masuk
bukti_barang_masuk.id
Restrict delete
retur_pembelian_id_ppn_fkey
retur_pembelian.id_ppn
pajak.id
Restrict delete
retur_pembelian_id_penerima_pegawai_id_fk
retur_pembelian.id_penerima
pegawai.id
Restrict delete
retur_pembelian_id_alasan_retur_alasan_retur_id_fk
retur_pembelian.id_alasan_retur
alasan_retur.id
Restrict delete
retur_pembelian_id_supplier_supplier_id_fk
retur_pembelian.id_supplier
supplier.id
Restrict delete
retur_pembelian_created_by_pegawai_id_fk
retur_pembelian.created_by
pegawai.id
Restrict delete
retur_pembelian_updated_by_pegawai_id_fk
retur_pembelian.updated_by
pegawai.id
Restrict delete
titip_faktur_id_rev_titip_faktur_id_fk
titip_faktur.id_rev
titip_faktur.id
Restrict delete
titip_faktur_created_by_pegawai_id_fk
titip_faktur.created_by
pegawai.id
Restrict delete
titip_faktur_updated_by_pegawai_id_fk
titip_faktur.updated_by
pegawai.id
Restrict delete
customer_foto_id_customer_id_fk
customer_foto.id
customer.id
Restrict delete
supplier_bank_id_supplier_id_fk
supplier_bank.id
supplier.id
Restrict delete
notification_updated_by_pegawai_id_fk
notification.updated_by
pegawai.id
Restrict delete
notification_created_by_pegawai_id_fk
notification.created_by
pegawai.id
Restrict delete
notification_id_pegawai_pegawai_id_fk
notification.id_pegawai
pegawai.id
Restrict delete
acc_value_id_account_account_id_fk
acc_value.id_account
account.id
Restrict delete
penerimaan_barang_detail_id_tipe_diskon_tipe_diskon_id_fk
penerimaan_barang_detail.id_tipe_diskon
tipe_diskon.id
Restrict delete
penerimaan_barang_detail_id_penerimaan_barang_id_fk
penerimaan_barang_detail.id
penerimaan_barang.id
Restrict delete
penerimaan_barang_detail_id_satuan_dipesan_satuan_id_fk
penerimaan_barang_detail.id_satuan_dipesan
satuan.id
Restrict delete
penerimaan_barang_detail_id_barang_barang_id_fk
penerimaan_barang_detail.id_barang
barang.id
Restrict delete
penerimaan_barang_detail_id_satuan_satuan_id_fk
penerimaan_barang_detail.id_satuan
satuan.id
Restrict delete
stok_barang_created_by_pegawai_id_fk
stok_barang.created_by
pegawai.id
Restrict delete
stok_barang_updated_by_pegawai_id_fk
stok_barang.updated_by
pegawai.id
Restrict delete
stok_barang_id_gudang_gudang_id_fk
stok_barang.id_gudang
gudang.id
Restrict delete
stok_barang_id_barang_barang_id_fk
stok_barang.id_barang
barang.id
Restrict delete
stok_barang_id_rak_barang_rak_barang_id_fk
stok_barang.id_rak_barang
rak_barang.id
Restrict delete
stok_barang_id_supplier_supplier_id_fk
stok_barang.id_supplier
supplier.id
Restrict delete
rencana_kunjungan_salesman_persetujuan_id_rencana_kunjungan_sal
rencana_kunjungan_salesman_persetujuan.id
rencana_kunjungan_salesman.id
Restrict delete
menu_id_permission_permission_id_fk
menu.id_permission
permission.id
Restrict delete
menu_parent_menu_id_fk
menu.parent
menu.id
Restrict delete
penerimaan_barang_created_by_pegawai_id_fk
penerimaan_barang.created_by
pegawai.id
Restrict delete
penerimaan_barang_id_area_area_id_fk
penerimaan_barang.id_area
area.id
Restrict delete
penerimaan_barang_id_penerima_berkas_approve_pegawai_id_fk
penerimaan_barang.id_penerima_berkas_approve
pegawai.id
Restrict delete
penerimaan_barang_id_surat_pesanan_surat_pesanan_id_fk
penerimaan_barang.id_surat_pesanan
surat_pesanan.id
Restrict delete
penerimaan_barang_id_penerima_berkas_waiting_pegawai_id_fk
penerimaan_barang.id_penerima_berkas_waiting
pegawai.id
Restrict delete
penerimaan_barang_updated_by_pegawai_id_fk
penerimaan_barang.updated_by
pegawai.id
Restrict delete
penerimaan_barang_id_supplier_supplier_id_fk
penerimaan_barang.id_supplier
supplier.id
Restrict delete
penerimaan_barang_id_ekspedisi_ekspedisi_id_fk
penerimaan_barang.id_ekspedisi
ekspedisi.id
Restrict delete
penerimaan_barang_id_penerima_berkas_pegawai_id_fk
penerimaan_barang.id_penerima_berkas
pegawai.id
Restrict delete
mv_refresh_control_created_by_fkey
mv_refresh_control.created_by
pegawai.id
Restrict delete
mv_refresh_control_updated_by_fkey
mv_refresh_control.updated_by
pegawai.id
Restrict delete
golongan_barang_created_by_pegawai_id_fk
golongan_barang.created_by
pegawai.id
Restrict delete
golongan_barang_updated_by_pegawai_id_fk
golongan_barang.updated_by
pegawai.id
Restrict delete
surat_jalan_detail_id_satuan_satuan_id_fk
surat_jalan_detail.id_satuan
satuan.id
Restrict delete
surat_jalan_detail_id_surat_jalan_id_fk
surat_jalan_detail.id
surat_jalan.id
Restrict delete
surat_jalan_detail_id_barang_barang_id_fk
surat_jalan_detail.id_barang
barang.id
Restrict delete
acc_ar_faktur_id_serah_terima_1_pegawai_id_fk
acc_ar_faktur.id_serah_terima_1
pegawai.id
Restrict delete
acc_ar_faktur_id_tipe_transaksi_tipe_transaksi_id_fk
acc_ar_faktur.id_tipe_transaksi
tipe_transaksi.id
Restrict delete
acc_ar_faktur_updated_by_pegawai_id_fk
acc_ar_faktur.updated_by
pegawai.id
Restrict delete
acc_ar_faktur_created_by_pegawai_id_fk
acc_ar_faktur.created_by
pegawai.id
Restrict delete
acc_ar_faktur_id_serah_terima_2_pegawai_id_fk
acc_ar_faktur.id_serah_terima_2
pegawai.id
Restrict delete
acc_ar_faktur_id_customer_customer_id_fk
acc_ar_faktur.id_customer
customer.id
Restrict delete
supplier_legalitas_id_supplier_id_fk
supplier_legalitas.id
supplier.id
Restrict delete
realisasi_stt_persetujuan_id_realisasi_stt_id_fk
realisasi_stt_persetujuan.id
realisasi_stt.id
Restrict delete
acc_gl_trans_updated_by_pegawai_id_fk
acc_gl_trans.updated_by
pegawai.id
Restrict delete
acc_gl_trans_created_by_pegawai_id_fk
acc_gl_trans.created_by
pegawai.id
Restrict delete
hari_libur_id_tipe_hari_libur_tipe_hari_libur_id_fk
hari_libur.id_tipe_hari_libur
tipe_hari_libur.id
Restrict delete
hari_libur_updated_by_pegawai_id_fk
hari_libur.updated_by
pegawai.id
Restrict delete
hari_libur_created_by_pegawai_id_fk
hari_libur.created_by
pegawai.id
Restrict delete
acc_gl_detail_gl_number_acc_gl_trans_gl_number_fk
acc_gl_detail.gl_number
acc_gl_trans.gl_number
Restrict delete
sales_order_persetujuan_id_sales_order_id_fk
sales_order_persetujuan.id
sales_order.id
Restrict delete
media_updated_by_pegawai_id_fk
media.updated_by
pegawai.id
Restrict delete
media_created_by_pegawai_id_fk
media.created_by
pegawai.id
Restrict delete
checking_created_by_pegawai_id_fk
checking.created_by
pegawai.id
Restrict delete
checking_updated_by_pegawai_id_fk
checking.updated_by
pegawai.id
Restrict delete
checking_id_surat_jalan_surat_jalan_id_fk
checking.id_surat_jalan
surat_jalan.id
Restrict delete
insentif_salesman_created_by_pegawai_id_fk
insentif_salesman.created_by
pegawai.id
Restrict delete
insentif_salesman_id_verif_pegawai_id_fk
insentif_salesman.id_verif
pegawai.id
Restrict delete
insentif_salesman_id_atasan_pegawai_id_fk
insentif_salesman.id_atasan
pegawai.id
Restrict delete
insentif_salesman_updated_by_pegawai_id_fk
insentif_salesman.updated_by
pegawai.id
Restrict delete
insentif_salesman_id_target_penjualan_fkey
insentif_salesman.id_target_penjualan
target_penjualan.id
Restrict delete
alasan_penolakan_created_by_pegawai_id_fk
alasan_penolakan.created_by
pegawai.id
Restrict delete
alasan_penolakan_updated_by_pegawai_id_fk
alasan_penolakan.updated_by
pegawai.id
Restrict delete
customer_legalitas_id_customer_id_fk
customer_legalitas.id
customer.id
Restrict delete
invoice_detail_id_barang_barang_id_fk
invoice_detail.id_barang
barang.id
Restrict delete
invoice_detail_id_invoice_id_fk
invoice_detail.id
invoice.id
Restrict delete
invoice_detail_id_satuan_satuan_id_fk
invoice_detail.id_satuan
satuan.id
Restrict delete
tipe_bpjs_kesehatan_updated_by_pegawai_id_fk
tipe_bpjs_kesehatan.updated_by
pegawai.id
Restrict delete
tipe_bpjs_kesehatan_created_by_pegawai_id_fk
tipe_bpjs_kesehatan.created_by
pegawai.id
Restrict delete
unit_id_driver_pegawai_id_fk
unit.id_driver
pegawai.id
Restrict delete
unit_lokasi_reg_regencies_id_fk
unit.lokasi
reg_regencies.id
Restrict delete
unit_created_by_pegawai_id_fk
unit.created_by
pegawai.id
Restrict delete
unit_updated_by_pegawai_id_fk
unit.updated_by
pegawai.id
Restrict delete
cetakan_logs_updated_by_pegawai_id_fk
cetakan_logs.updated_by
pegawai.id
Restrict delete
cetakan_logs_print_token_cetakan_token_token_fk
cetakan_logs.print_token
cetakan_token.token
Restrict delete
cetakan_logs_id_cetakan_id_fk
cetakan_logs.id
cetakan.id
Restrict delete
cetakan_logs_created_by_pegawai_id_fk
cetakan_logs.created_by
pegawai.id
Restrict delete
expense_type_id_account_account_id_fk
expense_type.id_account
account.id
Restrict delete
expense_type_created_by_pegawai_id_fk
expense_type.created_by
pegawai.id
Restrict delete
expense_type_updated_by_pegawai_id_fk
expense_type.updated_by
pegawai.id
Restrict delete
invoice_surat_jalan_id_surat_jalan_surat_jalan_id_fk
invoice_surat_jalan.id_surat_jalan
surat_jalan.id
Restrict delete
invoice_surat_jalan_id_invoice_invoice_id_fk
invoice_surat_jalan.id_invoice
invoice.id
Restrict delete
stok_value_id_barang_barang_id_fk
stok_value.id_barang
barang.id
Restrict delete
stok_value_id_gudang_gudang_id_fk
stok_value.id_gudang
gudang.id
Restrict delete
klaim_diskon_3_created_by_pegawai_id_fk
klaim_diskon_3.created_by
pegawai.id
Restrict delete
klaim_diskon_3_id_bukti_barang_masuk_bukti_barang_masuk_id_fk
klaim_diskon_3.id_bukti_barang_masuk
bukti_barang_masuk.id
Restrict delete
klaim_diskon_3_updated_by_pegawai_id_fk
klaim_diskon_3.updated_by
pegawai.id
Restrict delete
klaim_diskon_3_id_supplier_supplier_id_fk
klaim_diskon_3.id_supplier
supplier.id
Restrict delete
customer_kontak_id_customer_id_fk
customer_kontak.id
customer.id
Restrict delete
customer_kontak_created_by_pegawai_id_fk
customer_kontak.created_by
pegawai.id
Restrict delete
customer_kontak_updated_by_pegawai_id_fk
customer_kontak.updated_by
pegawai.id
Restrict delete
surat_penolakan_pembelian_updated_by_pegawai_id_fk
surat_penolakan_pembelian.updated_by
pegawai.id
Restrict delete
surat_penolakan_pembelian_created_by_pegawai_id_fk
surat_penolakan_pembelian.created_by
pegawai.id
Restrict delete
surat_penolakan_pembelian_id_surat_pesanan_surat_pesanan_id_fk
surat_penolakan_pembelian.id_surat_pesanan
surat_pesanan.id
Restrict delete
pengajuan_retur_penjualan_updated_by_pegawai_id_fk
pengajuan_retur_penjualan.updated_by
pegawai.id
Restrict delete
pengajuan_retur_penjualan_id_invoice_invoice_id_fk
pengajuan_retur_penjualan.id_invoice
invoice.id
Restrict delete
pengajuan_retur_penjualan_id_customer_customer_id_fk
pengajuan_retur_penjualan.id_customer
customer.id
Restrict delete
pengajuan_retur_penjualan_verify_by_pegawai_id_fk
pengajuan_retur_penjualan.verify_by
pegawai.id
Restrict delete
pengajuan_retur_penjualan_batal_by_fkey
pengajuan_retur_penjualan.batal_by
pegawai.id
Restrict delete
pengajuan_retur_penjualan_created_by_pegawai_id_fk
pengajuan_retur_penjualan.created_by
pegawai.id
Restrict delete
ketentuan_retur_barang_id_ketentuan_retur_ketentuan_retur_id_fk
ketentuan_retur_barang.id_ketentuan_retur
ketentuan_retur.id
Cascade on delete
ketentuan_retur_barang_id_barang_barang_id_fk
ketentuan_retur_barang.id_barang
barang.id
Cascade on delete
tanda_terima_invoice_detail_id_tanda_terima_invoice_id_fk
tanda_terima_invoice_detail.id
tanda_terima_invoice.id
Restrict delete
surat_tanda_terima_detail_id_sampai_di_outlet_pegawai_id_fk
surat_tanda_terima_detail.id_sampai_di_outlet
pegawai.id
Restrict delete
surat_tanda_terima_detail_id_rejected_pegawai_id_fk
surat_tanda_terima_detail.id_rejected
pegawai.id
Restrict delete
surat_tanda_terima_detail_id_terima_kembali_pegawai_id_fk
surat_tanda_terima_detail.id_terima_kembali
pegawai.id
Restrict delete
surat_tanda_terima_detail_id_verifikasi_pegawai_id_fk
surat_tanda_terima_detail.id_verifikasi
pegawai.id
Restrict delete
surat_tanda_terima_detail_id_packing_packing_id_fk
surat_tanda_terima_detail.id_packing
packing.id
Restrict delete
surat_tanda_terima_detail_id_terima_berkas_pegawai_id_fk
surat_tanda_terima_detail.id_terima_berkas
pegawai.id
Restrict delete
surat_tanda_terima_detail_id_surat_tanda_terima_id_fk
surat_tanda_terima_detail.id
surat_tanda_terima.id
Restrict delete
surat_tanda_terima_detail_id_surat_jalan_surat_jalan_id_fk
surat_tanda_terima_detail.id_surat_jalan
surat_jalan.id
Restrict delete
kode_e_report_created_by_pegawai_id_fk
kode_e_report.created_by
pegawai.id
Restrict delete
kode_e_report_updated_by_pegawai_id_fk
kode_e_report.updated_by
pegawai.id
Restrict delete
surat_tanda_terima_id_driver_pegawai_id_fk
surat_tanda_terima.id_driver
pegawai.id
Restrict delete
surat_tanda_terima_id_kendaraan_unit_id_fk
surat_tanda_terima.id_kendaraan
unit.id
Restrict delete
surat_tanda_terima_id_ekspedisi_harga_ekspedisi_harga_id_fk
surat_tanda_terima.id_ekspedisi_harga
ekspedisi_harga.id
Restrict delete
surat_tanda_terima_id_ongkos_ongkos_id_fk
surat_tanda_terima.id_ongkos
ongkos.id
Restrict delete
surat_tanda_terima_id_no_resi_ekspedisi_resi_id_fk
surat_tanda_terima.id_no_resi
ekspedisi_resi.id
Restrict delete
surat_tanda_terima_updated_by_pegawai_id_fk
surat_tanda_terima.updated_by
pegawai.id
Restrict delete
surat_tanda_terima_id_ekspedisi_ekspedisi_id_fk
surat_tanda_terima.id_ekspedisi
ekspedisi.id
Restrict delete
surat_tanda_terima_id_surat_tanda_terima_sebelumnya_surat_tanda
surat_tanda_terima.id_surat_tanda_terima_sebelumnya
surat_tanda_terima.id
Restrict delete
surat_tanda_terima_created_by_pegawai_id_fk
surat_tanda_terima.created_by
pegawai.id
Restrict delete
titip_faktur_detail_id_tanda_terima_invoice_tanda_terima_invoic
titip_faktur_detail.id_tanda_terima_invoice
tanda_terima_invoice.id
Restrict delete
titip_faktur_detail_id_titip_faktur_id_fk
titip_faktur_detail.id
titip_faktur.id
Restrict delete
internal_perusahaan_legalitas_id_internal_perusahaan_id_fk
internal_perusahaan_legalitas.id
internal_perusahaan.id
Restrict delete
stok_hold_id_stok_barang_id_fk
stok_hold.id
stok_barang.id
Restrict delete
cetakan_updated_by_pegawai_id_fk
cetakan.updated_by
pegawai.id
Restrict delete
cetakan_created_by_pegawai_id_fk
cetakan.created_by
pegawai.id
Restrict delete
packing_id_customer_customer_id_fk
packing.id_customer
customer.id
Restrict delete
packing_created_by_pegawai_id_fk
packing.created_by
pegawai.id
Restrict delete
packing_id_packer_pegawai_id_fk
packing.id_packer
pegawai.id
Restrict delete
packing_updated_by_pegawai_id_fk
packing.updated_by
pegawai.id
Restrict delete
packing_id_area_delivery_area_id_fk
packing.id_area_delivery
area.id
Restrict delete
packing_id_area_area_id_fk
packing.id_area
area.id
Restrict delete
proposal_ap_detail_id_proposal_ap_id_fk
proposal_ap_detail.id
proposal_ap.id
Restrict delete
proposal_ap_detail_id_auditor_pegawai_id_fk
proposal_ap_detail.id_auditor
pegawai.id
Restrict delete
proposal_ap_detail_ap_number_acc_ap_faktur_ap_number_fk
proposal_ap_detail.ap_number
acc_ap_faktur.ap_number
Restrict delete
proposal_ap_detail_id_finance_pegawai_id_fk
proposal_ap_detail.id_finance
pegawai.id
Restrict delete
proposal_ar_detail_invoice_number_acc_ar_faktur_invoice_number_
proposal_ar_detail.invoice_number
acc_ar_faktur.invoice_number
Cascade on delete
proposal_ar_detail_id_proposal_ar_id_fk
proposal_ar_detail.id
proposal_ar.id
Restrict delete
proposal_ar_detail_id_customer_customer_id_fk
proposal_ar_detail.id_customer
customer.id
Restrict delete
proposal_ar_detail_id_centang_berkas_fisik_pegawai_id_fk
proposal_ar_detail.id_centang_berkas_fisik
pegawai.id
Restrict delete
payment_ar_detail_id_payment_ar_id_fk
payment_ar_detail.id
payment_ar.id
Restrict delete
permission_parent_permission_id_fk
permission.parent
permission.id
Restrict delete
ekspedisi_created_by_pegawai_id_fk
ekspedisi.created_by
pegawai.id
Restrict delete
ekspedisi_updated_by_pegawai_id_fk
ekspedisi.updated_by
pegawai.id
Restrict delete
stok_opname_invoice_updated_by_pegawai_id_fk
stok_opname_invoice.updated_by
pegawai.id
Restrict delete
stok_opname_invoice_created_by_pegawai_id_fk
stok_opname_invoice.created_by
pegawai.id
Restrict delete
stok_opname_invoice_id_customer_customer_id_fk
stok_opname_invoice.id_customer
customer.id
Restrict delete
stok_opname_invoice_id_petugas_pegawai_id_fk
stok_opname_invoice.id_petugas
pegawai.id
Restrict delete
stok_opname_invoice_id_kolektor_pegawai_id_fk
stok_opname_invoice.id_kolektor
pegawai.id
Restrict delete
stok_harian_id_barang_barang_id_fk
stok_harian.id_barang
barang.id
Restrict delete
stok_harian_id_gudang_gudang_id_fk
stok_harian.id_gudang
gudang.id
Restrict delete
pengajuan_kenaikan_harga_detail_id_pengajuan_kenaikan_harga_id_
pengajuan_kenaikan_harga_detail.id
pengajuan_kenaikan_harga.id
Restrict delete
pengajuan_kenaikan_harga_detail_id_barang_barang_id_fk
pengajuan_kenaikan_harga_detail.id_barang
barang.id
Restrict delete
customer_kategori_created_by_pegawai_id_fk
customer_kategori.created_by
pegawai.id
Restrict delete
customer_kategori_updated_by_pegawai_id_fk
customer_kategori.updated_by
pegawai.id
Restrict delete
barang_dekat_ed_detail_id_barang_dekat_ed_id_fk
barang_dekat_ed_detail.id
barang_dekat_ed.id
Restrict delete
barang_dekat_ed_detail_id_barang_barang_id_fk
barang_dekat_ed_detail.id_barang
barang.id
Restrict delete
barang_dekat_ed_detail_id_stok_stok_barang_id_fk
barang_dekat_ed_detail.id_stok
stok_barang.id
Restrict delete
barang_dekat_ed_detail_id_stok_baru_stok_barang_id_fk
barang_dekat_ed_detail.id_stok_baru
stok_barang.id
Restrict delete
checklist_penerimaan_barang_updated_by_pegawai_id_fk
checklist_penerimaan_barang.updated_by
pegawai.id
Restrict delete
checklist_penerimaan_barang_created_by_pegawai_id_fk
checklist_penerimaan_barang.created_by
pegawai.id
Restrict delete
checklist_penerimaan_barang_id_surat_pesanan_surat_pesanan_id_f
checklist_penerimaan_barang.id_surat_pesanan
surat_pesanan.id
Restrict delete
insentif_salesman_detail_id_divisi_divisi_id_fk
insentif_salesman_detail.id_divisi
divisi.id
Restrict delete
insentif_salesman_detail_id_insentif_salesman_id_fk
insentif_salesman_detail.id
insentif_salesman.id
Restrict delete
kontrak_loyalty_id_program_loyalty_program_loyalty_id_fk
kontrak_loyalty.id_program_loyalty
program_loyalty.id
Restrict delete
kontrak_loyalty_created_by_pegawai_id_fk
kontrak_loyalty.created_by
pegawai.id
Restrict delete
kontrak_loyalty_updated_by_pegawai_id_fk
kontrak_loyalty.updated_by
pegawai.id
Restrict delete
kontrak_loyalty_id_customer_customer_id_fk
kontrak_loyalty.id_customer
customer.id
Restrict delete
komisi_kolektor_created_by_pegawai_id_fk
komisi_kolektor.created_by
pegawai.id
Restrict delete
komisi_kolektor_updated_by_pegawai_id_fk
komisi_kolektor.updated_by
pegawai.id
Restrict delete
initial_account_updated_by_pegawai_id_fk
initial_account.updated_by
pegawai.id
Restrict delete
initial_account_id_account_account_id_fk
initial_account.id_account
account.id
Restrict delete
initial_account_created_by_pegawai_id_fk
initial_account.created_by
pegawai.id
Restrict delete
pemindahan_barang_persetujuan_id_pemindahan_barang_id_fk
pemindahan_barang_persetujuan.id
pemindahan_barang.id
Restrict delete
klaim_loyalty_detail_id_klaim_loyalty_id_fk
klaim_loyalty_detail.id
klaim_loyalty.id
Restrict delete
klaim_loyalty_detail_id_invoice_invoice_id_fk
klaim_loyalty_detail.id_invoice
invoice.id
Restrict delete
urut_kunjungan_id_customer_customer_id_fk
urut_kunjungan.id_customer
customer.id
Restrict delete
estimasi_order_persetujuan_id_estimasi_order_id_fk
estimasi_order_persetujuan.id
estimasi_order.id
Restrict delete
jenis_identitas_updated_by_pegawai_id_fk
jenis_identitas.updated_by
pegawai.id
Restrict delete
jenis_identitas_created_by_pegawai_id_fk
jenis_identitas.created_by
pegawai.id
Restrict delete
pengajuan_pembayaran_ekspedisi_updated_by_pegawai_id_fk
pengajuan_pembayaran_ekspedisi.updated_by
pegawai.id
Restrict delete
pengajuan_pembayaran_ekspedisi_created_by_pegawai_id_fk
pengajuan_pembayaran_ekspedisi.created_by
pegawai.id
Restrict delete
pengajuan_pembayaran_ekspedisi_id_ekspedisi_ekspedisi_id_fk
pengajuan_pembayaran_ekspedisi.id_ekspedisi
ekspedisi.id
Restrict delete
retur_konsinyasi_persetujuan_id_retur_konsinyasi_id_fk
retur_konsinyasi_persetujuan.id
retur_konsinyasi.id
Restrict delete
ketentuan_retur_created_by_pegawai_id_fk
ketentuan_retur.created_by
pegawai.id
Restrict delete
ketentuan_retur_updated_by_pegawai_id_fk
ketentuan_retur.updated_by
pegawai.id
Restrict delete
mapping_kolektor_area_id_area_area_id_fk
mapping_kolektor_area.id_area
area.id
Restrict delete
mapping_kolektor_area_id_mapping_kolektor_id_fk
mapping_kolektor_area.id
mapping_kolektor.id
Restrict delete
mapping_kolektor_area_id_divisi_sales_divisi_sales_id_fk
mapping_kolektor_area.id_divisi_sales
divisi_sales.id
Restrict delete
mapping_customer_id_pegawai_pegawai_id_fk
mapping_customer.id_pegawai
pegawai.id
Restrict delete
mapping_customer_created_by_pegawai_id_fk
mapping_customer.created_by
pegawai.id
Restrict delete
mapping_customer_updated_by_pegawai_id_fk
mapping_customer.updated_by
pegawai.id
Restrict delete
mapping_customer_id_customer_customer_id_fk
mapping_customer.id_customer
customer.id
Restrict delete
reg_districts_regency_id_reg_regencies_id_fk
reg_districts.regency_id
reg_regencies.id
Restrict delete
packing_detail_id_checking_checking_id_fk
packing_detail.id_checking
checking.id
Restrict delete
packing_detail_id_packing_id_fk
packing_detail.id
packing.id
Restrict delete
packing_detail_id_surat_jalan_surat_jalan_id_fk
packing_detail.id_surat_jalan
surat_jalan.id
Restrict delete
acc_kas_detail_id_account_account_id_fk
acc_kas_detail.id_account
account.id
Restrict delete
acc_kas_detail_id_acc_kas_id_fk
acc_kas_detail.id
acc_kas.id
Restrict delete
penolakan_penawaran_tender_id_penawaran_tender_penawaran_tender
penolakan_penawaran_tender.id_penawaran_tender
penawaran_tender.id
Restrict delete
penolakan_penawaran_tender_updated_by_pegawai_id_fk
penolakan_penawaran_tender.updated_by
pegawai.id
Restrict delete
penolakan_penawaran_tender_created_by_pegawai_id_fk
penolakan_penawaran_tender.created_by
pegawai.id
Restrict delete
penawaran_tender_created_by_pegawai_id_fk
penawaran_tender.created_by
pegawai.id
Restrict delete
penawaran_tender_updated_by_pegawai_id_fk
penawaran_tender.updated_by
pegawai.id
Restrict delete
penawaran_tender_id_customer_customer_id_fk
penawaran_tender.id_customer
customer.id
Restrict delete

Check Constraints

Table Constraint Name Constraint