surat_penolakan_penjualan

9052 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('surat_penolakan_penjualan_id_seq'::regclass)
surat_penolakan_penjualan_detail.id surat_penolakan_penjualan_detail_id_surat_penolakan_penjualan_i R
nomor varchar 2147483647 null
tanggal date 13 null
id_customer int4 10 null
customer.id surat_penolakan_penjualan_id_customer_customer_id_fk R
id_sales_order int4 10 null
sales_order.id surat_penolakan_penjualan_id_sales_order_sales_order_id_fk R
status bpchar 1 null
catatan text 2147483647 null
created_by int4 10 null
pegawai.id surat_penolakan_penjualan_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id surat_penolakan_penjualan_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)
surat_penolakan_penjualan_pkey Primary key Asc id
surat_penolakan_penjualan_id_sales_order_index Performance Asc id_sales_order

Relationships

Close relationships within degrees of separation