CREATE TABLE sample(
name VARCHAR(50) NOT NULL PRIMARY KEY,
donorID VARCHAR(50),
FOREIGN KEY (donorID) REFERENCES donor (id)
)

CREATE TABLE donor(
id VARCHAR(50) NOT NULL PRIMARY KEY,
gender VARCHAR(50),
species VARCHAR(50)
);

CREATE TABLE animal_donor(
id VARCHAR(50) NOT NULL PRIMARY KEY,
strain VARCHAR(50),
species VARCHAR(50),
FOREIGN KEY (id) REFERENCES donor (id)
);

CREATE TABLE human_donor(
id VARCHAR(50) NOT NULL PRIMARY KEY,
dob VARCHAR(50),
gender VARCHAR(50),
FOREIGN KEY (id) REFERENCES donor (id)
);

CREATE TABLE lab_test(
testID VARCHAR(50) NOT NULL PRIMARY KEY,
donor VARCHAR(50),
FOREIGN KEY (donor) REFERENCES donor (id)
);

CREATE TABLE diagnoses(
diagID VARCHAR(50) NOT NULL PRIMARY KEY,
donor VARCHAR (50),
FOREIGN KEY (donor) REFERENCES human_donor (id)
);

CREATE TABLE medications(
medicID VARCHAR(50) NOT NULL PRIMARY KEY,
donor VARCHAR (50),
FOREIGN KEY (donor) REFERENCES human_donor (id)
);

CREATE TABLE family_history(
histID VARCHAR(50) NOT NULL PRIMARY KEY,
donor VARCHAR (50),
FOREIGN KEY (donor) REFERENCES human_donor (id)
);

CREATE TABLE life_style_factors(
factID VARCHAR(50) NOT NULL PRIMARY KEY,
donor VARCHAR (50),
FOREIGN KEY (donor) REFERENCES human_donor (id)
);
