AssistiveDevice and PatientAssistiveDevice Tables

CREATE TABLE mayoproject. AssistiveDevice( AssistiveDeviceID INT (9), Name VARCHAR (15), PRIMARY KEY (assistiveDeviceID) );

CREATE TABLE mayoproject. PatientAssistiveDevice( AssistiveDeviceID INT (9), ClinicNum INT (9),
FOREIGN KEY (clinicNum) REFERENCES mayoproject.patient (clinicNum);

FOREIGN KEY (assistiveDeviceID) REFERENCES mayoproject.AssistiveDevice (assistiveDeviceID); );


INSERT INTO mayoproject.AssistiveDevice (assistiveDeviceID, Name) VALUES (1, ‘walker’);

INSERT INTO mayoproject.AssistiveDevice (assistiveDeviceID, Name) VALUES (2, ‘quad cane’);

INSERT INTO mayoproject.AssistiveDevice (assistiveDeviceID, Name) VALUES (3, ‘crutches’);

INSERT INTO mayoproject.AssistiveDevice (assistiveDeviceID, Name) VALUES (4, ‘canes’);

INSERT INTO mayoproject.AssistiveDevice (assistiveDeviceID, Name) VALUES (6, ‘walker’);

INSERT INTO mayoproject.AssistiveDevice (assistiveDeviceID, Name) VALUES (7, ‘quad cane’);

INSERT INTO mayoproject.PatientAssistiveDevice (assistiveDeviceID, clinicNum) VALUES (1, 100000001);

INSERT INTO mayoproject.PatientAssistiveDevice (assistiveDeviceID, clinicNum) VALUES (2, 100000002);

INSERT INTO mayoproject.PatientAssistiveDevice (assistiveDeviceID, clinicNum) VALUES (3, 100000004);

INSERT INTO mayoproject.PatientAssistiveDevice (assistiveDeviceID, clinicNum) VALUES (4, 100000003);

INSERT INTO mayoproject.PatientAssistiveDevice (assistiveDeviceID, clinicNum) VALUES (5, 100000006);