Roadmap

  • Make the basic structure passage-centric instead of verse-centric
  • Figure out i18n (both html, php, and prompts and verses and etc)
  • Self register
    • Pay attention to password
    • Verse sets?
  • Pretty up the screen a bit...
  • Separate the verse text from the verse table - put it in a prompt to make things more flexible
  • Display a prompt (picture or sound or multiple texts later)
  • Implement accountability (emails sent automatically if someone misses or something?)
  • Interface for:
    • UserPassages
    • Passages
    • PassageMap
    • Verses
    • Prompts
    • Users
    • etc.
  • If working on a passage, some way to do verse by verse and then transition into passage for longer review (perhaps paragraph by paragraph?)
  • Some way to weight modulus by the number of words or something (particularly for longer passages)
  • Should there be a way for a user to mark a "problem verse" to give it some extra work (presumably after the daily review interval
  • It appears that modulus is not necessarily the most even way to break down verse review sessions. Maybe there needs to be some kind of calculation of average (perhaps from history?) and then a way to put off a verse or 2 until the next day or something?

BookAliases

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
alias char(25) No
code char(15) No
(:flextblend:)

Books

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
code char(15) No
name char(30) No
(:flextblend:)

Configs

Table comments: Master List of Configuration Sets

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
config_id mediumint(9) No
desc varchar(150) No
version char(10) No
set_id mediumint(9) No
(:flextblend:)

GroupMembers

Table comments: List of Group Members (EITHER subgroup OR user may be specif

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
group char(15) No
userisgroup tinyint(1) No
user char(15) No
(:flextblend:)

Groups

Table comments: Master List of Groups

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
group char(15) No
desc varchar(150) No
admin tinyint(1) No
(:flextblend:)

IntervalMap

Table comments: Map of Intervals to IntervalSets

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
set_id mediumint(9) No
interval_id mediumint(9) No
seq tinyint(4) No
(:flextblend:)

IntervalSets

Table comments: List of Master Intervals

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
set_id mediumint(9) No
desc varchar(150) No
(:flextblend:)

Intervals

Table comments: List of Intervals - how often reviewed and how many times

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
interval_id mediumint(9) No
divisor mediumint(9) No
repeat mediumint(9) No
desc varchar(150) No
(:flextblend:)

PassageMap

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
passage_id bigint(20) No
verse_id bigint(20) No
(:flextblend:)

Passages

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
passage_id bigint(20) No
desc varchar(250) No
version char(20) No
(:flextblend:)

Prompts

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
verse_id bigint(20) No
type char(20) No
desc varchar(100) No
prompt blob No
prompt_id bigint(20) No
primary tinyint(1) No
significant tinyint(1) No
(:flextblend:)

UserVerses

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
user char(15) No
verse_is_a_passage tinyint(1) No
verse_id mediumint(9) No
set_id mediumint(9) No
interval_id mediumint(9) No
modulus int(11) No
interval_start int(10) No
(:flextblend:)

Users

Table comments: Master List of Users

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
user char(15) No
desc varchar(150) No
passwd var(100) No
config_id mediumint(9) No
review_count int(10) Yes NULL count of reviews done, used in calculating intervals & etc.
(:flextblend:)

Verses

Table comments: Master List of Verses

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
verse_id bigint(20) No
version char(10) No
book char(10) No
chap smallint(6) No
verse smallint(6) No
text varchar(250) No
(:flextblend:)

integers

(:flextbl options="border=1" sep=" ":)
Field Type Null Default Comments
i int(11) No
(:flextblend:)