Created
November 28, 2023 17:27
-
-
Save Mau5trakt/400f87dcedfc4a207e56b00b2c31a1d8 to your computer and use it in GitHub Desktop.
movies database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE IF NOT EXISTS admin( | |
admin_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, | |
hash text | |
); | |
CREATE TABLE IF NOT EXISTS usuarios( | |
usuario_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, | |
username TEXT, | |
cedula TEXT, | |
correo TEXT, | |
hash TEXT | |
); | |
CREATE TABLE IF NOT EXISTS peliculas( | |
pelicula_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, | |
nombre TEXT, | |
sinopsis TEXT, | |
duracion TEXT, | |
fecha_inicio TEXT, | |
fecha_fin TEXT | |
); | |
CREATE TABLE IF NOT EXISTS salas( | |
sala_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL | |
); | |
CREATE TABLE IF NOT EXISTS funciones( | |
funcion_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, | |
hora_inicio TEXT, | |
hora_fin TEXT, | |
pelicula_id INTEGER, | |
sala_id INTEGER, | |
precio REAL, | |
FOREIGN KEY(pelicula_id) REFERENCES peliculas(pelicula_id), | |
FOREIGN KEY(sala_id) REFERENCES salas(sala_id) | |
); | |
CREATE TABLE IF NOT EXISTS funcion_usuario( | |
funcion_id INTEGER, | |
asiento TEXT, | |
fecha TEXT, | |
usuario_id INTEGER, | |
FOREIGN KEY(funcion_id) REFERENCES funciones(funcion_id), | |
FOREIGN KEY(usuario_id) REFERENCES usuarios(usuario_id) | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment