Common use of General Properties Clause in Contracts

General Properties. Note: The following options depend on the diagram database type you are chosen. Include auto increment Include table auto increment values in the SQL file with this option is on. Include character set Include table and field character set in the SQL file with this option is on. Include checks Include checks in the SQL file with this option is on. Include collation Include table collation in the SQL file with this option is on. Include Drop SQL Include drop object SQL statements in the SQL file with this option in on. Include Drop With CASCADE Include drop object SQL statements with the CASCADE option in the SQL file with this option in on. Include excludes Include excludes in the SQL file with this option is on. Include foreign keys Include foreign keys in the SQL file with this option is on. Include indexes Include indexes in the SQL file with this option is on. Include primary keys Include primary keys in the SQL file with this option is on. Include rules Include rules in the SQL file with this option is on. Include schema Include the schema names in the SQL file with this option is on. Otherwise, only object names are included in SQL statements. Include triggers Include triggers in the SQL file with this option is on. Include uniques Include uniques in the SQL file with this option is on. Server Version Select the server version for the SQL file. Chapter 10 – Other Advanced Tools‌ Useful Features‌ Navicat Data Modeler provides variety of tools that improve user experience when working on models.  Model Conversion  Auto Layout  Print and Export Model  Search Filter  Full Screen Mode Model Conversion‌ Navicat Data Modeler allows you to convert your models from one database type to another database type and also from one model type to another model type, e.g. MariaDB 10.0 physical model to PostgreSQL 9.0 physical model, Oracle 10g physical model to a logical model, a conceptual model to MySQL 5.0 physical model. During the conversion, all data types are converted automatically. The conversion process does not change the SQL syntax of views if converting from one database type to another. If you covert a physical model to logical/conceptual model, all views will be converted to entities. If the target database version is MySQL 4.0 or below, all views will be removed. To convert an opened model file, choose File -> Convert Model To. Then, choose the Model Type and select the target Database and Version if necessary. Auto Layout (Available only in Full Version)‌ To automatically arrange objects on the canvas, click the Auto Layout button. To change the Auto Layout format settings, simply choose Diagram -> Auto Layout with from the menu and set the following options: Auto Diagram Dimension Choose the suitable diagram dimension automatically. Auto Size Tables To Fit Resize the table to fit its content automatically. Quality The quality of the auto layout output. Object Distance The distance between the objects in the diagram. Print & Export Model‌ Preview a model To preview the pages before printing, simply click the Print Preview button. The model can be printed to the printer or exported to various file formats. Print to a printer Choose File -> Print to send your diagram directly to the printer. You can set the printer option in the pop-up window. Export to a file Choose File -> Export To and choose the file format to create a PDF, PNG, SVG or JPG file of your diagram. Search Filter‌ Object Filter allows you to filter models in Navicat Cloud Window and tables, entities or views in the canvas that names contain the filter string. Just specify a filter string in the Search text box. To remove the filter, simply delete the filter string. Full Screen Mode‌ Edit the model using the whole screen. The title bar that normally displays as part of the Navicat Data Modeler application will be hidden while in this mode. Choose View -> Full Screen in the menu bar or simply press CTRL+F11 to start the full screen mode. When the full screen mode is cancelled, the Navicat Data Modeler window will be returned to its previous state. Chapter 11 – Configurations‌ Options Settings‌ Navicat Data Modeler provides several options for customizing its user interface and performance. To open the Options window, choose Tools -> Options from the menu bar. General‌ General Check for updates on startup Check this option to allow Navicat Data Modeler checks for new version when it starts. Usage Data Share usage data Check this option to let your device sends us information about how you use Navicat Data Modeler to help us improve it. You can view the information being shared by clicking the Usage Data button. High DPI Scaling method Choose the scaling method: As is, UI Controls, UI Controls + Font. Scaling factor Specify a scale factor (from 100% through 400%, in 25% increments) for scaling the UI controls or fonts. Hint: Restart Navicat Data Modeler to take effect. Model‌ Hint: Restart Navicat Data Modeler to take effect. Highlight objects With this option is on, when a mouse cursor hovers over an object, Navicat Data Modeler will highlight its border with blue color. Highlight with relation With this option is on, when a mouse cursor hovers over a table, a entity or a view, Navicat Data Modeler will highlight it's foreign keys, relations or view relations with blue or green color indicating relationships with other objects. Guess field type With this option is on, Navicat Data Modeler will predict field types when you design fields/attributes in tables or entities. Query‌ Use code completion (Available only in Non-Essentials Edition) When you type the . (dot) symbol or a character, the editor will offer you a pop-up list that showing some suggestions for the code completion. Auto update code completion info (Available only in Non-Essentials Edition) With this option is on, Navicat Data Modeler will get the latest database information for the code completion from your model. You can click Clear Code Completion Info to delete the information for code completion feature that stored on your device. Editor‌ General Show line number Display line numbers at the left side of the editor for easily reference. Use code folding Code folding allows codes to collapse as a block and only the first line displayed in the editor. Use brace highlighting Highlight the pair of braces when your cursor moves to either one brace for easily reference. Use syntax highlighting Syntax highlight helps viewing codes clearly. Codes are highlighted in the editor with different colors and fonts according to the categories they belong to. This feature can be limited by setting the maximum file size (e.g. 10) in Disable if file size is larger than (MB) to increase performance. Use word wrap Enable the word wrap mode in the editor. Tab Width Enter the number of characters that a tab occupies, e.g. 5. See Edit View's Definition. Font and Colors Editor Font Define the font and its size used by editors.

