The basic development steps to manually build your LANSA application database are as follows:

  1. Create a table definition.
  2. Add the real fields to the table and identify key fields. Refer to Adding Real Fields to a Table.
  3. Create indexes. Refer to 1.6.3 Index Development.
  4. Add virtual columns to the table. Refer to 1.6.4 Virtual Column Development.
  5. Add validation rules and triggers. Refer to 1.6.5 Table Rules & Triggers Development.
  6. Create access routes to other tables in the database. Refer to 1.6.6 Access Route Development.
  7. Add Predetermined Joined Columns. Refer to 1.6.7 Predetermined Join Column Development.
  8. Make table operational. Refer to 1.6.9 Compiling Tables.

If you have modeled a database or imported other tables to define a group of tables, you will complete the following steps to complete the database:

  1. Create additional indexes if required. Refer to 1.6.3 Index Development.
  2. Add virtual columns. Refer to 1.6.4 Virtual Column Development.
  3. Add validation rules and triggers. Refer to 1.6.5 Table Rules & Triggers Development.
  4. Create access routes to other tables in the database. Refer to 1.6.6 Access Route Development.
  5. Add Predetermined Joined Columns. Refer to 1.6.7 Predetermined Join Column Development.
  6. Make tables operational. Refer to 1.6.9 Compiling Tables.

If you are deploying your database to another platform, you should review the Table Definition Attributes.

  • No labels