Table sola.application.type_action
Code list of request type actions. Identifies what actions the Property Details screen should support for RRRs when processing a service. One of new, vary or cancel.
Tags: FLOSS SOLA Extension, Reference Table

Generated by
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
request_type.type_action_code request_type_type_action_code_fk23 R
The code for the request type action.
display_value varchar 500 Displayed value of the request type action.
description varchar 1000  √  null Description of the request type action.
status bpchar 1 't'::bpchar Status of the request type action.

Analyzed at Tue May 31 09:57 NZST 2016

Column(s) Type Sort Constraint Name
code Primary key Asc type_action_pkey
display_value Must be unique Asc type_action_display_value_unique

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