Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP DATABASE IF EXISTS `Flyankomster`;
- CREATE DATABASE `Flyankomster`;
- USE `Flyankomster` ;
- CREATE TABLE IF NOT EXISTS `Flyankomster`.`Flyplass` (
- `FpKode` VARCHAR(45) NOT NULL,
- `FpNavn` VARCHAR(45),
- `FpTlf` VARCHAR(45),
- PRIMARY KEY (`FpKode`)
- );
- CREATE TABLE IF NOT EXISTS `Flyankomster`.`Rullebane` (
- `RKode` INT NOT NULL,
- `RLengde` VARCHAR(45),
- `RPos` VARCHAR(45),
- `Flyplass_FpKode` VARCHAR(45) NOT NULL,
- PRIMARY KEY (`RKode`),
- FOREIGN KEY (`Flyplass_FpKode`)
- REFERENCES `Flyankomster`.`Flyplass` (`FpKode`)
- );
- CREATE TABLE IF NOT EXISTS `Flyankomster`.`Fly` (
- `FlKode` INT NOT NULL,
- `FlPP` INT,
- `FlAntP` INT,
- `FlSelskap` VARCHAR(45),
- `Rullebane_RKode` INT NOT NULL,
- PRIMARY KEY (`FlKode`),
- FOREIGN KEY (`Rullebane_RKode`)
- REFERENCES `Flyankomster`.`Rullebane` (`RKode`)
- );
- CREATE TABLE IF NOT EXISTS `Flyankomster`.`Tidspunkt` (
- `Dato` DATE NOT NULL,
- `Klokkeslett` TIME NOT NULL,
- PRIMARY KEY (`Dato` , `Klokkeslett`)
- );
- CREATE TABLE IF NOT EXISTS `Flyankomster`.`Reise` (
- `ReiseType` VARCHAR(45) NOT NULL,
- `FK_Rullebane_RKode` INT NOT NULL,
- `FK_Fly_FlKode` INT NOT NULL,
- `FK_Tidspunkt_Dato` DATE NOT NULL,
- `FK_Tidspunkt_Klokkeslett` TIME NOT NULL,
- PRIMARY KEY (`FK_Tidspunkt_Dato` , `FK_Tidspunkt_Klokkeslett`, `FK_Fly_FlKode`),
- FOREIGN KEY (`FK_Rullebane_RKode`)
- REFERENCES `Flyankomster`.`Rullebane` (`RKode`),
- FOREIGN KEY (`FK_Fly_FlKode`)
- REFERENCES `Flyankomster`.`Fly` (`FlKode`),
- FOREIGN KEY (`FK_Tidspunkt_Dato`, `FK_Tidspunkt_Klokkeslett`)
- REFERENCES `Flyankomster`.`Tidspunkt` (`Dato`, `Klokkeslett`)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement