{"manufacturer": {"columns": [[0, "Manufacturer_ID", "INT", 0, null, 1], [1, "Open_Year", "REAL", 0, null, 0], [2, "Name", "TEXT", 0, null, 0], [3, "Num_of_Factories", "INT", 0, null, 0], [4, "Num_of_Shops", "INT", 0, null, 0]], "primary_keys": ["Manufacturer_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Manufacturer_ID"]]], "check_constraints": []}, "furniture": {"columns": [[0, "Furniture_ID", "INT", 0, null, 1], [1, "Name", "TEXT", 0, null, 0], [2, "Num_of_Component", "INT", 0, null, 0], [3, "Market_Rate", "REAL", 0, null, 0]], "primary_keys": ["Furniture_ID"], "foreign_keys": [], "unique_constraints": [[[0, 0, "Furniture_ID"]]], "check_constraints": []}, "furniture_manufacte": {"columns": [[0, "Manufacturer_ID", "INT", 0, null, 1], [1, "Furniture_ID", "INT", 0, null, 2], [2, "Price_in_Dollar", "REAL", 0, null, 0]], "primary_keys": ["Manufacturer_ID", "Furniture_ID"], "foreign_keys": [[0, 0, "furniture", "Furniture_ID", "Furniture_ID", "NO ACTION", "NO ACTION", "NONE"], [1, 0, "manufacturer", "Manufacturer_ID", "Manufacturer_ID", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [[[0, 0, "Manufacturer_ID"], [1, 1, "Furniture_ID"]]], "check_constraints": []}}
CREATE TABLE manufacturer (
    Manufacturer_ID INT   PRIMARY KEY,
    Open_Year REAL,
    Name TEXT,
    Num_of_Factories INT,
    Num_of_Shops INT,
    UNIQUE (Manufacturer_ID)
);

CREATE TABLE furniture (
    Furniture_ID INT   PRIMARY KEY,
    Name TEXT,
    Num_of_Component INT,
    Market_Rate REAL,
    UNIQUE (Furniture_ID)
);

CREATE TABLE furniture_manufacte (
    Manufacturer_ID INT   PRIMARY KEY,
    Furniture_ID INT   PRIMARY KEY,
    Price_in_Dollar REAL,
    PRIMARY KEY (Manufacturer_ID, Furniture_ID),
    UNIQUE (Manufacturer_ID, Furniture_ID),
    FOREIGN KEY (Furniture_ID) REFERENCES furniture(Furniture_ID),
    FOREIGN KEY (Manufacturer_ID) REFERENCES manufacturer(Manufacturer_ID)
);