satuan

36 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('satuan_id_seq'::regclass)
barang.id_satuan barang_id_satuan_satuan_id_fk R
barang.id_satuan_beli barang_id_satuan_beli_satuan_id_fk R
barang.id_satuan_tender barang_id_satuan_tender_satuan_id_fk R
barang_satuan.id_satuan barang_satuan_id_satuan_satuan_id_fk C
berita_acara.id_satuan berita_acara_id_satuan_satuan_id_fk R
bukti_barang_masuk_detail.id_satuan bukti_barang_masuk_detail_id_satuan_satuan_id_fk R
checking_detail.id_satuan checking_detail_id_satuan_satuan_id_fk R
estimasi_order_detail.id_satuan estimasi_order_detail_id_satuan_satuan_id_fk R
invoice_detail.id_satuan invoice_detail_id_satuan_satuan_id_fk R
invoice_retur_detail.id_satuan invoice_retur_detail_id_satuan_satuan_id_fk R
pemindahan_barang_detail.id_satuan pemindahan_barang_detail_id_satuan_satuan_id_fk R
penerimaan_barang_detail.id_satuan penerimaan_barang_detail_id_satuan_satuan_id_fk R
penerimaan_barang_detail.id_satuan_dipesan penerimaan_barang_detail_id_satuan_dipesan_satuan_id_fk R
pengajuan_retur_penjualan_detail.id_satuan pengajuan_retur_penjualan_detail_id_satuan_satuan_id_fk R
permintaan_penawaran_detail.id_satuan permintaan_penawaran_detail_id_satuan_satuan_id_fk R
sales_order_detail.id_satuan sales_order_detail_id_satuan_satuan_id_fk R
sales_order_detail.id_satuan_bonus sales_order_detail_id_satuan_bonus_satuan_id_fk R
stok_awal_barang.id_satuan stok_awal_barang_id_satuan_satuan_id_fk R
stok_opname_stok_barang.id_satuan stok_opname_stok_barang_id_satuan_fkey R
surat_jalan_detail.id_satuan surat_jalan_detail_id_satuan_satuan_id_fk R
surat_penolakan_pembelian_detail.id_satuan surat_penolakan_pembelian_detail_id_satuan_satuan_id_fk R
surat_pesanan_detail.id_satuan surat_pesanan_detail_id_satuan_satuan_id_fk R
satuan varchar 20 null
keterangan varchar 50 √ null
kode varchar 20 √ null

Indexes

Constraint Name Type Sort Column(s)
satuan_pkey Primary key Asc id
satuan_satuan_unique Must be unique Asc satuan

Relationships

Close relationships within degrees of separation