app_perform_goal

0 rows


Description

The main table for perform goals

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_perform_goal_id_seq'::regclass)
app_perform_goal_activity.goal_id Defined in XML R
app_perform_goal_perform_status_change.goal_id Defined in XML R
context_id int8 19 null
app_context.id Defined in XML R
category_id int8 19 null
app_perform_goal_category.id Defined in XML R
owner_id int8 19 √ null
app_user.id Defined in XML R
user_id int8 19 √ null
app_user.id Defined in XML R
name varchar 1024 ''::character varying
id_number varchar 100 √ null
description text 2147483647 √ null
start_date int8 19 null
target_type varchar 100 ''::character varying
target_date int8 19 null
target_value numeric 20,5 null
current_value numeric 20,5 null
current_value_updated_at int8 19 √ null
status varchar 255 ''::character varying
status_updated_at int8 19 null
closed_at int8 19 √ null
created_at int8 19 null
updated_at int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_perfgoal_id_pk Primary key Asc id
app_perfgoal_cat_ix Performance Asc category_id
app_perfgoal_clo_ix Performance Asc closed_at
app_perfgoal_con_ix Performance Asc context_id
app_perfgoal_id__ix Performance Asc id_number
app_perfgoal_own_ix Performance Asc owner_id
app_perfgoal_sta2_ix Performance Asc status
app_perfgoal_sta3_ix Performance Asc status_updated_at
app_perfgoal_sta_ix Performance Asc start_date
app_perfgoal_tar_ix Performance Asc target_date
app_perfgoal_use_ix Performance Asc user_id

Relationships

Close relationships within degrees of separation