



[français] finally, i posted lesson 28. [geneaologie project] 1. there are two tables tablePersons and tableCouples. 2. tablePersons contains all persons in the database. 3. tableCouples contains all known partnerships (including non traditional families having unestablished partnership roles, having a mother or a father, both mothers, both fathers). 4. siblings are established by similar parent values but will have to search the whole tablePersons to query. 5. cousins are queried similarly. and might take some amount of time. no idea yet on how to improve this?
tablePersons tableCouples
- idPerson, GUID - idCouple, GUID
- sFirstName, string - idOne, tablePersons.idPerson
- sMiddleName, string - idTwo, tablePersons.idPerson
- sLastName, string
- dateBirth, Date
- dateDeath, Date
- image, URL
- parent, tableCouples.idCouple
1 commentaire:
Hum... Are you sure about the meaning of your title for this post ? Maybe it's chosen on purpose, but i don't really get it.
(A french girl)
Enregistrer un commentaire