| SchemaSpy Analysis of sola.applicationExtension to the LADM used by SOLA to implement Case Management functionality. | Generated by SchemaSpy |
| Generated by SchemaSpy on Tue May 31 09:57 NZST 2016 | |
| Database Type: PostgreSQL - 9.4.6 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table / View | Children | Parents | Columns | Comments |
|---|---|---|---|---|
| application | 4 | 5 | 25 | Applications capture details and manage requests received by the land administration agency to change, update or report on land registry and/or cadastre information. Applications have a lifecycle and transition into different states as the land administration agency processes the request that instigated the application. The primary role of an application is to implement case management functionality in SOLA. Tags: FLOSS SOLA Extension, Change History |
| application_action_type | 2 | 1 | 5 | Code list of action types. Tags: FLOSS SOLA Extension, Reference Table |
| application_property | 3 | 15 | Captures details of property associated to an application. Tags: FLOSS SOLA Extension, Change History |
|
| application_spatial_unit | 2 | 7 | Captures details of parcels (a.k.a. Cadastre Objects or Spatial Units) associated to an application. Tags: FLOSS SOLA Extension, Change History |
|
| application_status_type | 2 | 4 | Code list of application status types. Tags: FLOSS SOLA Extension, Reference Table |
|
| application_uses_source | 2 | 7 | Links the application to the sources (a.k.a. documents) submitted with the application. Tags: FLOSS SOLA Extension, Change History |
|
| cancel_notification | 12 | |||
| Function: get_concatenated_name | 0 | Returns a concatenated list of all cadastre objects associated to the BA Unit referenced by the application. | ||
| Function: get_work_summary | 0 | Returns a summary of the services processed for a specified reporting period. Used by the Lodgement Statistics Report. | ||
| Function: getlodgement | 0 | Not used. Replaced by get_work_summary. | ||
| Function: getlodgetiming | 0 | Not used. Replaced by get_work_summary. | ||
| request_category_type | 1 | 4 | Code list of request category types. Request category types group the request types into logical groupings such as request types for registration or cadastral changes. Tags: FLOSS SOLA Extension, Reference Table |
|
| request_type | 3 | 4 | 15 | Code list of request types. Request types identify the different types of services provided by the land administration agency. SOLA includes a default set of request types that can be reconfigured to match those required by the land administration agency. Tags: FLOSS SOLA Extension, Reference Table |
| request_type_requires_source_type | 2 | 2 | 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 |
|
| Sequence: application_nr_seq | 0 | Sequence number used as the basis for the Application nr field. This sequence is used by the generate-application-nr business rule. | ||
| service | 1 | 4 | 17 | Used to control the type of change an application can make to the land registry and/or cadastre information recorded in SOLA. Services broadly identify the actions the land administration agency will undertake for the application. Every application lodged in SOLA must include at least one service. SOLA includes a default set of request types that can be reconfigured to match those services required by the land administration agency. Tags: FLOSS SOLA Extension, Change History |
| service_action_type | 2 | 1 | 5 | 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 |
| service_status_type | 2 | 4 | Code list of service status types. Tags: FLOSS SOLA Extension, Reference Table |
|
| systematic_registration_certificates | 4 | Used by systematic registration to identify parcels that require a certificate to be generated. | ||
| type_action | 1 | 4 | 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 |
|
| 18 Tables | 114 | |||
| 2 Views | 16 |