manarah.team team mailing list archive

[jmehdi <jmehdi@xxxxxxxxxx>]

assalamu alaykum,

Attached is the database schema of Bayt Al-Hikma .

The main tables are Book -> Kitab -> Bab -> Hadeeth
A book is a set of kitabs; a kitab is a set of babs; a bab is a set of 
hadeeths.
Let's explain that with examples:
* "sahih bukhari" = book
  - "1. The book of commencement of revelation" = kitab
     - "1 How the Divine Revelation commenced" = bab
        - Hadiths...

* babs are optional:
  "Sunan Abu-Dawud" = book
  - "1 Purification" = kitab
     - hadiths....

* kitabs are also optional:
  "40 hadiths of An-Nawawi" = book
  - Hadiths....

Reference table (which contains Qudsi/Marfu/Mauquf... categories), 
Reliability table (which contains Sahih/Hasan/... categories), IsnadLink 
table (Musnad/Mursal/Muttasil...) and IsnadNature table (Munkar/Mudraj) 
are not yet used.

Chains of transmettors are defined using: Hadeeth -> Sanad -> Isnad -> Rawi
The Isnad table contains the list of Rawis with their position; each 
hadeeth can have several chains, they are stored using the Sanad table.

--
Mehdi Magnon
Administrator of the Sabily Project - Free Islamic Operating System (http://www.sabily.org)
Administrator of Bayt Al Hikma - Islamic resources and Hadiths (http://www.bayt-al-hikma.com)

Attachment: baytAlHikma-schema.PNG
Description: PNG image

Attachment: baytAlHikma-schema-main.PNG
Description: PNG image

Attachment: sanad.png
Description: PNG image