surat_tanda_terima_detail

62681 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
surat_tanda_terima.id surat_tanda_terima_detail_id_surat_tanda_terima_id_fk R
id_customer int4 10 null
urut int4 10 null
total_koli numeric 0 null
total_kilo numeric 0 null
keterangan text 2147483647 '-'::text
is_terima_berkas bool 1 false
is_ttd_apj_faktur bool 1 false
is_stampel_faktur bool 1 false
is_sipa_apj_faktur bool 1 false
is_ttd_apj_sp bool 1 false
is_stampel_sp bool 1 false
is_sipa_apj_sp bool 1 false
id_surat_jalan int4 10 null
surat_jalan.id surat_tanda_terima_detail_id_surat_jalan_surat_jalan_id_fk R
id_packing int4 10 null
packing.id surat_tanda_terima_detail_id_packing_packing_id_fk R
is_terima_barang bool 1 false
is_sampai_di_outlet bool 1 false
waktu_sampai_di_outlet timestamptz 35,6 √ null
koli_diterima _varchar 2147483647 √ null
minimal_kilo numeric 0 √ '0'::numeric
biaya_ekspedisi numeric 0 √ '0'::numeric
filename _text 2147483647 √ null
is_rejected bool 1 false
is_terima_kembali bool 1 false
catatan_dari_atas text 2147483647 '-'::text
waktu_terima_kembali timestamptz 35,6 √ null
id_terima_kembali int4 10 √ null
pegawai.id surat_tanda_terima_detail_id_terima_kembali_pegawai_id_fk R
id_terima_berkas int4 10 √ null
pegawai.id surat_tanda_terima_detail_id_terima_berkas_pegawai_id_fk R
waktu_terima_berkas timestamptz 35,6 √ null
id_sampai_di_outlet int4 10 √ null
pegawai.id surat_tanda_terima_detail_id_sampai_di_outlet_pegawai_id_fk R
id_rejected int4 10 √ null
pegawai.id surat_tanda_terima_detail_id_rejected_pegawai_id_fk R
waktu_rejected timestamptz 35,6 √ null
is_verifikasi bool 1 false
id_verifikasi int4 10 √ null
pegawai.id surat_tanda_terima_detail_id_verifikasi_pegawai_id_fk R
waktu_verifikasi timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
surat_tanda_terima_detail_id_urut_pk Primary key Asc/Asc id + urut
surat_tanda_terima_detail_id_id_surat_jalan_unique Must be unique Asc/Asc id + id_surat_jalan

Relationships

Close relationships within degrees of separation