Data Dictionary

The following is a AI back translation of the data in the sotrage lay compiled by ChatGpt and manual efforts. It needs to be reviewed and updated for accuracy.

Table of Contents

Quran Data

• Table buckwalter-encoding - The buckwalter-encoding table serves as a reference for transliterating Arabic text into Latin characters using the Buckwalter system. This standardized mapping is widely used in computational linguistic studies and text processing of Arabic.
• Table dictionary-entries - The dictionary-entries table acts as a lexicon for the Qur'an, cataloging definitions, transliterations, and related forms of words. It is a foundational resource for both linguistic analysis and translation work.
• Table exact-arabic-list - The exact-arabic-list table provides a precise list of Arabic words in their original script, extracted from the Qur'an. It is used to ensure textual accuracy and facilitate analyses requiring direct access to the Qur'an's language.
• Table exact-transliteration-list - The exact-transliteration-list table contains transliterated versions of Arabic words from the Qur'an, using standardized Latin scripts. This is especially useful for linguistic studies and for readers unfamiliar with the Arabic script who wish to study the Qur'an's phonetics and structure.
• Table formula-archetype-list-lower - The formula-archetype-list-lower table organizes formulaic expressions by their archetypal forms, categorizing repeated patterns into simplified or "lower-case" structures for linguistic generalization. It is instrumental in recognizing underlying archetypes in the Qur'an's repetitive stylistic elements.
• Table formula-id-codes-linked-global-words - The formulaic-glosses table provides glosses or meanings for recurring formulae in the Qur'an, adding semantic context to repeated phrases. It helps in understanding the significance and meaning behind formulaic elements in the Qur'an's structure.
• Table formula-list - This table maps formulaic phrases to their unique identifiers, linking them to globally occurring words within the Qur'an. It serves as a bridge between formulaic data and individual lexical items, aiding in understanding the compositional use of words across formulaic expressions.
• Table formulaic-glosses - The formula-list table contains a comprehensive catalog of repeated phrases or formulae in the Qur'an. It captures patterns of words or phrases that recur throughout the text and provides details on their frequency, position, and context. This table is essential for identifying formulaic structures used in linguistic, thematic, and rhetorical analyses of the Qur'an.
• Table intertextual links - The intertextual links table documents references and connections between Qur'anic verses and external texts or traditions. It includes source details, bibliographic references, and text comparisons, supporting studies on the Qur'an's historical and literary context.
• Table intertextual sources - The intertextual sources table documents connections between Qur'anic verses and external texts, providing bibliographic references and source language data. This table supports comparative studies, highlighting the intertextuality of the Qur'an with earlier scriptures and traditions.
• Table lemma-list - The lemma-list table contains base forms of words
• Table proper-noun-list - The proper-noun-list table catalogs proper nouns found in the Qur'an, along with their transliterations, alternative spellings, and associated Arabic script. This dataset is instrumental in identifying and analyzing references to key individuals, places, and entities within the text, providing a foundation for historical and thematic studies.
• Table quran-data - This table represents the foundational dataset for the Qur'an, including information about its words, verses, chapters
• Table quran-full-parse - This is a denormalise view and combines a number of tables into a single fast moving table. This table provides a detailed grammatical breakdown of each verse, including word-by-word parsing and annotations of parts of speech. It is an essential resource for linguistic and syntactic analysis of the Qur'an.
• Table quran-translation - This table contains multiple translations of the Qur'an into various languages, each entry aligning with its corresponding verse. It includes details like the translator’s name and translation metadata, making it a valuable resource for comparative studies and linguistic research.
• Table quran-verse-endings - This table focuses on the rhyming and stylistic structures at the end of Qur'anic verses. It documents verse-ending patterns, including linguistic and phonetic features, and is vital for studying Qur'anic rhyme and rhythm.
• Table render-formulaic-density-summaries - This table summarizes data on formulaic density within the Qur'an, categorizing it by root structures and lemmas. It supports linguistic studies on the prevalence and distribution of formulaic language across chapters and contexts.
• Table root-list - The root-list table organizes words in the Qur'an by their linguistic roots, which form the basis of the Arabic language. It includes metadata such as occurrences and derivations, aiding in morphological and etymological studies.
• Table stats-suras - This table provides statistical data on each sura, including verse and word counts, provenance
• Table sura-data - This table provides metadata about each sura
• Table translation-list - The translation-list table catalogs translations of the Qur'an, detailing the translator, publication date, and descriptive notes. It allows users to explore and compare different interpretive perspectives on the text.
• Table transliteration-exceptions - The transliteration-exceptions table defines exceptions in standard transliteration rules, capturing unique cases where a word is rendered differently for linguistic or contextual reasons. It ensures consistency and accuracy in transliteration output.
• Table usage-verses-searches - This table logs searches performed by users for specific verses or queries, capturing metadata like referring pages and timestamps. It provides an audit trail of search behavior, useful for understanding user needs and refining search algorithms.

Application Specific Tables

• Table failed-searches - The failed-searches table logs unsuccessful user search queries, capturing details like the timestamp and user ID. This data helps in improving the search functionality by identifying gaps or user challenges in retrieving relevant results.
• Table help-page-links - This table contains metadata about help pages, including titles and URLs, allowing for easy navigation and access to user guides. It serves as a resource for assisting users in understanding system functionalities and features.
• Table login-logs - The login-logs table records user login activity, including timestamps, IP addresses, and user information. This data is vital for security audits and tracking user access patterns.
• Table quick-tips - The quick-tips table provides a collection of short, actionable suggestions for users navigating the system. It offers guidance on common tasks like searching verses, analyzing roots, and using advanced search functions.
• Table tooltip-text - This table contains text for tooltips displayed in the system, providing concise explanations of features or data points. It enhances the user interface by offering quick and context-sensitive help.
• Table usage - The usage table tracks user activity, including the pages they load, timestamps, and associated metadata. It provides insights into user behavior and system utilization, aiding in feature optimization and user experience improvements.
• Table users - The users table stores user account details, including login credentials, preferences, and activity data. It is a core component of user management, supporting authentication and personalization features.

Application Specific Tables with no table examples [Todo]

• Table bookmarks - This table allows users to save and manage bookmarks for specific verses or sections of the Qur'an, including timestamped metadata. It is a useful feature for revisiting and studying key passages.
• Table history - The history table records user activity history, such as recently viewed verses or pages. It provides a convenient way for users to revisit previously accessed content.
• Table messages - This table records system-generated messages sent to users, including their content, expiration dates, and status
• Table tagged-verses - The tagged-verses table tracks associations between user-defined tags and specific Qur'anic verses. It supports custom annotations and thematic exploration of the text.
• Table tags - The tags table enables users to categorize and label verses or content, storing tag names, colors, and related metadata. This functionality facilitates personalized organization and retrieval of content.