CREATE TABLE customers (
  customer_id INT NOT NULL AUTO_INCREMENT,
  first_name VARCHAR(255) NOT NULL,
  last_name VARCHAR(255) NOT NULL,
  phone_number VARCHAR(255) NOT NULL,
  street_address VARCHAR(255) NOT NULL,
  customer_star_rating DECIMAL(10,2),
  PRIMARY KEY (customer_id)
);

CREATE TABLE suppliers (
  supplier_id INT NOT NULL AUTO_INCREMENT,
  supplier_company_name VARCHAR(255) NOT NULL,
  supplier_star_rating DECIMAL(10,2),
  phone_number VARCHAR(255) NOT NULL,
  street_address VARCHAR(255) NOT NULL,
  PRIMARY KEY (supplier_id)
);

CREATE TABLE products (
  product_id INT NOT NULL AUTO_INCREMENT,
  product_name VARCHAR(255) NOT NULL,
  price
);