Create Tables Query - SE Bootcamp

--CREATE SCHEMA AllYouNeed;

--CREATE TABLE Customers(
--	CustomerID INT IDENTITY(1,1),
--	Name VARCHAR(50) NOT NULL,
--	Email VARCHAR(50) NOT NULL,
--	CONSTRAINT PK_Customer PRIMARY KEY (CustomerID)
--	);

--CREATE TABLE Products(
--	ProductID INT IDENTITY(1,1),
--	Name VARCHAR(50) NOT NULL,
--	Price DECIMAL(18,2) NOT NULL,
--	CONSTRAINT PK_Product PRIMARY KEY (ProductID)
--	);

CREATE TABLE Orders
(	
	OrderID INT IDENTITY(1,1),
	ProductID INT NOT NULL,
	CustomerID INT NOT NULL,
	Status BIT NOT NULL,
	CONSTRAINT PK_Orders PRIMARY KEY (OrderID),
	CONSTRAINT FK_Orders_Products FOREIGN KEY (ProductID) REFERENCES Products(ProductID),
	CONSTRAINT FK_Orders_Customers FOREIGN KEY (CustomerID) REFERENCES  Customers(CustomerID)
);

//Insert Data

INSERT INTO Customers(Name, Email)
VALUES
	('Santosh Guruju','santosh.guruju@macrokiosk.com'),
	('Cris Carry','santosh.guruju@icloud.com');


--SELECT * 
--FROM dbo.Customers;

--INSERT INTO Products(Name, Price)
--VALUES
--	('6 Inch TV Cabinet',300.00),
--	('L shape sofa', 3956.55);

SELECT * FROM Products;

INSERT INTO Orders(CustomerID, ProductID, Status)
VALUES
	(1,1,1);
	
--SELECT * FROM Orders;

--DROP TABLE dbo.Orders;