db.wikidata-create-tables.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of wikibrain-core Show documentation

There is a newer version: 0.9.1

CREATE TABLE IF NOT EXISTS WIKIDATA_ENTITY_LABELS (
  ENTITY_TYPE char NOT NULL,
  ENTITY_ID int NOT NULL,
  LANG_ID smallint  NOT NULL,
  LABEL TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS WIKIDATA_ENTITY_DESCRIPTIONS (
  ENTITY_TYPE char NOT NULL,
  ENTITY_ID int NOT NULL,
  LANG_ID smallint  NOT NULL,
  DESCRIPTION TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS WIKIDATA_ENTITY_ALIASES (
  ENTITY_TYPE char NOT NULL,
  ENTITY_ID int NOT NULL,
  LANG_ID smallint  NOT NULL,
  ALIAS TEXT NOT NULL
);

CREATE TABLE IF NOT EXISTS WIKIDATA_STATEMENT (

  --   Unique identifier
  ID VARCHAR(255) NOT NULL,

  --  id of item associated with the property - a "Q" would typically prefix it on Wikipedia
  ENTITY_TYPE char NOT NULL,
  ENTITY_ID int NOT NULL,

  -- Property id (starts with a p)
  PROP_ID int NOT NULL,

  -- Property value
  VAL_TYPE VARCHAR(50) NOT NULL,
  VAL_STR VARCHAR(4096) NOT NULL,

  -- Property rank: 0 = deprecated, 1 = normal, 2 = preferred
  RANK SMALLINT NOT NULL
)