Database Schema

The Application Generator uses the structure of your database to generate the code. There are some conventions to be followed though:

  • Table names must begin with prefix tbl_ (this can be changed to use custom prefix or none at all)
  • All tables must have primary key column (only one column per table) of type GUID

Once database schema has been created and normalised to your linking, code can be generated.

Following schema is used by GS SalesManager:

GS SalesManager Database Schema