action

-1 rows


Description

Represents a concrete action recorded by the case management system. All actions have an actor and the date/time they occurred.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
action_guid uuid 2147483647 case_management.uuid_generate_v4()

System generated unique key for the action. This key should never be exposed to users via any system utilizing the tables.
case_guid uuid 2147483647 null
case_file.case_file_guid FK_action__case_guid R

System generated unique key for a case. This key should never be exposed to users via any system utilizing the tables.
action_type_action_xref_guid uuid 2147483647 null
action_type_action_xref.action_type_action_xref_guid FK_action_action_type_action_xref R

System generated unique key for a relationship between case management actions and logical types. This key should never be exposed to users via any system utilizing the tables.
actor_guid uuid 2147483647 null

Represents the IDIR guid of the user who performed the action.
action_date timestamp 29,6 null

The date the action was recorded. This value is user entered.
active_ind bool 1 √ null

A boolean indicator to determine if the action is active and should be displayed in the application.
create_user_id varchar 32 null

The id of the user that created the case.
create_utc_timestamp timestamp 29,6 null

The timestamp when the case was created. The timestamp is stored in UTC with no Offset.
update_user_id varchar 32 √ null

The id of the user that updated the case.
update_utc_timestamp timestamp 29,6 √ null

The timestamp when the case was updated. The timestamp is stored in UTC with no Offset.
equipment_guid uuid 2147483647 √ null
equipment.equipment_guid fk_action__equipment_guid R

System generated unique key for a piece of equipment. This key should never be exposed to users via any system utilizing the tables.
wildlife_guid uuid 2147483647 √ null
wildlife.wildlife_guid fk_action__wildlife_guid R
decision_guid uuid 2147483647 √ null
decision.decision_guid fk_action__decision_guid R
case_note_guid uuid 2147483647 √ null
case_note.case_note_guid FK_action__case_note_guid R

Relates to case_note for note related actions such as UPDATENOTE.

Indexes

Constraint Name Type Sort Column(s)
PK_action_guid Primary key Asc action_guid

Relationships

Close relationships within degrees of separation