pegawai

202 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('pegawai_id_seq'::regclass)
acc_ap_faktur.created_by acc_ap_faktur_created_by_pegawai_id_fk R
acc_ap_faktur.updated_by acc_ap_faktur_updated_by_pegawai_id_fk R
acc_ar_faktur.created_by acc_ar_faktur_created_by_pegawai_id_fk R
acc_ar_faktur.id_serah_terima_1 acc_ar_faktur_id_serah_terima_1_pegawai_id_fk R
acc_ar_faktur.id_serah_terima_2 acc_ar_faktur_id_serah_terima_2_pegawai_id_fk R
acc_ar_faktur.updated_by acc_ar_faktur_updated_by_pegawai_id_fk R
acc_gl_trans.created_by acc_gl_trans_created_by_pegawai_id_fk R
acc_gl_trans.updated_by acc_gl_trans_updated_by_pegawai_id_fk R
acc_kas.canceled_by acc_kas_canceled_by_pegawai_id_fk R
acc_kas.created_by acc_kas_created_by_pegawai_id_fk R
acc_kas.updated_by acc_kas_updated_by_pegawai_id_fk R
agama.created_by agama_created_by_pegawai_id_fk R
agama.updated_by agama_updated_by_pegawai_id_fk R
alasan_penolakan.created_by alasan_penolakan_created_by_pegawai_id_fk R
alasan_penolakan.updated_by alasan_penolakan_updated_by_pegawai_id_fk R
alasan_retur.created_by alasan_retur_created_by_pegawai_id_fk R
alasan_retur.updated_by alasan_retur_updated_by_pegawai_id_fk R
ap_value.created_by ap_value_created_by_pegawai_id_fk R
ap_value.updated_by ap_value_updated_by_pegawai_id_fk R
ar_value.created_by ar_value_created_by_pegawai_id_fk R
ar_value.updated_by ar_value_updated_by_pegawai_id_fk R
area.created_by area_created_by_pegawai_id_fk R
area.updated_by area_updated_by_pegawai_id_fk R
barang.created_by barang_created_by_pegawai_id_fk R
barang.updated_by barang_updated_by_pegawai_id_fk R
barang_dekat_ed.created_by barang_dekat_ed_created_by_pegawai_id_fk R
barang_dekat_ed.updated_by barang_dekat_ed_updated_by_pegawai_id_fk R
barang_harga.created_by barang_harga_created_by_pegawai_id_fk R
barang_harga.updated_by barang_harga_updated_by_pegawai_id_fk R
barang_supplier.created_by barang_supplier_created_by_pegawai_id_fk R
barang_supplier.updated_by barang_supplier_updated_by_pegawai_id_fk R
biaya_expedisi.created_by biaya_expedisi_created_by_pegawai_id_fk R
biaya_expedisi.updated_by biaya_expedisi_updated_by_pegawai_id_fk R
biaya_transfer.created_by biaya_transfer_created_by_pegawai_id_fk R
biaya_transfer.updated_by biaya_transfer_updated_by_pegawai_id_fk R
bukti_barang_masuk.created_by bukti_barang_masuk_created_by_pegawai_id_fk R
bukti_barang_masuk.id_penerima bukti_barang_masuk_id_penerima_pegawai_id_fk R
bukti_barang_masuk.updated_by bukti_barang_masuk_updated_by_pegawai_id_fk R
cetakan.created_by cetakan_created_by_pegawai_id_fk R
cetakan.updated_by cetakan_updated_by_pegawai_id_fk R
cetakan_logs.created_by cetakan_logs_created_by_pegawai_id_fk R
cetakan_logs.updated_by cetakan_logs_updated_by_pegawai_id_fk R
cetakan_password.created_by cetakan_password_created_by_pegawai_id_fk R
cetakan_password.updated_by cetakan_password_updated_by_pegawai_id_fk R
cetakan_request.created_by cetakan_request_created_by_pegawai_id_fk R
cetakan_request.request_to cetakan_request_request_to_pegawai_id_fk R
cetakan_request.updated_by cetakan_request_updated_by_pegawai_id_fk R
cetakan_setting.created_by cetakan_setting_created_by_pegawai_id_fk R
cetakan_setting.updated_by cetakan_setting_updated_by_pegawai_id_fk R
cetakan_token.created_by cetakan_token_created_by_pegawai_id_fk R
cetakan_token.updated_by cetakan_token_updated_by_pegawai_id_fk R
checking.created_by checking_created_by_pegawai_id_fk R
checking.updated_by checking_updated_by_pegawai_id_fk R
checklist_penerimaan_barang.created_by checklist_penerimaan_barang_created_by_pegawai_id_fk R
checklist_penerimaan_barang.updated_by checklist_penerimaan_barang_updated_by_pegawai_id_fk R
coretax.created_by coretax_created_by_pegawai_id_fk R
coretax.updated_by coretax_updated_by_pegawai_id_fk R
customer.created_by customer_created_by_pegawai_id_fk R
customer.id_kolektor customer_id_kolektor_pegawai_id_fk R
customer.id_salesman customer_id_salesman_pegawai_id_fk R
customer.updated_by customer_updated_by_pegawai_id_fk R
customer_jenis.created_by customer_jenis_created_by_pegawai_id_fk R
customer_jenis.updated_by customer_jenis_updated_by_pegawai_id_fk R
customer_kategori.created_by customer_kategori_created_by_pegawai_id_fk R
customer_kategori.updated_by customer_kategori_updated_by_pegawai_id_fk R
customer_kontak.created_by customer_kontak_created_by_pegawai_id_fk R
customer_kontak.updated_by customer_kontak_updated_by_pegawai_id_fk R
divisi_sales.created_by divisi_sales_created_by_pegawai_id_fk R
divisi_sales.updated_by divisi_sales_updated_by_pegawai_id_fk R
ekspedisi.created_by ekspedisi_created_by_pegawai_id_fk R
ekspedisi.updated_by ekspedisi_updated_by_pegawai_id_fk R
ekspedisi_harga.created_by ekspedisi_harga_created_by_pegawai_id_fk R
ekspedisi_harga.updated_by ekspedisi_harga_updated_by_pegawai_id_fk R
ekspedisi_resi.created_by ekspedisi_resi_created_by_pegawai_id_fk R
ekspedisi_resi.updated_by ekspedisi_resi_updated_by_pegawai_id_fk R
estimasi_order.created_by estimasi_order_created_by_pegawai_id_fk R
estimasi_order.updated_by estimasi_order_updated_by_pegawai_id_fk R
expense_type.created_by expense_type_created_by_pegawai_id_fk R
expense_type.updated_by expense_type_updated_by_pegawai_id_fk R
faktur_pajak_pembelian.created_by faktur_pajak_pembelian_created_by_pegawai_id_fk R
faktur_pajak_pembelian.id_verified faktur_pajak_pembelian_id_verified_pegawai_id_fk R
faktur_pajak_pembelian.updated_by faktur_pajak_pembelian_updated_by_pegawai_id_fk R
golongan_barang.created_by golongan_barang_created_by_pegawai_id_fk R
golongan_barang.updated_by golongan_barang_updated_by_pegawai_id_fk R
golongan_darah.created_by golongan_darah_created_by_pegawai_id_fk R
golongan_darah.updated_by golongan_darah_updated_by_pegawai_id_fk R
hari_libur.created_by hari_libur_created_by_pegawai_id_fk R
hari_libur.updated_by hari_libur_updated_by_pegawai_id_fk R
initial_account.created_by initial_account_created_by_pegawai_id_fk R
initial_account.updated_by initial_account_updated_by_pegawai_id_fk R
insentif_noo.created_by insentif_noo_created_by_pegawai_id_fk R
insentif_noo.updated_by insentif_noo_updated_by_pegawai_id_fk R
insentif_salesman.created_by insentif_salesman_created_by_pegawai_id_fk R
insentif_salesman.id_atasan insentif_salesman_id_atasan_pegawai_id_fk R
insentif_salesman.id_verif insentif_salesman_id_verif_pegawai_id_fk R
insentif_salesman.updated_by insentif_salesman_updated_by_pegawai_id_fk R
invoice.created_by invoice_created_by_pegawai_id_fk R
invoice.exported_by invoice_exported_by_pegawai_id_fk R
invoice.id_serah_terima_1 invoice_id_serah_terima_1_pegawai_id_fk R
invoice.id_serah_terima_2 invoice_id_serah_terima_2_pegawai_id_fk R
invoice.updated_by invoice_updated_by_pegawai_id_fk R
invoice_retur.created_by invoice_retur_created_by_pegawai_id_fk R
invoice_retur.updated_by invoice_retur_updated_by_pegawai_id_fk R
invoice_revisi.created_by invoice_revisi_created_by_pegawai_id_fk R
invoice_revisi.updated_by invoice_revisi_updated_by_pegawai_id_fk R
jabatan.created_by jabatan_created_by_pegawai_id_fk R
jabatan.updated_by jabatan_updated_by_pegawai_id_fk R
jenis_barang.created_by jenis_barang_created_by_pegawai_id_fk R
jenis_barang.updated_by jenis_barang_updated_by_pegawai_id_fk R
jenis_identitas.created_by jenis_identitas_created_by_pegawai_id_fk R
jenis_identitas.updated_by jenis_identitas_updated_by_pegawai_id_fk R
kategori_surat_pesanan.created_by kategori_surat_pesanan_created_by_pegawai_id_fk R
kategori_surat_pesanan.updated_by kategori_surat_pesanan_updated_by_pegawai_id_fk R
ketentuan_retur.created_by ketentuan_retur_created_by_pegawai_id_fk R
ketentuan_retur.updated_by ketentuan_retur_updated_by_pegawai_id_fk R
klaim_diskon_3.created_by klaim_diskon_3_created_by_pegawai_id_fk R
klaim_diskon_3.updated_by klaim_diskon_3_updated_by_pegawai_id_fk R
klaim_loyalty.created_by klaim_loyalty_created_by_pegawai_id_fk R
klaim_loyalty.updated_by klaim_loyalty_updated_by_pegawai_id_fk R
klaim_program_pembelian.created_by klaim_program_pembelian_created_by_pegawai_id_fk R
klaim_program_pembelian.updated_by klaim_program_pembelian_updated_by_pegawai_id_fk R
kode_e_report.created_by kode_e_report_created_by_pegawai_id_fk R
kode_e_report.updated_by kode_e_report_updated_by_pegawai_id_fk R
kode_obat.created_by kode_obat_created_by_pegawai_id_fk R
kode_obat.updated_by kode_obat_updated_by_pegawai_id_fk R
komisi_kolektor.created_by komisi_kolektor_created_by_pegawai_id_fk R
komisi_kolektor.updated_by komisi_kolektor_updated_by_pegawai_id_fk R
kontrak_loyalty.created_by kontrak_loyalty_created_by_pegawai_id_fk R
kontrak_loyalty.updated_by kontrak_loyalty_updated_by_pegawai_id_fk R
mapping_customer.created_by mapping_customer_created_by_pegawai_id_fk R
mapping_customer.id_pegawai mapping_customer_id_pegawai_pegawai_id_fk R
mapping_customer.updated_by mapping_customer_updated_by_pegawai_id_fk R
mapping_kolektor.created_by mapping_kolektor_created_by_pegawai_id_fk R
mapping_kolektor.id_kolektor mapping_kolektor_id_kolektor_pegawai_id_fk R
mapping_kolektor.id_spv mapping_kolektor_id_spv_pegawai_id_fk R
mapping_kolektor.updated_by mapping_kolektor_updated_by_pegawai_id_fk R
mapping_salesman.created_by mapping_salesman_created_by_pegawai_id_fk R
mapping_salesman.id_salesman mapping_salesman_id_salesman_pegawai_id_fk R
mapping_salesman.id_spv mapping_salesman_id_spv_pegawai_id_fk R
mapping_salesman.updated_by mapping_salesman_updated_by_pegawai_id_fk R
mapping_target_salesman.created_by mapping_target_salesman_created_by_pegawai_id_fk R
mapping_target_salesman.id_pegawai mapping_target_salesman_id_pegawai_pegawai_id_fk R
mapping_target_salesman.updated_by mapping_target_salesman_updated_by_pegawai_id_fk R
media.created_by media_created_by_pegawai_id_fk R
media.updated_by media_updated_by_pegawai_id_fk R
mv_refresh_control.created_by mv_refresh_control_created_by_fkey R
mv_refresh_control.updated_by mv_refresh_control_updated_by_fkey R
no_faktur.created_by no_faktur_created_by_pegawai_id_fk R
no_faktur.updated_by no_faktur_updated_by_pegawai_id_fk R
noo.created_by noo_created_by_pegawai_id_fk R
noo.id_verif noo_id_verif_pegawai_id_fk R
noo.updated_by noo_updated_by_pegawai_id_fk R
noo_detail.id_pegawai noo_detail_id_pegawai_pegawai_id_fk R
nota_retur_pajak.created_by nota_retur_pajak_created_by_pegawai_id_fk R
nota_retur_pajak.updated_by nota_retur_pajak_updated_by_pegawai_id_fk R
notification.created_by notification_created_by_pegawai_id_fk R
notification.id_pegawai notification_id_pegawai_pegawai_id_fk R
notification.updated_by notification_updated_by_pegawai_id_fk R
ongkos.created_by ongkos_created_by_pegawai_id_fk R
ongkos.updated_by ongkos_updated_by_pegawai_id_fk R
pabrik.created_by pabrik_created_by_pegawai_id_fk R
pabrik.updated_by pabrik_updated_by_pegawai_id_fk R
packing.created_by packing_created_by_pegawai_id_fk R
packing.id_packer packing_id_packer_pegawai_id_fk R
packing.updated_by packing_updated_by_pegawai_id_fk R
payment_ap.created_by payment_ap_created_by_pegawai_id_fk R
payment_ap.updated_by payment_ap_updated_by_pegawai_id_fk R
payment_ar.created_by payment_ar_created_by_pegawai_id_fk R
payment_ar.id_rejected payment_ar_id_rejected_pegawai_id_fk R
payment_ar.id_verifikasi payment_ar_id_verifikasi_pegawai_id_fk R
payment_ar.updated_by payment_ar_updated_by_pegawai_id_fk R
pegawai.created_by pegawai_created_by_pegawai_id_fk R
pegawai.deleted_by pegawai_deleted_by_pegawai_id_fk R
pegawai.updated_by pegawai_updated_by_pegawai_id_fk R
pegawai_account.id pegawai_account_id_pegawai_id_fk C
pemindahan_barang.created_by pemindahan_barang_created_by_pegawai_id_fk R
pemindahan_barang.updated_by pemindahan_barang_updated_by_pegawai_id_fk R
penawaran_tender.created_by penawaran_tender_created_by_pegawai_id_fk R
penawaran_tender.updated_by penawaran_tender_updated_by_pegawai_id_fk R
penerimaan_barang.created_by penerimaan_barang_created_by_pegawai_id_fk R
penerimaan_barang.id_penerima_berkas penerimaan_barang_id_penerima_berkas_pegawai_id_fk R
penerimaan_barang.id_penerima_berkas_approve penerimaan_barang_id_penerima_berkas_approve_pegawai_id_fk R
penerimaan_barang.id_penerima_berkas_waiting penerimaan_barang_id_penerima_berkas_waiting_pegawai_id_fk R
penerimaan_barang.updated_by penerimaan_barang_updated_by_pegawai_id_fk R
penerimaan_pemindahan_barang.created_by penerimaan_pemindahan_barang_created_by_pegawai_id_fk R
penerimaan_pemindahan_barang.updated_by penerimaan_pemindahan_barang_updated_by_pegawai_id_fk R
pengajuan_kenaikan_harga.created_by pengajuan_kenaikan_harga_created_by_pegawai_id_fk R
pengajuan_kenaikan_harga.updated_by pengajuan_kenaikan_harga_updated_by_pegawai_id_fk R
pengajuan_pembayaran_ekspedisi.created_by pengajuan_pembayaran_ekspedisi_created_by_pegawai_id_fk R
pengajuan_pembayaran_ekspedisi.updated_by pengajuan_pembayaran_ekspedisi_updated_by_pegawai_id_fk R
pengajuan_pembayaran_ekspedisi_detail.id_centang pengajuan_pembayaran_ekspedisi_detail_id_centang_pegawai_id_fk R
pengajuan_perubahan_limit.created_by pengajuan_perubahan_limit_created_by_pegawai_id_fk R
pengajuan_perubahan_limit.id_salesman pengajuan_perubahan_limit_id_salesman_pegawai_id_fk R
pengajuan_perubahan_limit.id_spv pengajuan_perubahan_limit_id_spv_pegawai_id_fk R
pengajuan_perubahan_limit.updated_by pengajuan_perubahan_limit_updated_by_pegawai_id_fk R
pengajuan_retur_penjualan.batal_by pengajuan_retur_penjualan_batal_by_fkey R
pengajuan_retur_penjualan.created_by pengajuan_retur_penjualan_created_by_pegawai_id_fk R
pengajuan_retur_penjualan.updated_by pengajuan_retur_penjualan_updated_by_pegawai_id_fk R
pengajuan_retur_penjualan.verify_by pengajuan_retur_penjualan_verify_by_pegawai_id_fk R
penolakan_penawaran_tender.created_by penolakan_penawaran_tender_created_by_pegawai_id_fk R
penolakan_penawaran_tender.updated_by penolakan_penawaran_tender_updated_by_pegawai_id_fk R
permintaan_penawaran.created_by permintaan_penawaran_created_by_pegawai_id_fk R
permintaan_penawaran.updated_by permintaan_penawaran_updated_by_pegawai_id_fk R
printer_device.created_by printer_device_created_by_pegawai_id_fk R
printer_device.id printer_device_id_pegawai_id_fk R
printer_device.updated_by printer_device_updated_by_pegawai_id_fk R
printer_paper.id printer_paper_id_pegawai_id_fk R
program_loyalty.created_by program_loyalty_created_by_pegawai_id_fk R
program_loyalty.updated_by program_loyalty_updated_by_pegawai_id_fk R
program_pembelian.created_by program_pembelian_created_by_pegawai_id_fk R
program_pembelian.updated_by program_pembelian_updated_by_pegawai_id_fk R
program_penjualan.created_by program_penjualan_created_by_pegawai_id_fk R
program_penjualan.updated_by program_penjualan_updated_by_pegawai_id_fk R
program_reward.created_by program_reward_created_by_pegawai_id_fk R
program_reward.updated_by program_reward_updated_by_pegawai_id_fk R
proposal_ap.created_by proposal_ap_created_by_pegawai_id_fk R
proposal_ap.updated_by proposal_ap_updated_by_pegawai_id_fk R
proposal_ap_detail.id_auditor proposal_ap_detail_id_auditor_pegawai_id_fk R
proposal_ap_detail.id_finance proposal_ap_detail_id_finance_pegawai_id_fk R
proposal_ar.created_by proposal_ar_created_by_pegawai_id_fk R
proposal_ar.id_terima_berkas proposal_ar_id_terima_berkas_pegawai_id_fk R
proposal_ar.updated_by proposal_ar_updated_by_pegawai_id_fk R
proposal_ar_detail.id_centang_berkas_fisik proposal_ar_detail_id_centang_berkas_fisik_pegawai_id_fk R
rak_barang.id_penanggung_jawab rak_barang_id_penanggung_jawab_pegawai_id_fk R
realisasi_stt.created_by realisasi_stt_created_by_pegawai_id_fk R
realisasi_stt.updated_by realisasi_stt_updated_by_pegawai_id_fk R
rencana_kunjungan_salesman.created_by rencana_kunjungan_salesman_created_by_pegawai_id_fk R
rencana_kunjungan_salesman.id_salesman rencana_kunjungan_salesman_id_salesman_pegawai_id_fk R
rencana_kunjungan_salesman.updated_by rencana_kunjungan_salesman_updated_by_pegawai_id_fk R
retur_konsinyasi.created_by retur_konsinyasi_created_by_pegawai_id_fk R
retur_konsinyasi.updated_by retur_konsinyasi_updated_by_pegawai_id_fk R
retur_pembelian.created_by retur_pembelian_created_by_pegawai_id_fk R
retur_pembelian.id_penerima retur_pembelian_id_penerima_pegawai_id_fk R
retur_pembelian.updated_by retur_pembelian_updated_by_pegawai_id_fk R
sales_order.created_by sales_order_created_by_pegawai_id_fk R
sales_order.id_verifikasi sales_order_id_verifikasi_pegawai_id_fk R
sales_order.reject_by sales_order_reject_by_pegawai_id_fk R
sales_order.updated_by sales_order_updated_by_pegawai_id_fk R
sales_order_log.created_by sales_order_log_created_by_pegawai_id_fk R
sales_order_log.updated_by sales_order_log_updated_by_pegawai_id_fk R
setting_persetujuan.created_by setting_persetujuan_created_by_pegawai_id_fk R
setting_persetujuan.id_pegawai_1 setting_persetujuan_id_pegawai_1_pegawai_id_fk R
setting_persetujuan.id_pegawai_2 setting_persetujuan_id_pegawai_2_pegawai_id_fk R
setting_persetujuan.id_pegawai_3 setting_persetujuan_id_pegawai_3_pegawai_id_fk R
setting_persetujuan.updated_by setting_persetujuan_updated_by_pegawai_id_fk R
status_kerja.created_by status_kerja_created_by_pegawai_id_fk R
status_kerja.updated_by status_kerja_updated_by_pegawai_id_fk R
status_pernikahan.created_by status_pernikahan_created_by_pegawai_id_fk R
status_pernikahan.updated_by status_pernikahan_updated_by_pegawai_id_fk R
stok_awal_barang.created_by stok_awal_barang_created_by_pegawai_id_fk R
stok_awal_barang.updated_by stok_awal_barang_updated_by_pegawai_id_fk R
stok_barang.created_by stok_barang_created_by_pegawai_id_fk R
stok_barang.updated_by stok_barang_updated_by_pegawai_id_fk R
stok_opname.created_by stok_opname_created_by_pegawai_id_fk R
stok_opname.id_petugas stok_opname_id_petugas_pegawai_id_fk R
stok_opname.updated_by stok_opname_updated_by_pegawai_id_fk R
stok_opname_invoice.created_by stok_opname_invoice_created_by_pegawai_id_fk R
stok_opname_invoice.id_kolektor stok_opname_invoice_id_kolektor_pegawai_id_fk R
stok_opname_invoice.id_petugas stok_opname_invoice_id_petugas_pegawai_id_fk R
stok_opname_invoice.updated_by stok_opname_invoice_updated_by_pegawai_id_fk R
stok_opname_invoice_detail.scanned_by stok_opname_invoice_detail_scanned_by_pegawai_id_fk R
supplier.created_by supplier_created_by_pegawai_id_fk R
supplier.updated_by supplier_updated_by_pegawai_id_fk R
supplier_kontak.created_by supplier_kontak_created_by_pegawai_id_fk R
supplier_kontak.updated_by supplier_kontak_updated_by_pegawai_id_fk R
surat_jalan.created_by surat_jalan_created_by_pegawai_id_fk R
surat_jalan.id_picking surat_jalan_id_picking_pegawai_id_fk R
surat_jalan.updated_by surat_jalan_updated_by_pegawai_id_fk R
surat_penolakan_pembelian.created_by surat_penolakan_pembelian_created_by_pegawai_id_fk R
surat_penolakan_pembelian.updated_by surat_penolakan_pembelian_updated_by_pegawai_id_fk R
surat_penolakan_penjualan.created_by surat_penolakan_penjualan_created_by_pegawai_id_fk R
surat_penolakan_penjualan.updated_by surat_penolakan_penjualan_updated_by_pegawai_id_fk R
surat_pesanan.created_by surat_pesanan_created_by_pegawai_id_fk R
surat_pesanan.id_yang_menyerahkan surat_pesanan_id_yang_menyerahkan_pegawai_id_fk R
surat_pesanan.updated_by surat_pesanan_updated_by_pegawai_id_fk R
surat_tanda_terima.created_by surat_tanda_terima_created_by_pegawai_id_fk R
surat_tanda_terima.id_driver surat_tanda_terima_id_driver_pegawai_id_fk R
surat_tanda_terima.updated_by surat_tanda_terima_updated_by_pegawai_id_fk R
surat_tanda_terima_detail.id_rejected surat_tanda_terima_detail_id_rejected_pegawai_id_fk R
surat_tanda_terima_detail.id_sampai_di_outlet surat_tanda_terima_detail_id_sampai_di_outlet_pegawai_id_fk R
surat_tanda_terima_detail.id_terima_berkas surat_tanda_terima_detail_id_terima_berkas_pegawai_id_fk R
surat_tanda_terima_detail.id_terima_kembali surat_tanda_terima_detail_id_terima_kembali_pegawai_id_fk R
surat_tanda_terima_detail.id_verifikasi surat_tanda_terima_detail_id_verifikasi_pegawai_id_fk R
tanda_terima_invoice.created_by tanda_terima_invoice_created_by_pegawai_id_fk R
tanda_terima_invoice.updated_by tanda_terima_invoice_updated_by_pegawai_id_fk R
target_penjualan.created_by target_penjualan_created_by_pegawai_id_fk R
target_penjualan.id_atasan target_penjualan_id_atasan_pegawai_id_fk R
target_penjualan.id_pengganti target_penjualan_id_pengganti_fkey R
target_penjualan.updated_by target_penjualan_updated_by_pegawai_id_fk R
tipe_bpjs_kesehatan.created_by tipe_bpjs_kesehatan_created_by_pegawai_id_fk R
tipe_bpjs_kesehatan.updated_by tipe_bpjs_kesehatan_updated_by_pegawai_id_fk R
tipe_diskon.created_by tipe_diskon_created_by_pegawai_id_fk R
tipe_diskon.updated_by tipe_diskon_updated_by_pegawai_id_fk R
tipe_hari_libur.created_by tipe_hari_libur_created_by_pegawai_id_fk R
tipe_hari_libur.updated_by tipe_hari_libur_updated_by_pegawai_id_fk R
tipe_kunjungan.created_by tipe_kunjungan_created_by_pegawai_id_fk R
tipe_kunjungan.updated_by tipe_kunjungan_updated_by_pegawai_id_fk R
tipe_pembayaran.created_by tipe_pembayaran_created_by_pegawai_id_fk R
tipe_pembayaran.updated_by tipe_pembayaran_updated_by_pegawai_id_fk R
titip_faktur.created_by titip_faktur_created_by_pegawai_id_fk R
titip_faktur.updated_by titip_faktur_updated_by_pegawai_id_fk R
top_per_kota.created_by top_per_kota_created_by_pegawai_id_fk R
top_per_kota.updated_by top_per_kota_updated_by_pegawai_id_fk R
uang_muka_pembelian.created_by uang_muka_pembelian_created_by_pegawai_id_fk R
uang_muka_pembelian.updated_by uang_muka_pembelian_updated_by_pegawai_id_fk R
unit.created_by unit_created_by_pegawai_id_fk R
unit.id_driver unit_id_driver_pegawai_id_fk R
unit.updated_by unit_updated_by_pegawai_id_fk R
verifikasi_tagihan.created_by verifikasi_tagihan_created_by_pegawai_id_fk R
verifikasi_tagihan.updated_by verifikasi_tagihan_updated_by_pegawai_id_fk R
verifikasi_tagihan_detail.id_terima_kembali verifikasi_tagihan_detail_id_terima_kembali_pegawai_id_fk R
verifikasi_tagihan_detail.id_terima_uang verifikasi_tagihan_detail_id_terima_uang_pegawai_id_fk R
nama varchar 50 null
nama_panggilan varchar 50 null
email varchar 50 null
hp varchar 20 null
tempat_lahir varchar 256 null
tanggal_lahir date 13 null
jenis_kelamin bpchar 1 null
id_status_pernikahan int4 10 null
id_agama int4 10 null
id_golongan_darah int4 10 null
ukuran_seragam varchar 10 null
id_jenis_identitas int4 10 null
kode_pos varchar 10 null
nomor_identitas varchar 100 null
alamat_id text 2147483647 null
alamat_domisili text 2147483647 null
id_karyawan varchar 50 null
id_status_kerja int4 10 null
id_jabatan int4 10 null
tanggal_bergabung date 13 null
tanggal_berhenti date 13 null
fotonya varchar 256 null
ttd varchar 256 null
status bool 1 true
created_by int4 10 null
pegawai.id pegawai_created_by_pegawai_id_fk R
created_at timestamp 29,6 now()
updated_by int4 10 null
pegawai.id pegawai_updated_by_pegawai_id_fk R
updated_at timestamp 29,6 now()
id_atasan_langsung int4 10 null
is_customer bool 1 false
id_customer int4 10 null
deleted_by int4 10 null
pegawai.id pegawai_deleted_by_pegawai_id_fk R
deleted_at timestamp 29,6 null
deleted_reason text 2147483647 '-'::text
ukuran_sepatu varchar 2147483647 '-'::character varying
ukuran_celana varchar 2147483647 '-'::character varying
tinggi_badan int4 10 0
berat_badan int4 10 0
bpjs_kesehatan varchar 2147483647 '-'::character varying
bpjs_ketenagakerjaan varchar 2147483647 '-'::character varying
id_tipe_bpjs_kesehatan int4 10 null
alasan_berhenti text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
pegawai_pkey Primary key Asc id

Relationships