Verse 2
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.
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