Table sola.transaction.reg_status_type
Code list of registration status types. E.g. current, historic, pending, previous.
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
ba_unit.status_code ba_unit_status_code_fk39 R
br_validation.target_reg_moment br_validation_target_reg_moment_fk115 R
cadastre_object.status_code cadastre_object_status_code_fk63 R
notation.status_code notation_status_code_fk74 R
rrr.status_code rrr_status_code_fk43 R
source.status_code source_status_code_fk4 R
The code for the registration status type.
display_value varchar 500 Displayed value of the registration status type.
description varchar 1000  √  null Description of the registration status type.
status bpchar 1 Status of the registration status type

Analyzed at Tue May 31 09:59 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
code Primary key Asc reg_status_type_pkey
display_value Must be unique Asc reg_status_type_display_value_unique

Close relationships  within of separation:

Excluded from diagram's relationships: transaction_source.change_action  transaction.change_time  transaction_source.rowidentifier  transaction.change_action  transaction.rowidentifier  transaction.rowversion  transaction_source.rowversion  transaction_source.change_user  transaction.change_user  transaction_source.change_time