Database Structure

This directory contains the database schema and query functions for the French Learning App.

Tables

  1. french_categories - Categories of vocabulary (Greetings, Numbers, Food, etc.)
  2. french_vocabulary - French words and phrases with English translations
  3. french_user_progress - Tracks user learning progress (optional)

Files

  • migrations.ts - Database schema creation and initial data seeding
  • queries.ts - Functions for interacting with the database

Usage

The database is automatically initialized when the application starts. The initial data includes common French phrases organized by category.