[Wikidata-bugs] [Maniphest] [Commented On] T187775: Investigation: Constraints for a database schema to store representations of a Lexeme

[thiemowmde]

thiemowmde added a comment.

@WMDE-leszek, something like this would be my draft:

CREATE TABLE IF NOT EXISTS wbl_lexemes (
  lex_lexeme_id VARBINARY(20) NOT NULL PRIMARY KEY,
  lex_lexical_category_id VARBINARY(20) NOT NULL,
  lex_language_item_id VARBINARY(20) NOT NULL
);

CREATE TABLE IF NOT EXISTS wbl_lemmata (
  lem_lexeme_id VARBINARY(20) NOT NULL,
  lem_language_code VARBINARY(32) NOT NULL,
  lem_lemma VARCHAR(768) BINARY NOT NULL
);
CREATE UNIQUE INDEX wbl_lem_lexeme_id_language_code ON wbl_lemmata (lem_lexeme_id, lem_language_code);

TASK DETAIL

https://phabricator.wikimedia.org/T187775

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: thiemowmde
Cc: daniel, Lucas_Werkmeister_WMDE, Ladsgroup, WMDE-leszek, thiemowmde, Aklapper, Lydia_Pintscher, Lahi, Gq86, Cinemantique, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, aude, Darkdadaah, Mbch331

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs