klaim_diskon_3

52 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('klaim_diskon_3_id_seq'::regclass)
klaim_diskon_3_persetujuan.id klaim_diskon_3_persetujuan_id_klaim_diskon_3_id_fk R
nomor varchar 30 null
tanggal date 13 now()
status bpchar 1 null
id_bukti_barang_masuk int4 10 null
bukti_barang_masuk.id klaim_diskon_3_id_bukti_barang_masuk_bukti_barang_masuk_id_fk R
id_supplier int4 10 null
supplier.id klaim_diskon_3_id_supplier_supplier_id_fk R
jenis bpchar 1 null
id_reff int4 10 √ null
tanggal_reff date 13 √ null
reff bpchar 3 √ null
total_diskon_3 numeric 0 null
angsuran numeric 0 null
amount numeric 0 null
gambar varchar 2147483647 √ null
keterangan text 2147483647 null
created_by int4 10 null
pegawai.id klaim_diskon_3_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id klaim_diskon_3_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

Indexes

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

Relationships

Close relationships within degrees of separation