• Classes
    • id: cls
    • name: e.g. mental health
  • Categories
    • id: ctg
    • name: e.g. schizophrenia
  • ClassCatg
    • clsid
    • ctgid
  • ClassMember
    • clsid
    • usrid
  • ClassOrg
    • clsid
    • org
  • Users
    • id: usr
    • username
    • firstname
    • lastname
    • email
    • phone
    • typ: set (member, donor, tutor, partner, friend, moderator, coder, author)
    • password
    • stnid
    • ctyid
    • addr1
    • addr2
    • canbits: privileges
    • startdate
    • isactive
  • Tutors
    • id: tut
    • usrid
    • orgid
    • text: bio
    • imgfile
    • startdate
    • isactive
  • TutorTopic
    • tutid
    • topid
    • score: percent
  • Orgs
    • id: org
    • name
    • legalname
    • parid: parent org.
    • web
    • email
    • phone
    • fax
    • addr1
    • addr2
    • usrid: contact
    • ctyid
    • startdate
    • isactive
  • UserOrg
    • usrid
    • orgid
    • typ: see Users
    • startdate
    • isactive
  • Topics
    • id: top
    • name
    • descr
    • parid
    • childid
    • nextid
    • usrid: author
    • level: beg, int, adv, none
    • isqual: tutor quality, not subject
    • iscopy: childid = topid (copy)
    • isdep: deprecated
    • chgid: user modif.
    • chgdate
    • chgtime
  • TopicDigraph
    • topid
    • prereqid: topic
  • Remmos
    • id: rem
    • tutid
    • usrid
    • locid
    • islocal: tutor on site
    • ischat: just chatting (tutid = user 2)
    • date
    • starttime
    • endtime
    • unitcount: no. of quarter hours
    • isvote: no remmo, just up/down
    • isweekly
    • ismonthly
    • dayofweek
    • weekno: e.g. 3rd Monday in month
    • isrecurring
    • remid: id of recurring remmo
    • stnid
    • topid: default
  • RemmoTopic
    • remid
    • topid
    • updown: 1, 0, -1
  • Locations
    • id: loc
    • usrid
    • orgid
    • stncount
    • issound: speaker and mic
    • addr1
    • addr2
    • ctyid
    • ispublic: e.g. coffee shop
    • name: e.g. Tim Horton's
  • Stations
    • id: stn
    • usrid
    • locid
    • address: numeric
    • password: text
    • issound: speaker and mic
  • [ Lesson Path ]
    • topid/lsfile1/lsfile2/lsfile3.pdf
    • topid: 8 hex digits
  • Lessons
    • id: lsn
    • parid
    • childid
    • nextid
    • previd
    • usrid: author
    • orgid
    • topid
    • title
    • descr
    • filename: mylesson
    • isleaf: mylesson.pdf
    • iscopy: childid = lsnid (copy)
    • startdate
    • isactive
    • chgid: user modif.
    • chgdate
    • chgtime
  • TopicLesson
    • topid
    • lsnid: first lesson
    • usrid: lesson tree author
    • orgid
    • lngid
  • TutorLesson
    • tutid
    • lsnid
  • TutorLang
    • tutid
    • lngid
  • Blocks
    • usrid: blocked user
    • blkid: blocking user
    • tutid
    • spcid
    • orgid: org spaces
    • ischat
    • isrecur: blocked from subtopic spaces
    • canmask: and-ed with canbits
    • startdate
    • enddate
  • Spaces
    • id: spc
    • topid
    • ctgid
    • orgid
    • isfriend
    • usrid: main moderator
    • isclass: ctgid = clsid
    • startdate
    • isactive
  • Moderators
    • spcid
    • usrid
    • orgid
    • startdate
    • isactive
  • Threads
    • id: thr
    • spcid
    • pstid
    • subject
  • Posts
    • id: pst
    • thrid
    • spcid
    • pstid
    • usrid
    • isreply
    • text
    • date
    • time
  • Friends
    • usrid
    • memberid
    • startdate
    • isactive
  • Language
    • id: lng
    • language
  • Cities
    • id: cty
    • name
    • stateprov
    • cryid
  • States
    • code
    • name
    • cryid
    • regid (optional)
  • Countries
    • id: cry
    • code
    • name
  • Regions
    • id: reg
    • cryid
    • name
 
[ Back to Top ]