pengajuan_retur_penjualan

864 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('pengajuan_retur_penjualan_id_seq'::regclass)
invoice_retur.id_pengajuan_retur_penjualan invoice_retur_id_pengajuan_retur_penjualan_pengajuan_retur_penj R
pengajuan_retur_penjualan_detail.id pengajuan_retur_penjualan_detail_id_pengajuan_retur_penjualan_i R
pengajuan_retur_penjualan_persetujuan.id pengajuan_retur_penjualan_persetujuan_id_pengajuan_retur_penjua R
nomor varchar 2147483647 null
tanggal date 13 null
id_invoice int4 10 √ null
invoice.id pengajuan_retur_penjualan_id_invoice_invoice_id_fk R
id_salesman int4 10 null
catatan text 2147483647 √ null
status char 1 null
created_by int4 10 null
pegawai.id pengajuan_retur_penjualan_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id pengajuan_retur_penjualan_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
id_spv int4 10 √ null
nama_salesman varchar 2147483647 √ null
nama_spv varchar 2147483647 √ null
catatan_salesman text 2147483647 √ null
verify_by int4 10 √ null
pegawai.id pengajuan_retur_penjualan_verify_by_pegawai_id_fk R
verify_at timestamp 29,6 √ null
id_driver int4 10 √ null
waktu_diambil timestamp 29,6 √ null
no_pkp varchar 2147483647 √ null
file _varchar 100 √ null
id_customer int4 10 null
customer.id pengajuan_retur_penjualan_id_customer_customer_id_fk R
status_pajak varchar 2147483647 √ null
alamat_customer varchar 2147483647 √ null
invoice_number varchar 50 √ null
acc_ar_faktur.invoice_number Implied Constraint R
is_invoice bool 1 √ null
alasan_batal text 2147483647 √ null
batal_by int4 10 √ null
pegawai.id pengajuan_retur_penjualan_batal_by_fkey R
batal_at timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation