search

unquietpirate / tarotnotes

Tarot Notes is an Android app that helps you record and study your ongoing relationship with the tarot.
0 stars 0 forks source link

Create PHP MySQL TarotNotes Webservice #6

Open melek opened 11 years ago

melek commented 11 years ago

tarotdatabase

melek commented 11 years ago

Reader/querent can be the same type of object. I would like it if every person in a reading were easily connected to an account, either an existing account (Someone in one of your lists/google+-like circles) or a potential account. You could even invite them through the act of including their email in the reading. Re: Reader/Querent:

I would also like the reader/querent roles to be freely assignable to multiple persons, or people to be given multiple roles - and of course, require no roles. (What if you just saw some cards on the ground or dreamed up a spread and wanted to record it?) It could also be neat/useful to be able to create new roles on the fly ('dreamer').

The way I'd design the database in this case would be to simply make a 'reading_participants' databases for a given spread that keys the spread to a matched list of people and roles, where either can occur more than once (though no duplicate entries.. i can't think of a case for that)

Tables: People in Role in Readings Reading_ID Person_ID Role_ID 123 42 0 123 22 1

personRoles Role_ID Role_Name 0 Reader 1 Querent

People Person_ID Name 22 Pirate 42 Melek

[Lionel will add more to this later.]