General Properties. Note: The following options depend on the diagram database type you are chosen. Include auto increment Include table auto increment values in the SQL file with this option is on. Include character set Include table and field character set in the SQL file with this option is on. Include checks Include checks in the SQL file with this option is on. Include collation Include table collation in the SQL file with this option is on. Include Drop SQL Include drop object SQL statements in the SQL file with this option in on. Include Drop With CASCADE Include drop object SQL statements with the CASCADE option in the SQL file with this option in on. Include excludes Include excludes in the SQL file with this option is on. Include foreign keys Include foreign keys in the SQL file with this option is on. Include indexes Include indexes in the SQL file with this option is on. Include primary keys Include primary keys in the SQL file with this option is on. Include rules Include rules in the SQL file with this option is on. Include schema Include the schema names in the SQL file with this option is on. Otherwise, only object names are included in SQL statements. Include triggers Include triggers in the SQL file with this option is on. Include uniques Include uniques in the SQL file with this option is on. Server Version Select the server version for the SQL file. Chapter 10 – 12 - Other Advanced Tools‌ Useful Features‌ Navicat Data Modeler provides variety of tools that improve user experience when working on models.  Model Conversion  Auto Layout  Print and Export Model  Virtual Grouping  Search Filter  Dark Theme  Full Screen Mode Model Conversion‌ Navicat Data Modeler allows you to convert your models from one database type to another database type and also from one model type to another model type, e.g. MariaDB 10.0 physical model to PostgreSQL 9.0 physical model, Oracle 10g physical model to a logical model, a conceptual model to MySQL 5.0 physical model. During the conversion, all data types are converted automatically. The conversion process does not change the SQL syntax of views if converting from one database type to another. If you covert a physical model to logical/conceptual model, all views will be converted to entities. If the target database version is MySQL 4.0 or below, all views will be removed. To convert an opened model file, choose File -> Convert Model To. Then, choose the Model Type and select the target Database and Version if necessary. Auto Layout (Available only in Full Version)‌ Non-Essentials Edition)‌ To automatically arrange objects on the canvas, click the Auto Layout button. To change the Auto Layout format settings, simply choose Diagram -> Auto Layout with from the menu and set the following options: Auto Diagram Dimension Choose the suitable diagram dimension automatically. Auto Size Tables To Fit Resize the table to fit its content automatically. Quality The quality of the auto layout output. Object Distance The distance between the objects in the diagram. Print & Export Model‌ Preview a model To preview the pages before printing, simply click the Print Preview button. The model can be printed to the printer or exported to various file formats. Print to a printer Choose File -> Print to send your diagram directly to the printer. You can set the printer option in the pop-up window. Export to a file Choose File -> Export To and choose the file format to create a PDF, PNG, SVG or JPG file of your diagram. Search Filter‌ Object Filter allows you to filter models in Navicat Cloud Window and tables, entities or views in the canvas that names contain the filter string. Just specify a filter string in the Search text box. To remove the filter, simply delete the filter string. Full Screen Mode‌ Edit the model using the whole screen. The title bar that normally displays as part of the Navicat Data Modeler application will be hidden while in this mode. Choose View -> Full Screen in the menu bar or simply press CTRL+F11 to start the full screen mode. When the full screen mode is cancelled, the Navicat Data Modeler window will be returned to its previous state. Chapter 11 – Configurations‌ Options Settings‌ Navicat Data Modeler provides several options for customizing its user interface and performance. To open the Options window, choose Tools -> Options from the menu bar. General‌ General Check for updates on startup Check this option to allow Navicat Data Modeler checks for new version when it starts. Usage Data Share usage data Check this option to let your device sends us information about how you use Navicat Data Modeler to help us improve it. You can view the information being shared by clicking the Usage Data button. High DPI Scaling method Choose the scaling method: As is, UI Controls, UI Controls + Font. Scaling factor Specify a scale factor (from 100% through 400%, in 25% increments) for scaling the UI controls or fonts. Hint: Restart Navicat Data Modeler to take effect. Model‌ Hint: Restart Navicat Data Modeler to take effect. Highlight objects With this option is on, when a mouse cursor hovers over an object, Navicat Data Modeler will highlight its border with blue color. Highlight with relation With this option is on, when a mouse cursor hovers over a table, a entity or a view, Navicat Data Modeler will highlight it's foreign keys, relations or view relations with blue or green color indicating relationships with other objects. Guess field type With this option is on, Navicat Data Modeler will predict field types when you design fields/attributes in tables or entities. Query‌ Use code completion Virtual Grouping (Available only in Non-Essentials Edition) When you type the Edition)‌ Virtual Group aims to provide a platform for logical grouping objects by categories, so that all objects are effectively preserved. (dot) symbol or a character, the editor will offer you a pop-up list that showing some suggestions for the code completion. Auto update code completion info (Available only in Non-Essentials Edition) With this option is on, Navicat Data Modeler will get the latest database information for the code completion from your model. You can click Clear Code Completion Info to delete the information for code completion feature that stored on your device. Editor‌ General Show line number Display line numbers at the left side of the editor for easily reference. Use code folding Code folding allows codes to collapse as a block and only the first line displayed in the editor. Use brace highlighting Highlight the pair of braces when your cursor moves to either one brace for easily reference. Use syntax highlighting Syntax highlight helps viewing codes clearly. Codes are highlighted in the editor with different colors and fonts according to the categories they belong to. This feature It can be limited by setting the maximum file size (e.g. 10) applied on all connections, and models in Disable if file size is larger than (MB) to increase performanceNavicat Cloud / On-Prem Server. Use word wrap Enable the word wrap mode in the editor. Tab Width Enter the number of characters that Connections Create a tab occupies, e.g. 5. See Edit View's Definition. Font and Colors Editor Font Define the font and its size used by editors.new group

