The one thing I don't see in your tables is a date stamp when the data was added. I've always found that useful.
With the Is_current example (which I've called "status" on my sites), I store a date stamp there, which I use as an expiration field. I can check that field and determine: A) if it's before that date, the data is still "live" B) if it's after that date, the data is still stored, but no longer online I store an all-zero field to indicate non-expiring data. Just food for thought. My sites tend to be news/date sensitive stuff. -----Original Message----- From: Joseph Harris [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 10:13 AM To: [email protected] Subject: [wdvltalk] table check please This is a fairly simple one product site which may or may not have sessions and session cookies - at the moment not. This is also planned to be the template for at least one other site. TABLE Loop_allname nameID First_N Last_N Is_current (with Matt's advice) TABLE Loop_country name_ID countryID TABLE (look up) Loop_country_list countryID (1 to 200) country FORM Birthday (*compuslory) *FirstN LastN (DoB) Y *M *D Country *email Look-ups TABLE Loop_BirthY dobyID doby (1900 to 2005) TABLE Loop_BirthM dobmID dobm (Jan to Dec) TABLE Loop_BirthD dobdID dobd (1 to 31) Data TABLE Loop_birth_D nameID dob_D TABLE Loop_birth_M nameID dob_M TABLE Loop_birth_Y nameID dob_Y TABLE Loop_email_to_name nameID emailID TABLE Loop_email_address emailID email_address FORM Review (*compulsory) *first name last name country *email *review TABLE Loop_review_by nameID ReviewID TABLE Loop_review reviewID Review (if it is better to put a review url how should the reviews be stored?) FORM Guest Book (*compulsory) *first name last name country *email message TABLE Loop_GuBk_by nameID ReviewID TABLE Loop_GuBk reviewID message (if it is better to put a message url how should the messages be stored?) Sales info will be put to Loop_allname, Loop_country and Loop_email tables, but I have not yet determined how to identify these separately - probably a nameID sale_number table to keep tabs on sales numbers as well. This info will come from PayPal mails. Db access is via PHPMyAdmin and I'll be scratching my head about how to get the data from the forms to the Db later. Joseph Joseph Harris www.smilepoetryweekly.com ____ * The WDVL Discussion List from WDVL.COM * ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. ____ The WDVL Discussion List from WDVL.COM ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] To change subscription settings, add a password or view the web interface: http://intm-dl.sparklist.com/read/?forum=wdvltalk ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: unknown lmsubst tag argument: '' To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
