/*
 Navicat MySQL Dump SQL

 Source Server         : Debian
 Source Server Type    : MariaDB
 Source Server Version : 101111 (10.11.11-MariaDB-0+deb12u1)
 Source Host           : localhost:3306
 Source Schema         : GymFit

 Target Server Type    : MariaDB
 Target Server Version : 101111 (10.11.11-MariaDB-0+deb12u1)
 File Encoding         : 65001

 Date: 13/08/2025 14:53:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for statements
-- ----------------------------
DROP TABLE IF EXISTS `statements`;
CREATE TABLE `statements`  (
  `statement_id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `question_id` tinyint(3) UNSIGNED NOT NULL,
  `statement` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `archetype` enum('Catalyst','Champion','Coach','Connector','Custodian','Cultivator','Conductor','Calibrator') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  PRIMARY KEY (`statement_id`) USING BTREE,
  INDEX `fk_q`(`question_id` ASC) USING BTREE,
  CONSTRAINT `fk_q` FOREIGN KEY (`question_id`) REFERENCES `questions` (`question_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 97 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;
