Databases - Relation columns #62

Create 3 new column types:

Manual Relation

In the config for this column, the user selects a database

Then, when editing the column, they can select one or more records from the other database which show up as icons in the cell renderer.

When clicked, the cell should open the related database pre-filtered to the selected rows. This will require a bit of work.

Automatic Relation

This is the same as the manual relation, but in the config for the column the user picks a column from the local database and the foreign database to match. All rows that match the local column value on the foreign database show up in the column.

Relation Reference

This column references a relation on a related table. It allows users to view the inverse of a relation from the related table. In the column settings, the user chooses a database, then a relation column on that database.

The cell renders the icons for the rows that are related to this one using the foreign relation's rules (manual or automatic).

Clicking opens the foreign database pre-filtered to those rows.

Aside

Add support to the Database API and the plugins classes for querying these relations.