- CREATE DATABASE Project;
- CREATE TABLE airport (
- name varchar(255) NOT NULL PRIMARY KEY,
- hallNum int,
- gatesNum int,
- address varchar(255),
- City varchar(255)
- );
- CREATE TABLE plans (
- PlanID int NOT NULL PRIMARY KEY,
- planNum int FOREIGN KEY,
- PlanType varchar(255),
- CoID int FOREIGN KEY,
- Seats int
- );
- CREATE TABLE PlanCompanies (
- CoID int NOT NULL PRIMARY KEY,
- LastName varchar(255),
- FirstName varchar(255),
- Address varchar(255),
- Phone int
- );
- CREATE TABLE Employee (
- PersonID int NOT NULL PRIMARY KEY,
- LastName varchar(255),
- FirstName varchar(255),
- Address varchar(255),
- Age int,
- PersonNum int,
- Salary int
- );
- CREATE TABLE Resturants (
- RestName varchar(255) NOT NULL PRIMARY KEY,
- RentPrice int,
- TablesNum int
- );
- CREATE TABLE travelers (
- PersonNum int UNIQUE,
- LastName varchar(255),
- FirstName varchar(255),
- DestCity varchar(255),
- planNum int FOREIGN KEY,
- passportNum int NOT NULL PRIMARY KEY,
- BoardingTicket varchar(255),
- SeatNum int,
- Gender varchar(255)
- );
- CREATE TABLE Trips (
- TripNum int NOT NULL PRIMARY KEY,
- arrivalTime TIMESTAMP(fsp),
- takeOffTime TIMESTAMP(fsp),
- Address varchar(255),
- DestCity varchar(255),
- planNum int FOREIGN KEY
- );
- CREATE TABLE Charge (
- seraialNumber int NOT NULL PRIMARY KEY,
- weight int,
- type varchar(255),
- price int
- );
[text] data
Viewer
Editor
You can edit this paste and save as new: