Allowable JSON keys for SQL schema objects
SQL schema objects are java objects which represent either a table or a view in the database.
| Key Name | Tables | Views | Notes |
|---|---|---|---|
name | mandatory | mandatory | Both tables and views MUST have a name |
fields | mandatory | mandatory | Tables and views must have fields defined. In the case of a view each field MUST match to the fields referenced in the asClause |
finders | optional | optional | By default the some finders are automatically generated, e.g. findByPrimaryKey and findAll |
fieldFinders | optional | optional | Field finders are a short-cut to quick generations |
deleters | optional | invalid | Views are not able to perform delete statements |
inserters | optional | invalid | Views are not able to perform insert statements |
updaters | optional | invalid | Views are not able to perform update statements |
fieldUpdaters | optional | invalid | Views are not able to perform update statements |
questions | optional | optional | This ALWAYS returns a single boolean answer |
counters | optional | optional | This ALWAYS returns a single integer answer |
constants | optional | invalid | You cannot create a constant view. |