> 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 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.
