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_views
, f_likes
, f_favorites
, etc. These columns will be updated frequently as users interact with the site.
What are your suggestions?