With dbExpress Developper Edition, you can create your own Tables.
The Web services that will handle the access to those tables are automatically created, so you don’t have to care about the server side.
You can Add or Remove Fields with the +/- buttons, and you can also add a Parent table to the current Table. For example the table “Countries” will be a parent table of the table “Cities”.
When you add a parent table, the primary key of the parent table (eg. Countries.pk) will be added to the child table by using the name fk_parentTablename: for example fk_countries.
Example with a “Parent Key"
You can access to the table structure by double-clicking on the table name, and then, by using the +/- Buttons (1), you can add or remove fields from the selected table.
The “Add Parent” Button (2) lets you add a parent table to the selected table.
When you add/modify a field, you have access to this dialog box:
Read the DB Fields help page for more details.
The SQL Button (3), allows you to view and test the SQL Statment automatically created for the Web Service: