= Data model for PIPDI =

The PIPDI data model is mostly identical with the [[IsmiDataModel ISMI data model]].

It has a more elaborate subject hierarchy.

Conceptual objects in the database:

  * (abstract-) '''TEXT'''
  * '''ALIAS''' (title for text or name for person or place) 
  * '''WITNESS''' (aka manuscript)
  * '''CODEX''' (of one or more witnesses)
  * '''COLLECTION'''
  * '''REPOSITORY''' (aka library)
  * '''PERSON'''
  * '''PLACE'''
  * '''SUBJECT'''

We need:
  * linking chapters from the table of contents of the TEXT to folio pages of the WITNESS
  * chapters/sections at the TEXT level are tagged with subject keywords
  * sections at the WITNESS level have folio and line number information


== Objects ==

=== SECTION ===

Attributes:
  * '''title''' name or title of section (arabic)
  * '''title_translit'''
  * '''ord_no''' ordinal number for ordering same-level sections (used internally)

Relations:
  * SECTION is_part_of SECTION
  * SECTION is_found_in WITNESS
    * begins_on_folio
    * begins_on_line
    * ends_on_folio
    * ends_on_line


=== SUBJECT ===

subjects are subject matters that are treated in a text.

Attributes:
  * '''name''' subject name or description (English?)
  * '''name_arabic'''
  * '''notes'''

Relations:
  * SUBJECT is_part_of SUBJECT
  * TEXT has_subject SUBJECT

Examples:
  * ASTROLOGY
  * ASTRONOMY
    * hay’a (4-part division)
    * hay’a (general astronomy)
    * mīqāt
    * qibla determination
    * taqwīm
  * ASTRONOMICAL INSTRUMENTS
    * astrolabes
    * celestial globes/armillary spheres
    * equatoria
    * observational
    * quadrants
      * sundials
  * ASTRONOMICAL TABLES (ZĪJES)
  * CHRONOLOGY
  * COSMOLOGY-philosophical
  * COSMOLOGY-religious
  * GEOGRAPHY-mathematical
  * GEOGRAPHY-terrestrial phenomena (hay’at al-arḍ)
  * MATHEMATICS
    * algebra
    * arithmetic
      * arithmetic tables
      * basic arithmetic
      * number theory
    * geometry
      * conic sections
      * Euclidean constructions
      * general geometry
    * mensuration
    * inheritance (farā’iḍ)
    * magic squares
    * spherics
    * trigonometry
  * OPTICS
  * TECHNOLOGY
    * mechanical devices
    * military
    * navigation
  * PHILOSOPHY
    * metaphysics/ilâhiyyât 
    * natural philosophy/tabî‘iyyât 
    * epistemology/tasawwur and tasdîq
    * philosophy of mind/‘ilm al-nafs
    * ethics/akhlâq
    * politics/siyâsa
    * logic/mantiq
    * dialectic/âdâb al-bahth, ‘ilm al-munâzara
    * philosophy of language/‘ilm al-wad‘, ‘ilm al-balâgha, usûl al-fiqh 
    * multiple subjects
    * other