codekingpro/portable-devtools
114k
1���� �sphinx.addnodes��document���)��}�(� rawsource�� ��children�]�(�docutils.nodes��target���)��}�(h�
.. _erd_tool:�h]��2attributes�}�(�ids�]��classes�]��names�]��dupnames�]��backrefs�]��refid��erd-tool�u�tagname�h3�line�K�parent�h� _document�h�source��cD:\a\pgadmin-packaging-foundation\pgadmin-packaging-foundation\pgadmin4-8.6\docs\en_US\erd_tool.rst�ubh �section���)��}�(hhh]�(h �title���)��}�(h�`ERD Tool`:index:�h]�(h �index���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��entries�]�(�single��ERD Tool��index-0�hNt�auhh/h"h#hKh h+ubh)��}�(hhh]�h}�(h]�h>ah]�h]�h]�h]�uhh4h h+ubh �Text����ERD Tool�����}�(h h+h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhh)h h&h!hh"h#hKubh � paragraph���)��}�(hX: The Entity-Relationship Diagram (ERD) tool is a database design tool that provides a graphical representation of database tables, columns, and inter-relationships. ERD can give sufficient information for the database administrator to follow when developing and maintaining the database. The ERD Tool allows you to:�h]�hJX: The Entity-Relationship Diagram (ERD) tool is a database design tool that provides a graphical representation of database tables, columns, and inter-relationships. ERD can give sufficient information for the database administrator to follow when developing and maintaining the database. The ERD Tool allows you to:�����}�(h hWh!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh �bullet_list���)��}�(hhh]�(h � list_item���)��}�(h�ADesign and visualize the database tables and their relationships.�h]�hV)��}�(hhnh]�hJ�ADesign and visualize the database tables and their relationships.�����}�(h hph!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK h hlubah}�(h]�h]�h]�h]�h]�uhhjh"h#hK h hgh!hubhk)��}�(h�Add notes to the diagram.�h]�hV)��}�(hh�h]�hJ�Add notes to the diagram.�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK5h h�ubah}�(h]�h]�h]�h]�h]�uhhjh"h#hK6h hgh!hubhk)��}�(h�:Auto-align the tables and links for cleaner visualization.�h]�hV)��}�(hh�h]�hJ�:Auto-align the tables and links for cleaner visualization.�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h�ubah}�(h]�h]�h]�h]�h]�uhhjh"h#hKh hgh!hubhk)��}�(h�=Save the diagram and open it later to continue working on it.�h]�hV)��}�(hh�h]�hJ�=Save the diagram and open it later to continue working on it.�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h�ubah}�(h]�h]�h]�h]�h]�uhhjh"h#hKh hgh!hubhk)��}�(h�3Generate ready to run SQL from the database design.�h]�hV)��}�(hh�h]�hJ�3Generate ready to run SQL from the database design.�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK
h h�ubah}�(h]�h]�h]�h]�h]�uhhjh"h#hK
h hgh!hubhk)��}�(h�7Generate the database diagram for an existing database.�h]�hV)��}�(hh�h]�hJ�7Generate the database diagram for an existing database.�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h�ubah}�(h]�h]�h]�h]�h]�uhhjh"h#hKh hgh!hubhk)��}�(h�:Drag and drop tables from object explorer to the diagram.7�h]�hV)��}�(h�9Drag and drop tables from object explorer to the diagram.�h]�hJ�9Drag and drop tables from object explorer to the diagram.�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h�ubah}�(h]�h]�h]�h]�h]�uhhjh"h#hKh hgh!hubeh}�(h]�h]�h]�h]�h]��bullet��*�uhheh"h#hK h h&h!hubh �image���)��}�(h�L.. image:: images/erd_tool.png8 :alt: ERD tool window9 :align: center10�h]�h}�(h]�h]�h]�h]�h]��alt��ERD tool window��align��center��uri��images/erd_tool.png��11candidates�}�j j' suhj h"h#hKh h&h!hubhV)��}�(h��You can open multiple copies of the ERD tool in individual tabs simultaneously.12You can also generate an ERD from a database, schema or a table.�h]�hJ��You can open multiple copies of the ERD tool in individual tabs simultaneously.13You can also generate an ERD from a database, schema or a table.�����}�(h j* h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubhf)��}�(hhh]�(hk)��}�(h�yThe ERD for database will fetch all the tables from all the schemas of the database and plot them with foreign key links.�h]�hV)��}�(hj= h]�hJ�yThe ERD for database will fetch all the tables from all the schemas of the database and plot them with foreign key links.�����}�(h j? h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j; ubah}�(h]�h]�h]�h]�h]�uhhjh"h#hKh j8 h!hubhk)��}�(h��The ERD for schema will fetch all the tables from a schema and plot them with foreign key links. If any table refers to a table in another14schema, then that link/foreign key will be removed.�h]�hV)��}�(h��The ERD for schema will fetch all the tables from a schema and plot them with foreign key links. If any table refers to a table in another15schema, then that link/foreign key will be removed.�h]�hJ��The ERD for schema will fetch all the tables from a schema and plot them with foreign key links. If any table refers to a table in another16schema, then that link/foreign key will be removed.�����}�(h jV h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jR ubah}�(h]�h]�h]�h]�h]�uhhjh"h#hKh j8 h!hubhk)��}�(h��The ERD for table will fetch all the tables linked directly or indirectly to mentioned table. You can change the depth of traversal from :ref:`Preferences <preferences>`.17 18�h]�hV)��}�(h��The ERD for table will fetch all the tables linked directly or indirectly to mentioned table. You can change the depth of traversal from :ref:`Preferences <preferences>`.�h]�(hJ��The ERD for table will fetch all the tables linked directly or indirectly to mentioned table. You can change the depth of traversal from �����}�(h jn h!hh"NhNubh �pending_xref���)��}�(h� :ref:`Preferences <preferences>`�h]�h �inline���)��}�(hjz h]�hJ�Preferences�����}�(h j~ h!hh"NhNubah}�(h]�h]�(�xref��std��std-ref�eh]�h]�h]�uhj| h jx ubah}�(h]�h]�h]�h]�h]��refdoc��erd_tool�� refdomain�j� �reftype��ref��refexplicit���refwarn��� reftarget��preferences�uhjv h"h#hKh jn ubhJ�.�����}�(h jn h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jj ubah}�(h]�h]�h]�h]�h]�uhhjh"h#hKh j8 h!hubeh}�(h]�h]�h]�h]�h]�j j uhheh"h#hKh h&h!hubh%)��}�(hhh]�(h*)��}�(h�Toolbar�h]�hJ�Toolbar�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j� h!hh"h#hKubhV)��}�(h��The *ERD Tool* toolbar uses context-sensitive icons that provide shortcuts to frequently performed tasks. The option is enabled for the highlighted icon and is disabled for the grayed-out icon.�h]�(hJ�The �����}�(h j� h!hh"NhNubh �emphasis���)��}�(h�19*ERD Tool*�h]�hJ�ERD Tool�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubhJ�� toolbar uses context-sensitive icons that provide shortcuts to frequently performed tasks. The option is enabled for the highlighted icon and is disabled for the grayed-out icon.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK!h j� h!hubj )��}�(h�U.. image:: images/erd_tool_toolbar.png20 :alt: ERD tool toolbar21 :align: center22�h]�h}�(h]�h]�h]�h]�h]��alt��ERD tool toolbar��align��center��uri��images/erd_tool_toolbar.png�j( }�j j� suhj h"h#hK#h j� h!hubhV)��}�(h�[Hover over an icon on Toolbar to display a tooltip that describes the icon's functionality.�h]�hJ�]Hover over an icon on Toolbar to display a tooltip that describes the icon’s functionality.�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK'h j� h!hubeh}�(h]��toolbar�ah]�h]��toolbar�ah]�h]�uhh$h h&h!hh"h#hKubh%)��}�(hhh]�(h*)��}�(h�File Options�h]�hJ�File Options�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j
h!hh"h#hK*ubh �table���)��}�(hhh]�h �tgroup���)��}�(hhh]�(h �colspec���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j% ubj) )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j% ubj) )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j% ubh �thead���)��}�(hhh]�h �row���)��}�(hhh]�(h �entry���)��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h jW h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK1h jT ubah}�(h]�h]�h]�h]�h]�uhjR h jO ubjS )��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h jn h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK1h jk ubah}�(h]�h]�h]�h]�h]�uhjR h jO ubjS )��}�(hhh]�hV)��}�(h�Shortcut�h]�hJ�Shortcut�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK1h j� ubah}�(h]�h]�h]�h]�h]�uhjR h jO ubeh}�(h]�h]�h]�h]�h]�uhjM h jJ ubah}�(h]�h]�h]�h]�h]�uhjH h j% ubh �tbody���)��}�(hhh]�(jN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�*Open File*�h]�j� )��}�(hj� h]�hJ� Open File�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK3h j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h�>Click the *Open File* icon to load a previously saved diagram.�h]�(hJ�23Click the �����}�(h j� h!hh"NhNubj� )��}�(h�*Open File*�h]�hJ� Open File�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubhJ�) icon to load a previously saved diagram.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK3h j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h�Ctrl + O�h]�hJ�Ctrl + O�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK3h j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubeh}�(h]�h]�h]�h]�h]�uhjM h j� ubjN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�*Save*�h]�j� )��}�(hj h]�hJ�Save�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK5h j ubah}�(h]�h]�h]�h]�h]�uhjR h j ubjS )��}�(hhh]�hV)��}�(h�nClick the *Save* icon to perform a quick-save of a previously saved diagram, or to save the24diagram to a file.�h]�(hJ�25Click the �����}�(h j9 h!hh"NhNubj� )��}�(h�*Save*�h]�hJ�Save�����}�(h jA h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j9 ubhJ�^ icon to perform a quick-save of a previously saved diagram, or to save the26diagram to a file.�����}�(h j9 h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK5h j6 ubah}�(h]�h]�h]�h]�h]�uhjR h j ubjS )��}�(hhh]�hV)��}�(h�Ctrl + S�h]�hJ�Ctrl + S�����}�(h jb h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK5h j_ ubah}�(h]�h]�h]�h]�h]�uhjR h j ubeh}�(h]�h]�h]�h]�h]�uhjM h j� ubjN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h� *Save as*�h]�j� )��}�(hj� h]�hJ�Save as�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK8h j ubah}�(h]�h]�h]�h]�h]�uhjR h j| ubjS )��}�(hhh]�hV)��}�(h��Click the *Save As* to open a new browser dialog and specify a new location to save the diagram.27You need to click the down arrow beside the save button to see *Save As*.�h]�(hJ�28Click the �����}�(h j� h!hh"NhNubj� )��}�(h� *Save As*�h]�hJ�Save As�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubhJ�� to open a new browser dialog and specify a new location to save the diagram.29You need to click the down arrow beside the save button to see �����}�(h j� h!hh"NhNubj� )��}�(h� *Save As*�h]�hJ�Save As�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubhJ�.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK8h j� ubah}�(h]�h]�h]�h]�h]�uhjR h j| ubjS )��}�(hhh]�hV)��}�(h�Ctrl + Shift +30S�h]�hJ�Ctrl + Shift +31S�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK8h j� ubah}�(h]�h]�h]�h]�h]�uhjR h j| ubeh}�(h]�h]�h]�h]�h]�uhjM h j� ubeh}�(h]�h]�h]�h]�h]�uhj� h j% ubeh}�(h]�h]�h]�h]�h]��cols�Kuhj# h j ubah}�(h]�h]�(� longtable��colwidths-given�eh]�h]�h]�uhj h j
h!hh"h#hNubeh}�(h]��file-options�ah]�h]��file options�ah]�h]�uhh$h h&h!hh"h#hK*ubh%)��}�(hhh]�(h*)��}�(h�Export Options�h]�hJ�Export Options�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j h!hh"h#hK=ubj )��}�(hhh]�j$ )��}�(hhh]�(j) )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j( ubj) )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j( ubj) )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j( ubjI )��}�(hhh]�jN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h jR h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKDh jO ubah}�(h]�h]�h]�h]�h]�uhjR h jL ubjS )��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h ji h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKDh jf ubah}�(h]�h]�h]�h]�h]�uhjR h jL ubjS )��}�(hhh]�hV)��}�(h�Shortcut�h]�hJ�Shortcut�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKDh j} ubah}�(h]�h]�h]�h]�h]�uhjR h jL ubeh}�(h]�h]�h]�h]�h]�uhjM h jI ubah}�(h]�h]�h]�h]�h]�uhjH h j( ubj� )��}�(hhh]�(jN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�*Generate SQL*�h]�j� )��}�(hj� h]�hJ�Generate SQL�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKFh j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(hXH Click the *Generate SQL* icon to generate the DDL SQL for the diagram and open a query tool32with the generated SQL ready for execution.33You can select the option *With DROP Table* if you wish to have DROP Table DDL statements before34each CREATE Table DDL. You can see the option by clicking the down arrow beside the SQL button.�h]�(hJ�35Click the �����}�(h j� h!hh"NhNubj� )��}�(h�*Generate SQL*�h]�hJ�Generate SQL�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubhJ�� icon to generate the DDL SQL for the diagram and open a query tool36with the generated SQL ready for execution.37You can select the option �����}�(h j� h!hh"NhNubj� )��}�(h�*With DROP Table*�h]�hJ�With DROP Table�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubhJ�� if you wish to have DROP Table DDL statements before38each CREATE Table DDL. You can see the option by clicking the down arrow beside the SQL button.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKFh j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h�Option + Ctrl +39S�h]�hJ�Option + Ctrl +40S�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKFh j ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubeh}�(h]�h]�h]�h]�h]�uhjM h j� ubjN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�*Download image*�h]�j� )��}�(hj& h]�hJ�Download image�����}�(h j( h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j$ ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKKh j! ubah}�(h]�h]�h]�h]�h]�uhjR h j ubjS )��}�(hhh]�hV)��}�(h�JClick the *Download image* icon to save the ERD diagram in a image formate�h]�(hJ�41Click the �����}�(h jD h!hh"NhNubj� )��}�(h�*Download image*�h]�hJ�Download image�����}�(h jL h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h jD ubhJ�0 icon to save the ERD diagram in a image formate�����}�(h jD h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKKh jA ubah}�(h]�h]�h]�h]�h]�uhjR h j ubjS )��}�(hhh]�hV)��}�(h�Option + Ctrl +42I�h]�hJ�Option + Ctrl +43I�����}�(h jm h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKKh jj ubah}�(h]�h]�h]�h]�h]�uhjR h j ubeh}�(h]�h]�h]�h]�h]�uhjM h j� ubeh}�(h]�h]�h]�h]�h]�uhj� h j( ubeh}�(h]�h]�h]�h]�h]��cols�Kuhj# h j% ubah}�(h]�h]�(� longtable�j eh]�h]�h]�uhj h j h!hh"h#hNubeh}�(h]��export-options�ah]�h]��export options�ah]�h]�uhh$h h&h!hh"h#hK=ubh%)��}�(hhh]�(h*)��}�(h�Editing Options�h]�hJ�Editing Options�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j� h!hh"h#hKPubj )��}�(hhh]�j$ )��}�(hhh]�(j) )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j� ubj) )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j� ubj) )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j� ubjI )��}�(hhh]�jN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKWh j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKWh j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h�Shortcut�h]�hJ�Shortcut�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKWh j ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubeh}�(h]�h]�h]�h]�h]�uhjM h j� ubah}�(h]�h]�h]�h]�h]�uhjH h j� ubj� )��}�(hhh]�(jN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�*Add table*�h]�j� )��}�(hj: h]�hJ� Add table�����}�(h j< h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j8 ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKYh j5 ubah}�(h]�h]�h]�h]�h]�uhjR h j2 ubjS )��}�(hhh]�hV)��}�(h��Click this button to add a new table to the diagram. On clicking, this will open a table dialog44where you can put the table details.�h]�hJ��Click this button to add a new table to the diagram. On clicking, this will open a table dialog45where you can put the table details.�����}�(h jX h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKYh jU ubah}�(h]�h]�h]�h]�h]�uhjR h j2 ubjS )��}�(hhh]�hV)��}�(h�Option/Alt +46Ctrl + A�h]�hJ�Option/Alt +47Ctrl + A�����}�(h jo h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKYh jl ubah}�(h]�h]�h]�h]�h]�uhjR h j2 ubeh}�(h]�h]�h]�h]�h]�uhjM h j/ ubjN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�*Edit table*�h]�j� )��}�(hj� h]�hJ�48Edit table�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK\h j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h��Click this button to edit a table on the diagram. On clicking, this will open a table dialog49where you can change table details. This will enable when a table is selected.�h]�hJ��Click this button to edit a table on the diagram. On clicking, this will open a table dialog50where you can change table details. This will enable when a table is selected.�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK\h j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h�Option/Alt +51Ctrl + E�h]�hJ�Option/Alt +52Ctrl + E�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK\h j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubeh}�(h]�h]�h]�h]�h]�uhjM h j/ ubjN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�
*Clone table*�h]�j� )��}�(hj� h]�hJ�Clone table�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK_h j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h�vClick this button to clone the complete table structure, name it with a auto generated name and53put it in the diagram.�h]�hJ�vClick this button to clone the complete table structure, name it with a auto generated name and54put it in the diagram.�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK_h j ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h�Option/Alt +55Ctrl + C�h]�hJ�Option/Alt +56Ctrl + C�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK_h j ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubeh}�(h]�h]�h]�h]�h]�uhjM h j/ ubjN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�*Drop table/link*�h]�j� )��}�(hj? h]�hJ�Drop table/link�����}�(h jA h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j= ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKbh j: ubah}�(h]�h]�h]�h]�h]�uhjR h j7 ubjS )��}�(hhh]�hV)��}�(h�wYou can drop a table or link using this button. You need to select a table or link and click on57this button to drop it.�h]�hJ�wYou can drop a table or link using this button. You need to select a table or link and click on58this button to drop it.�����}�(h j] h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKbh jZ ubah}�(h]�h]�h]�h]�h]�uhjR h j7 ubjS )��}�(hhh]�hV)��}�(h�Option/Alt +59Ctrl + D�h]�hJ�Option/Alt +60Ctrl + D�����}�(h jt h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKbh jq ubah}�(h]�h]�h]�h]�h]�uhjR h j7 ubeh}�(h]�h]�h]�h]�h]�uhjM h j/ ubeh}�(h]�h]�h]�h]�h]�uhj� h j� ubeh}�(h]�h]�h]�h]�h]��cols�Kuhj# h j� ubah}�(h]�h]�(� longtable�j eh]�h]�h]�uhj h j� h!hh"h#hNubeh}�(h]��editing-options�ah]�h]��editing options�ah]�h]�uhh$h h&h!hh"h#hKPubh%)��}�(hhh]�(h*)��}�(h�Table Relationship Options�h]�hJ�Table Relationship Options�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j� h!hh"h#hKgubj )��}�(hhh]�j$ )��}�(hhh]�(j) )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j� ubj) )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j� ubj) )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j� ubjI )��}�(hhh]�jN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKnh j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKnh j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h�Shortcut�h]�hJ�Shortcut�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKnh j ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubeh}�(h]�h]�h]�h]�h]�uhjM h j� ubah}�(h]�h]�h]�h]�h]�uhjH h j� ubj� )��}�(hhh]�(jN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�*1M*�h]�j� )��}�(hjA h]�hJ�1M�����}�(h jC h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j? ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKph j< ubah}�(h]�h]�h]�h]�h]�uhjR h j9 ubjS )��}�(hhh]�hV)��}�(h��Click this button to open a one-to-many relationship dialog to add a relationship between the61two tables. The selected table becomes the referencing table and will have the *many* endpoint of62the link.�h]�(hJ��Click this button to open a one-to-many relationship dialog to add a relationship between the63two tables. The selected table becomes the referencing table and will have the �����}�(h j_ h!hh"NhNubj� )��}�(h�*many*�h]�hJ�many�����}�(h jg h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j_ ubhJ� endpoint of64the link.�����}�(h j_ h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKph j\ ubah}�(h]�h]�h]�h]�h]�uhjR h j9 ubjS )��}�(hhh]�hV)��}�(h�Option/Alt +65Ctrl + O�h]�hJ�Option/Alt +66Ctrl + O�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKph j� ubah}�(h]�h]�h]�h]�h]�uhjR h j9 ubeh}�(h]�h]�h]�h]�h]�uhjM h j6 ubjN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�*MM*�h]�j� )��}�(hj� h]�hJ�MM�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKth j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h��Click this button to open a many-to-many relationship dialog to add a relationship between the67two tables. This option will create a new table based on the selected columns for the two relating68tables and link them.�h]�hJ��Click this button to open a many-to-many relationship dialog to add a relationship between the69two tables. This option will create a new table based on the selected columns for the two relating70tables and link them.�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKth j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h�Option/Alt +71Ctrl + M�h]�hJ�Option/Alt +72Ctrl + M�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hKth j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubeh}�(h]�h]�h]�h]�h]�uhjM h j6 ubeh}�(h]�h]�h]�h]�h]�uhj� h j� ubeh}�(h]�h]�h]�h]�h]��cols�Kuhj# h j� ubah}�(h]�h]�(� longtable�j eh]�h]�h]�uhj h j� h!hh"h#hNubeh}�(h]��table-relationship-options�ah]�h]��table relationship options�ah]�h]�uhh$h h&h!hh"h#hKgubh%)��}�(hhh]�(h*)��}�(h�Node Color Options�h]�hJ�Node Color Options�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j h!hh"h#hKzubj )��}�(hhh]�j$ )��}�(hhh]�(j) )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j) ubj) )��}�(hhh]�h}�(h]�h]�h]�h]�h]��colwidth�Kuhj( h j) ubjI )��}�(hhh]�jN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�Icon�h]�hJ�Icon�����}�(h jI h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h jF ubah}�(h]�h]�h]�h]�h]�uhjR h jC ubjS )��}�(hhh]�hV)��}�(h�Behavior�h]�hJ�Behavior�����}�(h j` h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j] ubah}�(h]�h]�h]�h]�h]�uhjR h jC ubeh}�(h]�h]�h]�h]�h]�uhjM h j@ ubah}�(h]�h]�h]�h]�h]�uhjH h j) ubj� )��}�(hhh]�(jN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�*Fill Color*�h]�j� )��}�(hj� h]�hJ�73Fill Color�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h��Use Fill Color to change the background color of a table node. This is helpful if you want to74identify a of group tables. Once set, all the newly added tables will take the same color.�h]�hJ��Use Fill Color to change the background color of a table node. This is helpful if you want to75identify a of group tables. Once set, all the newly added tables will take the same color.�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubeh}�(h]�h]�h]�h]�h]�uhjM h j� ubjN )��}�(hhh]�(jS )��}�(hhh]�hV)��}�(h�*Text Color*�h]�j� )��}�(hj� h]�hJ�76Text Color�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhj� h j� ubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubjS )��}�(hhh]�hV)��}�(h�mUse Text Color to change the text color of a table node based on the fill color to make text77easily readable.�h]�hJ�mUse Text Color to change the text color of a table node based on the fill color to make text78easily readable.�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhhUh"h#hK�h j� ubah}�(h]�h]�h]�h]�h]�uhjR h j� ubeh}�(h]�h]�h]�h]�h]�uhjM h j� ubeh}�(h]�h]�h]�h]�h]�uhj� h j) ubeh}�(h]�h]�h]�h]�h]��cols�Kuhj# h j& ubah}�(h]�h]�(� longtable�j eh]�h]�h]�uhj h j h!hh"h#hNubeh}�(h]��node-color-options�ah]�h]��node color options�ah]�h]�uhh$h h&h!hh"h#hKzubh%)��}�(hhh]�(h*)��}�(h�Utility Options�h]�hJ�Utility Options�����}�(h j"79