rencana_kunjungan_salesman_detail

35807 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
rencana_kunjungan_salesman.id rencana_kunjungan_salesman_detail_id_rencana_kunjungan_salesman R
urut int4 10 null
id_customer int4 10 null
customer.id rencana_kunjungan_salesman_detail_id_customer_customer_id_fk R
foto _text 2147483647 √ null
is_lapangan bool 1 false
id_tipe_kunjungan int4 10 √ null
tipe_kunjungan.id rencana_kunjungan_salesman_detail_id_tipe_kunjungan_tipe_kunjun R
target_rp numeric 0 '0'::numeric
target_persen numeric 0 '0'::numeric
avg_dpp numeric 0 '0'::numeric
keterangan text 2147483647 √ null
waktu_kunjungan timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
rencana_kunjungan_salesman_detail_id_id_customer_unique Must be unique Asc/Asc id + id_customer

Relationships

Close relationships within degrees of separation