· 8 years ago · Jan 12, 2018, 05:46 PM
1CREATE TABLE IF NOT EXISTS METRO (
2matricula CHAR (8) UNIQUE,
3modelo ENUM ('moderno', 'antiguo'),
4capacidad INT,
5conductor VARCHAR (30),
6num_linea CHAR (8),
7CONSTRAINT met_mat_PK PRIMARY KEY (matricula),
8CONSTRAINT met_num_FK FOREIGN KEY (num_linea)
9REFERENCES LINEA (numero) ON DELETE SET NULL);