Database Tables

 

LyvaTeach Tables

  • Users
    • UsrId
    • FirstName
    • LastName
    • Email
    • Phone
    • Cell
    • Password
    • StartDate
    • ^EndDate
    • ^IsActive: Y/N
    • Addr1, Addr2
    • CtyId
  • Tutors
    • TutId
    • UsrId
    • MentorId
    • Intersection
    • Rate: $ amt.
    • PayPal info
    • StartDate
    • ^EndDate
    • IsPartner: Y/N
  • ContentCreators
    • CreId
    • UsrId
    • Rate: $ amt.
    • PayPal info
    • StartDate
    • ^EndDate
    • ^IsEmp: Y/N
    • ^IsAdmin: Y/N
  • Skills
    • SklId
    • UsrId
    • SubId
    • StartDate
    • EndDate
    • Rating: percent
    • Exper: hours
  • TutEval
    • TevId
    • TutId
    • UsrId
    • MtgId
    • AttrNo
    • Value: btwn 1 and 5
  • Sessions
    • SsnId
    • TutId
    • UsrId
    • DayOfWeek
    • Time
    • Length: Default = 60 mins.
  • Meetings
    • MtgId
    • SsnId
    • Date
    • Time
    • Length
  • Items
    • ItmId
    • MtgId
    • LsnId
    • Length
  • Subjects
    • SubId: body = <SubId>.SUB
    • ParId
    • NextId
    • ChildId: zero for courses (leaf subjects)
    • RefCount:  -ve: child = main record; +ve: main record
    • Name: folder name/course no.
    • Title
    • IsDept: Y/N
  • Lessons
    • LsnId: body = <LsnId>.LSN
    • SubId: folder name
    • CreId
    • ParId
    • NextId
    • ChildId
    • LsnNo
    • Title
    • Length: +ve: test length (minutes)
    • AnsKey: Y/N
    • Date
    • ModifId
    • ModifDate
  • City
    • CtyId
    • ParId
    • City
    • State
    • Country
  • Prereqs
    • PreId
    • SubId
    • PreSubId: zero for OR group
    • ParId: PreId of OR group
  • Marks
    • MrkId
    • UsrId
    • SubId
    • LsnId
    • Grade: percent
    • Passed: Y/N
  • Edits
    • EdtId
    • UsrId
    • EmpId
    • EditDate
    • EditTime
    • Date
    • Flag
    • EditType:  Dates/Flags preceded by caret (^)

Project Tables

  • UsrTab: (User)
    • usrid (4)
    • orgid (4)
    • username (32)
    • email (255)
    • password
    • altmail (255)
    • phone (25)
    • cell (25)
    • answer (80)
    • altans (80)
    • question (80)
    • queid (4)
    • altqueid (4)
    • isdev: (has website)
    • iscnv: (has converted $$)
    • balance ($)
    • expirydate
    • isfullyear
    • startdate
    • active
  • OrgTab: (Organization)
    • orgid (4)
    • orgname (255)
    • orglegname (255)
    • web (255)
    • phone (25)
    • fax (25)
    • addr1 (100)
    • addr2 (100)
    • city (80)
    • state (80)
    • cnyid (4)
    • postalcode (20)
    • balance ($)
    • startdate
    • active
  • EmpTab: (Employee)
    • empid (4)
    • usrid (4)
    • orgid (4)
    • title (80)
    • iscontact
    • startdate
    • active
  • PrjTab: (Project)
    • prjid (4)
    • orgid (4)
    • projname (255)
    • title (255)
    • descr (1024)
    • width
    • height
    • movtyp
    • ispassive
    • startdate
    • active
  • UprTab: (User Project)
    • uprid (4)
    • usrid (4)
    • prjid (4)
    • islead
    • isadmin
    • usrtyp (2)
    • startdate
    • active
  • QprTab: (Qty Project)
    • qprid (4)
    • prjid (4)
    • date
    • nodecount (8)
    • bytecount (8)
    • rank (4)
    • ispay
    • amt ($)
  • UliTab: (User Login)
    • prjid (4)
    • usrid (4)
    • date
    • logincount (4)
  • CnyTab: (Country)
    • cnyid (4)
    • cnycode (2)
    • country (50)
  • QueTab: (Security Question)
    • queid (4)
    • question (80)

Lyvathon Tables

  • IntTab: (Integer)
    • intid (8)
    • intval (8)
  • FltTab: (Float)
    • fltid (8)
    • fltval (8)
  • StrTab: (String) {6 tables}
    • strid (8)
    • strval (2^N): [3..8]
  • VarTab: (Var. String)
    • varid (8)
    • len (2)
    • datval ( < 32K )
  • RecTab: (Record) {2-level hierarchy}
    • recid (8)
    • swval (2)
    • isleaf
    • fldids (128):
      • 16 x (datid = 8)
      • 16 x (recid = 8)
      • 16 x (fnmid = 8)
      • 16 x (fdeid = 8)
      • 256 nybs (fldtyps)
  • IdxTab: (Index)
    • idxid (8)
    • tabid (8)
    • treid (8)
    • name (255)
    • idfcount (1): [1..16]
    • hifldnos (8):
      • 16 x (hi nyb)
    • lofldnos (8):
      • 16 x (lo nyb)
    • descord (2)
    • caseins (2)
    • isdupok
    • isprimkey
    • isautoinc
    • maxval (8) {autoinc}
  • DbtTab: (Database Table)
    • tabid (8)
    • prjid (8)
    • name (255)
    • desc (255)
    • fldcount (1)
      • max 256 flds (hi/lo nybs)
    • rftid (8): RecTab fldtyps
    • rfnid (8): RecTab fnmid
    • rfdid (8): RecTab fdeid
    • reccount (8)
  • FnmTab: (Field Name)
    • fnmid (8)
    • fldname (32)
  • FdeTab: (Field Description)
    • fdeid (8)
    • flddesc (255)
  • DbrTab: (Database Record)
    • dbrid (8)
    • tabid (8)
    • recid (8)
  • TreTab: (Tree)
    • treid (8)
    • parid (8)
    • subid (64)
      • 8 x (id = 8)
    • chibyt (1)
      • 8 x (subno >> rec = Y/N)