Table sola.party.party
An individual, group or organisation that is associated in some way with land office services. Implementation of the LADM LA_Party class.
Tags: LADM Reference Object, Change History

 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
application.agent_id application_agent_id_fk8 R
application.contact_person_id application_contact_person_id_fk14 R
ba_unit_as_party.party_id ba_unit_as_party_party_id_fk72 C
group_party.id group_party_id_fk32 C
party_for_rrr.party_id party_for_rrr_party_id_fk82 C
party_member.party_id party_member_party_id_fk34 C
party_role.party_id party_role_party_id_fk36 C
source_describes_party.party_id source_describes_party_party_id_fk41 C
LADM Definition: Identifier for the party.
ext_id varchar 255  √  null SOLA Extension: An identifier for the party from some external system such as a customer relationship management (CRM) system.
type_code varchar 20
party_type.code party_type_code_fk9 R
LADM Definition: The type of the party. E.g. naturalPerson, nonNaturalPerson, etc.
name varchar 255  √  null LADM Definition: The first name(s) for the party or the group or organisation name.
last_name varchar 50  √  null SOLA Extension: The last name for the party or blank for groups and organisations.
fathers_name varchar 50  √  null SOLA Extension: The first name of the father for the party. Relevant where the fathers first name forms part of the name for the party.
fathers_last_name varchar 50  √  null SOLA Extension: The last name of the father for the party. Relevant where the fathers last name forms part of the name for the party.
alias varchar 50  √  null SOLA Extension: Any alias for the party. A party can have more than one alias. If so, the aliases should be separated by a comma.
gender_code varchar 20  √  null
gender_type.code party_gender_code_fk13 R
SOLA Extension: Identifies the gender for the party. If the party is of type naturalPerson then a gender code must be specified.
address_id varchar 40  √  null
address.id party_address_id_fk10 R
SOLA Extension: Identifier for the contact address of the party.
id_type_code varchar 20  √  null
id_type.code party_id_type_code_fk12 R
SOLA Extension: Used to indicate the type of id used to verify the identity of the party.
id_number varchar 20  √  null SOLA Extension: The number from the id used to verify the identity of the party.
email varchar 50  √  null SOLA Extension: The party's contact email address.
mobile varchar 15  √  null SOLA Extension: The party's contact mobile phone number.
phone varchar 15  √  null SOLA Extension: The party's main contact phone number. I.e. landline.
fax varchar 15  √  null SOLA Extension: The party's fax number.
preferred_communication_code varchar 20  √  null
communication_type.code party_preferred_communication_code_fk11 R
SOLA Extension: Used to indicate the party's preferred means of communication with the land administration agency.
birth_date date 13  √  null SOLA Extension: Date of birth.
rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the party_historic table
rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar SOLA Extension: 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 SOLA Extension: The user id of the last person to modify the row.
change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
classification_code varchar 20  √  null FROM SOLA State Land Extension: The security classification for this Party. Only users with the security classification (or a higher classification) will be able to view the record. If null, the record is considered unrestricted.
redact_code varchar 20  √  null FROM SOLA State Land Extension: The redact classification for this Party. Only users with the redact classification (or a higher classification) will be able to view the record with un-redacted fields. If null, the record is considered unrestricted and no redaction to the record will occur unless bulk redaction classifications have been set for fields of the record.

Analyzed at Tue May 31 09:58 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc party_pkey
address_id Performance Asc party_address_id_fk10_ind
gender_code Performance Asc party_gender_code_fk13_ind
id_type_code Performance Asc party_id_type_code_fk12_ind
rowidentifier Performance Asc party_index_on_rowidentifier
preferred_communication_code Performance Asc party_preferred_communication_code_fk11_ind
type_code Performance Asc party_type_code_fk9_ind

Close relationships  within of separation:

Excluded from diagram's relationships: group_party.change_action  party_member.rowidentifier  source_describes_party.change_action  party_role.rowidentifier  source_describes_party.rowidentifier  party_member.change_action  party_role.rowversion  party_member.change_user  group_party.rowidentifier  party_role.change_action  group_party.change_user  group_party.change_time  party_member.rowversion  party_role.change_user  party_role.change_time  party_member.change_time  source_describes_party.change_user  source_describes_party.change_time  group_party.rowversion  source_describes_party.rowversion