================================================================================
COMPLETE DATABASE SCHEMA DUMP
================================================================================

Found 2 schema(s): dbo, LRSAdmin


================================================================================
SCHEMA: dbo (1 tables)
================================================================================

📋 dbo.sysdiagrams (1 rows)
   ├─ name: nvarchar(128) NOT NULL
   ├─ principal_id: int NOT NULL
   ├─ diagram_id: int NOT NULL
   ├─ version: int NULL
   ├─ definition: varbinary(-1) NULL


================================================================================
SCHEMA: LRSAdmin (168 tables)
================================================================================

📋 LRSAdmin.alf_access_control_entry (95 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ permission_id: numeric NOT NULL
   ├─ authority_id: numeric NOT NULL
   ├─ allowed: tinyint NOT NULL
   ├─ applies: int NOT NULL
   ├─ context_id: numeric NULL

📋 LRSAdmin.alf_access_control_list (498 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ acl_id: nvarchar(36) NOT NULL
   ├─ latest: tinyint NOT NULL
   ├─ acl_version: numeric NOT NULL
   ├─ inherits: tinyint NOT NULL
   ├─ inherits_from: numeric NULL
   ├─ type: int NOT NULL
   ├─ inherited_acl: numeric NULL
   ├─ is_versioned: tinyint NOT NULL
   └─ ... and 2 more columns

📋 LRSAdmin.alf_ace_context (0 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ class_context: nvarchar(1024) NULL
   ├─ property_context: nvarchar(1024) NULL
   ├─ kvp_context: nvarchar(1024) NULL

📋 LRSAdmin.alf_acl_change_set (77 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL

📋 LRSAdmin.alf_acl_member (1099 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ acl_id: numeric NOT NULL
   ├─ ace_id: numeric NOT NULL
   ├─ pos: int NOT NULL

📋 LRSAdmin.alf_activity_feed (0 rows)
   ├─ id: numeric NOT NULL
   ├─ post_id: numeric NULL
   ├─ post_date: datetime NOT NULL
   ├─ activity_summary: nvarchar(1024) NULL
   ├─ feed_user_id: nvarchar(255) NULL
   ├─ activity_type: nvarchar(255) NOT NULL
   ├─ activity_format: nvarchar(10) NULL
   ├─ site_network: nvarchar(255) NULL
   ├─ app_tool: nvarchar(36) NULL
   ├─ post_user_id: nvarchar(255) NOT NULL
   └─ ... and 1 more columns

📋 LRSAdmin.alf_activity_feed_control (0 rows)
   ├─ id: numeric NOT NULL
   ├─ feed_user_id: nvarchar(255) NOT NULL
   ├─ site_network: nvarchar(255) NULL
   ├─ app_tool: nvarchar(36) NULL
   ├─ last_modified: datetime NOT NULL

📋 LRSAdmin.alf_activity_post (0 rows)
   ├─ sequence_id: numeric NOT NULL
   ├─ post_date: datetime NOT NULL
   ├─ status: nvarchar(10) NOT NULL
   ├─ activity_data: nvarchar(1024) NOT NULL
   ├─ post_user_id: nvarchar(255) NOT NULL
   ├─ job_task_node: int NOT NULL
   ├─ site_network: nvarchar(255) NULL
   ├─ app_tool: nvarchar(36) NULL
   ├─ activity_type: nvarchar(255) NOT NULL
   ├─ last_modified: datetime NOT NULL

📋 LRSAdmin.alf_applied_patch (174 rows)
   ├─ id: nvarchar(64) NOT NULL
   ├─ description: nvarchar(1024) NULL
   ├─ fixes_from_schema: int NULL
   ├─ fixes_to_schema: int NULL
   ├─ applied_to_schema: int NULL
   ├─ target_schema: int NULL
   ├─ applied_on_date: datetime NULL
   ├─ applied_to_server: nvarchar(64) NULL
   ├─ was_executed: tinyint NULL
   ├─ succeeded: tinyint NULL
   └─ ... and 1 more columns

📋 LRSAdmin.alf_attributes (0 rows)
   ├─ id: numeric NOT NULL
   ├─ type: nvarchar(1) NOT NULL
   ├─ version: numeric NOT NULL
   ├─ acl_id: numeric NULL
   ├─ bool_value: tinyint NULL
   ├─ byte_value: tinyint NULL
   ├─ short_value: int NULL
   ├─ int_value: int NULL
   ├─ long_value: numeric NULL
   ├─ float_value: float NULL
   └─ ... and 3 more columns

📋 LRSAdmin.alf_audit_app (1 rows)
   ├─ id: numeric NOT NULL
   ├─ version: int NOT NULL
   ├─ app_name_id: numeric NOT NULL
   ├─ audit_model_id: numeric NOT NULL
   ├─ disabled_paths_id: numeric NOT NULL

📋 LRSAdmin.alf_audit_entry (0 rows)
   ├─ id: numeric NOT NULL
   ├─ audit_app_id: numeric NOT NULL
   ├─ audit_time: numeric NOT NULL
   ├─ audit_user_id: numeric NULL
   ├─ audit_values_id: numeric NULL

📋 LRSAdmin.alf_audit_model (3 rows)
   ├─ id: numeric NOT NULL
   ├─ content_data_id: numeric NOT NULL
   ├─ content_crc: numeric NOT NULL

📋 LRSAdmin.alf_authority (87 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ authority: nvarchar(100) NULL
   ├─ crc: numeric NULL

📋 LRSAdmin.alf_authority_alias (0 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ auth_id: numeric NOT NULL
   ├─ alias_id: numeric NOT NULL

📋 LRSAdmin.alf_child_assoc (541864 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ parent_node_id: numeric NOT NULL
   ├─ type_qname_id: numeric NOT NULL
   ├─ child_node_name_crc: numeric NOT NULL
   ├─ child_node_name: nvarchar(50) NOT NULL
   ├─ child_node_id: numeric NOT NULL
   ├─ qname_ns_id: numeric NOT NULL
   ├─ qname_localname: nvarchar(255) NOT NULL
   ├─ qname_crc: numeric NOT NULL
   └─ ... and 2 more columns

📋 LRSAdmin.alf_content_data (421673 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ content_url_id: numeric NULL
   ├─ content_mimetype_id: numeric NULL
   ├─ content_encoding_id: numeric NULL
   ├─ content_locale_id: numeric NULL

📋 LRSAdmin.alf_content_url (421660 rows)
   ├─ id: numeric NOT NULL
   ├─ content_url: nvarchar(255) NOT NULL
   ├─ content_url_short: nvarchar(12) NOT NULL
   ├─ content_url_crc: numeric NOT NULL
   ├─ content_size: numeric NOT NULL
   ├─ orphan_time: numeric NULL

📋 LRSAdmin.alf_encoding (2 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ encoding_str: nvarchar(100) NOT NULL

📋 LRSAdmin.alf_global_attributes (0 rows)
   ├─ name: nvarchar(160) NOT NULL
   ├─ attribute: numeric NULL

📋 LRSAdmin.alf_list_attribute_entries (0 rows)
   ├─ list_id: numeric NOT NULL
   ├─ mindex: int NOT NULL
   ├─ attribute_id: numeric NULL

📋 LRSAdmin.alf_locale (4 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ locale_str: nvarchar(20) NOT NULL

📋 LRSAdmin.alf_lock (42 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ shared_resource_id: numeric NOT NULL
   ├─ excl_resource_id: numeric NOT NULL
   ├─ lock_token: nvarchar(36) NOT NULL
   ├─ start_time: numeric NOT NULL
   ├─ expiry_time: numeric NOT NULL

📋 LRSAdmin.alf_lock_resource (42 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ qname_ns_id: numeric NOT NULL
   ├─ qname_localname: nvarchar(255) NOT NULL

📋 LRSAdmin.alf_map_attribute_entries (0 rows)
   ├─ map_id: numeric NOT NULL
   ├─ mkey: nvarchar(160) NOT NULL
   ├─ attribute_id: numeric NULL

📋 LRSAdmin.alf_mimetype (10 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ mimetype_str: nvarchar(100) NOT NULL

📋 LRSAdmin.alf_namespace (19 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ uri: nvarchar(100) NOT NULL

📋 LRSAdmin.alf_node (536540 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ store_id: numeric NOT NULL
   ├─ uuid: nvarchar(36) NOT NULL
   ├─ transaction_id: numeric NOT NULL
   ├─ node_deleted: tinyint NOT NULL
   ├─ type_qname_id: numeric NOT NULL
   ├─ acl_id: numeric NULL
   ├─ audit_creator: nvarchar(255) NULL
   ├─ audit_created: nvarchar(30) NULL
   └─ ... and 3 more columns

📋 LRSAdmin.alf_node_aspects (597477 rows)
   ├─ node_id: numeric NOT NULL
   ├─ qname_id: numeric NOT NULL

📋 LRSAdmin.alf_node_assoc (26585 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ source_node_id: numeric NOT NULL
   ├─ target_node_id: numeric NOT NULL
   ├─ type_qname_id: numeric NOT NULL

📋 LRSAdmin.alf_node_properties (5617250 rows)
   ├─ node_id: numeric NOT NULL
   ├─ actual_type_n: int NOT NULL
   ├─ persisted_type_n: int NOT NULL
   ├─ boolean_value: tinyint NULL
   ├─ long_value: numeric NULL
   ├─ float_value: float NULL
   ├─ double_value: float NULL
   ├─ string_value: nvarchar(1024) NULL
   ├─ serializable_value: image(2147483647) NULL
   ├─ qname_id: numeric NOT NULL
   └─ ... and 2 more columns

📋 LRSAdmin.alf_permission (6 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ type_qname_id: numeric NOT NULL
   ├─ name: nvarchar(100) NOT NULL

📋 LRSAdmin.alf_prop_class (2 rows)
   ├─ id: numeric NOT NULL
   ├─ java_class_name: nvarchar(255) NOT NULL
   ├─ java_class_name_short: nvarchar(32) NOT NULL
   ├─ java_class_name_crc: numeric NOT NULL

📋 LRSAdmin.alf_prop_date_value (0 rows)
   ├─ date_value: numeric NOT NULL
   ├─ full_year: int NOT NULL
   ├─ half_of_year: tinyint NOT NULL
   ├─ quarter_of_year: tinyint NOT NULL
   ├─ month_of_year: tinyint NOT NULL
   ├─ week_of_year: tinyint NOT NULL
   ├─ week_of_month: tinyint NOT NULL
   ├─ day_of_year: int NOT NULL
   ├─ day_of_month: tinyint NOT NULL
   ├─ day_of_week: tinyint NOT NULL

📋 LRSAdmin.alf_prop_double_value (0 rows)
   ├─ id: numeric NOT NULL
   ├─ double_value: float NOT NULL

📋 LRSAdmin.alf_prop_link (1 rows)
   ├─ root_prop_id: numeric NOT NULL
   ├─ prop_index: numeric NOT NULL
   ├─ contained_in: numeric NOT NULL
   ├─ key_prop_id: numeric NOT NULL
   ├─ value_prop_id: numeric NOT NULL

📋 LRSAdmin.alf_prop_root (1 rows)
   ├─ id: numeric NOT NULL
   ├─ version: int NOT NULL

📋 LRSAdmin.alf_prop_serializable_value (0 rows)
   ├─ id: bigint NOT NULL
   ├─ serializable_value: image(2147483647) NOT NULL

📋 LRSAdmin.alf_prop_string_value (2 rows)
   ├─ id: numeric NOT NULL
   ├─ string_value: nvarchar(1024) NOT NULL
   ├─ string_end_lower: nvarchar(16) NOT NULL
   ├─ string_crc: numeric NOT NULL

📋 LRSAdmin.alf_prop_unique_ctx (0 rows)
   ├─ id: numeric NOT NULL
   ├─ version: int NOT NULL
   ├─ value1_prop_id: numeric NOT NULL
   ├─ value2_prop_id: numeric NOT NULL
   ├─ value3_prop_id: numeric NOT NULL
   ├─ prop1_id: numeric NULL

📋 LRSAdmin.alf_prop_value (2 rows)
   ├─ id: numeric NOT NULL
   ├─ actual_type_id: numeric NOT NULL
   ├─ persisted_type: tinyint NOT NULL
   ├─ long_value: numeric NOT NULL

📋 LRSAdmin.alf_qname (277 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ ns_id: numeric NOT NULL
   ├─ local_name: nvarchar(200) NOT NULL

📋 LRSAdmin.alf_server (5 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ ip_address: nvarchar(39) NOT NULL

📋 LRSAdmin.alf_store (10 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ protocol: nvarchar(50) NOT NULL
   ├─ identifier: nvarchar(100) NOT NULL
   ├─ root_node_id: numeric NULL

📋 LRSAdmin.alf_transaction (88186 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ server_id: numeric NULL
   ├─ change_txn_id: nvarchar(56) NOT NULL
   ├─ commit_time_ms: numeric NULL

📋 LRSAdmin.alf_usage_delta (0 rows)
   ├─ id: numeric NOT NULL
   ├─ version: numeric NOT NULL
   ├─ node_id: numeric NOT NULL
   ├─ delta_size: numeric NOT NULL

📋 LRSAdmin.avm_aspects (0 rows)
   ├─ node_id: numeric NOT NULL
   ├─ qname_id: numeric NOT NULL

📋 LRSAdmin.avm_child_entries (1 rows)
   ├─ parent_id: numeric NOT NULL
   ├─ lc_name: nvarchar(160) NOT NULL
   ├─ name: nvarchar(160) NOT NULL
   ├─ child_id: numeric NOT NULL

📋 LRSAdmin.avm_history_links (1 rows)
   ├─ ancestor: numeric NOT NULL
   ├─ descendent: numeric NOT NULL

📋 LRSAdmin.avm_merge_links (0 rows)
   ├─ mfrom: numeric NOT NULL
   ├─ mto: numeric NOT NULL

📋 LRSAdmin.avm_node_properties (0 rows)
   ├─ node_id: numeric NOT NULL
   ├─ actual_type_n: int NOT NULL
   ├─ persisted_type_n: int NOT NULL
   ├─ multi_valued: tinyint NOT NULL
   ├─ boolean_value: tinyint NULL
   ├─ long_value: numeric NULL
   ├─ float_value: float NULL
   ├─ double_value: float NULL
   ├─ string_value: nvarchar(1024) NULL
   ├─ serializable_value: image(2147483647) NULL
   └─ ... and 1 more columns

📋 LRSAdmin.avm_nodes (3 rows)
   ├─ id: numeric NOT NULL
   ├─ class_type: nvarchar(20) NOT NULL
   ├─ vers: numeric NOT NULL
   ├─ version_id: int NOT NULL
   ├─ guid: nvarchar(36) NULL
   ├─ creator: nvarchar(255) NOT NULL
   ├─ owner: nvarchar(255) NOT NULL
   ├─ lastModifier: nvarchar(255) NOT NULL
   ├─ createDate: numeric NOT NULL
   ├─ modDate: numeric NOT NULL
   └─ ... and 14 more columns

📋 LRSAdmin.avm_store_properties (3 rows)
   ├─ id: numeric NOT NULL
   ├─ avm_store_id: numeric NULL
   ├─ qname_id: numeric NOT NULL
   ├─ actual_type_n: int NOT NULL
   ├─ persisted_type_n: int NOT NULL
   ├─ multi_valued: tinyint NOT NULL
   ├─ boolean_value: tinyint NULL
   ├─ long_value: numeric NULL
   ├─ float_value: float NULL
   ├─ double_value: float NULL
   └─ ... and 2 more columns

📋 LRSAdmin.avm_stores (1 rows)
   ├─ id: numeric NOT NULL
   ├─ vers: numeric NOT NULL
   ├─ name: nvarchar(255) NULL
   ├─ next_version_id: int NOT NULL
   ├─ current_root_id: numeric NULL
   ├─ acl_id: numeric NULL

📋 LRSAdmin.avm_version_layered_node_entry (0 rows)
   ├─ version_root_id: numeric NOT NULL
   ├─ md5sum: nvarchar(32) NOT NULL
   ├─ path: nvarchar(1024) NULL

📋 LRSAdmin.avm_version_roots (1 rows)
   ├─ id: numeric NOT NULL
   ├─ version_id: int NOT NULL
   ├─ avm_store_id: numeric NOT NULL
   ├─ create_date: numeric NOT NULL
   ├─ creator: nvarchar(255) NOT NULL
   ├─ root_id: numeric NOT NULL
   ├─ tag: nvarchar(255) NULL
   ├─ description: nvarchar(1024) NULL

📋 LRSAdmin.JBPM_ACTION (5424 rows)
   ├─ ID_: numeric NOT NULL
   ├─ class: char(1) NOT NULL
   ├─ NAME_: nvarchar(255) NULL
   ├─ ISPROPAGATIONALLOWED_: tinyint NULL
   ├─ ACTIONEXPRESSION_: nvarchar(255) NULL
   ├─ ISASYNC_: tinyint NULL
   ├─ REFERENCEDACTION_: numeric NULL
   ├─ ACTIONDELEGATION_: numeric NULL
   ├─ EVENT_: numeric NULL
   ├─ PROCESSDEFINITION_: numeric NULL
   └─ ... and 9 more columns

📋 LRSAdmin.JBPM_BYTEARRAY (171 rows)
   ├─ ID_: numeric NOT NULL
   ├─ NAME_: nvarchar(255) NULL
   ├─ FILEDEFINITION_: numeric NULL

📋 LRSAdmin.JBPM_BYTEBLOCK (6293 rows)
   ├─ PROCESSFILE_: numeric NOT NULL
   ├─ BYTES_: varbinary(1024) NULL
   ├─ INDEX_: int NOT NULL

📋 LRSAdmin.JBPM_COMMENT (0 rows)
   ├─ ID_: numeric NOT NULL
   ├─ VERSION_: int NOT NULL
   ├─ ACTORID_: nvarchar(255) NULL
   ├─ TIME_: datetime NULL
   ├─ MESSAGE_: nvarchar(-1) NULL
   ├─ TOKEN_: numeric NULL
   ├─ TASKINSTANCE_: numeric NULL
   ├─ TOKENINDEX_: int NULL
   ├─ TASKINSTANCEINDEX_: int NULL

📋 LRSAdmin.JBPM_DECISIONCONDITIONS (0 rows)
   ├─ DECISION_: numeric NOT NULL
   ├─ TRANSITIONNAME_: nvarchar(255) NULL
   ├─ EXPRESSION_: nvarchar(255) NULL
   ├─ INDEX_: int NOT NULL

📋 LRSAdmin.JBPM_DELEGATION (5664 rows)
   ├─ ID_: numeric NOT NULL
   ├─ CLASSNAME_: nvarchar(-1) NULL
   ├─ CONFIGURATION_: nvarchar(-1) NULL
   ├─ CONFIGTYPE_: nvarchar(255) NULL
   ├─ PROCESSDEFINITION_: numeric NULL

📋 LRSAdmin.JBPM_EVENT (4219 rows)
   ├─ ID_: numeric NOT NULL
   ├─ EVENTTYPE_: nvarchar(255) NULL
   ├─ TYPE_: char(1) NULL
   ├─ GRAPHELEMENT_: numeric NULL
   ├─ PROCESSDEFINITION_: numeric NULL
   ├─ NODE_: numeric NULL
   ├─ TRANSITION_: numeric NULL
   ├─ TASK_: numeric NULL

📋 LRSAdmin.JBPM_EXCEPTIONHANDLER (2 rows)
   ├─ ID_: numeric NOT NULL
   ├─ EXCEPTIONCLASSNAME_: nvarchar(-1) NULL
   ├─ TYPE_: char(1) NULL
   ├─ GRAPHELEMENT_: numeric NULL
   ├─ PROCESSDEFINITION_: numeric NULL
   ├─ GRAPHELEMENTINDEX_: int NULL
   ├─ NODE_: numeric NULL
   ├─ TRANSITION_: numeric NULL
   ├─ TASK_: numeric NULL

📋 LRSAdmin.JBPM_JOB (0 rows)
   ├─ ID_: numeric NOT NULL
   ├─ CLASS_: char(1) NOT NULL
   ├─ VERSION_: int NOT NULL
   ├─ DUEDATE_: datetime NULL
   ├─ PROCESSINSTANCE_: numeric NULL
   ├─ TOKEN_: numeric NULL
   ├─ TASKINSTANCE_: numeric NULL
   ├─ ISSUSPENDED_: tinyint NULL
   ├─ ISEXCLUSIVE_: tinyint NULL
   ├─ LOCKOWNER_: nvarchar(255) NULL
   └─ ... and 10 more columns

📋 LRSAdmin.JBPM_LOG (0 rows)
   ├─ ID_: numeric NOT NULL
   ├─ CLASS_: char(1) NOT NULL
   ├─ INDEX_: int NULL
   ├─ DATE_: datetime NULL
   ├─ TOKEN_: numeric NULL
   ├─ PARENT_: numeric NULL
   ├─ MESSAGE_: nvarchar(-1) NULL
   ├─ EXCEPTION_: nvarchar(-1) NULL
   ├─ ACTION_: numeric NULL
   ├─ NODE_: numeric NULL
   └─ ... and 30 more columns

📋 LRSAdmin.JBPM_MODULEDEFINITION (182 rows)
   ├─ ID_: numeric NOT NULL
   ├─ CLASS_: char(1) NOT NULL
   ├─ NAME_: nvarchar(255) NULL
   ├─ PROCESSDEFINITION_: numeric NULL
   ├─ STARTTASK_: numeric NULL

📋 LRSAdmin.JBPM_MODULEINSTANCE (9576 rows)
   ├─ ID_: numeric NOT NULL
   ├─ CLASS_: char(1) NOT NULL
   ├─ VERSION_: int NOT NULL
   ├─ PROCESSINSTANCE_: numeric NULL
   ├─ TASKMGMTDEFINITION_: numeric NULL
   ├─ NAME_: nvarchar(255) NULL

📋 LRSAdmin.JBPM_NODE (807 rows)
   ├─ ID_: numeric NOT NULL
   ├─ CLASS_: char(1) NOT NULL
   ├─ NAME_: nvarchar(255) NULL
   ├─ DESCRIPTION_: nvarchar(-1) NULL
   ├─ PROCESSDEFINITION_: numeric NULL
   ├─ ISASYNC_: tinyint NULL
   ├─ ISASYNCEXCL_: tinyint NULL
   ├─ ACTION_: numeric NULL
   ├─ SUPERSTATE_: numeric NULL
   ├─ SUBPROCNAME_: nvarchar(255) NULL
   └─ ... and 9 more columns

📋 LRSAdmin.JBPM_POOLEDACTOR (209226 rows)
   ├─ ID_: numeric NOT NULL
   ├─ VERSION_: int NOT NULL
   ├─ ACTORID_: nvarchar(255) NULL
   ├─ SWIMLANEINSTANCE_: numeric NULL

📋 LRSAdmin.JBPM_PROCESSDEFINITION (64 rows)
   ├─ ID_: numeric NOT NULL
   ├─ CLASS_: char(1) NOT NULL
   ├─ NAME_: nvarchar(255) NULL
   ├─ DESCRIPTION_: nvarchar(-1) NULL
   ├─ VERSION_: int NULL
   ├─ ISTERMINATIONIMPLICIT_: tinyint NULL
   ├─ STARTSTATE_: numeric NULL

📋 LRSAdmin.JBPM_PROCESSINSTANCE (4788 rows)
   ├─ ID_: numeric NOT NULL
   ├─ VERSION_: int NOT NULL
   ├─ KEY_: nvarchar(255) NULL
   ├─ START_: datetime NULL
   ├─ END_: datetime NULL
   ├─ ISSUSPENDED_: tinyint NULL
   ├─ PROCESSDEFINITION_: numeric NULL
   ├─ ROOTTOKEN_: numeric NULL
   ├─ SUPERPROCESSTOKEN_: numeric NULL

📋 LRSAdmin.JBPM_RUNTIMEACTION (0 rows)
   ├─ ID_: numeric NOT NULL
   ├─ VERSION_: int NOT NULL
   ├─ EVENTTYPE_: nvarchar(255) NULL
   ├─ TYPE_: char(1) NULL
   ├─ GRAPHELEMENT_: numeric NULL
   ├─ PROCESSINSTANCE_: numeric NULL
   ├─ ACTION_: numeric NULL
   ├─ PROCESSINSTANCEINDEX_: int NULL

📋 LRSAdmin.JBPM_SWIMLANE (351 rows)
   ├─ ID_: numeric NOT NULL
   ├─ NAME_: nvarchar(255) NULL
   ├─ ACTORIDEXPRESSION_: nvarchar(255) NULL
   ├─ POOLEDACTORSEXPRESSION_: nvarchar(255) NULL
   ├─ ASSIGNMENTDELEGATION_: numeric NULL
   ├─ TASKMGMTDEFINITION_: numeric NULL

📋 LRSAdmin.JBPM_SWIMLANEINSTANCE (14127 rows)
   ├─ ID_: numeric NOT NULL
   ├─ VERSION_: int NOT NULL
   ├─ NAME_: nvarchar(255) NULL
   ├─ ACTORID_: nvarchar(255) NULL
   ├─ SWIMLANE_: numeric NULL
   ├─ TASKMGMTINSTANCE_: numeric NULL

📋 LRSAdmin.JBPM_TASK (582 rows)
   ├─ ID_: numeric NOT NULL
   ├─ NAME_: nvarchar(255) NULL
   ├─ DESCRIPTION_: nvarchar(-1) NULL
   ├─ PROCESSDEFINITION_: numeric NULL
   ├─ ISBLOCKING_: tinyint NULL
   ├─ ISSIGNALLING_: tinyint NULL
   ├─ CONDITION_: nvarchar(255) NULL
   ├─ DUEDATE_: nvarchar(255) NULL
   ├─ PRIORITY_: int NULL
   ├─ ACTORIDEXPRESSION_: nvarchar(255) NULL
   └─ ... and 7 more columns

📋 LRSAdmin.JBPM_TASKACTORPOOL (468906 rows)
   ├─ TASKINSTANCE_: numeric NOT NULL
   ├─ POOLEDACTOR_: numeric NOT NULL

📋 LRSAdmin.JBPM_TASKCONTROLLER (0 rows)
   ├─ ID_: numeric NOT NULL
   ├─ TASKCONTROLLERDELEGATION_: numeric NULL

📋 LRSAdmin.JBPM_TASKINSTANCE (33507 rows)
   ├─ ID_: numeric NOT NULL
   ├─ CLASS_: char(1) NOT NULL
   ├─ VERSION_: int NOT NULL
   ├─ NAME_: nvarchar(255) NULL
   ├─ DESCRIPTION_: nvarchar(-1) NULL
   ├─ ACTORID_: nvarchar(255) NULL
   ├─ CREATE_: datetime NULL
   ├─ START_: datetime NULL
   ├─ END_: datetime NULL
   ├─ DUEDATE_: datetime NULL
   └─ ... and 12 more columns

📋 LRSAdmin.JBPM_TOKEN (4788 rows)
   ├─ ID_: numeric NOT NULL
   ├─ VERSION_: int NOT NULL
   ├─ NAME_: nvarchar(255) NULL
   ├─ START_: datetime NULL
   ├─ END_: datetime NULL
   ├─ NODEENTER_: datetime NULL
   ├─ NEXTLOGINDEX_: int NULL
   ├─ ISABLETOREACTIVATEPARENT_: tinyint NULL
   ├─ ISTERMINATIONIMPLICIT_: tinyint NULL
   ├─ ISSUSPENDED_: tinyint NULL
   └─ ... and 5 more columns

📋 LRSAdmin.JBPM_TOKENVARIABLEMAP (4788 rows)
   ├─ ID_: numeric NOT NULL
   ├─ VERSION_: int NOT NULL
   ├─ TOKEN_: numeric NULL
   ├─ CONTEXTINSTANCE_: numeric NULL

📋 LRSAdmin.JBPM_TRANSITION (1081 rows)
   ├─ ID_: numeric NOT NULL
   ├─ NAME_: nvarchar(255) NULL
   ├─ DESCRIPTION_: nvarchar(-1) NULL
   ├─ PROCESSDEFINITION_: numeric NULL
   ├─ FROM_: numeric NULL
   ├─ TO_: numeric NULL
   ├─ CONDITION_: nvarchar(255) NULL
   ├─ FROMINDEX_: int NULL

📋 LRSAdmin.JBPM_VARIABLEACCESS (54 rows)
   ├─ ID_: numeric NOT NULL
   ├─ VARIABLENAME_: nvarchar(255) NULL
   ├─ ACCESS_: nvarchar(255) NULL
   ├─ MAPPEDNAME_: nvarchar(255) NULL
   ├─ PROCESSSTATE_: numeric NULL
   ├─ TASKCONTROLLER_: numeric NULL
   ├─ INDEX_: int NULL
   ├─ SCRIPT_: numeric NULL

📋 LRSAdmin.JBPM_VARIABLEINSTANCE (47781 rows)
   ├─ ID_: numeric NOT NULL
   ├─ CLASS_: char(1) NOT NULL
   ├─ VERSION_: int NOT NULL
   ├─ NAME_: nvarchar(255) NULL
   ├─ CONVERTER_: char(1) NULL
   ├─ TOKEN_: numeric NULL
   ├─ TOKENVARIABLEMAP_: numeric NULL
   ├─ PROCESSINSTANCE_: numeric NULL
   ├─ BYTEARRAYVALUE_: numeric NULL
   ├─ DATEVALUE_: datetime NULL
   └─ ... and 6 more columns

📋 LRSAdmin.JMS_MESSAGES (216 rows)
   ├─ MESSAGEID: int NOT NULL
   ├─ DESTINATION: varchar(1024) NOT NULL
   ├─ TXID: int NULL
   ├─ TXOP: char(1) NULL
   ├─ MESSAGEBLOB: image(2147483647) NULL

📋 LRSAdmin.JMS_ROLES (3 rows)
   ├─ ROLEID: varchar(32) NOT NULL
   ├─ USERID: varchar(32) NOT NULL

📋 LRSAdmin.JMS_SUBSCRIPTIONS (4 rows)
   ├─ CLIENTID: varchar(128) NOT NULL
   ├─ SUBNAME: varchar(128) NOT NULL
   ├─ TOPIC: varchar(255) NOT NULL
   ├─ SELECTOR: varchar(255) NULL

📋 LRSAdmin.JMS_TRANSACTIONS (0 rows)
   ├─ TXID: int NOT NULL

📋 LRSAdmin.JMS_USERS (1 rows)
   ├─ USERID: varchar(32) NOT NULL
   ├─ PASSWD: varchar(32) NOT NULL
   ├─ CLIENTID: varchar(128) NULL

📋 LRSAdmin.lr_address (30622 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ address_area_name: nvarchar(250) NULL
   ├─ street_number: nvarchar(50) NULL
   ├─ street_name: nvarchar(100) NULL
   ├─ building_name: nvarchar(50) NULL
   ├─ building_number: int NULL
   ├─ layout_name: numeric NULL
   ├─ postal_code: nvarchar(10) NULL
   ├─ city: nvarchar(100) NULL
   └─ ... and 17 more columns

📋 LRSAdmin.lr_admin_document_party (0 rows)
   ├─ document: numeric NOT NULL
   ├─ party: numeric NOT NULL
   ├─ party_index: int NOT NULL

📋 LRSAdmin.lr_admin_document_rrr (0 rows)
   ├─ document: numeric NOT NULL
   ├─ rrr: numeric NOT NULL
   ├─ rrr_index: int NOT NULL

📋 LRSAdmin.lr_admin_source_document (0 rows)
   ├─ id: numeric NOT NULL
   ├─ purchase_price: float NULL
   ├─ memo_text: nvarchar(2500) NULL

📋 LRSAdmin.lr_applicant (54 rows)
   ├─ id: numeric NOT NULL
   ├─ application_type: numeric NOT NULL
   ├─ delivery_type: numeric NOT NULL

📋 LRSAdmin.lr_batch (4810 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ batch_number: nvarchar(50) NULL
   ├─ application_status: numeric NOT NULL
   ├─ invoice_number: nvarchar(150) NULL
   ├─ create_date: datetime NULL
   ├─ delivery_date: datetime NULL
   ├─ office: numeric NULL
   ├─ comments: nvarchar(800) NULL
   ├─ decision: nvarchar(100) NULL
   └─ ... and 8 more columns

📋 LRSAdmin.lr_batch_party (4804 rows)
   ├─ batch: numeric NOT NULL
   ├─ party: numeric NOT NULL
   ├─ party_index: int NOT NULL

📋 LRSAdmin.lr_batch_related (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ parent_id: numeric NOT NULL
   ├─ child_id: numeric NOT NULL
   ├─ process_id: numeric NULL

📋 LRSAdmin.lr_billing (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ invoice_number: nvarchar(50) NULL
   ├─ total_amount: float NULL
   ├─ status: numeric NOT NULL
   ├─ invoice_type: numeric NOT NULL
   ├─ wires_trx_id: numeric NULL
   ├─ wrx_date_submitted: datetime NULL
   ├─ wrx_date_accepted: datetime NULL
   ├─ due_date: datetime NULL
   └─ ... and 13 more columns

📋 LRSAdmin.lr_billing_dist_line (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ trans_code: nvarchar(50) NULL
   ├─ amount: float NULL
   ├─ flex_field_1: nvarchar(250) NULL
   ├─ flex_field_2: nvarchar(250) NULL
   ├─ flex_field_3: nvarchar(250) NULL
   ├─ flex_field_4: nvarchar(250) NULL
   ├─ flex_field_5: nvarchar(250) NULL
   ├─ wires_dist_line_id: nvarchar(50) NULL
   └─ ... and 5 more columns

📋 LRSAdmin.lr_billing_line (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ line_type: nvarchar(50) NULL
   ├─ quantity: float NULL
   ├─ amount: float NULL
   ├─ total_amount: float NULL
   ├─ wires_line_id: nvarchar(50) NULL
   ├─ description: nvarchar(800) NULL
   ├─ version: numeric NULL
   ├─ begin_lifespan_version: datetime NULL
   └─ ... and 3 more columns

📋 LRSAdmin.lr_building (0 rows)
   ├─ id: numeric NOT NULL
   ├─ compl_number: nvarchar(30) NULL
   ├─ actual_use_type: numeric NOT NULL
   ├─ number_of_units: int NULL
   ├─ number_of_floors: int NULL
   ├─ floor_area: float NULL
   ├─ floor_area_unit_type: numeric NOT NULL
   ├─ internal_area: float NULL
   ├─ internal_area_unit_type: numeric NOT NULL
   ├─ unit_factor: int NULL
   └─ ... and 5 more columns

📋 LRSAdmin.lr_building_unit (0 rows)
   ├─ id: numeric NOT NULL
   ├─ unit_number: nvarchar(30) NULL
   ├─ building_number: nvarchar(30) NULL
   ├─ compl_number: nvarchar(30) NULL
   ├─ condo_plan: nvarchar(20) NULL
   ├─ use_type: numeric NOT NULL
   ├─ bunit_type: numeric NULL
   ├─ bunit_category: numeric NOT NULL
   ├─ bunit_purpose: numeric NOT NULL
   ├─ use_typespecificbld: nvarchar(50) NULL
   └─ ... and 19 more columns

📋 LRSAdmin.lr_business_calendar (8 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ code: nvarchar(255) NOT NULL
   ├─ label: nvarchar(255) NOT NULL
   ├─ day_part: nvarchar(500) NULL

📋 LRSAdmin.lr_condition (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ condition_type: numeric NOT NULL
   ├─ condition_seq: numeric NULL
   ├─ condition_number: nvarchar(100) NULL
   ├─ cond_stage: nvarchar(150) NULL
   ├─ condition_text: nvarchar(1500) NULL
   ├─ original_text: nvarchar(1000) NULL
   ├─ custom_condition: tinyint NULL
   ├─ last_edited_by: nvarchar(255) NULL
   └─ ... and 15 more columns

📋 LRSAdmin.lr_contact (0 rows)
   ├─ id: numeric NOT NULL
   ├─ contact_type: numeric NOT NULL

📋 LRSAdmin.lr_corporation (11983 rows)
   ├─ id: numeric NOT NULL
   ├─ name: nvarchar(150) NULL
   ├─ represent_name: nvarchar(50) NULL
   ├─ gsm_number: nvarchar(50) NULL
   ├─ cac_number: nvarchar(50) NULL
   ├─ corp1: nvarchar(50) NULL
   ├─ corp2: nvarchar(50) NULL
   ├─ corp_dict1: numeric NOT NULL
   ├─ corp_dict2: numeric NOT NULL

📋 LRSAdmin.lr_dictionary (2643 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ code: nvarchar(64) NOT NULL
   ├─ label: nvarchar(254) NOT NULL
   ├─ descr: nvarchar(1000) NULL
   ├─ category: nvarchar(64) NOT NULL
   ├─ general_term: tinyint NULL
   ├─ sort_order: int NULL
   ├─ hidden: tinyint NULL
   ├─ version: numeric NULL
   └─ ... and 5 more columns

📋 LRSAdmin.lr_document_ext (21466 rows)
   ├─ parent_id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ extended_comments: nvarchar(2000) NULL
   ├─ extended_params: nvarchar(1000) NULL

📋 LRSAdmin.lr_extension_link (4 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ parent_class: nvarchar(255) NOT NULL
   ├─ child_class: nvarchar(255) NOT NULL

📋 LRSAdmin.lr_fee_rate (29003 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ fee_name: numeric NOT NULL
   ├─ transaction_type: numeric NULL
   ├─ area: numeric NULL
   ├─ size: numeric NULL
   ├─ measuremente_unit_type: numeric NULL
   ├─ location: numeric NULL
   ├─ land_use_type_category: numeric NULL
   ├─ land_use_type: numeric NULL
   └─ ... and 6 more columns

📋 LRSAdmin.lr_fee_structure (54 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ fee_name: numeric NOT NULL
   ├─ is_transaction_type: tinyint NULL
   ├─ is_property_area: tinyint NULL
   ├─ is_property_size: tinyint NULL
   ├─ is_property_location: tinyint NULL
   ├─ is_property_land_use_type_category: tinyint NULL
   ├─ is_property_land_use_type: tinyint NULL
   ├─ is_size_range: tinyint NULL

📋 LRSAdmin.lr_formfield (1731 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ form_name: nvarchar(64) NOT NULL
   ├─ class_name: nvarchar(64) NOT NULL
   ├─ attribute_name: nvarchar(64) NOT NULL
   ├─ xsd_type: nvarchar(64) NOT NULL
   ├─ data_length: int NULL
   ├─ caption: nvarchar(128) NULL
   ├─ mandatory: tinyint NULL
   ├─ category: nvarchar(64) NULL
   └─ ... and 14 more columns

📋 LRSAdmin.lr_ground_rent (3 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ propertyNumber: nvarchar(50) NOT NULL
   ├─ paidYear: nvarchar(10) NOT NULL
   ├─ amount: float NULL
   ├─ paidSum: float NULL

📋 LRSAdmin.lr_incoming_document (21479 rows)
   ├─ id: numeric NOT NULL
   ├─ establish_right: tinyint NULL

📋 LRSAdmin.lr_individual (13910 rows)
   ├─ id: numeric NOT NULL
   ├─ first_name: nvarchar(150) NULL
   ├─ second_name: nvarchar(150) NULL
   ├─ last_name: nvarchar(150) NULL
   ├─ last_name2: nvarchar(150) NULL
   ├─ gender: numeric NOT NULL
   ├─ salutation: numeric NOT NULL
   ├─ civil_state: numeric NOT NULL
   ├─ profession: numeric NOT NULL
   ├─ occupation: nvarchar(50) NULL
   └─ ... and 10 more columns

📋 LRSAdmin.lr_launit (4729 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ unit_uid: nvarchar(50) NULL
   ├─ old_property_id: nvarchar(50) NULL
   ├─ tenure_type: numeric NOT NULL
   ├─ name: nvarchar(250) NULL
   ├─ rental_amount: float NULL
   ├─ build_value: float NULL
   ├─ build_term: int NULL
   ├─ register_type: nvarchar(100) NULL
   └─ ... and 15 more columns

📋 LRSAdmin.lr_launit_lineage (52 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ child_id: numeric NULL
   ├─ parent_id: numeric NULL
   ├─ child_uid: nvarchar(50) NULL
   ├─ parent_uid: nvarchar(50) NOT NULL
   ├─ transaction_number: nvarchar(50) NULL
   ├─ transaction_cancel: nvarchar(50) NULL
   ├─ archive_date: datetime NULL

📋 LRSAdmin.lr_launit_spatial_unit (4729 rows)
   ├─ launit: numeric NOT NULL
   ├─ spatial_unit: numeric NOT NULL
   ├─ unit_index: int NOT NULL

📋 LRSAdmin.lr_mc_job (11 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ job_instance_id: numeric NOT NULL
   ├─ job_id: numeric NOT NULL
   ├─ job_priority: numeric NOT NULL
   ├─ job_name: nvarchar(250) NULL
   ├─ job_status: int NULL
   ├─ job_started: datetime NULL
   ├─ job_updated: datetime NULL
   ├─ job_ended: datetime NULL
   └─ ... and 3 more columns

📋 LRSAdmin.lr_mortgage (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ amount: float NULL
   ├─ interest_rate: float NULL
   ├─ ranking: int NULL
   ├─ mortgage_type: numeric NOT NULL
   ├─ mrg1: nvarchar(50) NULL
   ├─ mrg2: nvarchar(50) NULL
   ├─ mrg_dict1: numeric NOT NULL
   ├─ mrg_dict2: numeric NOT NULL
   └─ ... and 5 more columns

📋 LRSAdmin.lr_parcel (4729 rows)
   ├─ id: numeric NOT NULL
   ├─ actual_use_type: numeric NOT NULL
   ├─ land_type: numeric NULL
   ├─ land_category: numeric NOT NULL
   ├─ land_purpose: numeric NOT NULL
   ├─ survey_plan_no: nvarchar(50) NULL
   ├─ survey_type: numeric NOT NULL
   ├─ survey_date: datetime NULL
   ├─ parcel_number: nvarchar(4) NULL
   ├─ survey_name: nvarchar(32) NULL
   └─ ... and 11 more columns

📋 LRSAdmin.lr_party (25878 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ party_type: numeric NOT NULL
   ├─ party_role_type: numeric NOT NULL
   ├─ name: nvarchar(250) NULL
   ├─ name2: nvarchar(250) NULL
   ├─ person: numeric NULL
   ├─ share_nominator: int NULL
   ├─ share_denominator: int NULL
   ├─ share_description: nvarchar(250) NULL
   └─ ... and 17 more columns

📋 LRSAdmin.lr_party_contact (0 rows)
   ├─ contact: numeric NOT NULL
   ├─ party: numeric NOT NULL
   ├─ contact_index: int NOT NULL

📋 LRSAdmin.lr_party_ext (25794 rows)
   ├─ parent_id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ extended_comments: nvarchar(2000) NULL
   ├─ extended_params: nvarchar(1000) NULL

📋 LRSAdmin.lr_party_group (0 rows)
   ├─ id: numeric NOT NULL
   ├─ group_type: numeric NOT NULL
   ├─ address: numeric NULL
   ├─ fax: nvarchar(64) NULL
   ├─ email: nvarchar(64) NULL
   ├─ phone1_number: nvarchar(20) NULL
   ├─ phone1_extension: nvarchar(5) NULL
   ├─ phone1_type: numeric NOT NULL
   ├─ phone2_number: nvarchar(20) NULL
   ├─ phone2_extension: nvarchar(5) NULL
   └─ ... and 4 more columns

📋 LRSAdmin.lr_party_launit (0 rows)
   ├─ id: numeric NOT NULL
   ├─ launit: numeric NOT NULL

📋 LRSAdmin.lr_party_member (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ share_nominator: int NULL
   ├─ share_denominator: int NULL
   ├─ party_ref: numeric NULL
   ├─ version: numeric NULL
   ├─ begin_lifespan_version: datetime NULL
   ├─ end_lifespan_version: datetime NULL
   ├─ group_ref: numeric NULL
   ├─ member_index: int NULL

📋 LRSAdmin.lr_payment (69 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ transaction_number: nvarchar(50) NULL
   ├─ is_paid: tinyint NULL
   ├─ invoice_number: nvarchar(50) NULL
   ├─ receipt_number: numeric NULL
   ├─ payment_type: numeric NOT NULL
   ├─ payment_date: datetime NULL
   ├─ payment_status: numeric NOT NULL
   ├─ receipt_no: nvarchar(30) NULL
   └─ ... and 28 more columns

📋 LRSAdmin.lr_payment_transaction (795 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ calculated_fee: float NULL
   ├─ manual_fee: float NULL
   ├─ transaction_params: nvarchar(2000) NULL
   ├─ receipt_no: nvarchar(30) NULL
   ├─ payment_type: numeric NOT NULL
   ├─ payment_date: datetime NULL
   ├─ bank_type: numeric NOT NULL
   ├─ bank_name: nvarchar(50) NULL
   └─ ... and 30 more columns

📋 LRSAdmin.lr_person (25893 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ address: numeric NULL
   ├─ person_type: numeric NOT NULL
   ├─ person_id_type: numeric NOT NULL
   ├─ person_id_number: nvarchar(64) NULL
   ├─ person_id_date: datetime NULL
   ├─ person_id_issue: nvarchar(255) NULL
   ├─ tin: nvarchar(50) NULL
   ├─ fax: nvarchar(64) NULL
   └─ ... and 27 more columns

📋 LRSAdmin.lr_process_event (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ event_type: numeric NOT NULL
   ├─ event_date: datetime NULL
   ├─ description: nvarchar(800) NULL
   ├─ actor: nvarchar(50) NULL
   ├─ history: numeric NULL
   ├─ event_index: int NULL

📋 LRSAdmin.lr_process_history (94622 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ process_id: numeric NULL
   ├─ process_name: nvarchar(255) NULL
   ├─ task_id: numeric NULL
   ├─ task_name: nvarchar(255) NULL
   ├─ task_description: nvarchar(255) NULL
   ├─ task_create: datetime NULL
   ├─ task_complete: datetime NULL
   ├─ task_transition: nvarchar(255) NULL
   └─ ... and 3 more columns

📋 LRSAdmin.lr_registry (1 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ code: nvarchar(32) NOT NULL
   ├─ description: nvarchar(255) NOT NULL
   ├─ lodgment_class: nvarchar(255) NOT NULL
   ├─ transaction_class: nvarchar(255) NOT NULL

📋 LRSAdmin.lr_registry_office (1 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ string_code: nvarchar(10) NULL
   ├─ digital_code: int NULL
   ├─ office_name: nvarchar(100) NULL
   ├─ office_type: nvarchar(100) NULL
   ├─ address: nvarchar(255) NULL
   ├─ head_name: nvarchar(100) NULL
   ├─ phone: nvarchar(255) NULL
   ├─ fax: nvarchar(64) NULL
   └─ ... and 5 more columns

📋 LRSAdmin.lr_rejection (193 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ rejection_date: datetime NULL
   ├─ comments: datetime NULL
   ├─ lodgment_id: numeric NULL

📋 LRSAdmin.lr_rejection_reason (182 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ reason_type: numeric NOT NULL
   ├─ comments: nvarchar(2000) NULL
   ├─ rejection_id: numeric NULL
   ├─ rejection_index: int NULL

📋 LRSAdmin.lr_rental_amount_revision (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ effective_date: datetime NOT NULL
   ├─ annual_rental_amount: float NULL
   ├─ begin_lifespan_version: datetime NULL
   ├─ end_lifespan_version: datetime NULL
   ├─ property_number: nvarchar(50) NOT NULL

📋 LRSAdmin.lr_replicationcontent (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ node_path: nvarchar(254) NOT NULL
   ├─ parent_path: nvarchar(254) NOT NULL
   ├─ package: numeric NULL
   ├─ create_date: datetime NOT NULL

📋 LRSAdmin.lr_replicationlog (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ package: numeric NULL
   ├─ batch_id: numeric NOT NULL
   ├─ entity_id: numeric NOT NULL
   ├─ entity_classname: nvarchar(128) NOT NULL
   ├─ logged_at: datetime NOT NULL
   ├─ uploaded_at: datetime NULL
   ├─ uploaded: tinyint NULL
   ├─ repeat_number: int NOT NULL

📋 LRSAdmin.lr_replicationpackage (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ package_name: nvarchar(128) NOT NULL
   ├─ status: numeric NOT NULL
   ├─ modify_date: datetime NOT NULL
   ├─ create_date: datetime NOT NULL

📋 LRSAdmin.lr_rrr (225 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ rrr_type: numeric NOT NULL
   ├─ transaction_source: nvarchar(50) NULL
   ├─ transaction_cancel: nvarchar(50) NULL
   ├─ share_nominator: int NULL
   ├─ share_denominator: int NULL
   ├─ description: nvarchar(1500) NULL
   ├─ time_spec: datetime NULL
   ├─ start_date: datetime NULL
   └─ ... and 25 more columns

📋 LRSAdmin.lr_rrr_billing (0 rows)
   ├─ rrr: numeric NOT NULL
   ├─ billing: numeric NOT NULL
   ├─ rrr_index: int NOT NULL

📋 LRSAdmin.lr_rrr_condition (0 rows)
   ├─ rrr: numeric NOT NULL
   ├─ condition: numeric NOT NULL
   ├─ rrr_index: int NOT NULL

📋 LRSAdmin.lr_rrr_deleted (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ rrr_type: numeric NOT NULL
   ├─ transaction_source: nvarchar(50) NULL
   ├─ transaction_cancel: nvarchar(50) NULL
   ├─ share_nominator: int NULL
   ├─ share_denominator: int NULL
   ├─ description: nvarchar(1500) NULL
   ├─ time_spec: datetime NULL
   ├─ start_date: datetime NULL
   └─ ... and 25 more columns

📋 LRSAdmin.lr_rrr_metadata (12 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ code: nvarchar(64) NOT NULL
   ├─ label: nvarchar(254) NOT NULL
   ├─ descr: nvarchar(1000) NULL
   ├─ category: nvarchar(64) NOT NULL
   ├─ general_term: tinyint NULL
   ├─ sort_order: int NULL
   ├─ hidden: tinyint NULL
   ├─ rrr_type: int NOT NULL
   └─ ... and 5 more columns

📋 LRSAdmin.lr_rrr_patched (0 rows)
   ├─ id: numeric NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ rrr_type: numeric NOT NULL
   ├─ transaction_source: nvarchar(50) NULL
   ├─ transaction_cancel: nvarchar(50) NULL
   ├─ share_nominator: int NULL
   ├─ share_denominator: int NULL
   ├─ description: nvarchar(1500) NULL
   ├─ time_spec: datetime NULL
   ├─ start_date: datetime NULL
   └─ ... and 25 more columns

📋 LRSAdmin.lr_setting (363 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ category: nvarchar(64) NOT NULL
   ├─ name: nvarchar(150) NOT NULL
   ├─ value: nvarchar(1000) NOT NULL
   ├─ description: nvarchar(1000) NULL

📋 LRSAdmin.lr_simplecounter (42 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ counter: nvarchar(255) NOT NULL
   ├─ value: numeric NOT NULL
   ├─ office_prefix: tinyint NULL
   ├─ digital_prefix: tinyint NULL
   ├─ digital_length: int NOT NULL
   ├─ modify_date: datetime NULL
   ├─ with_rollback: tinyint NULL
   ├─ own_prefix: nvarchar(5) NULL
   └─ ... and 2 more columns

📋 LRSAdmin.lr_simplecounter_pool (1 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ counter: nvarchar(255) NOT NULL
   ├─ value: numeric NOT NULL
   ├─ ref_number: nvarchar(255) NULL
   ├─ modify_date: datetime NULL

📋 LRSAdmin.lr_site_analysis (4729 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ neighbourhood: nvarchar(50) NULL
   ├─ max_high_allow: numeric NULL
   ├─ devlopment_status: numeric NULL
   ├─ density: numeric NULL
   ├─ with_planning_schema: tinyint NULL
   ├─ tps_nopta_number: nvarchar(50) NULL
   ├─ max_area_development: float NULL
   ├─ topography: numeric NULL
   └─ ... and 46 more columns

📋 LRSAdmin.lr_source_document (21479 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ document_number: nvarchar(50) NULL
   ├─ ref_number: nvarchar(50) NULL
   ├─ minute_number: nvarchar(50) NULL
   ├─ document_type: numeric NOT NULL
   ├─ duplicate: tinyint NULL
   ├─ access_type: numeric NOT NULL
   ├─ acceptance: datetime NULL
   ├─ recordation: datetime NULL
   └─ ... and 17 more columns

📋 LRSAdmin.lr_spatial_unit (4729 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ suid: nvarchar(50) NULL
   ├─ old_property_id: nvarchar(50) NULL
   ├─ tenure_type: numeric NOT NULL
   ├─ label: nvarchar(250) NULL
   ├─ note: nvarchar(500) NULL
   ├─ comments: nvarchar(800) NULL
   ├─ spatial_unit_type: numeric NOT NULL
   ├─ status: numeric NOT NULL
   └─ ... and 51 more columns

📋 LRSAdmin.lr_spatial_unit_ext (4729 rows)
   ├─ parent_id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ extended_comments: nvarchar(2000) NULL
   ├─ extended_params: nvarchar(1000) NULL

📋 LRSAdmin.lr_spatial_unit_member (0 rows)
   ├─ parent_unit: numeric NOT NULL
   ├─ child_unit: numeric NOT NULL
   ├─ unit_index: int NOT NULL

📋 LRSAdmin.lr_survey_plan (1 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ plan_number: nvarchar(40) NULL
   ├─ local_government_area: numeric NULL
   ├─ zone: numeric NOT NULL
   ├─ layout: numeric NOT NULL
   ├─ city: nvarchar(100) NULL
   ├─ cell: nvarchar(100) NULL
   ├─ ward: nvarchar(100) NULL
   ├─ district_text: nvarchar(100) NULL
   └─ ... and 20 more columns

📋 LRSAdmin.lr_taxation (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ tax_amount: float NULL
   ├─ tax_type: numeric NOT NULL
   ├─ tax_date: datetime NULL
   ├─ comments: nvarchar(800) NULL
   ├─ version: numeric NULL
   ├─ begin_lifespan_version: datetime NULL
   ├─ end_lifespan_version: datetime NULL

📋 LRSAdmin.lr_tempcounter (43 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ counter: numeric NOT NULL
   ├─ value_text: nvarchar(255) NOT NULL
   ├─ ref_number: nvarchar(255) NULL
   ├─ transaction_id: numeric NULL
   ├─ transaction_index: int NULL

📋 LRSAdmin.lr_transaction (16766 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ transaction_number: nvarchar(50) NULL
   ├─ transaction_type: numeric NULL
   ├─ transaction_status: numeric NOT NULL
   ├─ transaction_source: numeric NOT NULL
   ├─ source_property_ids: nvarchar(500) NULL
   ├─ target_property_ids: nvarchar(500) NULL
   ├─ old_property_id: nvarchar(50) NULL
   ├─ parent_property_ids: nvarchar(500) NULL
   └─ ... and 88 more columns

📋 LRSAdmin.lr_transaction_document (33306 rows)
   ├─ transaction_id: numeric NOT NULL
   ├─ document_id: numeric NOT NULL
   ├─ document_index: int NOT NULL

📋 LRSAdmin.lr_transaction_ext (16766 rows)
   ├─ parent_id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ extended_comments: nvarchar(2000) NULL
   ├─ extended_params: nvarchar(1000) NULL
   ├─ NonExistingPropertiesSearch: nvarchar(1000) NULL
   ├─ CountPropertiesSearch: numeric NULL

📋 LRSAdmin.lr_transaction_launit (16520 rows)
   ├─ transaction_id: numeric NOT NULL
   ├─ launit_id: numeric NOT NULL
   ├─ launit_index: int NOT NULL

📋 LRSAdmin.lr_transaction_metadata (42 rows)
   ├─ Id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ code: nvarchar(64) NOT NULL
   ├─ label: nvarchar(128) NOT NULL
   ├─ descr: nvarchar(1000) NULL
   ├─ category: nvarchar(64) NOT NULL
   ├─ general_term: tinyint NULL
   ├─ sort_order: int NULL
   ├─ hidden: tinyint NULL
   ├─ group_name: nvarchar(255) NULL
   └─ ... and 32 more columns

📋 LRSAdmin.lr_transaction_note (1059 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ note_type: numeric NOT NULL
   ├─ comments: nvarchar(800) NULL
   ├─ user_name: nvarchar(150) NULL
   ├─ task_id: numeric NULL
   ├─ task_name: nvarchar(250) NULL
   ├─ comment_ref: nvarchar(250) NULL
   ├─ create_date: datetime NULL
   ├─ transaction_id: numeric NULL
   └─ ... and 1 more columns

📋 LRSAdmin.lr_transaction_party (23968 rows)
   ├─ transaction_id: numeric NOT NULL
   ├─ party_id: numeric NOT NULL
   ├─ party_index: int NOT NULL

📋 LRSAdmin.lr_transaction_record (123 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ operation_type: numeric NOT NULL
   ├─ source_rrr: numeric NULL
   ├─ target_rrr: numeric NULL
   ├─ transaction_id: numeric NULL
   ├─ record_index: int NULL

📋 LRSAdmin.lr_usage (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ usage_type: numeric NOT NULL
   ├─ comments: nvarchar(800) NULL
   ├─ version: numeric NULL
   ├─ begin_lifespan_version: datetime NULL
   ├─ end_lifespan_version: datetime NULL

📋 LRSAdmin.lr_valuation (0 rows)
   ├─ id: numeric NOT NULL
   ├─ Hjtype: nvarchar(255) NOT NULL
   ├─ value: float NULL
   ├─ value_type: numeric NOT NULL
   ├─ value_date: datetime NULL
   ├─ comments: nvarchar(800) NULL
   ├─ valu1: nvarchar(50) NULL
   ├─ valu2: nvarchar(50) NULL
   ├─ valu_dict1: numeric NOT NULL
   ├─ valu_dict2: numeric NOT NULL
   └─ ... and 9 more columns

📋 LRSAdmin.sdms_bootstrap (190 rows)
   ├─ id: numeric NOT NULL
   ├─ resource_name: nvarchar(255) NOT NULL
   ├─ res_version: int NOT NULL
   ├─ created: datetime NOT NULL
   ├─ modified: datetime NOT NULL
   ├─ is_model: tinyint NOT NULL
   ├─ resource_type: nvarchar(255) NULL


================================================================================
POTENTIALLY RELEVANT TABLES FOR DOCUMENT/PAGE MANAGEMENT
================================================================================

Found 11 potentially relevant table(s):

✅ LRSAdmin.alf_content_data (421,673 rows)
✅ LRSAdmin.alf_content_url (421,660 rows)
✅ LRSAdmin.alf_lock_resource (42 rows)
📦 LRSAdmin.lr_admin_document_party (empty)
📦 LRSAdmin.lr_admin_document_rrr (empty)
📦 LRSAdmin.lr_admin_source_document (empty)
✅ LRSAdmin.lr_document_ext (21,466 rows)
✅ LRSAdmin.lr_incoming_document (21,479 rows)
📦 LRSAdmin.lr_replicationcontent (empty)
✅ LRSAdmin.lr_source_document (21,479 rows)
✅ LRSAdmin.lr_transaction_document (33,306 rows)

================================================================================
DETAILED: LRSAdmin.lr_source_document
================================================================================

Columns (27):
  id: numeric NOT NULL
  Hjtype: nvarchar(255) NOT NULL
  document_number: nvarchar(50) NULL
  ref_number: nvarchar(50) NULL
  minute_number: nvarchar(50) NULL
  document_type: numeric NOT NULL
  duplicate: tinyint NULL
  access_type: numeric NOT NULL
  acceptance: datetime NULL
  recordation: datetime NULL
  submission: datetime NULL
  issued_by: nvarchar(500) NULL
  page_count: int NULL
  comments: nvarchar(800) NULL
  create_date: datetime NULL
  modified_at: datetime NULL
  modified_by: nvarchar(255) NULL
  property_file_page: nvarchar(50) NULL
  sdoc1: nvarchar(50) NULL
  sdoc2: nvarchar(50) NULL
  sdoc_dict1: numeric NOT NULL
  sdoc_dict2: numeric NOT NULL
  sdoc_count1: int NULL
  sdoc_count2: int NULL
  version: numeric NULL
  begin_lifespan_version: datetime NULL
  end_lifespan_version: datetime NULL


Sample data for PL11089:
------------------------------------------------------------

Record (ID: 10000000013787):
  id: 10000000013787
  Hjtype: com.landsystems.lrs.model.IncomingDocument
  document_number: PL11089
  document_type: 111
  duplicate: 0
  access_type: 17
  submission: 1989-02-08 00:00:00
  issued_by: Ministry of Lands, Survey and Town Planning (MLSTP)
  page_count: 1
  create_date: 2015-03-09 10:14:41.373000
  modified_at: 2015-03-11 15:49:45.477000
  modified_by: alamba
  sdoc_dict1: 1
  sdoc_dict2: 1
  version: 1

Record (ID: 10000000013791):
  id: 10000000013791
  Hjtype: com.landsystems.lrs.model.IncomingDocument
  document_number: PL11089
  document_type: 103
  duplicate: 0
  access_type: 17
  submission: 1988-08-01 00:00:00
  issued_by: Ministry of Lands, Survey and Town Planning (MLSTP)
  page_count: 46
  create_date: 2015-03-09 10:16:58.877000
  modified_at: 2015-07-29 13:57:57.143000
  modified_by: uofem
  sdoc_dict1: 1
  sdoc_dict2: 1
  version: 1

Record (ID: 10000000013800):
  id: 10000000013800
  Hjtype: com.landsystems.lrs.model.IncomingDocument
  document_number: PL11089
  document_type: 127
  duplicate: 0
  access_type: 17
  submission: 1989-02-15 00:00:00
  issued_by: Director General
  page_count: 2
  create_date: 2015-03-09 10:23:44.940000
  modified_at: 2015-03-11 15:49:45.477000
  modified_by: alamba
  property_file_page: 29
  sdoc_dict1: 1
  sdoc_dict2: 1
  version: 1

================================================================================
SCHEMA DUMP COMPLETE
================================================================================

Total tables found: 169
Save this output to a file for reference!