acc_kas

2574 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acc_kas_id_seq'::regclass)
acc_kas_detail.id acc_kas_detail_id_acc_kas_id_fk R
date date 13 null
reference varchar 20 null
akun int4 10 null
account.id acc_kas_akun_account_id_fk R
kepada varchar 100 null
description varchar 2147483647 null
total numeric 0 '0'::numeric
type bpchar 1 null
status bpchar 1 null
id_reff int4 10 √ null
reff varchar 2147483647 √ null
created_by int4 10 null
pegawai.id acc_kas_created_by_pegawai_id_fk R
updated_by int4 10 null
pegawai.id acc_kas_updated_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_at timestamp 29,6 √ now()
deleted_by int4 10 √ null
deleted_at timestamp 29,6 √ null
deleted_reason text 2147483647 ''::text
canceled_by int4 10 √ null
pegawai.id acc_kas_canceled_by_pegawai_id_fk R
canceled_at timestamp 29,6 √ null
canceled_reason varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
acc_kas_pkey Primary key Asc id
acc_kas_reference_unique Must be unique Asc reference

Relationships

Close relationships within degrees of separation