program_pembelian

49 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('program_pembelian_id_seq'::regclass)
bukti_barang_masuk_program.id_program bukti_barang_masuk_program_id_program_program_pembelian_id_fk R
estimasi_order_detail.id_program estimasi_order_detail_id_program_program_pembelian_id_fk R
klaim_program_pembelian.id_program_pembelian klaim_program_pembelian_id_program_pembelian_program_pembelian_ R
permintaan_penawaran_detail.id_program permintaan_penawaran_detail_id_program_program_pembelian_id_fk R
permintaan_penawaran_program.id_program permintaan_penawaran_program_id_program_program_pembelian_id_fk R
program_pembelian_persetujuan.id program_pembelian_persetujuan_id_program_pembelian_id_fk R
surat_pesanan_program.id_program surat_pesanan_program_id_program_program_pembelian_id_fk R
id_supplier _int4 10 √ null
nomor varchar 20 null
tanggal date 13 null
nama varchar 2147483647 null
tanggal_awal date 13 null
tanggal_akhir date 13 null
status char 1 null
keterangan text 2147483647 √ null
created_by int4 10 null
pegawai.id program_pembelian_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id 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
file varchar 2147483647 √ null

Indexes

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

Relationships

Close relationships within degrees of separation