Submarine Cable map

CREATE TABLE countries (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT UNIQUE NOT NULL
)
CREATE TABLE landing_points (
    id TEXT PRIMARY KEY,
    name TEXT NOT NULL,
    tbd BOOLEAN NOT NULL DEFAULT 0,
    latitude REAL,
    longitude REAL,
    country_id INTEGER,
    FOREIGN KEY (country_id) REFERENCES countries(id) ON DELETE CASCADE
)
CREATE TABLE cables (
    id TEXT PRIMARY KEY,
    name TEXT NOT NULL,
    planned BOOLEAN NOT NULL DEFAULT 0,
    length INTEGER,
    length_unit TEXT,
    notes TEXT,
    owners TEXT,
    rfs TEXT,
    rfs_year INTEGER,
    suppliers TEXT,
    url TEXT,
    latitude REAL,
    longitude REAL,
    geometry TEXT
)
CREATE TABLE cables_landing_points (
    cable_id TEXT NOT NULL,
    landing_point_id TEXT NOT NULL,
    PRIMARY KEY (cable_id, landing_point_id),
    FOREIGN KEY (cable_id) REFERENCES cables(id) ON DELETE CASCADE,
    FOREIGN KEY (landing_point_id) REFERENCES landing_points(id) ON DELETE CASCADE
) WITHOUT ROWID