Paginated Joins Demo
This demo shows how to paginate results from different tables in one view. In the demo, a user can schedule animal exhibits in different rooms of a museum. There are three tables of animal exhibits (barnyard animals, jungle animals, sea creatures), one table of animal types (animal_types), one table of exhibits rooms (rooms), one relationship table to relate animal types to animals (animal_relations), and one final table to relate animals to rooms (animals_rooms). You can download a set of project files here.
The paginated view of the exhibit schedule displays data from all the animals tables, the animal type table and the room table.
Table views
- barnyard animals
- jungle animals
- sea creatures
- rooms
- animal_types
- animal_relations (relates animal types to animals)
- animals_rooms (relates animals to rooms; also carries a start and end date)
