News Reader

Database Administration

Manage database schema and check system health

Authentication Required

Write operations require admin password authentication.

Default password: MartinMak@123456 (change this in production!)

Database Health

No health data available

Database Actions

Initialize and Reset operations require admin password

Database Schema

Articles Table

id TEXT PRIMARY KEY
title TEXT NOT NULL
content TEXT NOT NULL
author TEXT NOT NULL
published_at TEXT NOT NULL
image_url TEXT
tags TEXT
url TEXT NOT NULL
download_date TEXT NOT NULL
district TEXT NOT NULL
short_description TEXT NOT NULL

Article Files Table

id TEXT PRIMARY KEY
article_id TEXT NOT NULL
file_type TEXT NOT NULL CHECK (file_type IN ('pdf', 'screenshot', 'archive'))
file_path TEXT NOT NULL
file_name TEXT NOT NULL
file_size INTEGER NOT NULL
mime_type TEXT NOT NULL
created_at TEXT NOT NULL
updated_at TEXT NOT NULL
FOREIGN KEY (article_id) REFERENCES articles(id) ON DELETE CASCADE

Indexes

idx_articles_published_at ON articles(published_at DESC)
idx_articles_author ON articles(author)
idx_articles_district ON articles(district)
idx_articles_tags ON articles(tags)
idx_article_files_article_id ON article_files(article_id)
idx_article_files_file_type ON article_files(file_type)
idx_article_files_created_at ON article_files(created_at DESC)