CREATE TABLE `flyplass` (
  `FPkode` VARCHAR(50) NOT NULL,
  `Fnavn` varchar(45) DEFAULT NULL,
  `TLF` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`FPkode`)
);


CREATE TABLE `fly` (
  `Fkode` int(11) NOT NULL,
  `Fselskap` varchar(45) DEFAULT NULL,
  `Pplass` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`Fkode`)
);

CREATE TABLE `rullebane` (
  `Rkode` int(11) NOT NULL,
  `Pos` varchar(45) DEFAULT NULL,
  `Lengde` varchar(45) DEFAULT NULL,
  `FPkode` VARCHAR(45) DEFAULT NULL,
  PRIMARY KEY (`Rkode`),
  KEY `fk_FPkode` (`FPkode`),
  CONSTRAINT `fk_FPkode` FOREIGN KEY (`FPkode`) REFERENCES `flyplass` (`FPkode`)
);


CREATE TABLE `reise` (
  `AntPerson` varchar(45) DEFAULT NULL,
  `Rkode` int(11) NOT NULL,
  `Fkode` int(11) DEFAULT NULL,
  `tid` int(11) NOT NULL,
  `Ank_Avr` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`Rkode`,`tid`),
  KEY `fk_Fkode` (`Fkode`),
  CONSTRAINT `fk_Fkode` FOREIGN KEY (`Fkode`) REFERENCES `fly` (`Fkode`),
  CONSTRAINT `fk_Rkode` FOREIGN KEY (`Rkode`) REFERENCES `rullebane` (`Rkode`)
);