Meta information

Meta information

This page is only for navigation. Context-sensitive help is available when you click one of the links below and select the menu item Help.

Database settings

Diagram	Choice of several database diagrams
Create all Indexes	Recreates all indexes of the diagrams
Drop all Indexes	Deletes all existing indexes of the chosen diagram
Check Table Order	Checks the table arrangements / linkings for consistency

Table settings

Table	Chosen table that has to be edited from list
Restore Constraints	Restores the database constraints
Drop Constraints	Drops the database constraints
Start Version tracking	Activates version tracking for the chosen table
Restore References to this table	Restores the references to this table
Drop References to this table	Drops simple references to this table
Create Table	Applies the chosen table from the selection list
Drop Table	Deletes the table from the selection list. Previously the appropriate references and constraints should be deleted Caution: All data of this table are deleted
Check Foreign-Key- Values	Checks the values of foreign key for consistency

Table informations

Display of the version of the table
Complete name of table is displayed

If the following information applies, this is shown by an [X]:

Has References	The chosen table is referred to by other tables
Has Foreign Keys	Has foreign keys with references to other tables
Has Indexes	Indexes are available
Versions are tracked	Versioning of the data records for this table is activated
Has Version Table	A versioning table for saving the information for tracking changes to data records exists for the selected table

Link 'Edit Table Table name'

If data records within a table need correcting, and this cannot be accomplished during the running administration, this can be done by clicking the link Edit Table. The site of tables of data records is shown from which the data record can be corrected.

File information about the table

Name	Listing of the column name in a table
Comment	Contains a short description
User Type	Field type from the view of the user/application
DB Type	Field type in the database
Size	Data field size in bytes
Foreign Key Table	Shows the name of the table of the foreign key
Foreign Key Column	Shows the name of the column of the foreign key
Is Nullable	Shows whether this column allows zero values
Is Primary Key	Shows whether this column is a/the primary key in the table
Is Foreign Key	Shows whether this column is a foreign key
Is Referenced Key	Shows whether this column is referenced by another table as a foreign key

References table

If references are available, these are shown in the following table. The following is displayed:

Name of the referenced table
Name of the corresponding row