Table: ratings

SHOW CREATE TABLE ratings

CREATE TABLE `ratings` (
  `ratingId` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) DEFAULT NULL,
  `movieId` int(11) DEFAULT NULL,
  `rating` decimal(5,2) DEFAULT NULL CHECK (`rating` >= 0 and `rating` <= 5),
  `added` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`ratingId`),
  KEY `movieId` (`movieId`),
  CONSTRAINT `ratings_ibfk_1` FOREIGN KEY (`movieId`) REFERENCES `movies` (`movieId`)
) ENGINE=InnoDB AUTO_INCREMENT=105340 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci `ENCRYPTION_KEY_ID`=100

SELECT * FROM ratings