uang_muka_pembelian

27 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('uang_muka_pembelian_id_seq'::regclass)
uang_muka_pembelian_persetujuan.id uang_muka_pembelian_persetujuan_id_uang_muka_pembelian_id_fk R
tanggal date 13 null
nomor varchar 2147483647 null
id_surat_pesanan int4 10 null
surat_pesanan.id uang_muka_pembelian_id_surat_pesanan_surat_pesanan_id_fk R
id_akun int4 10 null
account.id uang_muka_pembelian_id_akun_account_id_fk R
bayar numeric 0 '0'::numeric
sisa numeric 0 '0'::numeric
catatan text 2147483647 √ null
status bpchar 1 null
created_by int4 10 null
pegawai.id uang_muka_pembelian_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id uang_muka_pembelian_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
angsuran numeric 0 '0'::numeric

Indexes

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

Relationships

Close relationships within degrees of separation