create table Condition
(conditionID int,
name varchar(30),
primary key(conditionID));
insert into CONDITION (conditionID, name) values (1, 'Stable');
insert into CONDITION (conditionID, name) values (2, 'Recovory');
insert into CONDITION (conditionID, name) values (3, 'Critical');
insert into CONDITION (conditionID, name) values (4, 'Critical but Stable');
create table PatientCondition
(conditionID int,
clinicNum int,
primary key(conditionID, clinicNum),
foreign key (conditionID) references condition (conditionID),
foreign key (clinicNum) references patient(clinicNum));
insert into PATIENTCONDITION (conditionID, clinicNum) values (1, 100000001);
insert into PATIENTCONDITION (conditionID, clinicNum) values (2, 100000002);
insert into PATIENTCONDITION (conditionID, clinicNum) values (3, 100000003);
insert into PATIENTCONDITION (conditionID, clinicNum) values (4, 100000004);
This is the altered table creation statement used to insert this table into the mySQL database using RazorSQL
ReplyDeletecreate table mayoproject.PatientCondition
(conditionID int not null,
clinicNum int not null,
primary key(conditionID, clinicNum),
foreign key (conditionID) references mayoproject.condition(conditionID),
foreign key (clinicNum) references mayoproject.patient(clinicNum));