app_approval_application_activity

0 rows


Description

Table to store application event logs

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_approval_application_activity_id_seq'::regclass)
application_id int8 19 null
app_approval_application.id Defined in XML R
workflow_stage_id int8 19 null
app_approval_workflow_stage.id Defined in XML R
workflow_stage_approval_level_id int8 19 null
app_approval_workflow_stage_approval_level.id Defined in XML R
user_id int8 19 null
app_user.id Defined in XML R
timestamp int8 19 null
activity_type int2 5 null
activity_info text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
app_apprapplacti_id2_pk Primary key Asc id
app_apprapplacti_act_ix Performance Asc activity_type
app_apprapplacti_app2_ix Performance Asc application_id
app_apprapplacti_use2_ix Performance Asc user_id
app_apprapplacti_wor2_ix Performance Asc workflow_stage_id
app_apprapplacti_wor3_ix Performance Asc workflow_stage_approval_level_id

Relationships