neal-words/words.sql

CREATE TABLE words (
	word text not null,
	is_new boolean not null,
	rank integer not null,
	primary key (word)
);

CREATE TABLE combos (
	x text not null,
	y text not null,
	z text not null,
	primary key (x, y),
	foreign key (x) references words(word),
	foreign key (y) references words(word),
	foreign key (z) references words(word)
);

insert into words (word, rank, is_new)
values ('Earth', 1, 0), ('Wind', 1, 0), ('Fire', 1, 0), ('Water', 1, 0);