================================================================================ LRS43 DATABASE - QUICK COLUMN REFERENCE ================================================================================ LRSAdmin.lr_party -------------------------------------------------------------------------------- id numeric [PK] Hjtype nvarchar(255) party_type numeric party_role_type numeric name nvarchar(250) name2 nvarchar(250) person numeric share_nominator int share_denominator int share_description nvarchar(250) shares nvarchar(255) share_type numeric tax_exempt tinyint title_holder tinyint cert_no nvarchar(100) unit_uid nvarchar(500) ruid numeric part1 nvarchar(50) part2 nvarchar(50) part_dict1 numeric part_dict2 numeric comments nvarchar(800) version numeric begin_lifespan_version datetime end_lifespan_version datetime source_id numeric previous_id numeric LRSAdmin.lr_person -------------------------------------------------------------------------------- id numeric [PK] Hjtype nvarchar(255) address numeric person_type numeric person_id_type numeric person_id_number nvarchar(64) person_id_date datetime person_id_issue nvarchar(255) tin nvarchar(50) fax nvarchar(64) email nvarchar(64) phone1_number nvarchar(20) phone1_extension nvarchar(5) phone1_type numeric phone2_number nvarchar(20) phone2_extension nvarchar(5) phone2_type numeric phone3_number nvarchar(20) phone3_extension nvarchar(5) phone3_type numeric birth_date datetime pers1 nvarchar(50) pers2 nvarchar(50) pers_dict1 numeric pers_dict2 numeric pers_cost1 float pers_cost2 float pers_count1 int pers_count2 int pers_date1 datetime pers_date2 datetime is_submiter tinyint submiter nvarchar(800) version numeric begin_lifespan_version datetime end_lifespan_version datetime source_id numeric LRSAdmin.lr_address -------------------------------------------------------------------------------- id numeric [PK] Hjtype nvarchar(255) address_area_name nvarchar(250) street_number nvarchar(50) street_name nvarchar(100) building_name nvarchar(50) building_number int layout_name numeric postal_code nvarchar(10) city nvarchar(100) ward nvarchar(100) cell nvarchar(100) local_government_area numeric country numeric region numeric origin_region numeric district numeric cadregion numeric subdistrict numeric subcounty nvarchar(30) address_line1 nvarchar(50) address_line2 nvarchar(100) address_line3 nvarchar(100) district_text nvarchar(100) version numeric begin_lifespan_version datetime end_lifespan_version datetime LRSAdmin.lr_transaction -------------------------------------------------------------------------------- id numeric [PK] Hjtype nvarchar(255) transaction_number nvarchar(50) transaction_type numeric transaction_status numeric transaction_source numeric source_property_ids nvarchar(500) target_property_ids nvarchar(500) old_property_id nvarchar(50) parent_property_ids nvarchar(500) tenure_type numeric is_search_oldfile tinyint registration_fee float consideration float interest_money float create_date datetime complete_date datetime start_date datetime expiration_date datetime sign_date datetime registration_date datetime application_date datetime firstpay_date datetime balance_date datetime balance_sum float partial tinyint pageNumber nvarchar(16) cert_nos nvarchar(255) term_year int term_month int term_year_ext int term_month_ext int lease_extension numeric lease_duration numeric duration int build_term int build_value float pay_period_year int pay_period_month int volume nvarchar(20) folio nvarchar(20) volume_linked nvarchar(20) folio_linked nvarchar(20) recordingno nvarchar(30) internal_receipt_no nvarchar(30) serial_number nvarchar(30) general_number nvarchar(50) related_number nvarchar(50) related_page_number nvarchar(50) related_volume nvarchar(50) deed_case numeric related_instr_number nvarchar(50) lodgment_number nvarchar(50) boxno nvarchar(20) special_condition nvarchar(50) inscription nvarchar(800) inscription2 nvarchar(800) reg_initials nvarchar(20) blockplot nvarchar(200) volumefolio nvarchar(150) filetype numeric region numeric district numeric is_delivered tinyint is_right_required tinyint is_inactive tinyint is_mem_transaction tinyint comments nvarchar(800) site_analysis nvarchar(800) inspection_officer nvarchar(50) gis_params nvarchar(800) tran1 nvarchar(50) tran2 nvarchar(50) tran_date1 datetime tran_date2 datetime tran_dict1 numeric tran_dict2 numeric tran_cost1 float tran_cost2 float tran_count1 int tran_count2 int version numeric begin_lifespan_version datetime end_lifespan_version datetime demandnotice_number nvarchar(12) batch numeric transaction_index int term_day int consideration_currency numeric temp_consideration nvarchar(30) improvement_amount_currency numeric data_corrected_transaction_number nvarchar(50) data_corrected_transaction_type numeric data_corrected_comments nvarchar(800) data_corrected_create_date datetime data_corrected_complete_date datetime recommendation_memorandum nvarchar(800) SurveyPlan numeric LRSAdmin.lr_transaction_party -------------------------------------------------------------------------------- transaction_id numeric [PK] party_id numeric party_index int [PK] LRSAdmin.lr_source_document -------------------------------------------------------------------------------- id numeric [PK] Hjtype nvarchar(255) document_number nvarchar(50) ref_number nvarchar(50) minute_number nvarchar(50) document_type numeric duplicate tinyint access_type numeric acceptance datetime recordation datetime submission datetime issued_by nvarchar(500) page_count int comments nvarchar(800) create_date datetime modified_at datetime modified_by nvarchar(255) property_file_page nvarchar(50) sdoc1 nvarchar(50) sdoc2 nvarchar(50) sdoc_dict1 numeric sdoc_dict2 numeric sdoc_count1 int sdoc_count2 int version numeric begin_lifespan_version datetime end_lifespan_version datetime LRSAdmin.lr_dictionary -------------------------------------------------------------------------------- Id numeric [PK] Hjtype nvarchar(255) code nvarchar(64) label nvarchar(254) descr nvarchar(1000) category nvarchar(64) general_term tinyint sort_order int hidden tinyint version numeric begin_lifespan_version datetime end_lifespan_version datetime label_lang nvarchar(254) descr_lang nvarchar(1000) parentcode nvarchar(64) LRSAdmin.alf_node -------------------------------------------------------------------------------- id numeric [PK] version numeric store_id numeric uuid nvarchar(36) transaction_id numeric node_deleted tinyint type_qname_id numeric acl_id numeric audit_creator nvarchar(255) audit_created nvarchar(30) audit_modifier nvarchar(255) audit_modified nvarchar(30) audit_accessed nvarchar(30) LRSAdmin.alf_node_properties -------------------------------------------------------------------------------- node_id numeric [PK] actual_type_n int persisted_type_n int boolean_value tinyint long_value numeric float_value float double_value float string_value nvarchar(1024) serializable_value image(2147483647) qname_id numeric [PK] list_index int [PK] locale_id numeric [PK] LRSAdmin.alf_child_assoc -------------------------------------------------------------------------------- id numeric [PK] version numeric parent_node_id numeric type_qname_id numeric child_node_name_crc numeric child_node_name nvarchar(50) child_node_id numeric qname_ns_id numeric qname_localname nvarchar(255) qname_crc numeric is_primary tinyint assoc_index int