pa_measure

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pa_measure_id numeric 10 null
pa_achievement.pa_measure_id pameasure_paachievement R
pa_goal.pa_measure_id pameasure_pagoal R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
measuretype bpchar 1 null
manualactual numeric 0 √ null
manualnote varchar 2000 √ null
calculationclass varchar 60 √ null
pa_measurecalc_id numeric 10 √ null
pa_measurecalc.pa_measurecalc_id pameasurecalc_pameasure R
pa_benchmark_id numeric 10 √ null
pa_benchmark.pa_benchmark_id pabenchmark_pameasure R
pa_ratio_id numeric 10 √ null
pa_ratio.pa_ratio_id paratio_pameasure R
pa_hierarchy_id numeric 10 √ null
pa_hierarchy.pa_hierarchy_id pahierarchy_pameasure R
measuredatatype bpchar 1 null
r_requesttype_id numeric 10 √ null
r_requesttype.r_requesttype_id rrequesttype_pameasure R
c_projecttype_id numeric 10 √ null
c_projecttype.c_projecttype_id cprojecttype_pameasure R
pa_measure_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
pa_measure_pkey Primary key Asc pa_measure_id
pa_measure_uu_idx Must be unique Asc pa_measure_uu

Check Constraints

Constraint Name Constraint
pa_measure_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation