| SchemaSpy Analysis of sola.opentenure | Generated by SchemaSpy |
| Generated by SchemaSpy on Tue May 31 09:57 NZST 2016 | |
| Database Type: PostgreSQL - 9.4.6 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table | Children | Parents | Columns | Comments |
|---|---|---|---|---|
| attachment | 1 | 16 | Extension to the LADM used by SOLA to store claim files attachments. | |
| attachment_chunk | 9 | Holds temporary pieces of attachment uploaded on the server. In case of large files, document can be split into smaller pieces (chunks) allowing reliable upload. After all pieces uploaded, client will instruct server to create a document and remove temporary files stored in this table. | ||
| claim | 6 | 6 | 28 | Main table to store claim and claim challenge information submitted by the community recorders. SOLA Open Tenure extention. |
| claim_comment | 1 | 10 | ||
| claim_location | 1 | 10 | ||
| claim_share | 1 | 1 | 10 | Identifies the share a party has in a claim. |
| claim_status | 1 | 4 | Code list of claim status. | |
| claim_uses_attachment | 1 | 7 | Links the claim to the attachment submitted with the claim. SOLA Open Tenure extension. | |
| field_constraint | 1 | 2 | 14 | Dynamic form field constraint. |
| field_constraint_option | 1 | 10 | Dynamic form field constraint option, used to limit field values. | |
| field_constraint_type | 1 | 4 | Reference table for the field constraint types, used in dynamic forms. | |
| field_payload | 3 | 15 | Dynamic form field payload. | |
| field_template | 1 | 2 | 12 | Dynamic form field template. |
| field_type | 2 | 4 | Reference table for the field types, used in dynamic forms. | |
| field_value_type | 1 | 4 | Reference table for the field value types, used in dynamic forms. | |
| form_payload | 1 | 2 | 8 | Dynamic form payload. |
| form_template | 2 | 8 | Dynamic form template. | |
| party | 2 | 2 | 18 | Extension to the LADM used by SOLA to store party information (cliamant or owner). |
| party_for_claim_share | 2 | 7 | Identifies parties involved in the claim share. | |
| rejection_reason | 1 | 4 | Rejection reason codes | |
| section_element_payload | 1 | 1 | 7 | Dynamic form section element payload. |
| section_payload | 1 | 1 | 14 | Dynamic form section payload. |
| section_template | 1 | 1 | 15 | Sections of dynamic form template. |
| 23 Tables | 238 | |||
| 0 Views | 0 |