{"Manufacturers": {"columns": [[0, "Code", "INTEGER", 0, null, 1], [1, "Name", "VARCHAR(255)", 1, null, 0], [2, "Headquarter", "VARCHAR(255)", 1, null, 0], [3, "Founder", "VARCHAR(255)", 1, null, 0], [4, "Revenue", "REAL", 0, null, 0]], "primary_keys": ["Code"], "foreign_keys": [], "unique_constraints": [], "check_constraints": []}, "Products": {"columns": [[0, "Code", "INTEGER", 0, null, 1], [1, "Name", "VARCHAR(255)", 1, null, 0], [2, "Price", "DECIMAL", 1, null, 0], [3, "Manufacturer", "INTEGER", 1, null, 0]], "primary_keys": ["Code"], "foreign_keys": [[0, 0, "Manufacturers", "Manufacturer", "Code", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [], "check_constraints": []}}
CREATE TABLE Manufacturers (
    Code INTEGER   PRIMARY KEY,
    Name VARCHAR(255) NOT NULL,
    Headquarter VARCHAR(255) NOT NULL,
    Founder VARCHAR(255) NOT NULL,
    Revenue REAL
);

CREATE TABLE Products (
    Code INTEGER   PRIMARY KEY,
    Name VARCHAR(255) NOT NULL,
    Price DECIMAL NOT NULL,
    Manufacturer INTEGER NOT NULL,
    FOREIGN KEY (Manufacturer) REFERENCES Manufacturers(Code)
);