klaim_program_pembelian

11 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('klaim_program_pembelian_id_seq'::regclass)
klaim_program_pembelian_persetujuan.id klaim_program_pembelian_persetujuan_id_klaim_program_pembelian_ R
nomor varchar 30 null
tanggal date 13 now()
status bpchar 1 null
id_program_pembelian int4 10 null
program_pembelian.id klaim_program_pembelian_id_program_pembelian_program_pembelian_ R
jenis varchar 2147483647 null
id_reff int4 10 √ null
tanggal_reff date 13 √ null
reff bpchar 3 √ null
jumlah varchar 2147483647 null
gambar _varchar 2147483647 √ null
keterangan text 2147483647 null
created_by int4 10 null
pegawai.id klaim_program_pembelian_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id klaim_program_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
target target 2147483647 √ 'bulanan'::target
periode_start varchar 2147483647 √ null
periode_end varchar 2147483647 √ null

Indexes

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

Relationships

Close relationships within degrees of separation