← Back to team overview

manarah.team team mailing list archive

Re: Database schema

 

The schema already supports that.
Look at: http://www.bayt-al-hikma.com/nawawi/hadeeth/1
The hadeeth is related by Bukhari (n°1), Muslim (n°4692) and Nawawi (n°1). In the database the hadeeth exists only once, and as the sanad can be found in Bukhari, all other books inherit this information.

For hadeeths that I haven't yet added in Bukhari or Muslim, I only put one rawi, as in this hadeeth: http://www.bayt-al-hikma.com/nawawi/hadeeth/2

About this, do you know any book in which we can find matching hadeeths in different books? For example, to know that Bukhari n°1 = Muslim n°4692.

sanad.png is attached again

wa salam

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)


Le 01/03/2012 22:43, Abdelmonam Kouka a écrit :
Wa alaykom assalem,

Good design, I think we will adopt it inshallah.
Juste for the case of 40 Nawawi there is no sanad! there is only the rawi and the book in which exist the hadith, exemple: "hadith 1: *On the authority of Omar bin Al-Khattab, who said : I heared the messenger of Allah salla Allah u alihi wa sallam say :Actions are but by intention and every man shall have but that which he intended. Thus he whose migration was for Allah and His messenger, his migration was for Allah and His messenger, and he whose migration was to achieve some worldly benefit or to take some woman in marriage, his migration was for that for which he migrated. related by Bukhari and Muslim*"

so we should find a solution to link this hadith from this book with its equivalent in Bukhari and Muslim, we will need this option when we will start adding books that explain the Hadith.

2012/3/1 jmehdi <jmehdi@xxxxxxxxxx <mailto: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)


    --
    Mailing list: https://launchpad.net/~manarah.team
    <https://launchpad.net/%7Emanarah.team>
    Post to     : manarah.team@xxxxxxxxxxxxxxxxxxx
    <mailto:manarah.team@xxxxxxxxxxxxxxxxxxx>
    Unsubscribe : https://launchpad.net/~manarah.team
    <https://launchpad.net/%7Emanarah.team>
    More help   : https://help.launchpad.net/ListHelp




--
عبد المنعم كوكة
Abdelmonam Kouka
http://sabily-guru.blogspot.com/
http://geek-tounsi.blogspot.com/

Attachment: sanad.PNG
Description: PNG image


Follow ups

References