Re: [Slashcode-development] Topics

[Brian A. <br...@ta...>]

Eric Dannewitz wrote:
> Well, you could KEEP the sid and have a sequence that links stories and
> topics together. Then you'd have the nice SID thing alive still, and then
> deal with the space issue.
SID will still be around. There will just be an additional sequence.
Think of it as a candidate key.

> Or you could maybe have two tables that assign a sequence to a SID (story and
> topic) and then those sequences are added to another table that links
> multiple stories and topics together.....
The only reason to do header tables like that (and the next version of
comments
is like this) is if you need to worry about relating multiple items to 
topics (classic many to many relationship). 

This shows up in comments, where we have a header table and use
sequences
from it to create parents in comments (we need this so that stories,
polls,
journals, ladybug... other unwritten bits of code) can use the comments
table.

	-Brian