Advertisement
ShihabZzz

Untitled

Dec 3rd, 2023
711
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 0.67 KB | None | 0 0
  1. CREATE TABLE customers (
  2.   customer_id INT NOT NULL AUTO_INCREMENT,
  3.   first_name VARCHAR(255) NOT NULL,
  4.   last_name VARCHAR(255) NOT NULL,
  5.   phone_number VARCHAR(255) NOT NULL,
  6.   street_address VARCHAR(255) NOT NULL,
  7.   customer_star_rating DECIMAL(10,2),
  8.   PRIMARY KEY (customer_id)
  9. );
  10.  
  11. CREATE TABLE suppliers (
  12.   supplier_id INT NOT NULL AUTO_INCREMENT,
  13.   supplier_company_name VARCHAR(255) NOT NULL,
  14.   supplier_star_rating DECIMAL(10,2),
  15.   phone_number VARCHAR(255) NOT NULL,
  16.   street_address VARCHAR(255) NOT NULL,
  17.   PRIMARY KEY (supplier_id)
  18. );
  19.  
  20. CREATE TABLE products (
  21.   product_id INT NOT NULL AUTO_INCREMENT,
  22.   product_name VARCHAR(255) NOT NULL,
  23.   price
  24. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement