Database layouts
- Primary Key and indexes
- Columns which are Foreign Keys or ar reffered by Foreign Keys. By clicking them you can easy navigate the schema.
- Foreign Keys. The can be drawn in two disinct ways. The drawn line is fitting exactly the involved column.
In the layout above, 'ID' is Primary Key in ETL_INT_LINE_SERVICE. The icon has a small '1', because this column is the first one in the Primary Key. The column 'ID_JOB' is indexed.
The Foreign Keys are drawn between the columns which they join.
If two tables are referencing the same column, their lines may be joined together.
Like ETL_JOB.ID_JOB_NAME and ETL_JOB.ID_JOB_TYPE are both referencing RUM_LINE_LIST_OF_VALUE.ID.
The line joins has a curve indicating the direction where the line is going to.
To see which are the columns joined by a foreign key, click on the foreign key. The columns will be highlighted.
Using groups you can do a visual grouping of the tables.
On a larger layout they help you to better organize the tables inside the layout.
Tip : You can do Layout » Autoplace to automatically place the tables in the layout, eventually with setting groups.
A layout may be a module ( part ) of your database. Under each layout you can open Browse or SQL sessions. Each of this sessions will be saved under the current layout, and can be later reopened.
