Subject:
|
Re: SciBrick is looking for you!
|
Newsgroups:
|
lugnet.org.scibrick
|
Date:
|
Mon, 25 Oct 2004 19:42:39 GMT
|
Viewed:
|
8635 times
|
| |
|
|
In lugnet.org.scibrick, Bram Lambrecht wrote:
> I am...here's the database structure I came up with (with a couple notes):
> <http://scibrick.org/scibrickdbstructure.txt
> TXT file>¬
I might suggest combining sb_m, sb_m_loc, and sb_m_profile into sb_m, and just
not fill in the _loc and _profile bits unless either supplied or member is a
"full" member. Unless people can have multiple locations and profiles...
Also, you might be able to combine worldcity and zipcodes, and "if country !=
'USA', go by country/city, else go by (state/city) or (zipcode)". I suppose
technically that might take up more space for the table if you set up an extra
key for country/city... Eh, either way I suppose. Although admittedly, that'd
give you only one place to look if you were trying to reference by long/lat.
Hmm.
Oh yeah, sb_m_site maybe also should get that "brickshelf?" flag. And sb_l you
might want to have a logo url/icon location.
Dang, I'm picky, huh?
> As you can see, there is quite a bit of information that needs to be entered
> and displayed. Error checking is the worst part of it,
Is this error checking insofar as existing members/officers OK'ing people's
information?
> then there's also
> making sure the members are logged in (I'm using PHP sessions for that right
> now) and that only members at the proper level can add bios or events, etc.
> I also want to make sure members get signed up for appropriate mailing lists.
Ooo, there's another two tables for you :) Mailing list info & members/list
crossref
DaveE
|
|
Message has 1 Reply:
 | | Re: SciBrick is looking for you!
|
| (...) I think I might have required unique member ids on those tables too. The idea was to keep the number of columns in sb_m down, but maybe that's not really necessary. (...) The zipcodes table is 40,000+ rows, while the world cities table is only (...) (22 years ago, 25-Oct-04, to lugnet.org.scibrick, FTX)
|
Message is in Reply To:
| | Re: SciBrick is looking for you!
|
| (...) It is a fairly easy job, just somewhat tedious. Well, the goal was to use the (URL) template engine> to completely separate style from content. (...) I am...here's the database structure I came up with (with a couple notes): (URL) file> As you (...) (22 years ago, 25-Oct-04, to lugnet.org.scibrick, FTX)
|
74 Messages in This Thread:
 
 
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
This Message and its Replies on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
