Each verse can be associated with multiple topics across all three categories: ontological, thematic, and general. The topics are organized hierarchically, meaning each topic may have parent topics and child topics.

Database Structure

The QUL exports ayah topics data as a SQLite database with the following structure:

topic_id: Unique identifier for the topic
topic_name: The English name of the topic
arabic_name: The Arabic name or transliteration of the topic (if available)
verse_key: The verse identifier in format "chapter:verse" (e.g., "2:255")
is_ontology: Boolean indicating if this is an ontology topic
is_thematic: Boolean indicating if this is a thematic topic
parent_topic_id: ID of the parent topic (for hierarchical organization)
description: Detailed description of what the topic encompasses