Database Tables
Home
PDF
LyvaTags
Lyvathon
Tables
Misc.
Grammar
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)
[
Back to Top
]