Differences between revisions 16 and 17
Revision 16 as of 2002-07-10 21:04:58
Size: 2522
Editor: scf5-fe0-1
Comment:
Revision 17 as of 2003-04-24 11:24:50
Size: 3405
Editor: ptp
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
DonPark and AdamShand are thinking about ways to create a SQL (or maybe LDAP or XML or something) schema which a community wireless group can use as a universal data collection point. We're trying to catalog everything we can think of that a community wireless group would want to keep track of (yes we know we're doomed to failure :-).  DonPark and AdamShand are thinking about ways to create a SQL (or maybe LDAP or XML or something) schema which a community wireless group can use as a universal data collection point. We're trying to catalog everything we can think of that a community wireless group would want to keep track of (yes we know we're doomed to failure :-).
Line 24: Line 24:
 * Node   * Node
Line 48: Line 48:
 * Network   * Network
Line 53: Line 53:
 
Line 57: Line 57:
 
Line 62: Line 62:
  * A: <node> <name>PCHS</name> </node> ... 
   
  * A: <node> <name>PCHS</name> </node> ...
Line 72: Line 72:

community database take two. March 2003
AdamShand, JerrittCollord, AaronBaer, (insert your name here)

I pulled this right out of postgresql since it doesnt appear to be documented anywhere else -- DonPark

User Table
|| userid || character varying(20) ||
|| firstname || character varying(50) ||
|| lastname || character varying(100) ||
|| password || character varying(8) ||
|| memberstatus || character varying(10) ||
|| phone1 || character varying(15) ||
|| phone2 || character varying(15) ||
|| url || character varying(200) ||
|| comments || character varying(2000) ||
|| certificationid || numeric ||
|| mailto || character varying(100) ||
|| MOIN_ID || character varying(24) ||
|| tempkey || character varying(16) ||





----

DonPark and AdamShand are thinking about ways to create a SQL (or maybe LDAP or XML or something) schema which a community wireless group can use as a universal data collection point. We're trying to catalog everything we can think of that a community wireless group would want to keep track of (yes we know we're doomed to failure :-).

  • Don, it occurred to me that it might be worth checking out the NoCatAuth SQL schema (etc/nocat.schema in the tarball), they had originally planned for it to be more then just the auth server. -- Adam. I looked it over. added bandwidth and date to Node. Created Network. added URLs and password to User. (8Jun) -- DonPark

    How would the local *Cat box regulate bandwidth to the user? Would the local *Cat box have a table with users and their respective classes (owner, member, guest, etc..), or would there be another table for that? Somehow we have to account for the bandwidth shaping aspect of things. We could add a field of Type STATUS, memberstatus (nodeOwner, fullMember, guest), and have the local node shape bandwidth for those values. Make sense? -- DanRichardson

Databases

  • User
    • varchar GUID (32,Key)
    • date created
    • date modified
    • varchar username (64)
    • varchar first_name (64)
    • varchar last_name (64)
    • varchar password (64)
    • Type ICQ, icq_id
    • Type Jabber, jabber_id
    • Type URL, homepage
    • Type URL, faceimage
    • Type Address, mailing
    • Type Login, last_login
    • varchar notes (5k)
  • Node
    • varchar GUID (32,Key)
    • date created
    • date modified
    • varchar name (128)
    • Type Antenna, antenna_type
    • Type Direction antenna_pointing_direction
    • int power_output
    • int kbits_second
    • Type Address, antenna_address
    • Type GPS, antenna_gps
    • Type Affiliated group [n]
    • Type User, Owner [n]
    • Type User, Administrator [n]
    • varchar notes (5k)
    • Type URL, description
    • Type URL, login_help
  • GPS Loc
    • float lat
    • float long
    • float altitude
  • Network
    • GUID varchar(32,Key)
    • date created
    • date modified
    • name varchar(128)

System for getting at the data

  • XML-RPC interface
  • xmlrpc.personaltelco.net:3322
  • inserts
  • updates
  • queries
    • Q: <nodequery sql="select * where name=\"PCHS\" " />

    • A: <node> <name>PCHS</name> </node> ...

Implementation

  • PHP page talking to a MySQL server


[http://www.nodedb.com/ndbcom.dtd] NodeDB.com xml schema...


community database take two. March 2003 AdamShand, JerrittCollord, AaronBaer, (insert your name here)

I pulled this right out of postgresql since it doesnt appear to be documented anywhere else -- DonPark

User Table

userid

character varying(20)

firstname

character varying(50)

lastname

character varying(100)

password

character varying(8)

memberstatus

character varying(10)

phone1

character varying(15)

phone2

character varying(15)

url

character varying(200)

comments

character varying(2000)

certificationid

numeric

mailto

character varying(100)

MOIN_ID

character varying(24)

tempkey

character varying(16)


[CategoryDocumentation]

CommunityDatabase (last edited 2012-03-11 02:06:36 by RussellSenior)