mvmVT9u2

1CREATE TABLE IF NOT EXISTS Aluno 
2     
3id INTEGER PRIMARY KEY,
4nome TEXT NOT NULL 
5     
6id INTEGER PRIMARY KEY,
7nome TEXT NOT NULL 
8     
9id INTEGER PRIMARY KEY,
10nome TEXT NOT NULL 
11     
12id INTEGER PRIMARY KEY,
13nome TEXT NOT NULL,
14status TEXT NOT NULL,
15plano_ensino TEXT NOT NULL,
16carga_horaria INTEGER NOT NULL,
17id_coordenador INTEGER,
18FOREIGN KEY(id_coordenador) REFERENCES Coordenador(id) ON UPDATE CASCADE ON DELETE SET NULL 
19     
20id INTEGER PRIMARY KEY,
21ano INTEGER NOT NULL,
22semestre INTEGER NOT NULL,
23turma INTEGER NOT NULL,
24data DATE NOT NULL,
25id_professor INTEGER,
26id_disciplina INTEGER,
27id_curso INTEGER,
28FOREIGN KEY(id_disciplina) REFERENCES Disciplina(id) ON UPDATE CASCADE ON DELETE SET NULL,
29FOREIGN KEY(id_professor) REFERENCES Professor(id) ON UPDATE CASCADE ON DELETE SET NULL,
30FOREIGN KEY(id_curso) REFERENCES Curso(id) ON UPDATE CASCADE ON DELETE SET NULL 
31     
32id INTEGER PRIMARY KEY,
33dt_solicitacao date NOT NULL,
34status INTEGER NOT NULL,
35id_aluno INTEGER,
36id_disciplina_ofertada INTEGER,
37id_coordenador INTEGER,
38FOREIGN KEY(id_aluno) REFERENCES Aluno(id) ON UPDATE CASCADE ON DELETE SET NULL,
39FOREIGN KEY(id_disciplina_ofertada) REFERENCES Disciplina_ofertada(id) ON UPDATE CASCADE ON DELETE SET NULL,
40FOREIGN KEY(id_coordenador) REFERENCES Coordenador(id) ON UPDATE CASCADE ON DELETE SET NULL