Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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`)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement