MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table methodology(
method_id int primary key,
date_added date,
description varchar(1000) character set utf8);

create index idx_methodology_date_added on methodology(date_added);
create table text_item(
t_id int primary key,
date_written date,
original_language varchar(2),
description varchar(1000) character set utf8,
foreign key(date_written) references methodology(date_added));