Subject:
|
Re: SciBrick is looking for you!
|
Newsgroups:
|
lugnet.org.scibrick
|
Date:
|
Mon, 25 Oct 2004 20:23:19 GMT
|
Viewed:
|
3705 times
|
| |
|
|
In lugnet.org.scibrick, David Eaton wrote:
| |
In lugnet.org.scibrick, Bram Lambrecht wrote:
| |
I am...here’s the database structure I came up with (with a couple notes):
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...
|
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.
| |
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.
|
The zipcodes table is 40,000+ rows, while the world cities table is only a
couple hundred rows. Doesn’t make much sense to combine them, since it would
make it more difficult to add cities to the world table.
| |
Oh yeah, sb_m_site maybe also should get that “brickshelf?” flag.
|
Yah, that’s not a bad idea. I was thinking of using something like the
Brickshelf Viewer for brickshelf flagged entries to keep people on scibrick.org
| |
And sbl you might want to have a logo url/icon location.
|
Hmm, good idea.
No, I appreciate the feedback.
| |
| |
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?
|
No, more along the lines of making sure the data people enter is the valid
type/size/etc. Automatic error checking with appropriate error messages and a
chance to correct the errors.
| |
| |
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
|
Unfortunately, no. I don’t have access to the mailing list files, so members
will have to be subscribed to the list via an email sent from the scibrick.org
server to the mailing list server.
--Bram
|
|
Message has 1 Reply:
 | | Re: SciBrick is looking for you!
|
| (...) Depends how much space you need to save, I guess. If you're using varchar's or text fields (for profiles certainly), you're only adding an extra... 2 bytes for a null entry? Forget if it's 1 or 2. So maybe 18 bytes extra per member. I guess (...) (20 years ago, 25-Oct-04, to lugnet.org.scibrick, FTX)
|
Message is in Reply To:
| | Re: SciBrick is looking for you!
|
| (...) 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 (...) (20 years ago, 25-Oct-04, to lugnet.org.scibrick)
|
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
|
|
|
|
