SchemaSpy Analysis of sola.party - ColumnsThe SOLA implementation of the LADM Party package. Represents people and organisations that are associated to land rights and/or land transactions. Generated by
SchemaSpy
Generated by SchemaSpy on Tue May 31 09:58 NZST 2016
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

sola.party contains 78 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
group_party 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).
party 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).
party_member 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).
party_role 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).
source_describes_party change_action bpchar 1 'i'::bpchar
communication_type status bpchar 1 't'::bpchar Status of the communication type
gender_type status bpchar 1 't'::bpchar Status of the gender type
group_party_type status bpchar 1 't'::bpchar SOLA Extension: Status of the group party type
id_type status bpchar 1 't'::bpchar Status of the id type
party_role_type status bpchar 1 't'::bpchar Status of the party role type
party_type status bpchar 1 't'::bpchar SOLA Extension: Status of the party type
party birth_date date 13  √  null SOLA Extension: Date of birth.
party_member share float8 17,17  √  null LADM Definition: The share of a RRR held by a party member expressed as a fraction with a numerator and a denominator.
group_party rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
party rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
party_member rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
party_role rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
source_describes_party rowversion int4 10 0
group_party change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
party change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
party_member change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
party_role change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
source_describes_party change_time timestamp 29,6 now()
party fax varchar 15  √  null SOLA Extension: The party's fax number.
party mobile varchar 15  √  null SOLA Extension: The party's contact mobile phone number.
party phone varchar 15  √  null SOLA Extension: The party's main contact phone number. I.e. landline.
party 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.
communication_type code varchar 20 The code for the communication type.
gender_type code varchar 20 The code for the gender type.
group_party_type code varchar 20 LADM Definition: The code for the group party type.
id_type code varchar 20 The code for the id type.
party_role_type code varchar 20 The code for the party role type.
party_type code varchar 20 LADM Definition: The code for the party type.
party gender_code varchar 20  √  null SOLA Extension: Identifies the gender for the party. If the party is of type naturalPerson then a gender code must be specified.
party id_number varchar 20  √  null SOLA Extension: The number from the id used to verify the identity of the party.
party id_type_code varchar 20  √  null SOLA Extension: Used to indicate the type of id used to verify the identity of the party.
party preferred_communication_code varchar 20  √  null SOLA Extension: Used to indicate the party's preferred means of communication with the land administration agency.
party 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.
group_party type_code varchar 20 LADM Definition: The type of the group party. E.g. family, tribe, association, etc.
party type_code varchar 20 LADM Definition: The type of the party. E.g. naturalPerson, nonNaturalPerson, etc.
party_role type_code varchar 20 SOLA Extension: The type of role the party holds
party address_id varchar 40  √  null SOLA Extension: Identifier for the contact address of the party.
party_member group_id varchar 40 LADM Definition: Identifier of the group party
group_party id varchar 40 LADM Definition: Identifier for the group party.
party id varchar 40 LADM Definition: Identifier for the party.
party_member party_id varchar 40 LADM Definition: Identifier for the party.
party_role party_id varchar 40 LADM Definition: Identifier for the party.
source_describes_party party_id varchar 40
group_party rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the group_party_historic table
party rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the party_historic table
party_member rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the party_member_historic table
party_role rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the party_role_historic table
source_describes_party rowidentifier varchar 40 uuid_generate_v1()
source_describes_party source_id varchar 40
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.
group_party change_user varchar 50  √  null SOLA Extension: The user id of the last person to modify the row.
party change_user varchar 50  √  null SOLA Extension: The user id of the last person to modify the row.
party_member change_user varchar 50  √  null SOLA Extension: The user id of the last person to modify the row.
party_role change_user varchar 50  √  null SOLA Extension: The user id of the last person to modify the row.
source_describes_party change_user varchar 50  √  null
party email varchar 50  √  null SOLA Extension: The party's contact email address.
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.
party 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.
party last_name varchar 50  √  null SOLA Extension: The last name for the party or blank for groups and organisations.
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.
party name varchar 255  √  null LADM Definition: The first name(s) for the party or the group or organisation name.
communication_type display_value varchar 500 Displayed value of the communication type.
gender_type display_value varchar 500 Displayed value of the gender type.
group_party_type display_value varchar 500 LADM Definition: Displayed value of the group party type.
id_type display_value varchar 500 Displayed value of the id type.
party_role_type display_value varchar 500 Displayed value of the party role type.
party_type display_value varchar 500 LADM Definition: Displayed value of the party type.
communication_type description varchar 1000  √  null Description of the communication type.
gender_type description varchar 1000  √  null Description of the gender type.
group_party_type description varchar 1000  √  null LADM Definition: Description of the group party type.
id_type description varchar 1000  √  null Description of the id type.
party_role_type description varchar 1000  √  null Description of the party role type.
party_type description varchar 1000  √  null LADM Definition: Description of the party type.