proposal_ap

121 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('proposal_ap_id_seq'::regclass)
payment_ap_detail.id_proposal_ap_detail payment_ap_detail_id_proposal_ap_detail_proposal_ap_id_fk R
proposal_ap_detail.id proposal_ap_detail_id_proposal_ap_id_fk R
proposal_ap_persetujuan.id proposal_ap_persetujuan_id_proposal_ap_id_fk R
nomor varchar 30 null
tanggal date 13 now()
pengajuan text 2147483647 null
tanggal_pengajuan date 13 now()
catatan text 2147483647 √ null
grandtotal numeric 0 '0'::numeric
status bpchar 1 'D'::bpchar
id_tipe_transaksi int4 10 √ null
tipe_transaksi.id proposal_ap_id_tipe_transaksi_tipe_transaksi_id_fk R
id_location_supplier int4 10 √ null
location_supplier.id proposal_ap_id_location_supplier_location_supplier_id_fk R
created_by int4 10 null
pegawai.id proposal_ap_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id proposal_ap_updated_by_pegawai_id_fk R
updated_at timestamp 29,6 √ now()
deleted_by int4 10 √ null
deleted_at timestamp 29,6 √ null
deleted_reason text 2147483647 ''::text
jatuh_tempo_awal date 13 √ null
jatuh_tempo_akhir date 13 √ null
overdue_awal int4 10 √ null
overdue_akhir int4 10 √ null

Indexes

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

Relationships

Close relationships within degrees of separation