First-Class Plugin Architecture

Tables registered (18 models)

Key enums (Core domain)

enum class UserRole : int {
    Guest      = 0,
    Reader     = 1,
    Editor     = 2,
    Reviewer   = 3,
    Admin      = 4,
    SuperAdmin = 5,
    System     = 100
};

enum class UserStatus : int {
    Pending     = 0,
    Active      = 1,
    Deactivated = 2,
    Banned      = 3,
    Suspended   = 4,
    Deleted     = 5
};

enum class RegistrationMode : int {
    Free                  = 0,
    RequiresAdminApproval = 1,
    AdminAddsUsers        = 2
};

Core validator count

The Core plugin registers approximately 13 validators covering authentication logic, user role enforcement, token lifecycle, registration flow, and admin-only operations. These validators collectively enforce the access control matrix for all auth operations.

Tables registered (13 models)

Slipbox SQL schema (note table)

CREATE TABLE IF NOT EXISTS note (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    title       TEXT    NOT NULL,
    content     TEXT,           -- Markdown
    parent_id   INTEGER REFERENCES note(id),
    map_id      INTEGER REFERENCES map(id),
    path        TEXT,           -- computed by trigger
    note_order  INTEGER NOT NULL DEFAULT 0,
    created_at  TEXT    NOT NULL,
    updated_at  TEXT,
    user_id     INTEGER REFERENCES user(id)
);

CREATE TABLE IF NOT EXISTS link (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    source_id   INTEGER NOT NULL REFERENCES note(id),
    target_id   INTEGER NOT NULL REFERENCES note(id),
    link_type   TEXT,
    description TEXT,
    created_at  TEXT    NOT NULL
);

CREATE TABLE IF NOT EXISTS map (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    name        TEXT    NOT NULL,
    description TEXT,
    created_at  TEXT    NOT NULL
);

Bundled JS libraries

The Slipbox plugin registers these static JS/CSS files for the frontend note editor:

• markdown-it.min.js — Markdown renderer
• markdown-it-emoji.min.js — emoji extension
• highlight.min.js — syntax highlighting
• github.min.css — code highlight theme

Tables registered (3 models)

SQL schema

CREATE TABLE IF NOT EXISTS repetition_session (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    user_id     INTEGER NOT NULL REFERENCES user(id),
    started_at  TEXT    NOT NULL,
    completed_at TEXT,
    status      TEXT    NOT NULL DEFAULT 'active',
    item_count  INTEGER NOT NULL DEFAULT 0
);

CREATE TABLE IF NOT EXISTS repetition_review (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    session_id  INTEGER NOT NULL
                  REFERENCES repetition_session(id),
    note_id     INTEGER NOT NULL REFERENCES note(id),
    rating      INTEGER NOT NULL,  -- 0 (fail) to 5 (perfect)
    reviewed_at TEXT    NOT NULL
);

CREATE TABLE IF NOT EXISTS repetition_prediction (
    id              INTEGER PRIMARY KEY AUTOINCREMENT,
    note_id         INTEGER NOT NULL UNIQUE REFERENCES note(id),
    user_id         INTEGER NOT NULL REFERENCES user(id),
    interval_days   INTEGER NOT NULL DEFAULT 1,
    ease_factor     REAL    NOT NULL DEFAULT 2.5,
    due_date        TEXT    NOT NULL,
    review_count    INTEGER NOT NULL DEFAULT 0,
    last_reviewed_at TEXT
);

Repetition triggers (4)

Custom queries

Frontend app

• Review session interface (card-by-card)
• Rating buttons: 0 (Again) · 1 · 2 · 3 · 4 · 5 (Perfect)
• Session progress bar
• Statistics panel: due / not-due / never reviewed counts
• Served from /web/app_repetition.html

Tables registered (9 models)

SQL schema (key tables)

CREATE TABLE IF NOT EXISTS dictionary_term (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    title       TEXT    NOT NULL,
    definition  TEXT,           -- Markdown
    map_id      INTEGER REFERENCES dictionary_map(id),
    language    TEXT    NOT NULL DEFAULT 'en',
    created_at  TEXT    NOT NULL,
    updated_at  TEXT
);

CREATE TABLE IF NOT EXISTS dictionary_term_alias (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    term_id     INTEGER NOT NULL
                  REFERENCES dictionary_term(id),
    alias       TEXT    NOT NULL,
    created_at  TEXT    NOT NULL
);

CREATE TABLE IF NOT EXISTS dictionary_term_understanding (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    term_id     INTEGER NOT NULL
                  REFERENCES dictionary_term(id),
    user_id     INTEGER NOT NULL REFERENCES user(id),
    level       INTEGER NOT NULL DEFAULT 0,
    -- 0=Unknown 1=Recognised 2=Understood
    -- 3=Applied 4=Internalised
    updated_at  TEXT    NOT NULL,
    UNIQUE(term_id, user_id)
);

CREATE TABLE IF NOT EXISTS dictionary_term_visit (
    id          INTEGER PRIMARY KEY AUTOINCREMENT,
    term_id     INTEGER NOT NULL
                  REFERENCES dictionary_term(id),
    user_id     INTEGER REFERENCES user(id),
    source      TEXT,  -- search/fk/direct/repetition
    visited_at  TEXT   NOT NULL
);