stok_opname_invoice

189 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stok_opname_invoice_id_seq'::regclass)
stok_opname_invoice_area.id stok_opname_invoice_area_id_stok_opname_invoice_id_fk R
stok_opname_invoice_detail.id stok_opname_invoice_detail_id_stok_opname_invoice_id_fk R
stok_opname_invoice_persetujuan.id stok_opname_invoice_persetujuan_id_stok_opname_invoice_id_fk R
nomor varchar 2147483647 null
tanggal date 13 null
status bpchar 1 null
keterangan varchar 2147483647 √ null
id_kolektor int4 10 √ null
pegawai.id stok_opname_invoice_id_kolektor_pegawai_id_fk R
id_customer int4 10 √ null
customer.id stok_opname_invoice_id_customer_customer_id_fk R
total numeric 0 null
total_centang numeric 0 null
total_belum_centang numeric 0 null
total_rp numeric 0 null
total_rp_centang numeric 0 null
total_rp_belum_centang numeric 0 null
created_by int4 10 null
pegawai.id stok_opname_invoice_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id stok_opname_invoice_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
id_petugas int4 10 √ null
pegawai.id stok_opname_invoice_id_petugas_pegawai_id_fk R

Indexes

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

Relationships

Close relationships within degrees of separation