1 Table of Contents Chapter 1 - Introduction 4 About Navicat Data Modeler 4 Installation 5 Registration 6 Migration / Upgrade 7 End-User License Agreement 7 Chapter 2 - User Interface Chapter 4 - Model 23 About Model 23 Create Model 25 Chapter 5 - Physical Model 27 About Physical Model 27 Add Databases / Schemas to Physical Model 27 Add Tables to Physical Model 28 Add to Physical Model 30 Work with View Builder (Available only in Non-Essentials Version) 31 Edit View's Definition 37 Add Foreign Keys to Physical Model 40 Chapter 6 - Logical Model 41 About

1 Table of Contents Chapter 1 - Introduction 4 About Navicat Data Modeler 4 Installation 5 Registration 5 Migration / Upgrade 6 End-User License Agreement 7 Chapter 2 - User Interface Chapter 4 - Model 23 About Model 23 Create Model 25 Chapter 5 - Physical Model 27 About Physical Models 27 Add Databases / Schemas to Physical Model 27 Add Tables to Physical Model 28 Add to Physical Model 30 Work with View Builder (Available only in Non-Essentials Version) 31 Edit View's Definition 37 Add Foreign Keys to Physical Model 40 Chapter 6 - Logical Model 41 About

78 Maintain Objects 79 Redis 80 Databases 80 Data 80 Chapter 6 - Data Viewer 81 About Data Viewer 81 RDBMS 81 RDBMS Data Viewer 81 Use Navigation Bar 81 Edit Records 82 Replace Records 88 Filter Records 90 Manipulate Raw Data 90 Format Data View 91 View Field Comments 92 MongoDB 93 MongoDB Data Viewer 93 Use Navigation Bar 93 Grid View 94 Tree Tree View 100 JSON View 102 Sort / Find / Replace Documents 102 Redis 105 Redis Data Viewer 105 Use Navigation Bar 105 Edit Keys 106 Sort Keys 106 Search Keys 107 Assistant Editors

76 Maintain Objects 77 Redis 78 Databases 78 Data 78 Chapter 6 - Data Viewer 79 About Data Viewer 79 RDBMS 79 RDBMS Data Viewer 79 Use Navigation Bar 79 Edit Records 80 Replace Records 86 Filter Records 88 Manipulate Raw Data 89 Format Data View 89 View Field Comments 91 MongoDB 91 MongoDB Data Viewer 91 Use Navigation Bar 92 Grid View 93 Tree Tree View 98 JSON View 100 Sort / Find / Replace Documents 100 Redis 103 Redis Data Viewer 103 Use Navigation Bar 103 Edit Keys 104 Sort Keys 105 Search Keys 105 Assistant Editors

76 Maintain Objects 77 Redis 78 Databases 78 Data 78 Chapter 6 - Data Viewer 79 About Data Viewer 79 RDBMS 79 RDBMS Data Viewer 79 Use Navigation Bar 79 Edit Records 80 Replace Records 86 Filter Records 88 Manipulate Raw Data 89 Format Data View 89 View Field Comments 90 MongoDB 90 MongoDB Data Viewer 90 Use Navigation Bar 91 Grid View 92 Tree Tree View 97 JSON View 99 Sort / Find / Replace Documents 99 Redis 102 Redis Data Viewer 102 Use Navigation Bar 102 Edit Keys 103 Sort Keys 104 Search Keys 104 Assistant Editors

Guide 24.2.ea. Page 7 of 1010. Data Editor overview Data View and Format Data Filters Data viewing and editing Data refresh Navigation Managing Panels Managing Data formats Managing Charts Working Information System (GIS) data GIS examples Working with XML and JSON Virtual column expressions SQL Editor overview Data Editor tools Viewing and editing data Data operations Advanced data types SQL Editor Pending Transactions Auto and manual commit modes Query Manager Data transfer Data import and replace Search overview Data Search Database full text Search Database metadata Search File Search

User Guide 24.1. Page 7 of 1008. Data Editor overview Data View and Format Data Filters Data viewing and editing Data refresh Navigation Managing Panels Managing Data formats Managing Charts Working Information System (GIS) data GIS examples Working with XML and JSON Virtual column expressions SQL Editor overview Data Editor tools Viewing and editing data Data operations Advanced data types SQL Editor Pending Transactions Auto and manual commit modes Query Manager Data transfer Data import and replace Search overview Data Search Database full text Search Database metadata Search File Search

Project security Editors overview Data Editor overview Data View and Format Data Filters Data viewing and editing Data refresh Navigation Managing Panels Managing Data formats Managing Charts Projects Editors in DBeaver Data Editor tools Viewing and editing data Data operations DBeaver Ultimate User Guide 24.1. Page 8 of 1169. Working with Spatial Geographic Information System (GIS) data GIS examples examples Working with XML and JSON Virtual column expressions Mock Data generation SQL Editor overview SQL Execution Query execution plan Script management SQL Assist and Auto Complete SQL templates

Project security Editors overview Data Editor overview Data View and Format Data Filters Data viewing and editing Data refresh Navigation Managing Panels Managing Data formats Managing Charts Projects in DBeaver Data Editor tools Viewing and editing data Data operations DBeaver Ultimate User Guide 24.2.ea. Page 8 of 1171. Working with Spatial Geographic Information System (GIS) data GIS examples examples Working with XML and JSON Virtual column expressions Mock Data generation SQL Editor overview SQL Execution Query execution plan Script management SQL Assist and Auto Complete SQL templates

Editors overview Data Editor overview Data View and Format Data Filters Data viewing and editing Data refresh Navigation Managing Panels Projects workspace Editors in DBeaver Data Editor tools Viewing Viewing and editing data Data operations DBeaver User Guide 24.2.ea. Page 8 of 1171. Managing Data formats Managing Charts Working with Spatial Geographic Information System (GIS) data GIS examples Working Working with XML and JSON Virtual column expressions Mock Data generation SQL Editor overview SQL Execution Query execution plan Script management SQL Assist and Auto Complete SQL templates Visual