Gueopic/App

Database

Closed this issue · 0 comments

A database system must be used, due easy compatibility, we choosen SQLite.

The database will have a simple API (classes) with Query (getAll, getById and search) and CRUD (create, replace, update, delete) elements for:

  • Table Verbs:

    • id
    • Verb text
    • Audio file name
  • Table Items

    • id
    • Item text (optional)
    • Image filename
    • Audio file name
  • Table settings

    • id: string (no autoincremental)
    • value