CREATE TABLE alunos (
	id INT AUTO_INCREMENT PRIMARY KEY,
    codigo_barras VARCHAR(50) NOT NULL UNIQUE,
    nome VARCHAR(255) NOT NULL,
    turma VARCHAR(10) NOT NULL,
    data_cadastro TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


CREATE TABLE presenca (
	id INT AUTO_INCREMENT PRIMARY KEY,
    aluno_id INT NOT NULL,
    data_checkin DATETIME NOT NULL,
    CONSTRAINT fk_aluno
    	FOREIGN KEY (aluno_id)
    	REFERENCES alunos(id)
    	ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


INSERT INTO alunos (codigo_barras, nome, turma) VALUES
('1001001A', 'Ana Souza', '1A'),
('1001001B', 'Bruno Lima', '1B'),
('1001001C', 'Carla Mendes', '1C'),
('2002002A', 'Daniel Neves', '2A'),
('2002002B', 'Elisa Ferreira', '2B'),
('2002002C', 'Fábio Gomes', '2C'),
('3003003A', 'Gabriela Santos', '3A'),
('3003003B', 'Hugo Oliveira', '3B'),
('3003003C', 'Isabela Rocha', '3C');