Table vs Model name

By convention, all tables use a plural form, while corresponding models use singular form of a word.

Examples are:

  • Table COMPUTERS is mapped to model Computer
  • Table PEOPLE is mapped to model Person
  • etc.

This convention can be overridden with @Table annotation.

English inflections

ActiveJDBC is using English inflections to convert singular form of a model to a plural form of a table. It does include simple cases such as adding an s at the end: COMPUTERS => Computer, as well as English exceptions, such as PEOPLE => Person, MICE => Mouse, etc.

If you are interested in how this is done, and what exceptions are supported, you can inspect source code of Inflector

Bootstrapping

At the time of first use of a model after an application start, ActiveJDBC fetches metadata from a connected database and looks for tables corresponding to names of models using either English inflections, or values provided by @Table annotations

Examples:

Default mapping

will be mapped to a table COMPUTERS.

Default mapping with English exception

will be mapped to a table OCTOPI.

Overridden mapping

will be mapped to a table OPERATOR.


How to comment

The comment section below is to discuss documentation on this page.

If you have an issue, or discover bug, please follow instructions on the Support page