Re: Table Design In General

Chris wrote:
> Thanks for the input Frank!
>
> I ran your question by the purchasers here this morning.
>
> The product numbers you have here don't line up with RCA's current
> catalog. Product 7035 is now actually Hall & Oates Live At the Apollo.
> Their numbering system has changed a bit too: the current available
> products are RCA7035.2 (CD) and RCA7035.4 (Cassette).
>
> That being said, the purchasers are pretty sure that the numbering that
> you have here indicates a 7" vinyl single (the 45rpm disc) vs. a 12"
> vinyl single (the 78rpm disc).
>
> Thanks again,
> Chris
>

Thx - we *do* talk 1957, after all, so 12" 78rpm did cross my mind. However, I never say any "hitsingles" on 12" 78rpm; though we did have a 33/45/78 rpm turntable in those (end 50's) days.

RCA 47-7035 of course is not the same as RCA7035.2, so it may well point to another recording/artist, etc.

However, it does indicate a problem: RCA should (probably) still be able to decode RCA 47-7035 into Elvis/Jailhouse ROck/etc.

That's where "active until" (or "active_since") column come in. Back to the problem at hand: the *key* does not change, maybe the current description does. But it should (probably - this would be a business requirement, if at all) be possible to indicate the properties of RCA 47-7035 for eternity.

-- 
Regards,
Frank van Bortel