pengajuan_perubahan_limit

666 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('pengajuan_perubahan_limit_id_seq'::regclass)
pengajuan_perubahan_limit_persetujuan.id pengajuan_perubahan_limit_persetujuan_id_pengajuan_perubahan_li R
nomor varchar 20 null
tanggal date 13 null
tanggal_perubahan date 13 null
id_customer int4 10 null
customer.id pengajuan_perubahan_limit_id_customer_customer_id_fk R
id_salesman int4 10 null
pegawai.id pengajuan_perubahan_limit_id_salesman_pegawai_id_fk R
id_spv int4 10 null
pegawai.id pengajuan_perubahan_limit_id_spv_pegawai_id_fk R
top_sebelum int4 10 0
top_sesudah int4 10 0
saldo_piutang_sebelum numeric 0 null
saldo_piutang_sesudah numeric 0 null
catatan text 2147483647 √ null
status bpchar 1 null
created_by int4 10 null
pegawai.id pengajuan_perubahan_limit_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id pengajuan_perubahan_limit_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

Indexes

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

Relationships

Close relationships within degrees of separation