Table sola.application.request_type_requires_source_type
Identifies the types of sources (a.k.a. documents) that must be provided before a service can be processed by the land administration agency.
Tags: FLOSS SOLA Extension

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
source_type_code varchar 20
administrative_source_type.code request_type_requires_source_type_source_type_code_fk128 C
The source type required by the request type.
request_type_code varchar 20
request_type.code request_type_requires_source_type_request_type_code_fk129 C
The request type that requries the source to be present on the application.

Analyzed at Tue May 31 09:57 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
source_type_code + request_type_code Primary key Asc/Asc request_type_requires_source_type_pkey
request_type_code Performance Asc request_type_requires_source_type_request_type_code_fk129_ind
source_type_code Performance Asc request_type_requires_source_type_source_type_code_fk128_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