target_penjualan

3143 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('target_penjualan_id_seq'::regclass)
insentif_salesman.id_target_penjualan insentif_salesman_id_target_penjualan_fkey R
target_penjualan.id_target_penjualan target_penjualan_id_target_penjualan_target_penjualan_id_fk R
target_penjualan_persetujuan.id target_penjualan_persetujuan_id_target_penjualan_id_fk R
nomor varchar 2147483647 null
tanggal date 13 null
periode date 13 null
catatan text 2147483647 null
status bpchar 1 null
created_by int4 10 null
pegawai.id target_penjualan_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id target_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
target numeric 0 '0'::numeric
reff varchar 2147483647 null
id_reff int4 10 null
id_target_penjualan int4 10 √ null
target_penjualan.id target_penjualan_id_target_penjualan_target_penjualan_id_fk R
id_atasan int4 10 √ null
pegawai.id target_penjualan_id_atasan_pegawai_id_fk R
nama_pegawai varchar 2147483647 ''::character varying
nama_atasan varchar 2147483647 ''::character varying
id_pengganti int4 10 √ null
pegawai.id target_penjualan_id_pengganti_fkey R
nama_pengganti varchar 2147483647 ''::character varying

Indexes

Constraint Name Type Sort Column(s)
target_penjualan_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation