Everyone on our team will post a couple of tables. Here are the two ICD9 tables:


CREATE TABLE mayoproject.ICD9ProcedureCode
(
ICD9ProcedureCodeID INT(9),
ICD9ProcedureCode VARCHAR(15),
clinicNum INT(9),
PRIMARY KEY(ICD9ProcedureCodeID)

);


ALTER TABLE mayoproject.ICD9ProcedureCode
ADD FOREIGN KEY (clinicNum)
REFERENCES mayoproject.patient(clinicNum);


CREATE TABLE mayoproject.ICD9Diagnostic
(
ICD9DiagnoticID INT(9),
ICD9Diagnostic VARCHAR(15),
clinicNum INT(9),
PRIMARY KEY(ICD9DiagnoticID)
);


ALTER TABLE mayoproject.ICD9Diagnostic
ADD FOREIGN KEY (clinicNum)
REFERENCES mayoproject.patient(clinicNum);


INSERT INTO mayoproject.ICD9ProcedureCode (ICD9ProcedureCodeID, ICD9ProcedureCode, clinicNum) VALUES (1, '01.02', 100000001);

INSERT INTO mayoproject.ICD9ProcedureCode (ICD9ProcedureCodeID, ICD9ProcedureCode, clinicNum) VALUES (2, '01.41', 100000002);

INSERT INTO mayoproject.ICD9ProcedureCode (ICD9ProcedureCodeID, ICD9ProcedureCode, clinicNum) VALUES (3, '01.52', 100000002);

INSERT INTO mayoproject.ICD9ProcedureCode (ICD9ProcedureCodeID, ICD9ProcedureCode, clinicNum) VALUES (4, '39.64', 100000004);

INSERT INTO mayoproject.ICD9ProcedureCode (ICD9ProcedureCodeID, ICD9ProcedureCode, clinicNum) VALUES (5, '92.32', 100000003);

INSERT INTO mayoproject.ICD9ProcedureCode (ICD9ProcedureCodeID, ICD9ProcedureCode, clinicNum) VALUES (6, '84.3', 100000005);


INSERT INTO mayoproject.ICD9Diagnostic (ICD9DiagnoticID, ICD9Diagnostic, clinicNum) VALUES (1, '001-139', 100000001);

INSERT INTO mayoproject.ICD9Diagnostic (ICD9DiagnoticID, ICD9Diagnostic, clinicNum) VALUES (2, '771.2', 100000002);

INSERT INTO mayoproject.ICD9Diagnostic (ICD9DiagnoticID, ICD9Diagnostic, clinicNum) VALUES (3, '079.53', 100000002);

INSERT INTO mayoproject.ICD9Diagnostic (ICD9DiagnoticID, ICD9Diagnostic, clinicNum) VALUES (4, '090-099', 100000004);

INSERT INTO mayoproject.ICD9Diagnostic (ICD9DiagnoticID, ICD9Diagnostic, clinicNum) VALUES (5, '062.5', 100000003);

INSERT INTO mayoproject.ICD9Diagnostic (ICD9DiagnoticID, ICD9Diagnostic, clinicNum) VALUES (6, '066.1', 100000005);