Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE equipo (
- nom_eq VARCHAR2(50) PRIMARY KEY,
- director VARCHAR2(50)
- );
- CREATE TABLE ciclista (
- dorsal INT PRIMARY KEY,
- nombre VARCHAR2(50),
- edad INT,
- nom_eq VARCHAR2(50) NOT NULL,
- FOREIGN KEY (nom_eq) REFERENCES equipo(nom_eq)
- );
- CREATE TABLE etapa (
- n_etapa INT PRIMARY KEY,
- km INT,
- salida VARCHAR2(50),
- llegada VARCHAR2(50),
- dorsal INT,
- FOREIGN KEY (dorsal) REFERENCES ciclista(dorsal)
- );
- CREATE TABLE puerto (
- nombre VARCHAR2(50) PRIMARY KEY,
- altura INT,
- categoria VARCHAR2(50),
- n_etapa INT NOT NULL,
- dorsal INT,
- FOREIGN KEY (n_etapa) REFERENCES etapa(n_etapa),
- FOREIGN KEY (dorsal) REFERENCES ciclista(dorsal)
- );
- CREATE TABLE maillot (
- codigo INT PRIMARY KEY,
- tipo VARCHAR2(50),
- premio INT,
- color VARCHAR2(50)
- );
- CREATE TABLE llevar (
- dorsal INT NOT NULL,
- n_etapa INT,
- codigo INT,
- PRIMARY KEY(dorsal,n_etapa),
- FOREIGN KEY (dorsal) REFERENCES ciclista(dorsal),
- FOREIGN KEY (n_etapa) REFERENCES etapa(n_etapa),
- FOREIGN KEY (codigo) REFERENCES maillot(codigo)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement