Skip to main content

Guidelines For Building

How to Design Tables and Views

Both Tables and Views can be leveraged to generate screens and apis. Please make ample use of Views, as they help a lot.

Table Design

  • First column should be key

View Design

  • Include all key columns from joined tables too
  • View based APIs for query data work great
  • You can use View based APIs Create/Edit/Delete, if the View Design and database allows such operation on Views.
  • Else, For APIs Create/Edit/Delete, customize API calls to manipulate data in underlying tables