Review my database design
View Single Post
12-14-2007, 02:37 PM
Join Date: Sep 2007
Originally Posted by
Good thinking bmicallef.
Quick things off the top of my head:
- There is no status table.
- Since you're using tinyint as your datatype for user_rank in your users table, you should do the same the the ID in your users_rank table. Tinyint should be more than enough, especdially if you make it unsigned since it'll go up to 255.
- In your comments table, isn't the comments_comments column a little redundant?
I don't need a status table. Not necessary. I will have only two status, hide or show i.e 0 or 1.
I'll change them. Between, can you explain difference between signed and unsigned? :)
It should be comment_comment. I know it sounds confusing. I have two choices, either stay with it due to the table prefix standard in other tables or just change it to comment. The first option sounds better to me but I'll consider a second opinion.
Necessity is the mother of invention.
View Public Profile
Send a private message to Haris
Find More Posts by Haris