TCI database

sandbox.sql

CREATE TABLE `activities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `activities` VALUES (1,'Act 1'),(2,'Act 2');

CREATE TABLE `activity_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_activity` varchar(45) DEFAULT NULL,
  `type` varchar(45) DEFAULT NULL,
  `weight` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `activity_details` VALUES (1,'1','coding',2),(2,'1','design',4),(3,'2','coding',1),(4,'2','design',3),(5,'2','design',4);