id int not_null auto_increment comment(Primary key - unique identifier for each sentiment analysis)
sentiment_status int not_null default(0) comment(Sentiment classification - 0: neutral, 1: positive, 2: negative, 3: mixed)
sentiment_approved int not_null default(0) comment(Approval status - 0: pending review, 1: approved, 2: rejected)
reviews_id int not_null comment(FK to reviews table - review being analyzed)
products_id int not_null comment(FK to products table - product being reviewed)
date_added datetime default null comment(Timestamp when sentiment analysis was performed)
date_modified datetime default null comment(Timestamp of last modification to sentiment record)
user_admin varchar(255) default null comment(Administrator username who reviewed or modified the sentiment)
review_count int unsigned not_null default(0) comment(Comment number when the analyse start)
--
primary id
idx_reviews_reviews_id reviews_id
idx_reviews_products_id products_id
##
engine innodb
character_set utf8mb4
collate utf8mb4_unicode_ci