Flyvninger SQL

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`.`Reise` (
    `ReiseType` VARCHAR(45) NOT NULL,
    `Dato` DATE NOT NULL,
    `Klokkeslett` TIME NOT NULL,
    `Fly_FlKode` INT NOT NULL,
    PRIMARY KEY (`Dato` , `Klokkeslett`, `Fly_FlKode`),
    FOREIGN KEY (`Fly_FlKode`)
        REFERENCES `Flyankomster`.`Fly` (`FlKode`)
);