billingCodes Table

CREATE TABLE BillingCodes
(billingCodeID INT NOT NULL,
visitCharge DOUBLE,
CPTCode INT,
integerIncrement INT,
visitID INT(4),
FOREIGN KEY (visitID) REFERENCES Visit(visitID))

ALTER TABLE BillingCodes
ADD PRIMARY KEY(billingCodeID)
//note: I forgot to add the primary key so I had to do this 'ALTER' query to get it done.



INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000111, 120.32, 1000, 1, 1);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000112, 98.58, 1001, 3, 2);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000113, 508.13, 1002, 1, 3);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000114, 988.46, 1003, 2, 4);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000115, 319.01, 1004, 5, 5);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000116, 274.99, 1005, 1, 6);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000117, 1014.11, 1006, 2, 7);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000118, 63.63, 1007, 10, 8);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000119, 666.74, 1008, 12, 9);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000120, 780.00, 1009, 6, 10);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000121, 381, 1010, 5, 11);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000122, 890.54, 1011, 4, 12);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000123, 200.00, 1012, 7, 13);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000124, 150.59, 1013, 8, 14);

INSERT INTO BillingCodes (billingCodeID, visitCharge, CPTCode, integerIncrement, visitID)
VALUES(10000125, 563.49, 1014, 8, 15);