Defining Tables
This portal is used to view and maintain information about an application table.
You can access the portal from theAdmin Menu > Database > Table. You are brought to a query portal with options for searching for a specific table. Once a table has been selected you are brought to the maintenance portal to view and maintain the selected record.
The following zones may appear as part of the portal's Main tab page
• Table. This zone provides information about the selected table.
• Fields. This zone lists all fields of the selected table and provides various actions to maintain this information.
The following zones may appear as part of the portal's Relationship tab page
• Entity Relationship Diagram. This zone provides a visual representation of the table’s relationship to other tables in the application’s data model.
The following zones may appear as part of the portal's Constraints tab page
• Table Constraints. This zone lists the various key constraints defined for the selected table and provides various actions to maintain this information..
• Referred By Constraints. This zone lists all tables referring to the selected table via foreign key constraints.