proposal_ar

4239 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('proposal_ar_id_seq'::regclass)
payment_ar.id_proposal fk_payment_ar_id_proposal R
proposal_ar_detail.id proposal_ar_detail_id_proposal_ar_id_fk R
proposal_ar_persetujuan.id proposal_ar_persetujuan_id_proposal_ar_id_fk R
verifikasi_tagihan.id_proposal_ar verifikasi_tagihan_id_proposal_ar_proposal_ar_id_fk R
nomor varchar 2147483647 null
tanggal date 13 null
id_kolektor int4 10 null
id_area int4 10 null
area.id proposal_ar_id_area_area_id_fk R
grandtotal numeric 0 null
keterangan varchar 2147483647 null
status char 1 null
created_by int4 10 null
pegawai.id proposal_ar_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id proposal_ar_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
overdue_awal int4 10 √ null
overdue_akhir int4 10 √ null
id_terima_berkas int4 10 √ null
pegawai.id proposal_ar_id_terima_berkas_pegawai_id_fk R
waktu_terima_berkas timestamp 29,6 √ null
ongkos numeric 0 0

Indexes

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

Relationships

Close relationships within degrees of separation