{"singer": {"columns": [[0, "Singer_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Birth_Year", "REAL", 0, null, 0], [3, "Net_Worth_Millions", "REAL", 0, null, 0], [4, "Citizenship", "TEXT", 0, null, 0]], "primary_keys": ["Singer_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Singer_ID"]]], "check_constraints": []}, "song": {"columns": [[0, "Song_ID", "INT", 0, null, 1], [1, "Title", "TEXT", 0, null, 0], [2, "Singer_ID", "INT", 0, null, 0], [3, "Sales", "REAL", 0, null, 0], [4, "Highest_Position", "REAL", 0, null, 0]], "primary_keys": ["Song_ID"], "foreign_keys": [[0, 0, "singer", "Singer_ID", "Singer_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Song_ID"]]], "check_constraints": []}}
CREATE TABLE singer (
    Singer_ID INT   PRIMARY KEY,
    Name TEXT,
    Birth_Year REAL,
    Net_Worth_Millions REAL,
    Citizenship TEXT,
    UNIQUE (Singer_ID)
);

CREATE TABLE song (
    Song_ID INT   PRIMARY KEY,
    Title TEXT,
    Singer_ID INT,
    Sales REAL,
    Highest_Position REAL,
    UNIQUE (Song_ID),
    FOREIGN KEY (Singer_ID) REFERENCES singer(Singer_ID)
);