Database Design
Closed this issue · 3 comments
GoogleCodeExporter commented
Users:
- ID
- Username
- First
- Email
- PasswordHash
- Active
- Verified
- Verify Code
- Location(City.ID)
- Lat
- Long
Options:
- Install Date
- Site GMT Offset
- Install Location (Relative to http://site/
- Site Name
- Site Motto
Frequency:
- ID
- Freq (stored in Hz)
- Category.ID
- Lat
- Long
- Verified
- Protocol
- Location (City.ID)
(Might have to seperate lat/long in a seperate this into additional table
to allow multiple users to report they can here the signal at their
lat/long and possibly allow board to triangulate)
Tags:
- User.ID
- Freq.ID
- Tags (CSV)
Catgegory:
- ID
- Description
- Abbreviation
Comments_Freq:
- User.ID
- Freq.ID
- Date
- Comment
Comments_Loc:
- User.ID
- City.ID
- Date
- Comment
Country:
- ID
- Name
State:
- ID
- Name
- Country.ID
City
- ID
- Name
- State.ID
(These 3 location tables will be a bear on end users, would prefer to
supply the data if it all possible)
Original issue reported on code.google.com by hepa...@gmail.com on 21 Oct 2006 at 6:09
GoogleCodeExporter commented
Add GMT into users table, this allows times to be calculate local to users
setting.
Original comment by hepa...@gmail.com on 21 Oct 2006 at 7:53
GoogleCodeExporter commented
Add Version to Options table
Original comment by hepa...@gmail.com on 21 Oct 2006 at 8:23
GoogleCodeExporter commented
Database is complete. Minor changes as we develop will occur, but database is
created and work can be based on it.
Original comment by hepa...@gmail.com on 13 Nov 2006 at 5:51
- Changed state: Fixed