DROP TABLE IF EXISTS Customers;
DROP TABLE IF EXISTS Employees;
DROP TABLE IF EXISTS Technician;
DROP TABLE IF EXISTS Services;

CREATE TABLE Customers
(

Customer_ID INT,
First_Name VARCHAR (25) NOT NULL,
Last_Name VARCHAR (25) NOT NULL,
Street_Address VARCHAR (50) NOT NULL,
City VARCHAR(25) NOT NULL,
State VARCHAR(2) NOT NULL,
Zip INT NOT NULL,
Phone_Number INT NOT NULL,

CONSTRAINT Customers_pk
  PRIMARY KEY(Customer_ID)

);
CREATE TABLE Employees
(

Employee_ID INT,
First_Name VARCHAR(25) NOT NULL,
Last_Name VARCHAR(25) NOT NULL,
Street_Address VARCHAR(50) NOT NULL,
City VARCHAR(25) NOT NULL,
State VARCHAR(2) NOT NULL,
Zip INT NOT NULL,
Wage DECIMAL(10,2) NOT NULL,

CONSTRAINT Employees_pk
  PRIMARY KEY  (Employee_ID),
CONSTRAINT Employees_fk_Customers
  FOREIGN KEY (Customer_ID) REFERENCES Customers (Customer_ID),
--  FOREIGN KEY (Service_ID_fk) REFERENCES Services (Service_ID)
);