DROP TABLE IF EXISTS PRODUCT;

DROP TABLE IF EXISTS MANUFACTURER;

CREATE TABLE PRODUCT (

id VARCHAR(50) PRIMARY KEY,

title VARCHAR(250) NOT NULL,

description VARCHAR(250) NOT NULL,

rating VARCHAR(250) ,

category VARCHAR(250) ,

manufacturer_id VARCHAR(50)

);

CREATE TABLE MANUFACTURER (

id VARCHAR(50) PRIMARY KEY,

name VARCHAR(50) NOT NULL,

address VARCHAR(50) NOT NULL

);