klaim_loyalty

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('klaim_loyalty_id_seq'::regclass)
klaim_loyalty_detail.id klaim_loyalty_detail_id_klaim_loyalty_id_fk R
tanggal date 13 null
periode_awal date 13 null
periode_akhir date 13 null
target_rp numeric 0 '0'::numeric
target_persen numeric 0 '0'::numeric
reward jsonb 2147483647 null
nomor varchar 2147483647 null
id_kontrak_loyalty int4 10 null
kontrak_loyalty.id klaim_loyalty_id_kontrak_loyalty_kontrak_loyalty_id_fk R
jenis_klaim varchar 2147483647 'T'::character varying
grandtotal numeric 0 '0'::numeric
catatan text 2147483647 null
status char 1 null
created_by int4 10 null
pegawai.id klaim_loyalty_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id klaim_loyalty_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)
klaim_loyalty_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation