{"poker_player": {"columns": [[0, "Poker_Player_ID", "INT", 0, null, 1], [1, "People_ID", "INT", 0, null, 0], [2, "Final_Table_Made", "REAL", 0, null, 0], [3, "Best_Finish", "REAL", 0, null, 0], [4, "Money_Rank", "REAL", 0, null, 0], [5, "Earnings", "REAL", 0, null, 0]], "primary_keys": ["Poker_Player_ID"], "foreign_keys": [[0, 0, "people", "People_ID", "People_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Poker_Player_ID"]]], "check_constraints": []}, "people": {"columns": [[0, "People_ID", "INT", 0, null, 1], [1, "Nationality", "TEXT", 0, null, 0], [2, "Name", "TEXT", 0, null, 0], [3, "Birth_Date", "TEXT", 0, null, 0], [4, "Height", "REAL", 0, null, 0]], "primary_keys": ["People_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "People_ID"]]], "check_constraints": []}}
CREATE TABLE poker_player (
    Poker_Player_ID INT   PRIMARY KEY,
    People_ID INT,
    Final_Table_Made REAL,
    Best_Finish REAL,
    Money_Rank REAL,
    Earnings REAL,
    UNIQUE (Poker_Player_ID),
    FOREIGN KEY (People_ID) REFERENCES people(People_ID)
);

CREATE TABLE people (
    People_ID INT   PRIMARY KEY,
    Nationality TEXT,
    Name TEXT,
    Birth_Date TEXT,
    Height REAL,
    UNIQUE (People_ID)
);