CREATE TABLE units_language ( unit varchar (20) NOT NULL, language_id integer NOT NULL, localized varchar (20), localized_plural varchar (20), FOREIGN KEY (unit) REFERENCES units (name), FOREIGN KEY (language_id) REFERENCES language (id) ); CREATE INDEX units_name_idx ON units (name); CREATE INDEX units_language_unit_idx ON units_language (unit);