-- Create DB

USE master

CREATE DATABASE mydb_lmao_bottom_text

GO

-- Create tables

USE mydb_lmao_bottom_text

CREATE TABLE Suppliers (
							SupplierID		INT PRIMARY KEY,
							ContactName		VARCHAR(20),
							DeFactoAddress	VARCHAR(20),
							DeJuroAddress	VARCHAR(20),
							PhoneNumber		INT,
							Email			VARCHAR(20)
						)

CREATE TABLE Terms		(
							TermsID			INT PRIMARY KEY,
							Validity		DATETIME,
							Price			INT,
							SupplierID		INT REFERENCES Suppliers(SupplierID),
							EmployeeID		INT REFERENCES Employees(EmployeeID),
							Content			VARBINARY,
							OfferValue		INT
						)


CREATE TABLE Employees (
						EmployeeID			INT,
						Name				VARCHAR(20),
						Position			VARCHAR(20)
						)