🗂️ Flashcard Learning Engine

System Logic Companion Application & Relational DB Previewer

Data Schema Prompt
What is the core SQL constraint used to enforce column data uniqueness?
System Verification Evaluation
The UNIQUE constraint or PRIMARY KEY attribute definitions.
Card 1 of 4
🛠️ Relational Database Layout (SQLite DDL)

This interface demonstrates the exact transactional table layout initialized by the Python backend application layer:

CREATE TABLE flashcards (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    deck_name TEXT NOT NULL,
    front_prompt TEXT NOT NULL,
    back_answer TEXT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    review_count INTEGER DEFAULT 0,
    ease_factor FLOAT DEFAULT 2.5
);