I am making a web project and I created necessary and the most important table, but I am not sure that I did it right.
In this site users will post data like text, picture, text's category, etc. I created a table like this:
CREATE TABLE `feed` ( `f_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `u_id` int(10) unsigned NOT NULL, `f_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `f_loc` varchar(50) NOT NULL, `f_lang` varchar(2) NOT NULL, `f_cat` smallint(2) unsigned NOT NULL, `f_text` text NOT NULL, `f_img_ids` text NOT NULL, `f_img_flag` tinyint(1) unsigned NOT NULL DEFAULT '0', `f_type` tinyint(1) unsigned NOT NULL DEFAULT '1', `f_status` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`f_id`), KEY `u_id` (`u_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
Is this table schema good or does it need to be improved?
I also want to record every feed's statistics and add some columns like
f_favorites, etc. These columns will be updated frequently as users interact with the site.
What are your suggestions?