/* AQUI CREARE LA TABLA */ CREATE DATABASE fejesus; CREATE TABLE leccion ( id_leccion INT NOT NULL AUTO_INCREMENT, titulo VARCHAR(30), instructor VARCHAR(50), no_leccion INT, PRIMARY KEY(id_leccion), INDEX(no_leccion) ) ENGINE=INNODB; DESCRIBE leccion; CREATE TABLE preguntas ( id_pregunta INT NOT NULL AUTO_INCREMENT, pregunta VARCHAR(200), verso VARCHAR(40), id_leccion INT NOT NULL, id_seccion INT NOT NULL, PRIMARY KEY (id_pregunta), INDEX(id_leccion), INDEX(id_seccion), FOREIGN KEY (id_leccion) REFERENCES leccion(id_leccion) ON UPDATE CASCADE ON DELETE RESTRICT ) ENGINE=INNODB; DESCRIBE preguntas; CREATE TABLE seccion ( id_seccion INT NOT NULL AUTO_INCREMENT, leccion_id INT NOT NULL, titulo VARCHAR(100), PRIMARY KEY(id_seccion), INDEX (leccion_id), FOREIGN KEY (leccion_id) REFERENCES leccion(id_leccion) ON UPDATE CASCADE ON DELETE RESTRICT ) ENGINE=INNODB; DESCRIBE seccion;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter