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