So, does this look about right for starting with the Forum/message side of things?
*******************************************
FORUM TABLE
Forum ID (auto-sequential increase)
Forum Title (txt)
Forum Description (txt)
*******************************************
*******************************************
CATEGORY TABLE
Category ID (auto-sequential increase)
Forum ID (carried from Forum)
Category Title (txt)
Category Description (txt)
*******************************************
*******************************************
TOPIC TABLE
Topic ID (auto-sequential increase)
Category ID (carried from Category)
Forum ID (carried from Category)
Topic Title (txt)
Topic Description (txt)
*******************************************
*******************************************
POST TABLE
Post ID (auto-sequential increase)
Topic ID (carried from Topic)
Category ID (carried from Topic)
Forum ID (carried from Topic)
Post Title (txt)
Post Message (txt)
User Details (carried from the User Table – after logon?)
*******************************************
So by this, it should go…..
F1
C1 (f1)
T1 (f1 c1)
P1 (f1 c1 t1)
P2 (f1 c1 t1)
P3 (f1 c1 t1)
P4 (f1 c1 t1)
T2 (f1 c1)
P1 (f1 c1 t2)
P2 (f1 c1 t2)
P2 (f1 c1 t2)
C2 (f1)
T1 (f1 c2)
P1 (f1 c2 t1)
P2 (f1 c2 t1)
T2 (f1 c2)
P1 (f1 c2 t2)
P2 (f1 c2 t2)
