Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Train
- (
- trainID CHAR(10) NOT NULL UNIQUE,
- departure TIMESTAMP(0),
- arrival TIMESTAMP(0),
- trainStatus CHAR(20),
- pairedWith CHAR(10),
- confirmed BOOLEAN,
- PRIMARY KEY (trainID),
- FOREIGN KEY (pairedWith) REFERENCES Train (trainID)
- );
- *
- CREATE TABLE Car
- (
- carID CHAR(10) NOT NULL UNIQUE,
- description VARCHAR,
- PRIMARY KEY (carID),
- );
- *
- CREATE TABLE Route
- (
- routeID CHAR(4) NOT NULL UNIQUE,
- trainRatios CHAR(20),
- PRIMARY KEY (routeID)
- );
- CREATE TABLE Section
- (
- sectionID SERIAL,
- westCity CHAR(20),
- eastCity CHAR(20),
- PRIMARY KEY (sectionID),
- );
- CREATE TABLE Travels
- (
- trainID CHAR(10) NOT NULL,
- routeID CHAR(4) NOT NULL,
- FOREIGN KEY (trainID) REFERENCES Train (trainID),
- FOREIGN KEY (routeID) REFERENCES Route (routeID)
- );
- CREATE TABLE PartOf
- (
- routeID CHAR(4) NOT NULL,
- sectionID INTEGER NOT NULL,
- PRIMARY KEY (routeID, sectionID),
- FOREIGN KEY (routeID) REFERENCES Route (routeID),
- FOREIGN KEY (sectionID) REFERENCES Section(routeID)
- );
- CREATE TABLE OnBoard
- (
- trainID CHAR(10) NOT NULL,
- sectionID INTEGER NOT NULL,
- date TIMESTAMP(0) NOT NULL,
- redBkng INTEGER,
- silverBkng INTEGER,
- goldBkng INTEGER,
- PRIMARY KEY (trainID, sectionID, date),
- FOREIGN KEY (trainID) REFERENCES Train (trainID),
- FOREIGN KEY (sectionID) REFERENCES Section(routeID)
- );
- CREATE TABLE ConsistsOf
- (
- trainID CHAR(10) NOT NULL,
- carID CHAR(10) NOT NULL,
- PRIMARY KEY (trainID, carID),
- FOREIGN KEY (trainID) REFERENCES Train (trainID),
- FOREIGN KEY (carID) REFERENCES Car(carID)
- );
Add Comment
Please, Sign In to add comment