CUI_PT Table

• I. Db Table

  CuiPt
  Name	Type	Properties	Notes
  cui	VARCHAR(8)	Index, NOT NULL	Concept Unique Identifier
  pt	VARCHAR(3100)	NOT NULL	Preferred Term

• II. SQL Examples
  • Find preferred term for CUI, "Cxxxxxxx"
    1. SELECT pt FROM CuiPt WHERE EUI= 'Cxxxxxxx';

• III. Data

  File: ${STMT_DIR}/data/tables/cuiPreferredTerm.data
  Used in smt -pt

  Meta Version	Rows
  Meta-2024AB	3,426,422
  Meta-2024AA	3,382,902
  Meta-2023AB	3,361,181
  Meta-2023AA	3,312,953
  Meta-2022AB	4,661,936
  Meta-2022AA	4,553,415
  Meta-2021AB	4,536,277
  Meta-2021AA	4,440,677
  Meta-2020AB	4,412,440
  Meta-2020AA	4,280,540
  Meta-2019AB	4,258,236
  Meta-2019AA	3,847,999
  Meta-2018AB	3,822,264
  Meta-2018AA	3,665,368
  Meta-2017AB	3,639,655
  Meta-2017AA	3,465,007
  Meta-2016AB	3,436,328
  Meta-2016AA	3,250,160
  Meta-2015AB	3,221,156
  Meta-2015AA	3,114,753
  Meta-2014AB	3,091,269
  Meta-2014AA	2,972,950
  Meta-2013AB	2,880,384
  Meta-2013AA	2,918,436
  Meta-2012AB	2,885,877
  Meta-2012AA	2,669,278
  Meta-2011AB	2,611,468
  Meta-2011AA	2,404,431