JsonSQL Demo

🛠️ MySQL Export

Exportiere die aktuelle Datenstruktur als CREATE TABLE-Statements im MySQL-Format.

Gesamte Datenbankstruktur

-- CREATE TABLE für `classes`
DROP TABLE IF EXISTS `classes`;
CREATE TABLE `classes` (
  `id` INT AUTO_INCREMENT,
  `name` VARCHAR(255),
  `room` VARCHAR(10),
  `teacher_id` INT,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB CHARACTER SET=utf8mb4;

-- CREATE TABLE für `courses`
DROP TABLE IF EXISTS `courses`;
CREATE TABLE `courses` (
  `id` INT AUTO_INCREMENT,
  `subject` VARCHAR(255),
  `level` ENUM(''),
  `weekday` ENUM(''),
  `time_from` VARCHAR(255),
  `time_to` VARCHAR(255),
  `teacher_id` INT,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB CHARACTER SET=utf8mb4;

-- CREATE TABLE für `enrollments`
DROP TABLE IF EXISTS `enrollments`;
CREATE TABLE `enrollments` (
  `id` INT AUTO_INCREMENT,
  `student_id` INT,
  `course_id` INT,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB CHARACTER SET=utf8mb4;

-- CREATE TABLE für `students`
DROP TABLE IF EXISTS `students`;
CREATE TABLE `students` (
  `id` INT AUTO_INCREMENT,
  `firstname` VARCHAR(50),
  `lastname` VARCHAR(50),
  `email` VARCHAR(255),
  `class_id` INT,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB CHARACTER SET=utf8mb4;

-- CREATE TABLE für `teachers`
DROP TABLE IF EXISTS `teachers`;
CREATE TABLE `teachers` (
  `id` INT AUTO_INCREMENT,
  `gender` ENUM(''),
  `firstname` VARCHAR(50),
  `lastname` VARCHAR(50),
  `email` VARCHAR(100),
  `description` TEXT,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB CHARACTER SET=utf8mb4;

Tabelle	Aktion
🗂️ `classes`	📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT)
🗂️ `courses`	📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT)
🗂️ `enrollments`	📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT)
🗂️ `students`	📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT)
🗂️ `teachers`	📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT)
🛢️ `Alle Tabellen`	📄 CREATE (alle) 🧾 INSERTs (alle) 📦 Komplett (alle)