Table sola.opentenure.claim
Main table to store claim and claim challenge information submitted by the community recorders. SOLA Open Tenure extention.

 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
id varchar 40
claim.challenged_claim_id fk_challenged_claim R
claim_comment.claim_id claim_comment_claim_id_fk8 C
claim_location.claim_id claim_location_claim_id_fk8 C
claim_share.claim_id claim_share_claim_id_fk12 C
claim_uses_attachment.claim_id claim_uses_attachment_claim_id_fk126 C
form_payload.claim_id form_payload_claim_id_fkey C
Identifier for the claim.
nr varchar 15 Auto generated claim number. Generated by the generate-claim-nr business rule when the claim record is initially saved.
lodgement_date timestamp 29,6  √  null The lodgement date and time of the claim.
challenge_expiry_date timestamp 29,6  √  null Expiration date when challenge claim can be submitted.
decision_date timestamp 29,6  √  null The decision date on the claim by the authority.
description varchar 250  √  null Free description of the claim.
challenged_claim_id varchar 40  √  null
claim.id fk_challenged_claim R
The identifier of the challenged claim. If this value is provided, it means the record is a claim challenge type.
claimant_id varchar 40
party.id claim_claimant_id_fk8 R
The identifier of the claimant.
mapped_geometry geometry 2147483647  √  null Claimed property geometry calculated using system SRID
gps_geometry geometry 2147483647  √  null Claimed property geometry in Lat/Long format
status_code varchar 20 'created'::character varying
claim_status.code claim_status_code_fk18 R
The status of the claim.
recorder_name varchar 50 User's ID, who has created the claim.
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the claim_historic table.
rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
change_user varchar 50  √  null The user id of the last person to modify the row.
change_time timestamp 29,6 now() The date and time the row was last modified.
type_code varchar 20  √  null
rrr_type.code claim_fk_type_code R
Type of claim (e.g. ownership, usufruct, occupation).
start_date date 13  √  null Start date of right (occupation)
land_use_code varchar 20  √  null
land_use_type.code fk_claim_land_use_type R
Land use code
notes varchar 1000  √  null Any note that could be usefully stored as part of the claim
north_adjacency varchar 500  √  null Optional information about adjacency on the north
south_adjacency varchar 500  √  null Optional information about adjacency on the south
east_adjacency varchar 500  √  null Optional information about adjacency on the east
west_adjacency varchar 500  √  null Optional information about adjacency on the west
assignee_name varchar 50  √  null User name who is assigned to work with claim
rejection_reason_code varchar 20  √  null
rejection_reason.code fk_claim_rejection_reason_code R
Rejection reason code.
claim_area int8 19  √  0 Claim area in square meters.

Analyzed at Tue May 31 09:57 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc claim_pkey

Close relationships  within of separation:

Excluded from diagram's relationships: field_payload.rowversion  section_payload.rowversion  party.rowidentifier  form_payload.change_user  form_template.rowidentifier  section_payload.change_user  claim_share.change_action  claim_uses_attachment.change_time  section_template.rowidentifier  party.change_user  section_template.rowversion  field_template.change_action  claim_share.change_time  claim_uses_attachment.change_action  attachment.change_time  claim_location.rowidentifier  field_constraint.change_action  claim_share.rowversion  field_constraint_option.rowversion  field_payload.change_user  party_for_claim_share.change_user  attachment.change_user  claim_uses_attachment.change_user  section_element_payload.change_action  party.change_action  field_constraint_option.change_action  claim_comment.rowidentifier  field_payload.change_action  party_for_claim_share.rowversion  section_template.change_user  section_element_payload.change_time  section_payload.rowidentifier  section_payload.change_action  form_payload.change_action  party_for_claim_share.change_time  field_template.rowidentifier  form_payload.rowversion  party_for_claim_share.change_action  field_constraint.rowidentifier  field_constraint_option.change_time  field_constraint.change_user  claim_share.change_user  field_template.rowversion  field_payload.rowidentifier  claim_location.change_action  attachment.rowversion  field_template.change_time  claim_share.rowidentifier  claim_comment.change_time  party_for_claim_share.rowidentifier  field_constraint_option.rowidentifier  form_template.rowversion  party.change_time  attachment.rowidentifier  claim_uses_attachment.rowidentifier  field_payload.change_time  claim_comment.change_action  section_element_payload.rowversion  form_template.change_action  section_template.change_action  field_constraint_option.change_user  party.rowversion  claim_comment.rowversion  form_template.change_time  section_payload.change_time  claim_uses_attachment.rowversion  form_template.change_user  field_constraint.rowversion  section_template.change_time  section_element_payload.change_user  field_constraint.change_time  form_payload.change_time  claim_location.rowversion  section_element_payload.rowidentifier  claim_comment.change_user  field_template.change_user  claim_location.change_time  claim_location.change_user  attachment.change_action  form_payload.rowidentifier