titip_faktur

945 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('titip_faktur_id_seq'::regclass)
titip_faktur.id_rev titip_faktur_id_rev_titip_faktur_id_fk R
titip_faktur_detail.id titip_faktur_detail_id_titip_faktur_id_fk R
titip_faktur_persetujuan.id titip_faktur_persetujuan_id_titip_faktur_id_fk R
nomor varchar 2147483647 null
tanggal date 13 null
id_kolektor int4 10 null
catatan text 2147483647 null
status bpchar 1 null
grandtotal numeric 0 null
created_by int4 10 null
pegawai.id titip_faktur_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id titip_faktur_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_rev int4 10 √ null
titip_faktur.id titip_faktur_id_rev_titip_faktur_id_fk R

Indexes

Constraint Name Type Sort Column(s)
titip_faktur_pkey Primary key Asc id
titip_faktur_nomor_unique Must be unique Asc nomor

Relationships

Close relationships within degrees of separation