General Properties. Note: The following options depend on the diagram database type you are chosen. Include auto increment Include table auto increment values in the SQL file with this option is on. Include character set Include table and field character set in the SQL file with this option is on. Include checks Include checks in the SQL file with this option is on. Include collation Include table collation in the SQL file with this option is on. Include Drop SQL Include drop object SQL statements in the SQL file with this option in on. Include Drop With CASCADE Include drop object SQL statements with the CASCADE option in the SQL file with this option in on. Include excludes Include excludes in the SQL file with this option is on. Include foreign keys Include foreign keys in the SQL file with this option is on. Include indexes Include indexes in the SQL file with this option is on. Include primary keys Include primary keys in the SQL file with this option is on. Include rules Include rules in the SQL file with this option is on. Include schema Include the schema names in the SQL file with this option is on. Otherwise, only object names are included in SQL statements. Include triggers Include triggers in the SQL file with this option is on. Include uniques Include uniques in the SQL file with this option is on. Server Version Select the server version for the SQL file. Chapter 10 – Other Advanced Tools‌ Useful Features‌ Navicat Data Modeler provides variety of tools that improve user experience when working on models.  • Model Conversion  • Auto Layout  • Print and Export Model  • Search Filter  • Full Screen Mode Model Conversion‌ Navicat Data Modeler allows you to convert your models from one database type to another database type and also from one model type to another model type, e.g. MariaDB 10.0 physical model to PostgreSQL 9.0 physical model, Oracle 10g physical model to a logical model, a conceptual model to MySQL 5.0 physical model. During the conversion, all data types are converted automatically. The conversion process does not change the SQL syntax of views if converting from one database type to another. If you covert a physical model to logical/conceptual model, all views will be converted to entities. If the target database version is MySQL 4.0 or below, all views will be removed. To convert an opened model file, choose File -> Convert Model To. Then, choose the Model Type and select the target Database and Version if necessary. Auto Layout (Available only in Full Version)‌ To automatically arrange objects on the canvas, click the Auto Layout button. To change the Auto Layout format settings, simply choose Diagram -> Auto Layout with from the menu and set the following options: Auto Diagram Dimension Choose the suitable diagram dimension automatically. Auto Size Tables To Fit Resize the table to fit its content automatically. Quality The quality of the auto layout output. Object Distance The distance between the objects in the diagram. Print & Export Model‌ Preview a model To preview the pages before printing, simply click the Print Preview button. The model can be printed to the printer or exported to various file formats. Print to a printer Choose File -> Print to send your diagram directly to the printer. You can set the printer option in the pop-up window. Export to a file Choose File -> Export To and choose the file format to create a PDF, PNG, SVG or JPG file of your diagram. Search Filter‌ Object Filter allows you to filter models in Navicat Cloud Window and tables, entities or views in the canvas that names contain the filter string. Just specify a filter string in the Search text box. To remove the filter, simply delete the filter string. Full Screen Mode‌ Edit the model using the whole screen. The title bar that normally displays as part of the Navicat Data Modeler application will be hidden while in this mode. Choose View -> Full Screen in the menu bar or simply press CTRL+F11 to start the full screen mode. When the full screen mode is cancelled, the Navicat Data Modeler window will be returned to its previous state. Chapter 11 – Configurations‌ Options Settings‌ Navicat Data Modeler provides several options for customizing its user interface and performance. To open the Options window, choose Tools -> Options from the menu bar. General‌ General Check for updates on startup Check this option to allow Navicat Data Modeler checks for new version when it starts. Usage Data Share usage data Check this option to let your device sends us information about how you use Navicat Data Modeler to help us improve it. You can view the information being shared by clicking the Usage Data button. High DPI Scaling method Choose the scaling method: As is, UI Controls, UI Controls + Font. Scaling factor Specify a scale factor (from 100% through 400%, in 25% increments) for scaling the UI controls or fonts. Hint: Restart Navicat Data Modeler to take effect. Model‌ Hint: Restart Navicat Data Modeler to take effect. Highlight objects With this option is on, when a mouse cursor hovers over an object, Navicat Data Modeler will highlight its border with blue color. Highlight with relation With this option is on, when a mouse cursor hovers over a table, a entity or a view, Navicat Data Modeler will highlight it's foreign keys, relations or view relations with blue or green color indicating relationships with other objects. Guess field type With this option is on, Navicat Data Modeler will predict field types when you design fields/attributes in tables or entities. Query‌ Use code completion (Available only in Non-Essentials Edition) When you type the . (dot) symbol or a character, the editor will offer you a pop-up list that showing some suggestions for the code completion. Auto update code completion info (Available only in Non-Essentials Edition) With this option is on, Navicat Data Modeler will get the latest database information for the code completion from your model. You can click Clear Code Completion Info to delete the information for code completion feature that stored on your device. Editor‌ General Show line number Display line numbers at the left side of the editor for easily reference. Use code folding Code folding allows codes to collapse as a block and only the first line displayed in the editor. Use brace highlighting Highlight the pair of braces when your cursor moves to either one brace for easily reference. Use syntax highlighting Syntax highlight helps viewing codes clearly. Codes are highlighted in the editor with different colors and fonts according to the categories they belong to. This feature can be limited by setting the maximum file size (e.g. 10) in Disable if file size is larger than (MB) to increase performance. Use word wrap Enable the word wrap mode in the editor. Tab Width Enter the number of characters that a tab occupies, e.g. 5. See Edit View's Definition. Font and Colors Editor Font Define the font and its size used by editors.