airline-postgresql.sql

来自「Hibernate开发及整合应用大全 蔡雪焘编著 本书用典型的示例剖析Hiber」· SQL 代码 · 共 31 行

CREATE TABLE persons(
 person_id INT NOT NULL,
 first_name VARCHAR(32) NOT NULL,
 last_name VARCHAR(32) NOT NULL,
 PRIMARY KEY( person_id )
);

CREATE TABLE flights(
 flight_id INT NOT NULL,
 name VARCHAR(32) NOT NULL,
 departure_utc TIMESTAMP NOT NULL,
 arrival_utc TIMESTAMP NOT NULL,
 PRIMARY KEY( flight_id )
);

CREATE TABLE reservations(
 reservation_id INT NOT NULL,
 person_id_fk INT NOT NULL,
 flight_id_fk INT NOT NULL,
 registration_utc TIMESTAMP NOT NULL,
 comment TEXT,
 PRIMARY KEY(reservation_id,person_id_fk,flight_id_fk),
 FOREIGN KEY (person_id_fk) REFERENCES persons(person_id),
 FOREIGN KEY (flight_id_fk) REFERENCES flights(flight_id)
);

INSERT INTO persons VALUES(1,'Aslak','Helles鴜');
INSERT INTO persons VALUES(2,'Eivind','Waaler');
INSERT INTO persons VALUES(3,'Ludovic','Claude');