The To-Do Application Database Schema

The To-Do application uses a SQLite database for storing information. The database has four tables:

  1. projects
  2. todo_items
  3. people
  4. people_todo

Projects can have many todo_items and any number of people can be linked with any number of todo_items through the people_todo table.

You will find the to-do.sqlite database file in the ./components/ folder in the tutorials distribution. The to-do TEMPLATE.sqlite file serves as a backup if you need an empty database to start with.


Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.