🔌 Connecting to database...
📊 Extracting database schema...
✅ Found 169 tables
  [1/169] Processing LRSAdmin.alf_access_control_entry... ✅ (7 columns)
  [2/169] Processing LRSAdmin.alf_access_control_list... ✅ (12 columns)
  [3/169] Processing LRSAdmin.alf_ace_context... ✅ (5 columns)
  [4/169] Processing LRSAdmin.alf_acl_change_set... ✅ (2 columns)
  [5/169] Processing LRSAdmin.alf_acl_member... ✅ (5 columns)
  [6/169] Processing LRSAdmin.alf_activity_feed... ✅ (11 columns)
  [7/169] Processing LRSAdmin.alf_activity_feed_control... ✅ (5 columns)
  [8/169] Processing LRSAdmin.alf_activity_post... ✅ (10 columns)
  [9/169] Processing LRSAdmin.alf_applied_patch... ✅ (11 columns)
  [10/169] Processing LRSAdmin.alf_attributes... ✅ (13 columns)
  [11/169] Processing LRSAdmin.alf_audit_app... ✅ (5 columns)
  [12/169] Processing LRSAdmin.alf_audit_entry... ✅ (5 columns)
  [13/169] Processing LRSAdmin.alf_audit_model... ✅ (3 columns)
  [14/169] Processing LRSAdmin.alf_authority... ✅ (4 columns)
  [15/169] Processing LRSAdmin.alf_authority_alias... ✅ (4 columns)
  [16/169] Processing LRSAdmin.alf_child_assoc... ✅ (12 columns)
  [17/169] Processing LRSAdmin.alf_content_data... ✅ (6 columns)
  [18/169] Processing LRSAdmin.alf_content_url... ✅ (6 columns)
  [19/169] Processing LRSAdmin.alf_encoding... ✅ (3 columns)
  [20/169] Processing LRSAdmin.alf_global_attributes... ✅ (2 columns)
  [21/169] Processing LRSAdmin.alf_list_attribute_entries... ✅ (3 columns)
  [22/169] Processing LRSAdmin.alf_locale... ✅ (3 columns)
  [23/169] Processing LRSAdmin.alf_lock... ✅ (7 columns)
  [24/169] Processing LRSAdmin.alf_lock_resource... ✅ (4 columns)
  [25/169] Processing LRSAdmin.alf_map_attribute_entries... ✅ (3 columns)
  [26/169] Processing LRSAdmin.alf_mimetype... ✅ (3 columns)
  [27/169] Processing LRSAdmin.alf_namespace... ✅ (3 columns)
  [28/169] Processing LRSAdmin.alf_node... ✅ (13 columns)
  [29/169] Processing LRSAdmin.alf_node_aspects... ✅ (2 columns)
  [30/169] Processing LRSAdmin.alf_node_assoc... ✅ (5 columns)
  [31/169] Processing LRSAdmin.alf_node_properties... ✅ (12 columns)
  [32/169] Processing LRSAdmin.alf_permission... ✅ (4 columns)
  [33/169] Processing LRSAdmin.alf_prop_class... ✅ (4 columns)
  [34/169] Processing LRSAdmin.alf_prop_date_value... ✅ (10 columns)
  [35/169] Processing LRSAdmin.alf_prop_double_value... ✅ (2 columns)
  [36/169] Processing LRSAdmin.alf_prop_link... ✅ (5 columns)
  [37/169] Processing LRSAdmin.alf_prop_root... ✅ (2 columns)
  [38/169] Processing LRSAdmin.alf_prop_serializable_value... ✅ (2 columns)
  [39/169] Processing LRSAdmin.alf_prop_string_value... ✅ (4 columns)
  [40/169] Processing LRSAdmin.alf_prop_unique_ctx... ✅ (6 columns)
  [41/169] Processing LRSAdmin.alf_prop_value... ✅ (4 columns)
  [42/169] Processing LRSAdmin.alf_qname... ✅ (4 columns)
  [43/169] Processing LRSAdmin.alf_server... ✅ (3 columns)
  [44/169] Processing LRSAdmin.alf_store... ✅ (5 columns)
  [45/169] Processing LRSAdmin.alf_transaction... ✅ (5 columns)
  [46/169] Processing LRSAdmin.alf_usage_delta... ✅ (4 columns)
  [47/169] Processing LRSAdmin.avm_aspects... ✅ (2 columns)
  [48/169] Processing LRSAdmin.avm_child_entries... ✅ (4 columns)
  [49/169] Processing LRSAdmin.avm_history_links... ✅ (2 columns)
  [50/169] Processing LRSAdmin.avm_merge_links... ✅ (2 columns)
  [51/169] Processing LRSAdmin.avm_node_properties... ✅ (11 columns)
  [52/169] Processing LRSAdmin.avm_nodes... ✅ (24 columns)
  [53/169] Processing LRSAdmin.avm_store_properties... ✅ (12 columns)
  [54/169] Processing LRSAdmin.avm_stores... ✅ (6 columns)
  [55/169] Processing LRSAdmin.avm_version_layered_node_entry... ✅ (3 columns)
  [56/169] Processing LRSAdmin.avm_version_roots... ✅ (8 columns)
  [57/169] Processing LRSAdmin.JBPM_ACTION... ✅ (19 columns)
  [58/169] Processing LRSAdmin.JBPM_BYTEARRAY... ✅ (3 columns)
  [59/169] Processing LRSAdmin.JBPM_BYTEBLOCK... ✅ (3 columns)
  [60/169] Processing LRSAdmin.JBPM_COMMENT... ✅ (9 columns)
  [61/169] Processing LRSAdmin.JBPM_DECISIONCONDITIONS... ✅ (4 columns)
  [62/169] Processing LRSAdmin.JBPM_DELEGATION... ✅ (5 columns)
  [63/169] Processing LRSAdmin.JBPM_EVENT... ✅ (8 columns)
  [64/169] Processing LRSAdmin.JBPM_EXCEPTIONHANDLER... ✅ (9 columns)
  [65/169] Processing LRSAdmin.JBPM_JOB... ✅ (20 columns)
  [66/169] Processing LRSAdmin.JBPM_LOG... ✅ (40 columns)
  [67/169] Processing LRSAdmin.JBPM_MODULEDEFINITION... ✅ (5 columns)
  [68/169] Processing LRSAdmin.JBPM_MODULEINSTANCE... ✅ (6 columns)
  [69/169] Processing LRSAdmin.JBPM_NODE... ✅ (19 columns)
  [70/169] Processing LRSAdmin.JBPM_POOLEDACTOR... ✅ (4 columns)
  [71/169] Processing LRSAdmin.JBPM_PROCESSDEFINITION... ✅ (7 columns)
  [72/169] Processing LRSAdmin.JBPM_PROCESSINSTANCE... ✅ (9 columns)
  [73/169] Processing LRSAdmin.JBPM_RUNTIMEACTION... ✅ (8 columns)
  [74/169] Processing LRSAdmin.JBPM_SWIMLANE... ✅ (6 columns)
  [75/169] Processing LRSAdmin.JBPM_SWIMLANEINSTANCE... ✅ (6 columns)
  [76/169] Processing LRSAdmin.JBPM_TASK... ✅ (17 columns)
  [77/169] Processing LRSAdmin.JBPM_TASKACTORPOOL... ✅ (2 columns)
  [78/169] Processing LRSAdmin.JBPM_TASKCONTROLLER... ✅ (2 columns)
  [79/169] Processing LRSAdmin.JBPM_TASKINSTANCE... ✅ (22 columns)
  [80/169] Processing LRSAdmin.JBPM_TOKEN... ✅ (15 columns)
  [81/169] Processing LRSAdmin.JBPM_TOKENVARIABLEMAP... ✅ (4 columns)
  [82/169] Processing LRSAdmin.JBPM_TRANSITION... ✅ (8 columns)
  [83/169] Processing LRSAdmin.JBPM_VARIABLEACCESS... ✅ (8 columns)
  [84/169] Processing LRSAdmin.JBPM_VARIABLEINSTANCE... ✅ (16 columns)
  [85/169] Processing LRSAdmin.JMS_MESSAGES... ✅ (5 columns)
  [86/169] Processing LRSAdmin.JMS_ROLES... ✅ (2 columns)
  [87/169] Processing LRSAdmin.JMS_SUBSCRIPTIONS... ✅ (4 columns)
  [88/169] Processing LRSAdmin.JMS_TRANSACTIONS... ✅ (1 columns)
  [89/169] Processing LRSAdmin.JMS_USERS... ✅ (3 columns)
  [90/169] Processing LRSAdmin.lr_address... ✅ (27 columns)
  [91/169] Processing LRSAdmin.lr_admin_document_party... ✅ (3 columns)
  [92/169] Processing LRSAdmin.lr_admin_document_rrr... ✅ (3 columns)
  [93/169] Processing LRSAdmin.lr_admin_source_document... ✅ (3 columns)
  [94/169] Processing LRSAdmin.lr_applicant... ✅ (3 columns)
  [95/169] Processing LRSAdmin.lr_batch... ✅ (18 columns)
  [96/169] Processing LRSAdmin.lr_batch_party... ✅ (3 columns)
  [97/169] Processing LRSAdmin.lr_batch_related... ✅ (5 columns)
  [98/169] Processing LRSAdmin.lr_billing... ✅ (23 columns)
  [99/169] Processing LRSAdmin.lr_billing_dist_line... ✅ (15 columns)
  [100/169] Processing LRSAdmin.lr_billing_line... ✅ (13 columns)
  [101/169] Processing LRSAdmin.lr_building... ✅ (15 columns)
  [102/169] Processing LRSAdmin.lr_building_unit... ✅ (29 columns)
  [103/169] Processing LRSAdmin.lr_business_calendar... ✅ (5 columns)
  [104/169] Processing LRSAdmin.lr_condition... ✅ (25 columns)
  [105/169] Processing LRSAdmin.lr_contact... ✅ (2 columns)
  [106/169] Processing LRSAdmin.lr_corporation... ✅ (9 columns)
  [107/169] Processing LRSAdmin.lr_dictionary... ✅ (15 columns)
  [108/169] Processing LRSAdmin.lr_document_ext... ✅ (4 columns)
  [109/169] Processing LRSAdmin.lr_extension_link... ✅ (4 columns)
  [110/169] Processing LRSAdmin.lr_fee_rate... ✅ (16 columns)
  [111/169] Processing LRSAdmin.lr_fee_structure... ✅ (10 columns)
  [112/169] Processing LRSAdmin.lr_formfield... ✅ (24 columns)
  [113/169] Processing LRSAdmin.lr_ground_rent... ✅ (6 columns)
  [114/169] Processing LRSAdmin.lr_incoming_document... ✅ (2 columns)
  [115/169] Processing LRSAdmin.lr_individual... ✅ (20 columns)
  [116/169] Processing LRSAdmin.lr_launit... ✅ (25 columns)
  [117/169] Processing LRSAdmin.lr_launit_lineage... ✅ (9 columns)
  [118/169] Processing LRSAdmin.lr_launit_spatial_unit... ✅ (3 columns)
  [119/169] Processing LRSAdmin.lr_mc_job... ✅ (13 columns)
  [120/169] Processing LRSAdmin.lr_mortgage... ✅ (15 columns)
  [121/169] Processing LRSAdmin.lr_parcel... ✅ (21 columns)
  [122/169] Processing LRSAdmin.lr_party... ✅ (27 columns)
  [123/169] Processing LRSAdmin.lr_party_contact... ✅ (3 columns)
  [124/169] Processing LRSAdmin.lr_party_ext... ✅ (4 columns)
  [125/169] Processing LRSAdmin.lr_party_group... ✅ (14 columns)
  [126/169] Processing LRSAdmin.lr_party_launit... ✅ (2 columns)
  [127/169] Processing LRSAdmin.lr_party_member... ✅ (10 columns)
  [128/169] Processing LRSAdmin.lr_payment... ✅ (38 columns)
  [129/169] Processing LRSAdmin.lr_payment_transaction... ✅ (40 columns)
  [130/169] Processing LRSAdmin.lr_person... ✅ (37 columns)
  [131/169] Processing LRSAdmin.lr_process_event... ✅ (8 columns)
  [132/169] Processing LRSAdmin.lr_process_history... ✅ (13 columns)
  [133/169] Processing LRSAdmin.lr_registry... ✅ (6 columns)
  [134/169] Processing LRSAdmin.lr_registry_office... ✅ (15 columns)
  [135/169] Processing LRSAdmin.lr_rejection... ✅ (5 columns)
  [136/169] Processing LRSAdmin.lr_rejection_reason... ✅ (6 columns)
  [137/169] Processing LRSAdmin.lr_rental_amount_revision... ✅ (7 columns)
  [138/169] Processing LRSAdmin.lr_replicationcontent... ✅ (6 columns)
  [139/169] Processing LRSAdmin.lr_replicationlog... ✅ (10 columns)
  [140/169] Processing LRSAdmin.lr_replicationpackage... ✅ (6 columns)
  [141/169] Processing LRSAdmin.lr_rrr... ✅ (35 columns)
  [142/169] Processing LRSAdmin.lr_rrr_billing... ✅ (3 columns)
  [143/169] Processing LRSAdmin.lr_rrr_condition... ✅ (3 columns)
  [144/169] Processing LRSAdmin.lr_rrr_deleted... ✅ (35 columns)
  [145/169] Processing LRSAdmin.lr_rrr_metadata... ✅ (15 columns)
  [146/169] Processing LRSAdmin.lr_rrr_patched... ✅ (35 columns)
  [147/169] Processing LRSAdmin.lr_setting... ✅ (6 columns)
  [148/169] Processing LRSAdmin.lr_simplecounter... ✅ (12 columns)
  [149/169] Processing LRSAdmin.lr_simplecounter_pool... ✅ (6 columns)
  [150/169] Processing LRSAdmin.lr_site_analysis... ✅ (56 columns)
  [151/169] Processing LRSAdmin.lr_source_document... ✅ (27 columns)
  [152/169] Processing LRSAdmin.lr_spatial_unit... ✅ (61 columns)
  [153/169] Processing LRSAdmin.lr_spatial_unit_ext... ✅ (4 columns)
  [154/169] Processing LRSAdmin.lr_spatial_unit_member... ✅ (3 columns)
  [155/169] Processing LRSAdmin.lr_survey_plan... ✅ (30 columns)
  [156/169] Processing LRSAdmin.lr_taxation... ✅ (9 columns)
  [157/169] Processing LRSAdmin.lr_tempcounter... ✅ (7 columns)
  [158/169] Processing LRSAdmin.lr_transaction... ✅ (98 columns)
  [159/169] Processing LRSAdmin.lr_transaction_document... ✅ (3 columns)
  [160/169] Processing LRSAdmin.lr_transaction_ext... ✅ (6 columns)
  [161/169] Processing LRSAdmin.lr_transaction_launit... ✅ (3 columns)
  [162/169] Processing LRSAdmin.lr_transaction_metadata... ✅ (42 columns)
  [163/169] Processing LRSAdmin.lr_transaction_note... ✅ (11 columns)
  [164/169] Processing LRSAdmin.lr_transaction_party... ✅ (3 columns)
  [165/169] Processing LRSAdmin.lr_transaction_record... ✅ (7 columns)
  [166/169] Processing LRSAdmin.lr_usage... ✅ (7 columns)
  [167/169] Processing LRSAdmin.lr_valuation... ✅ (19 columns)
  [168/169] Processing LRSAdmin.sdms_bootstrap... ✅ (7 columns)
  [169/169] Processing LRSAdmin.tqb_transaction_type... ✅ (2 columns)

💾 Saving schema to database_schema.json...
📝 Creating markdown documentation: database_schema.md...
📋 Creating quick reference: database_quick_reference.txt...

✅ Schema documentation complete!

📁 Files created:
   - database_schema.json (Full schema in JSON format)
   - database_schema.md (Human-readable markdown)
   - database_quick_reference.txt (Quick column reference)

💡 Use these files to reference exact column names when writing SQL queries!
