Defining Objects in the Repository
Once you have started the Definer you can begin entering the specifications of your application. The following diagram shows how to define the application's objects.
Defining your Application's Table Structure
Whatever approach you take, the procedure you follow will always include the following steps, which correspond to the letters A to C in the diagram:
A. To define a table, specify which columns it has, and on which domains they are based. (Of course, you can also define your domains first).
If the table is a subtype, specify what its supertype table is (indicated by the loop).
B. To define relationships between tables, specify which columns are involved.
C. To define constraints, write SQL statements that relate to the table, column, or domain level.