SchemaSpy Analysis of sola.opentenure - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Tue May 31 09:57 NZST 2016 |
| ||||||
|
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 | 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 |