Table sola.application.service_action_type
Code list of service action types. Service actions identify the actions user can perform against services. E.g. lodge, start, revert, cancel, complete.
Tags: FLOSS SOLA Extension, Reference Table

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
code varchar 20
br_validation.target_service_moment br_validation_target_service_moment_fk114 R
service.action_code service_action_code_fk25 R
The code for the service action type.
display_value varchar 500 Displayed value of the service action type.
status_to_set varchar 20  √  null
service_status_type.code service_action_type_status_to_set_fk26 R
The status to set on the service when the service action is applied.
status bpchar 1 't'::bpchar Status of the service action type
description varchar 1000  √  null Description of the service action type.

Analyzed at Tue May 31 09:57 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
code Primary key Asc service_action_type_pkey
display_value Must be unique Asc service_action_type_display_value_unique
status_to_set Performance Asc service_action_type_status_to_set_fk26_ind

Close relationships  within of separation:

Excluded from diagram's relationships: application_property.rowidentifier  application_property.change_user  service.rowidentifier  application.rowidentifier  application_spatial_unit.rowversion  service.change_action  application.change_action  application.change_time  application_uses_source.rowversion  application_uses_source.change_time  application_uses_source.rowidentifier  application_spatial_unit.rowidentifier  application.rowversion  application.change_user  application_uses_source.change_user  service.change_user  application_property.rowversion  service.rowversion  application_property.change_action  application_property.change_time  application_spatial_unit.change_time  application_spatial_unit.change_user  service.change_time  application_uses_source.change_action  application_spatial_unit.change_action