dranikpg / lab-planes Goto Github PK

CREATE TABLE IF NOT EXISTS airlines (
    id INTEGER PRIMARY KEY,
    name TEXT NOT NULL,
    foundation_date TEXT,
    country TEXT
)

CREATE TABLE IF NOT EXISTS airplanes (
    id INTEGER PRIMARY KEY,
    call_sign TEXT NOT NULL,
    model TEXT NOT NULL,
    capacity INTEGER,
    year_of_manufacture TEXT,
    airline_id INTEGER,
    FOREIGN KEY(airline_id) REFERENCES airlines(id)
)