Server-Side Data

Global Database

1. AppTab: Apps
   1. id: org
   2. entid
   3. isfree
   4. isservdata
2. UsrTab: Users
   1. id: usr
   2. entid
   3. isconv: converted
3. AppUsrTab
   1. appid
   2. usrid
   3. isconv: converted
4. CtyTab: Cities
   1. id: cty
   2. sptid
   3. cntid
5. SpTab: State/Province
   1. id: sptid
   2. cntid
   3. regid
   4. state
   5. statecode
6. CntTab: Countries
   1. id: cntid
   2. country
   3. countrycode
7. RegTab: Regions
   1. id: regid
   2. cntid
   3. region
8. WebTab: Websites
   1. id: web
   2. url
9. TxtTab: Blurbs
   1. id: txt
   2. text (256)

Keyword Database

1. BufTab
   1. id: buf
   2. entid
   3. buf (256)
   4. indexed text (like a search engine)
   5. repetition: asterisk (*)
   6. format: (fld val)*
   7. esc: \)
   8. esc: \\
2. KwdTab: Keywords
   1. id: kwd
   2. text (16)
3. FldTab: Field Names
   1. id: fld
   2. name (16)
4. PhrTab: Phrases
   1. fldid
   2. kwdid
   3. bufid
   4. pos
5. KwcTab: Keyword Counts
   1. fldid
   2. bufid
   3. count
6. FpTab: Field Pos Values
   1. fldid
   2. bufid
   3. pos (0 - 255)

App-Specific Database

1. OrgTab: Organizations
   1. id: org
   2. entid
   3. webid
2. ItmTab: Items
   1. id: itm
   2. entid
3. EntTab: Entities
   1. id: ent
   2. shortname (first)
   3. longname (last)
   4. clsid
   5. ctgid
   6. locid
   7. logid
   8. bal (price)
   9. active
   10. flags (32 bits)
   11. txtid
4. EvtTab: Events
   1. id: evt
   2. date
   3. time
   4. length
   5. untid
   6. cost
   7. iscalc
   8. cntid (currency typ)
   9. locid
   10. txtid
5. EvtDetlTab
   1. evtid
   2. sdtid (src-dest)
   3. reltyp
   4. qty
   5. untid
   6. rate
   7. cost
   8. txtid
6. UniTab: Units
   1. id: unt
   2. units
7. ClsTab: Classes/Categories
   1. id: cls
   2. shortname
   3. longname
   4. typ: O/U/I/A
   5. isclass (class/catg)
   6. txtid
   7. max count = 128
8. RelTab: Relationships
   1. id: rel
   2. reltyp (1 - 9)
   3. setsrcclass (128 bits)
   4. setsrccatg (128 bits)
   5. setdestclass (128 bits)
   6. setdestcatg (128 bits)
   7. isgraph (2-way)
   8. txtid
9. OrgRelTab: Org-Org
   1. id: ortid (sdtid)
   2. srcrelid
   3. destrelid
   4. txtid
10. UsrRelTab: Usr-Usr
    1. id: urtid (sdtid)
    2. srcrelid
    3. destrelid
    4. txtid
11. ItmRelTab: Itm-Itm
    1. id: irtid (sdtid)
    2. srcrelid
    3. destrelid
    4. txtid
12. OrgUsrTab: Org-Usr
    1. id: outid (sdtid)
    2. srcrelid
    3. destrelid
    4. txtid
13. OrgItmTab: Org-Itm
    1. id: oitid (sdtid)
    2. srcrelid
    3. destrelid
    4. txtid
14. UsrItmTab: Usr-Itm
    1. id: uitid (sdtid)
    2. srcrelid
    3. destrelid
    4. txtid
15. LogTab: Login
    1. id: log
    2. email
    3. username
    4. password
    5. phone
    6. question
    7. answer
16. LocTab: Locations
    1. id: loc
    2. room
    3. floor
    4. addr1
    5. addr2
    6. majorint
    7. ctyid
    8. txtid