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
communication_type code varchar 20 The code for the communication type.
communication_type description varchar 1000  √  null Description of the communication type.
communication_type display_value varchar 500 Displayed value of the communication type.
communication_type status bpchar 1 't'::bpchar Status of the communication type
gender_type code varchar 20 The code for the gender type.
gender_type description varchar 1000  √  null Description of the gender type.
gender_type display_value varchar 500 Displayed value of the gender type.
gender_type status bpchar 1 't'::bpchar Status of the gender type
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).
group_party change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
group_party change_user varchar 50  √  null SOLA Extension: The user id of the last person to modify the row.
group_party id varchar 40 LADM Definition: Identifier for the group party.
group_party rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the group_party_historic table
group_party rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
group_party type_code varchar 20 LADM Definition: The type of the group party. E.g. family, tribe, association, etc.
group_party_type code varchar 20 LADM Definition: The code for the group party type.
group_party_type description varchar 1000  √  null LADM Definition: Description of the group party type.
group_party_type display_value varchar 500 LADM Definition: Displayed value of the group party type.
group_party_type status bpchar 1 't'::bpchar SOLA Extension: Status of the group party type
id_type code varchar 20 The code for the id type.
id_type description varchar 1000  √  null Description of the id type.
id_type display_value varchar 500 Displayed value of the id type.
id_type status bpchar 1 't'::bpchar Status of the id type
party address_id varchar 40  √  null SOLA Extension: Identifier for the contact address of the party.
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.
party birth_date date 13  √  null SOLA Extension: Date of birth.
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_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
party change_user varchar 50  √  null SOLA Extension: The user id of the last person to modify the row.
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.
party email varchar 50  √  null SOLA Extension: The party's contact email address.
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 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 fax varchar 15  √  null SOLA Extension: The party's fax number.
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 varchar 40 LADM Definition: Identifier for the party.
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 last_name varchar 50  √  null SOLA Extension: The last name for the party or blank for groups and organisations.
party mobile varchar 15  √  null SOLA Extension: The party's contact mobile phone number.
party name varchar 255  √  null LADM Definition: The first name(s) for the party or the group or organisation name.
party phone varchar 15  √  null SOLA Extension: The party's main contact phone number. I.e. landline.
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.
party rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the party_historic table
party rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
party type_code varchar 20 LADM Definition: The type of the party. E.g. naturalPerson, nonNaturalPerson, etc.
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_member change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
party_member change_user varchar 50  √  null SOLA Extension: The user id of the last person to modify the row.
party_member group_id varchar 40 LADM Definition: Identifier of the group party
party_member party_id varchar 40 LADM Definition: Identifier for the party.
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_member rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
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.
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).
party_role change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
party_role change_user varchar 50  √  null SOLA Extension: The user id of the last person to modify the row.
party_role party_id varchar 40 LADM Definition: Identifier for the party.
party_role rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the party_role_historic table
party_role rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
party_role type_code varchar 20 SOLA Extension: The type of role the party holds
party_role_type code varchar 20 The code for the party role type.
party_role_type description varchar 1000  √  null Description of the party role type.
party_role_type display_value varchar 500 Displayed value of the party role type.
party_role_type status bpchar 1 't'::bpchar Status of the party role type
party_type code varchar 20 LADM Definition: The code for the party type.
party_type description varchar 1000  √  null LADM Definition: Description of the party type.
party_type display_value varchar 500 LADM Definition: Displayed value of the party type.
party_type status bpchar 1 't'::bpchar SOLA Extension: Status of the party type
source_describes_party change_action bpchar 1 'i'::bpchar
source_describes_party change_time timestamp 29,6 now()
source_describes_party change_user varchar 50  √  null
source_describes_party party_id varchar 40
source_describes_party rowidentifier varchar 40 uuid_generate_v1()
source_describes_party rowversion int4 10 0
source_describes_party source_id varchar 40