proposal_ar_detail

69959 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
proposal_ar.id proposal_ar_detail_id_proposal_ar_id_fk R
id_customer int4 10 null
customer.id proposal_ar_detail_id_customer_customer_id_fk R
urut int4 10 null
invoice_number varchar 2147483647 null
acc_ar_faktur.invoice_number proposal_ar_detail_invoice_number_acc_ar_faktur_invoice_number_ C
centang_berkas_fisik bool 1 √ false
keterangan varchar 2147483647 √ null
saldo_piutang numeric 0 null
status bpchar 1 'B'::bpchar
id_centang_berkas_fisik int4 10 √ null
pegawai.id proposal_ar_detail_id_centang_berkas_fisik_pegawai_id_fk R
waktu_centang_berkas_fisik timestamptz 35,6 √ null
keterangan_dari_atas varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
proposal_ar_detail_id_urut_id_customer_invoice_number_pk Primary key Asc/Asc/Asc/Asc id + urut + id_customer + invoice_number
proposal_ar_detail_id_invoice_number_idx Must be unique Asc/Asc id + invoice_number

Relationships

Close relationships within degrees of separation