Table sola.opentenure.party
Extension to the LADM used by SOLA to store party information (cliamant or owner).

 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 uuid_generate_v1()
claim.claimant_id claim_claimant_id_fk8 R
party_for_claim_share.party_id party_for_claim_share_party_id_fk23 C
Unique identifier for the party.
name varchar 255 First name of party.
last_name varchar 50  √  null Last name of claimant.
id_type_code varchar 20  √  null
id_type.code fk_party_id_type R
ID document type code
id_number varchar 20  √  null ID document number.
birth_date date 13  √  null Date of birth of the party.
gender_code varchar 20  √  null
gender_type.code fk_party_gender R
Gender code of the party.
mobile_phone varchar 15  √  null Mobile phone number of the party.
phone varchar 15  √  null Landline phone number of the party.
email varchar 50  √  null Email address of the party.
address varchar 255  √  null Living address of the party.
user_name varchar 50 User name who has created the record.
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the document_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.
is_person bool 1 true Indicates if record is for individual or company (legal entity)

Analyzed at Tue May 31 09:57 NZST 2016

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

Close relationships  within of separation:

Excluded from diagram's relationships: field_payload.rowversion  section_payload.rowversion  form_payload.change_user  form_template.rowidentifier  section_payload.change_user  claim_share.change_action  claim_uses_attachment.change_time  section_template.rowidentifier  claim.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  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  claim.rowversion  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  claim.change_action  attachment.rowversion  field_template.change_time  claim_share.rowidentifier  claim_comment.change_time  party_for_claim_share.rowidentifier  claim.change_time  field_constraint_option.rowidentifier  form_template.rowversion  attachment.rowidentifier  claim_uses_attachment.rowidentifier  claim.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  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