proposal_ap_detail

7067 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
proposal_ap.id proposal_ap_detail_id_proposal_ap_id_fk R
urut int4 10 null
ap_number varchar 2147483647 null
acc_ap_faktur.ap_number proposal_ap_detail_ap_number_acc_ap_faktur_ap_number_fk R
rencana_pembayaran numeric 0 null
centang_auditor bool 1 √ false
keterangan_auditor varchar 500 √ null
centang_finance bool 1 √ false
keterangan_finance varchar 500 √ null
status bool 1 √ false
angsur numeric 0 '0'::numeric
proposed_pay numeric 0 null
sisa_proposal numeric 0 null
id_auditor int4 10 √ null
pegawai.id proposal_ap_detail_id_auditor_pegawai_id_fk R
waktu_centang_auditor timestamptz 35,6 √ null
id_finance int4 10 √ null
pegawai.id proposal_ap_detail_id_finance_pegawai_id_fk R
waktu_centang_finance timestamptz 35,6 √ null
overdue int4 10 null

Indexes

Constraint Name Type Sort Column(s)
proposal_ap_detail_id_ap_number_unique Must be unique Asc/Asc id + ap_number

Relationships

Close relationships within degrees of separation