search

bradcypert / porios

Connecting people through podcasts.
http://www.porios.com
3 stars 0 forks source link

Normalize Messages/Threads table #34

Closed bradcypert closed 8 years ago

bradcypert commented 8 years ago

Need to normalize the Messesages and Threads table into a 2nd degree.

Probably call the new table Thread Users.

New Tables should probably look like this...

ThreadUsers

Col Type Default
id primary, auto generated none
thread reference, thread none
user reference, users none

Threads

Col Type Default
id primary, auto generated none

Messages

Col Type Default
id primary, auto generated none
thread reference, threads none
sent reference, users none
message text none
time_sent timestamp current_time