SchemaSpy Analysis of sola.opentenure - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue May 31 09:57 NZST 2016
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

sola.opentenure contains 238 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
field_payload boolean_payload bool 1  √  null Boolean field value.
form_template is_default bool 1 false Indicates whether form is default for all new claims.
party is_person bool 1 true Indicates if record is for individual or company (legal entity)
attachment 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).
claim 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).
claim_comment 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).
claim_location 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).
claim_share 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).
claim_uses_attachment 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).
field_constraint change_action bpchar 1 'i'::bpchar
field_constraint_option 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).
field_payload 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).
field_template 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).
form_payload 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).
form_template 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).
party 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).
party_for_claim_share 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).
section_element_payload 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).
section_payload 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).
section_template 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).
claim_status status bpchar 1 't'::bpchar Status of the service claim.
field_constraint_type status bpchar 1 'c'::bpchar Status of the constraint type.
field_type status bpchar 1 'c'::bpchar Status of the field type.
field_value_type status bpchar 1 'c'::bpchar Status of the field value type.
rejection_reason status bpchar 1 't'::bpchar Status of the rejection reason.
attachment body bytea 2147483647 Binary content of the attachment.
attachment_chunk body bytea 2147483647 The content of the chunk.
party birth_date date 13  √  null Date of birth of the party.
attachment document_date date 13  √  null Document date.
claim start_date date 13  √  null Start date of right (occupation)
claim_share percentage float8 17,17  √  null Percentage of the share. Another form of nominator/denominator presentation.
claim gps_geometry geometry 2147483647  √  null Claimed property geometry in Lat/Long format
claim_location gps_location geometry 2147483647  √  null Additional claim location geometry in Lat/Long format.
claim mapped_geometry geometry 2147483647  √  null Claimed property geometry calculated using system SRID
claim_location mapped_location geometry 2147483647 Additional claim location geometry.
claim_share denominator int2 5  √  null Denominator part of the share (i.e. bottom number of fraction)
claim_share nominator int2 5  √  null Nominiator part of the share (i.e. top number of fraction)
field_constraint_option item_order int4 10 1 Field constraint option ordering number.
field_payload item_order int4 10 1 Field ordering number.
field_template item_order int4 10 1 Field ordering number.
section_payload item_order int4 10 1 Section ordering number.
section_template item_order int4 10 1 Section ordering number.
section_payload max_occurrences int4 10 Maximum occurane of the section elements on the form. If max > 1, UI will be shown as a table.
section_template max_occurrences int4 10 Maximum occurane of the section elements on the form. If max > 1, UI will be shown as a table.
section_payload min_occurrences int4 10 Minimum occurane of the section elements on the form.
section_template min_occurrences int4 10 Minimum occurane of the section elements on the form.
attachment rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
claim rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
claim_comment rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
claim_location rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
claim_share rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
claim_uses_attachment rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
field_constraint rowversion int4 10 0
field_constraint_option rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
field_payload rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
field_template rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
form_payload rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
form_template rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
party rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
party_for_claim_share rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
section_element_payload rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
section_payload rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
section_template rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
claim claim_area int8 19  √  0 Claim area in square meters.
attachment size int8 19 File size.
attachment_chunk size int8 19 Size of the chunk in bytes.
attachment_chunk start_position int8 19 Staring position of the byte in the source/destination document
field_payload big_decimal_payload numeric 20,10  √  null Decimal or integer field value.
field_constraint max_value numeric 20,10  √  null Maximum field value, used in range constraint.
field_constraint min_value numeric 20,10  √  null Minimum field value, used in range constraint.
claim challenge_expiry_date timestamp 29,6  √  null Expiration date when challenge claim can be submitted.
attachment change_time timestamp 29,6 now() The date and time the row was last modified.
claim change_time timestamp 29,6 now() The date and time the row was last modified.
claim_comment change_time timestamp 29,6 now() The date and time the row was last modified.
claim_location change_time timestamp 29,6 now() The date and time the row was last modified.
claim_share change_time timestamp 29,6 now() The date and time the row was last modified.
claim_uses_attachment change_time timestamp 29,6 now() The date and time the row was last modified.
field_constraint change_time timestamp 29,6 now()
field_constraint_option change_time timestamp 29,6 now() The date and time the row was last modified.
field_payload change_time timestamp 29,6 now() The date and time the row was last modified.
field_template change_time timestamp 29,6 now() The date and time the row was last modified.
form_payload change_time timestamp 29,6 now() The date and time the row was last modified.
form_template change_time timestamp 29,6 now() The date and time the row was last modified.
party change_time timestamp 29,6 now() The date and time the row was last modified.
party_for_claim_share change_time timestamp 29,6 now() The date and time the row was last modified.
section_element_payload change_time timestamp 29,6 now() The date and time the row was last modified.
section_payload change_time timestamp 29,6 now() The date and time the row was last modified.
section_template change_time timestamp 29,6 now() The date and time the row was last modified.
attachment_chunk creation_time timestamp 29,6 now() Date and time when chuck was created.
claim_comment creation_time timestamp 29,6 now() The date and time when comment was created.
claim decision_date timestamp 29,6  √  null The decision date on the claim by the authority.
claim lodgement_date timestamp 29,6  √  null The lodgement date and time of the claim.
attachment file_extension varchar 5 File extension of the attachment. E.g. pdf, tiff, doc, etc
party mobile_phone varchar 15  √  null Mobile phone number of the party.
claim nr varchar 15 Auto generated claim number. Generated by the generate-claim-nr business rule when the claim record is initially saved.
party phone varchar 15  √  null Landline phone number of the party.
claim_status code varchar 20 The code for the claim status.
rejection_reason code varchar 20 The code for the rejection reason.
party gender_code varchar 20  √  null Gender code of the party.
party id_number varchar 20  √  null ID document number.
party id_type_code varchar 20  √  null ID document type code
claim land_use_code varchar 20  √  null Land use code
claim rejection_reason_code varchar 20  √  null Rejection reason code.
claim status_code varchar 20 'created'::character varying The status of the claim.
attachment type_code varchar 20 Attached document type code.
claim type_code varchar 20  √  null Type of claim (e.g. ownership, usufruct, occupation).
attachment_chunk attachment_id varchar 40 Attachment ID, which will be used to create final document object. Used to group all chunks together.
claim_uses_attachment attachment_id varchar 40 Identifier of the attachment associated to the claim.
claim challenged_claim_id varchar 40  √  null The identifier of the challenged claim. If this value is provided, it means the record is a claim challenge type.
attachment_chunk claim_id varchar 40  √  null Claim ID. Used to clean the table when saving claim. It will guarantee that no orphan chunks left in the table.
claim_comment claim_id varchar 40 Identifier for the claim.
claim_location claim_id varchar 40 Identifier for the claim.
claim_share claim_id varchar 40 Identifier of the claim the share is assocaited with.
claim_uses_attachment claim_id varchar 40 Identifier for the claim the record is associated to.
form_payload claim_id varchar 40 Foreign key to the parent claim object.
party_for_claim_share claim_share_id varchar 40 Identifier of the claim share.
claim claimant_id varchar 40 The identifier of the claimant.
field_constraint_option field_constraint_id varchar 40 Field constraint ID.
field_constraint field_template_id varchar 40 Field template id, which constraint relates to.
section_payload form_payload_id varchar 40 Foreign key reference to form payload.
attachment id varchar 40 uuid_generate_v1() Identifier for the attachment.
attachment_chunk id varchar 40 uuid_generate_v1() Unique ID of the chunk
claim id varchar 40 Identifier for the claim.
claim_comment id varchar 40 Identifier for the claim comment.
claim_location id varchar 40 Identifier for the claim location.
claim_share id varchar 40 Identifier for the claim share.
field_constraint id varchar 40 Primary key.
field_constraint_option id varchar 40 Primary key.
field_payload id varchar 40 Primary key.
field_template id varchar 40 Primary key.
form_payload id varchar 40 Primary key.
party id varchar 40 uuid_generate_v1() Unique identifier for the party.
section_element_payload id varchar 40
section_payload id varchar 40 Primary key.
section_template id varchar 40
party_for_claim_share party_id varchar 40 Identifier for the party.
attachment rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the document_historic table
claim rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the claim_historic table.
claim_comment rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the claim_historic table.
claim_location rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the claim_historic table.
claim_share rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the claim_share_historic table
claim_uses_attachment rowidentifier varchar 40 uuid_generate_v1() Unique row identifier.
field_constraint rowidentifier varchar 40 uuid_generate_v1()
field_constraint_option rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the form historic table.
field_payload rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the form historic table.
field_template rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the form historic table.
form_payload rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the form historic table.
form_template rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the form historic table.
party rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the document_historic table
party_for_claim_share rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the party_for_claim_share_historic table
section_element_payload rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the form historic table.
section_payload rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the form historic table.
section_template rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the form historic table.
field_payload section_element_payload_id varchar 40 Section element id.
section_element_payload section_payload_id varchar 40 Section payload ID.
field_template section_template_id varchar 40 Section template ID.
claim assignee_name varchar 50  √  null User name who is assigned to work with claim
attachment change_user varchar 50  √  null The user id of the last person to modify the row.
claim change_user varchar 50  √  null The user id of the last person to modify the row.
claim_comment change_user varchar 50  √  null The user id of the last person to modify the row.
claim_location change_user varchar 50  √  null The user id of the last person to modify the row.
claim_share change_user varchar 50  √  null The user id of the last person to modify the row.
claim_uses_attachment change_user varchar 50  √  null The user id of the last person to modify the row.
field_constraint change_user varchar 50  √  null
field_constraint_option change_user varchar 50  √  null The user id of the last person to modify the row.
field_payload change_user varchar 50  √  null The user id of the last person to modify the row.
field_template change_user varchar 50  √  null The user id of the last person to modify the row.
form_payload change_user varchar 50  √  null The user id of the last person to modify the row.
form_template change_user varchar 50  √  null The user id of the last person to modify the row.
party change_user varchar 50  √  null The user id of the last person to modify the row.
party_for_claim_share change_user varchar 50  √  null The user id of the last person to modify the row.
section_element_payload change_user varchar 50  √  null The user id of the last person to modify the row.
section_payload change_user varchar 50  √  null The user id of the last person to modify the row.
section_template change_user varchar 50  √  null The user id of the last person to modify the row.
claim_comment comment_user varchar 50 The user id who has created comment.
party email varchar 50  √  null Email address of the party.
party last_name varchar 50  √  null Last name of claimant.
attachment_chunk md5 varchar 50  √  null Checksum of the chunk, calculated using MD5.
claim recorder_name varchar 50 User's ID, who has created the claim.
attachment user_name varchar 50 User's ID, who has created the attachment.
attachment_chunk user_name varchar 50 User's id (name), who has loaded the chunk
party user_name varchar 50 User name who has created the record.
claim description varchar 250  √  null Free description of the claim.
party address varchar 255  √  null Living address of the party.
field_constraint_type code varchar 255 The code for the constraint type.
field_type code varchar 255 The code for the field type.
field_value_type code varchar 255 The code for the field value type.
attachment description varchar 255  √  null Short document description.
field_constraint display_name varchar 255 Value to be used as a visible text (header) of UI component.
field_constraint_option display_name varchar 255 Value to be used as a visible text of UI component.
field_payload display_name varchar 255 Value to be used as a visible text of UI component.
field_template display_name varchar 255 Value to be used as a visible text (header) of UI component.
form_template display_name varchar 255 Form name, which can be used for displaying on the UI.
section_payload display_name varchar 255 Value to be used as a visible text (header) of UI component.
section_template display_name varchar 255 Value to be used as a visible text (header) of UI component.
section_payload element_display_name varchar 255 Text value to be used as a visible label of the section element UI component.
section_template element_display_name varchar 255 Text value to be used as a visible label of the section element UI component.
section_payload element_name varchar 255 Section element name to be used as UI component name.
section_template element_name varchar 255 Section element name to be used as UI component name.
field_constraint error_msg varchar 255 Error message to display in case of constraint violation.
section_template error_msg varchar 255 Error message to show when min/max conditions are not met.
field_constraint field_constraint_type varchar 255 Type of constraint.
field_payload field_type varchar 255 Field type code.
field_template field_type varchar 255 Field type code.
field_payload field_value_type varchar 255
attachment file_name varchar 255 Actual file name of the attachment.
form_payload form_template_name varchar 255 Foreign key to relevant dynamic form template.
section_template form_template_name varchar 255 Foreign key reference to form template.
field_constraint format varchar 255  √  null Regular expression, used to check field value
field_template hint varchar 255  √  null Field hint to be used for UI component.
attachment mime_type varchar 255 Mime type of the attachment.
field_constraint name varchar 255 Field name to be used as UI component name.
field_constraint_option name varchar 255 Field name to be used as UI component name.
field_payload name varchar 255 Field name to be used as UI component name.
field_template name varchar 255 Field name to be used as UI component name.
form_template name varchar 255
party name varchar 255 First name of party.
section_payload name varchar 255 Section name to be used as UI component name.
section_template name varchar 255 Section name to be used as UI component name.
attachment reference_nr varchar 255  √  null Document reference number.
claim_comment comment varchar 500 Comment text.
claim_location description varchar 500  √  null Claim location description.
claim_status display_value varchar 500 Displayed value of the claim status.
field_constraint_type display_value varchar 500 Displayed value of the constraint type.
field_type display_value varchar 500 Displayed value of the field type.
field_value_type display_value varchar 500 Displayed value of the field value type.
claim east_adjacency varchar 500  √  null Optional information about adjacency on the east
claim north_adjacency varchar 500  √  null Optional information about adjacency on the north
claim south_adjacency varchar 500  √  null Optional information about adjacency on the south
claim west_adjacency varchar 500  √  null Optional information about adjacency on the west
claim_status description varchar 1000  √  null Description of the claim status.
field_constraint_type description varchar 1000  √  null Description of the constraint type.
field_type description varchar 1000  √  null Description of the field type.
field_value_type description varchar 1000  √  null Description of the field value type.
rejection_reason description varchar 1000  √  null Description of the rejection reason.
claim notes varchar 1000  √  null Any note that could be usefully stored as part of the claim
rejection_reason display_value varchar 2000 Displayed value of the rejection reason.
field_payload string_payload varchar 2048  √  null String field value.