Database Design

The database consists of 3 main tables.

1. Users
2. Congas
3. Conga Members.

A brief summary of each are below. For full details see models.py.

Users

This table stores the details of each registered user of the system. It tightly integrates with the built-in Django authorisation table.

Most of the standard user details (name, etc.) and authentication are all handled by the Django table. The Users table simply stores the extra details required for the Pi Conga.

Congas

This table stores details for each Conga. Amoung other things, it tracks the following.

• The name of the conga.
• The owner.
• The password.

Conga Members

This table tracks which users are members of which congas and their position in that Conga.