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
party address varchar 255  √  null
claim assignee_name varchar 50  √  null
attachment_chunk attachment_id varchar 40
claim_uses_attachment attachment_id varchar 40
field_payload big_decimal_payload numeric 20,10  √  null
party birth_date date 13  √  null
attachment body bytea 2147483647
attachment_chunk body bytea 2147483647
field_payload boolean_payload bool 1  √  null
claim challenge_expiry_date timestamp 29,6  √  null
claim challenged_claim_id varchar 40  √  null
attachment change_action bpchar 1 'i'::bpchar
claim change_action bpchar 1 'i'::bpchar
claim_comment change_action bpchar 1 'i'::bpchar
claim_location change_action bpchar 1 'i'::bpchar
claim_share change_action bpchar 1 'i'::bpchar
claim_uses_attachment change_action bpchar 1 'i'::bpchar
field_constraint change_action bpchar 1 'i'::bpchar
field_constraint_option change_action bpchar 1 'i'::bpchar
field_payload change_action bpchar 1 'i'::bpchar
field_template change_action bpchar 1 'i'::bpchar
form_payload change_action bpchar 1 'i'::bpchar
form_template change_action bpchar 1 'i'::bpchar
party change_action bpchar 1 'i'::bpchar
party_for_claim_share change_action bpchar 1 'i'::bpchar
section_element_payload change_action bpchar 1 'i'::bpchar
section_payload change_action bpchar 1 'i'::bpchar
section_template change_action bpchar 1 'i'::bpchar
attachment change_time timestamp 29,6 now()
claim change_time timestamp 29,6 now()
claim_comment change_time timestamp 29,6 now()
claim_location change_time timestamp 29,6 now()
claim_share change_time timestamp 29,6 now()
claim_uses_attachment change_time timestamp 29,6 now()
field_constraint change_time timestamp 29,6 now()
field_constraint_option change_time timestamp 29,6 now()
field_payload change_time timestamp 29,6 now()
field_template change_time timestamp 29,6 now()
form_payload change_time timestamp 29,6 now()
form_template change_time timestamp 29,6 now()
party change_time timestamp 29,6 now()
party_for_claim_share change_time timestamp 29,6 now()
section_element_payload change_time timestamp 29,6 now()
section_payload change_time timestamp 29,6 now()
section_template change_time timestamp 29,6 now()
attachment change_user varchar 50  √  null
claim change_user varchar 50  √  null
claim_comment change_user varchar 50  √  null
claim_location change_user varchar 50  √  null
claim_share change_user varchar 50  √  null
claim_uses_attachment change_user varchar 50  √  null
field_constraint change_user varchar 50  √  null
field_constraint_option change_user varchar 50  √  null
field_payload change_user varchar 50  √  null
field_template change_user varchar 50  √  null
form_payload change_user varchar 50  √  null
form_template change_user varchar 50  √  null
party change_user varchar 50  √  null
party_for_claim_share change_user varchar 50  √  null
section_element_payload change_user varchar 50  √  null
section_payload change_user varchar 50  √  null
section_template change_user varchar 50  √  null
claim claim_area int8 19  √  0
attachment_chunk claim_id varchar 40  √  null
claim_comment claim_id varchar 40
claim_location claim_id varchar 40
claim_share claim_id varchar 40
claim_uses_attachment claim_id varchar 40
form_payload claim_id varchar 40
party_for_claim_share claim_share_id varchar 40
claim claimant_id varchar 40
claim_status code varchar 20
field_constraint_type code varchar 255
field_type code varchar 255
field_value_type code varchar 255
rejection_reason code varchar 20
claim_comment comment varchar 500
claim_comment comment_user varchar 50
attachment_chunk creation_time timestamp 29,6 now()
claim_comment creation_time timestamp 29,6 now()
claim decision_date timestamp 29,6  √  null
claim_share denominator int2 5  √  null
attachment description varchar 255  √  null
claim description varchar 250  √  null
claim_location description varchar 500  √  null
claim_status description varchar 1000  √  null
field_constraint_type description varchar 1000  √  null
field_type description varchar 1000  √  null
field_value_type description varchar 1000  √  null
rejection_reason description varchar 1000  √  null
field_constraint display_name varchar 255
field_constraint_option display_name varchar 255
field_payload display_name varchar 255
field_template display_name varchar 255
form_template display_name varchar 255
section_payload display_name varchar 255
section_template display_name varchar 255
claim_status display_value varchar 500
field_constraint_type display_value varchar 500
field_type display_value varchar 500
field_value_type display_value varchar 500
rejection_reason display_value varchar 2000
attachment document_date date 13  √  null
claim east_adjacency varchar 500  √  null
section_payload element_display_name varchar 255
section_template element_display_name varchar 255
section_payload element_name varchar 255
section_template element_name varchar 255
party email varchar 50  √  null
field_constraint error_msg varchar 255
section_template error_msg varchar 255
field_constraint_option field_constraint_id varchar 40
field_constraint field_constraint_type varchar 255
field_constraint field_template_id varchar 40
field_payload field_type varchar 255
field_template field_type varchar 255
field_payload field_value_type varchar 255
attachment file_extension varchar 5
attachment file_name varchar 255
section_payload form_payload_id varchar 40
form_payload form_template_name varchar 255
section_template form_template_name varchar 255
field_constraint format varchar 255  √  null
party gender_code varchar 20  √  null
claim gps_geometry geometry 2147483647  √  null
claim_location gps_location geometry 2147483647  √  null
field_template hint varchar 255  √  null
attachment id varchar 40 uuid_generate_v1()
attachment_chunk id varchar 40 uuid_generate_v1()
claim id varchar 40
claim_comment id varchar 40
claim_location id varchar 40
claim_share id varchar 40
field_constraint id varchar 40
field_constraint_option id varchar 40
field_payload id varchar 40
field_template id varchar 40
form_payload id varchar 40
party id varchar 40 uuid_generate_v1()
section_element_payload id varchar 40
section_payload id varchar 40
section_template id varchar 40
party id_number varchar 20  √  null
party id_type_code varchar 20  √  null
form_template is_default bool 1 false
party is_person bool 1 true
field_constraint_option item_order int4 10 1
field_payload item_order int4 10 1
field_template item_order int4 10 1
section_payload item_order int4 10 1
section_template item_order int4 10 1
claim land_use_code varchar 20  √  null
party last_name varchar 50  √  null
claim lodgement_date timestamp 29,6  √  null
claim mapped_geometry geometry 2147483647  √  null
claim_location mapped_location geometry 2147483647
section_payload max_occurrences int4 10
section_template max_occurrences int4 10
field_constraint max_value numeric 20,10  √  null
attachment_chunk md5 varchar 50  √  null
attachment mime_type varchar 255
section_payload min_occurrences int4 10
section_template min_occurrences int4 10
field_constraint min_value numeric 20,10  √  null
party mobile_phone varchar 15  √  null
field_constraint name varchar 255
field_constraint_option name varchar 255
field_payload name varchar 255
field_template name varchar 255
form_template name varchar 255
party name varchar 255
section_payload name varchar 255
section_template name varchar 255
claim_share nominator int2 5  √  null
claim north_adjacency varchar 500  √  null
claim notes varchar 1000  √  null
claim nr varchar 15
party_for_claim_share party_id varchar 40
claim_share percentage float8 17,17  √  null
party phone varchar 15  √  null
claim recorder_name varchar 50
attachment reference_nr varchar 255  √  null
claim rejection_reason_code varchar 20  √  null
attachment rowidentifier varchar 40 uuid_generate_v1()
claim rowidentifier varchar 40 uuid_generate_v1()
claim_comment rowidentifier varchar 40 uuid_generate_v1()
claim_location rowidentifier varchar 40 uuid_generate_v1()
claim_share rowidentifier varchar 40 uuid_generate_v1()
claim_uses_attachment rowidentifier varchar 40 uuid_generate_v1()
field_constraint rowidentifier varchar 40 uuid_generate_v1()
field_constraint_option rowidentifier varchar 40 uuid_generate_v1()
field_payload rowidentifier varchar 40 uuid_generate_v1()
field_template rowidentifier varchar 40 uuid_generate_v1()
form_payload rowidentifier varchar 40 uuid_generate_v1()
form_template rowidentifier varchar 40 uuid_generate_v1()
party rowidentifier varchar 40 uuid_generate_v1()
party_for_claim_share rowidentifier varchar 40 uuid_generate_v1()
section_element_payload rowidentifier varchar 40 uuid_generate_v1()
section_payload rowidentifier varchar 40 uuid_generate_v1()
section_template rowidentifier varchar 40 uuid_generate_v1()
attachment rowversion int4 10 0
claim rowversion int4 10 0
claim_comment rowversion int4 10 0
claim_location rowversion int4 10 0
claim_share rowversion int4 10 0
claim_uses_attachment rowversion int4 10 0
field_constraint rowversion int4 10 0
field_constraint_option rowversion int4 10 0
field_payload rowversion int4 10 0
field_template rowversion int4 10 0
form_payload rowversion int4 10 0
form_template rowversion int4 10 0
party rowversion int4 10 0
party_for_claim_share rowversion int4 10 0
section_element_payload rowversion int4 10 0
section_payload rowversion int4 10 0
section_template rowversion int4 10 0
field_payload section_element_payload_id varchar 40
section_element_payload section_payload_id varchar 40
field_template section_template_id varchar 40
attachment size int8 19
attachment_chunk size int8 19
claim south_adjacency varchar 500  √  null
claim start_date date 13  √  null
attachment_chunk start_position int8 19
claim_status status bpchar 1 't'::bpchar
field_constraint_type status bpchar 1 'c'::bpchar
field_type status bpchar 1 'c'::bpchar
field_value_type status bpchar 1 'c'::bpchar
rejection_reason status bpchar 1 't'::bpchar
claim status_code varchar 20 'created'::character varying
field_payload string_payload varchar 2048  √  null
attachment type_code varchar 20
claim type_code varchar 20  √  null
attachment user_name varchar 50
attachment_chunk user_name varchar 50
party user_name varchar 50
claim west_adjacency varchar 500  √  null