Subject:
|
Re: SciBrick is looking for you!
|
Newsgroups:
|
lugnet.org.scibrick
|
Date:
|
Mon, 25 Oct 2004 19:42:39 GMT
|
Viewed:
|
4234 times
|
| |
![Post a public reply to this message](/news/icon-reply.gif) | |
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: ![](/news/x.gif) | | 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 (...) (20 years ago, 25-Oct-04, to lugnet.org.scibrick, FTX)
|
Message is in Reply To:
![](/news/x.gif) | | 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 (...) (20 years ago, 25-Oct-04, to lugnet.org.scibrick, FTX)
|
74 Messages in This Thread: ![(Cancelled)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Tom McDonald (21-Oct-04 to lugnet.org.scibrick, lugnet.general, lugnet.build.mecha, lugnet.space, lugnet.castle)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Eric Sophie (22-Oct-04 to lugnet.org.scibrick, lugnet.general, lugnet.build.mecha, lugnet.space, lugnet.castle)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Eric Sophie (22-Oct-04 to lugnet.org.scibrick, lugnet.general, lugnet.build.mecha, lugnet.space, lugnet.castle)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Leonard Hoffman (22-Oct-04 to lugnet.org.scibrick, lugnet.general, lugnet.build.mecha, lugnet.space, lugnet.castle)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Jason S. Mantor (22-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/268.gif) ![Re: SciBrick is looking for you! -Leonard Hoffman (22-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Eric Sophie (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Leonard Hoffman (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Eric Sophie (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Adrian Drake (25-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/268.gif) ![Re: SciBrick is looking for you! -Leonard Hoffman (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Allister McLaren (26-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Eric Sophie (26-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/268.gif) ![Re: SciBrick is looking for you! -Eric Sophie (22-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Leonard Hoffman (22-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Eric Sophie (22-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Chris Giddens (22-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Eric Sophie (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Chris Giddens (25-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Jason S. Mantor (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Kevin Blocksidge (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Eric Sophie (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Marc Nelson, Jr. (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/268.gif) ![Re: SciBrick is looking for you! -Jason S. Mantor (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Leonard Hoffman (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Keith Goldman (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Jason S. Mantor (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/268.gif) ![Re: SciBrick is looking for you! -Michael Rutherford (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Ross Crawford (24-Oct-04 to lugnet.org.scibrick, lugnet.off-topic.fun)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Leonard Hoffman (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Ryan Rubino (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Leonard Hoffman (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Ryan Rubino (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Bram Lambrecht (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Dan Boger (25-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Bram Lambrecht (25-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![You are here](/news/here.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Bram Lambrecht (25-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -David Eaton (25-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Bram Lambrecht (25-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Anthony Sava (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -David Eaton (25-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Mark Sandlin (25-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Joe Meno (25-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Dan Simonson (17-Jun-05 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/268.gif) ![Re: SciBrick is looking for you! -Leonard Hoffman (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Eric Sophie (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Leonard Hoffman (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Brian P. Gefrich (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Leonard Hoffman (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Brian P. Gefrich (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Leonard Hoffman (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Brian P. Gefrich (24-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Marc Nelson, Jr. (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Jason S. Mantor (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Kevin Blocksidge (22-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Eric Sophie (22-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Kevin Blocksidge (22-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Eric Sophie (22-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Anthony Sava (23-Oct-04 to lugnet.org.scibrick, lugnet.off-topic.fun)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/268.gif) ![Re: SciBrick is looking for you! -Kevin Blocksidge (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Eric Sophie (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Marc Nelson, Jr. (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/46.gif) ![Re: SciBrick is looking for you! -Ross Crawford (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Marc Nelson, Jr. (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -John Henry Kruer (25-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Marc Nelson, Jr. (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif) ![](/news/246.gif) ![Re: SciBrick is looking for you! -Tom McDonald (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Mark Papenfuss (24-Oct-04 to lugnet.org.scibrick, lugnet.off-topic.fun)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Marc Nelson, Jr. (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/268.gif) ![Re: SciBrick is looking for you! -Paul Baulch (23-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/268.gif) ![Re: SciBrick is looking for you! -Scott M. Duke-Sylvester (25-Oct-04 to lugnet.org.scibrick)](/news/x.gif)
![](/news/x.gif) ![](/news/68.gif) ![Re: SciBrick is looking for you! -Eric Sophie (26-Apr-05 to lugnet.org.scibrick, lugnet.admin.suggestions)](/news/x.gif)
- 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
|
|
|
|