Rudy,
Thank you for the comments and advice; the classification tables
could see one poem on several tables. A Limerick could be a science
poem and a Dotty Ditty, all at the same time
I think the string in string theory
Must be feeling pretty weary
For dimensions, eleven
(Including heaven?),
Lead to that Einsteinian query.
for example. If it were to be all one table there would be at least
5 series columns and six or seven poem types with each poem using at
least two classification columns, and all would have to be [NULL]. I
already have 400 poems so I need to be able to pull out the number and
titles in each area at times. But I'll think further about that.
The rest of your comments are clear and I will follow what you say.
Thanks again, much appreciated.
Joseph
> > Mainly I think to Rudy for kind comment.
>
> a quick and free review, worth every penny:
>
>
> > Main table:
> > POEMS Poem_id, title, date_written, date_update[NULL]
>
> good
>
>
> > Classification tables:
> > a number with the simple structure:
> > LIMERICK Lim_id, poem_id
> > HAIKU haiku_id, poem_id
>
> no, just one table
>
>
> > Publishing:
> > PUBLISH publish_id, poem_id, bookspp_id [NULL], magspw_id[NULL],
> > book_other_id[NULL], mag_other_id[NULL]
> > BOOKSPP book_id, book_name
> > MAGSPW magspw_id, mag_no, mag_date
> > BOOK_OTHER book_other_id, book_other_name, book_other_publisher,
> > book_other_address[NULL], book_other_email [NULL],
> > book_other_fax[NULL}, book_other_phone[NULL],
book_contact1_id[NULL],
> > book_contact2_id[NULL]
> > MAGS_OTHER (same columns as book_other)
>
> no, i would collapse all of these into two tables, one to
cross-reference
> the poem to the pubication, and the other to identify the
publication
>
> create table PUBLISH
> ( poem_id
> , pub_id
> )
> create table PUBLICATIONS
> ( pub_id
> , pub_type enum('book','magazine','book(other)','magazine(other)')
> , pub_name
> , pub_no
> , pub_date
> , pub_publisher
> , pub_email
> , pub_fax
> , pub_phone
> , pub_contact1_id
> , pub_contact2_id
> )
>
> > contacts:
> > BOOK_CONTACT book_contact_id, book_other_id,
book_contact_name[NULL],
> > (book_contact) _address[NULL], _email[NULL], _fax[NULL],
_phone[NULL],
> > _change[NULL]
> > MAGS_CONTACT (same columns as book_contact)
>
> one table, CONTACTS
>
>
> > submission record:
> > SUBMIT submit_id, poem_id, submit_date, response_date[NULL],
> > accept_date[NULL], reject_date[NULL], payment_offer[NULL],
> > payment_receipt[NULL], payment_amt[NULL]
>
> needs pub_id link
>
>
> > BANKED banked_id, submit_id, date, amount
> > ACCEPTED accept_id, submit_id, acceptance_date, publication_date,
> > payment_due_date, payment_receipt_ref(publisher's)[NULL],
> > overdue_note[NULL]
> >
> > book sales:
> > BOOK_SALES_OTHER book_sales_other_id, bookspp_id[NULL], outlet_id,
> > no_sold[NULL], value
> > OUTLET outlet_id, name, type, outlet_contact_id
> > OUTLET_CONTACT (as BOOK_CONTACT)
> > BOOK_SALES book_sales_id, book_spp_id, sale_date, sale_value
>
> on the surface, these look okay, did not look at them too closely
>
>
>
> > And I assume it is possible to have a script to automatically fill
in
> > the last table as sales occur.
>
> indeed, you will need scripts for all of them
>
>
> rudy
>
>
> ____ . The WDVL Discussion List from WDVL.COM . ____
> To Join wdvltalk, Send An Email To:
mailto:[EMAIL PROTECTED]
> Send Your Posts To: [EMAIL PROTECTED]
> To set a personal password send an email to [EMAIL PROTECTED]
with the words: "set WDVLTALK pw=yourpassword" in the body of the
email.
> To change subscription settings to the wdvltalk digest version:
> http://wdvl.internet.com/WDVL/Forum/#sub
>
> ________________ http://www.wdvl.com _______________________
>
> You are currently subscribed to wdvltalk as:
[EMAIL PROTECTED]
> To unsubscribe send a blank email to
%%email.unsub%%
>
> 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]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ 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.
