Open-ILS/tests/datasets/sql/auth_mesh.sql

   1 \set xact_id '''IMPORT MESH AUTHORITIES'''
   2
   3 INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$<record  xmlns="http://www.loc.gov/MARC21/slim">
   4   <leader>00957nz  a2200301n  4500</leader>
   5   <controlfield tag="001">D000136</controlfield>
   6   <controlfield tag="003">DNLM</controlfield>
   7   <controlfield tag="005">20160202000000.0</controlfield>
   8   <controlfield tag="008">990101 n ancnnbabn          || ana      </controlfield>
   9   <datafield tag="040" ind1=" " ind2=" ">
  10     <subfield code="a">DNLM</subfield>
  11     <subfield code="c">DNLM</subfield>
  12   </datafield>
  13   <datafield tag="060" ind1=" " ind2="0">
  14     <subfield code="a">QU 105</subfield>
  15   </datafield>
  16   <datafield tag="072" ind1=" " ind2=" ">
  17     <subfield code="a">G2.</subfield>
  18     <subfield code="x">111.</subfield>
  19     <subfield code="x">29</subfield>
  20   </datafield>
  21   <datafield tag="072" ind1=" " ind2=" ">
  22     <subfield code="a">G2.</subfield>
  23     <subfield code="x">300.</subfield>
  24     <subfield code="x">176</subfield>
  25   </datafield>
  26   <datafield tag="072" ind1=" " ind2=" ">
  27     <subfield code="a">G3.</subfield>
  28     <subfield code="x">30</subfield>
  29   </datafield>
  30   <datafield tag="072" ind1=" " ind2=" ">
  31     <subfield code="a">G7.</subfield>
  32     <subfield code="x">700.</subfield>
  33     <subfield code="x">345.</subfield>
  34     <subfield code="x">110</subfield>
  35   </datafield>
  36   <datafield tag="072" ind1=" " ind2=" ">
  37     <subfield code="a">G9.</subfield>
  38     <subfield code="x">188.</subfield>
  39     <subfield code="x">50</subfield>
  40   </datafield>
  41   <datafield tag="150" ind1=" " ind2=" ">
  42     <subfield code="a">Acid-Base Equilibrium</subfield>
  43   </datafield>
  44   <datafield tag="450" ind1=" " ind2=" ">
  45     <subfield code="w">nnna</subfield>
  46     <subfield code="a">Acid-Base Balance</subfield>
  47   </datafield>
  48   <datafield tag="450" ind1=" " ind2=" ">
  49     <subfield code="a">Anion Gap</subfield>
  50   </datafield>
  51   <datafield tag="450" ind1=" " ind2=" ">
  52     <subfield code="w">nnna</subfield>
  53     <subfield code="a">Acid Base Balance</subfield>
  54   </datafield>
  55   <datafield tag="450" ind1=" " ind2=" ">
  56     <subfield code="w">nnna</subfield>
  57     <subfield code="a">Acid Base Equilibrium</subfield>
  58   </datafield>
  59   <datafield tag="450" ind1=" " ind2=" ">
  60     <subfield code="w">nnna</subfield>
  61     <subfield code="a">Anion Gaps</subfield>
  62   </datafield>
  63   <datafield tag="450" ind1=" " ind2=" ">
  64     <subfield code="w">nnna</subfield>
  65     <subfield code="a">Balance, Acid-Base</subfield>
  66   </datafield>
  67   <datafield tag="450" ind1=" " ind2=" ">
  68     <subfield code="w">nnna</subfield>
  69     <subfield code="a">Equilibrium, Acid-Base</subfield>
  70   </datafield>
  71   <datafield tag="450" ind1=" " ind2=" ">
  72     <subfield code="w">nnna</subfield>
  73     <subfield code="a">Gap, Anion</subfield>
  74   </datafield>
  75   <datafield tag="450" ind1=" " ind2=" ">
  76     <subfield code="w">nnna</subfield>
  77     <subfield code="a">Gaps, Anion</subfield>
  78   </datafield>
  79   <datafield tag="667" ind1=" " ind2=" ">
  80     <subfield code="a">consider also ACID-BASE IMBALANCE</subfield>
  81   </datafield>
  82   <datafield tag="680" ind1=" " ind2=" ">
  83     <subfield code="i">The balance between acids and bases in the BODY FLUIDS. The pH (HYDROGEN-ION CONCENTRATION) of the arterial BLOOD provides an index for the total body acid-base balance.</subfield>
  84   </datafield>
  85 </record>$$, :xact_id);
  86 INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$<record  xmlns="http://www.loc.gov/MARC21/slim">
  87   <leader>00231nz  a2200097n  4500</leader>
  88   <controlfield tag="001">D000136Q000187</controlfield>
  89   <controlfield tag="003">DNLM</controlfield>
  90   <controlfield tag="005">20160202000000.0</controlfield>
  91   <controlfield tag="008">990101 n ancnnbabn           n ana      </controlfield>
  92   <datafield tag="040" ind1=" " ind2=" ">
  93     <subfield code="a">DNLM</subfield>
  94     <subfield code="c">DNLM</subfield>
  95   </datafield>
  96   <datafield tag="150" ind1=" " ind2=" ">
  97     <subfield code="a">Acid-Base Equilibrium</subfield>
  98     <subfield code="x">drug effects</subfield>
  99   </datafield>
 100 </record>$$, :xact_id);
 101 INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$<record  xmlns="http://www.loc.gov/MARC21/slim">
 102   <leader>00227nz  a2200097n  4500</leader>
 103   <controlfield tag="001">D000136Q000235</controlfield>
 104   <controlfield tag="003">DNLM</controlfield>
 105   <controlfield tag="005">20160202000000.0</controlfield>
 106   <controlfield tag="008">990101 n ancnnbabn           n ana      </controlfield>
 107   <datafield tag="040" ind1=" " ind2=" ">
 108     <subfield code="a">DNLM</subfield>
 109     <subfield code="c">DNLM</subfield>
 110   </datafield>
 111   <datafield tag="150" ind1=" " ind2=" ">
 112     <subfield code="a">Acid-Base Equilibrium</subfield>
 113     <subfield code="x">genetics</subfield>
 114   </datafield>
 115 </record>$$, :xact_id);
 116 INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$<record  xmlns="http://www.loc.gov/MARC21/slim">
 117   <leader>00229nz  a2200097n  4500</leader>
 118   <controlfield tag="001">D000136Q000276</controlfield>
 119   <controlfield tag="003">DNLM</controlfield>
 120   <controlfield tag="005">20160202000000.0</controlfield>
 121   <controlfield tag="008">990101 n ancnnbabn           n ana      </controlfield>
 122   <datafield tag="040" ind1=" " ind2=" ">
 123     <subfield code="a">DNLM</subfield>
 124     <subfield code="c">DNLM</subfield>
 125   </datafield>
 126   <datafield tag="150" ind1=" " ind2=" ">
 127     <subfield code="a">Acid-Base Equilibrium</subfield>
 128     <subfield code="x">immunology</subfield>
 129   </datafield>
 130 </record>$$, :xact_id);
 131 INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$<record  xmlns="http://www.loc.gov/MARC21/slim">
 132   <leader>00229nz  a2200097n  4500</leader>
 133   <controlfield tag="001">D000136Q000502</controlfield>
 134   <controlfield tag="003">DNLM</controlfield>
 135   <controlfield tag="005">20160202000000.0</controlfield>
 136   <controlfield tag="008">990101 n ancnnbabn           n ana      </controlfield>
 137   <datafield tag="040" ind1=" " ind2=" ">
 138     <subfield code="a">DNLM</subfield>
 139     <subfield code="c">DNLM</subfield>
 140   </datafield>
 141   <datafield tag="150" ind1=" " ind2=" ">
 142     <subfield code="a">Acid-Base Equilibrium</subfield>
 143     <subfield code="x">physiology</subfield>
 144   </datafield>
 145 </record>$$, :xact_id);
 146 INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$<record  xmlns="http://www.loc.gov/MARC21/slim">
 147   <leader>00236nz  a2200097n  4500</leader>
 148   <controlfield tag="001">D000136Q000528</controlfield>
 149   <controlfield tag="003">DNLM</controlfield>
 150   <controlfield tag="005">20160202000000.0</controlfield>
 151   <controlfield tag="008">990101 n ancnnbabn           n ana      </controlfield>
 152   <datafield tag="040" ind1=" " ind2=" ">
 153     <subfield code="a">DNLM</subfield>
 154     <subfield code="c">DNLM</subfield>
 155   </datafield>
 156   <datafield tag="150" ind1=" " ind2=" ">
 157     <subfield code="a">Acid-Base Equilibrium</subfield>
 158     <subfield code="x">radiation effects</subfield>
 159   </datafield>
 160 </record>$$, :xact_id);
 161 INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$<record  xmlns="http://www.loc.gov/MARC21/slim">
 162   <leader>00720nz  a2200205n  4500</leader>
 163   <controlfield tag="001">D000138</controlfield>
 164   <controlfield tag="003">DNLM</controlfield>
 165   <controlfield tag="005">20160202000000.0</controlfield>
 166   <controlfield tag="008">990101 n ancnnbabn          || ana      </controlfield>
 167   <datafield tag="040" ind1=" " ind2=" ">
 168     <subfield code="a">DNLM</subfield>
 169     <subfield code="c">DNLM</subfield>
 170   </datafield>
 171   <datafield tag="072" ind1=" " ind2=" ">
 172     <subfield code="a">C18.</subfield>
 173     <subfield code="x">452.</subfield>
 174     <subfield code="x">76.</subfield>
 175     <subfield code="x">176</subfield>
 176   </datafield>
 177   <datafield tag="150" ind1=" " ind2=" ">
 178     <subfield code="a">Acidosis</subfield>
 179   </datafield>
 180   <datafield tag="450" ind1=" " ind2=" ">
 181     <subfield code="w">nnna</subfield>
 182     <subfield code="a">Metabolic Acidosis</subfield>
 183   </datafield>
 184   <datafield tag="450" ind1=" " ind2=" ">
 185     <subfield code="w">nnna</subfield>
 186     <subfield code="a">Acidoses</subfield>
 187   </datafield>
 188   <datafield tag="450" ind1=" " ind2=" ">
 189     <subfield code="w">nnna</subfield>
 190     <subfield code="a">Acidoses, Metabolic</subfield>
 191   </datafield>
 192   <datafield tag="450" ind1=" " ind2=" ">
 193     <subfield code="w">nnna</subfield>
 194     <subfield code="a">Acidosis, Metabolic</subfield>
 195   </datafield>
 196   <datafield tag="450" ind1=" " ind2=" ">
 197     <subfield code="w">nnna</subfield>
 198     <subfield code="a">Metabolic Acidoses</subfield>
 199   </datafield>
 200   <datafield tag="550" ind1=" " ind2=" ">
 201     <subfield code="a">Acid-Base Equilibrium</subfield>
 202   </datafield>
 203   <datafield tag="667" ind1=" " ind2=" ">
 204     <subfield code="a">general or unspecified; prefer specifics</subfield>
 205   </datafield>
 206   <datafield tag="680" ind1=" " ind2=" ">
 207     <subfield code="i">A pathologic condition of acid accumulation or depletion of base in the body. The two main types are RESPIRATORY ACIDOSIS and metabolic acidosis, due to metabolic acid build up.</subfield>
 208   </datafield>
 209 </record>$$, :xact_id);
 210 INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$<record  xmlns="http://www.loc.gov/MARC21/slim">
 211   <leader>00218nz  a2200097n  4500</leader>
 212   <controlfield tag="001">D000138Q000469</controlfield>
 213   <controlfield tag="003">DNLM</controlfield>
 214   <controlfield tag="005">20160202000000.0</controlfield>
 215   <controlfield tag="008">990101 n ancnnbabn           n ana      </controlfield>
 216   <datafield tag="040" ind1=" " ind2=" ">
 217     <subfield code="a">DNLM</subfield>
 218     <subfield code="c">DNLM</subfield>
 219   </datafield>
 220   <datafield tag="150" ind1=" " ind2=" ">
 221     <subfield code="a">Acidosis</subfield>
 222     <subfield code="x">parasitology</subfield>
 223   </datafield>
 224 </record>$$, :xact_id);
 225 INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$<record  xmlns="http://www.loc.gov/MARC21/slim">
 226   <leader>00216nz  a2200097n  4500</leader>
 227   <controlfield tag="001">D000138Q000276</controlfield>
 228   <controlfield tag="003">DNLM</controlfield>
 229   <controlfield tag="005">20160202000000.0</controlfield>
 230   <controlfield tag="008">990101 n ancnnbabn           n ana      </controlfield>
 231   <datafield tag="040" ind1=" " ind2=" ">
 232     <subfield code="a">DNLM</subfield>
 233     <subfield code="c">DNLM</subfield>
 234   </datafield>
 235   <datafield tag="150" ind1=" " ind2=" ">
 236     <subfield code="a">Acidosis</subfield>
 237     <subfield code="x">immunology</subfield>
 238   </datafield>
 239 </record>$$, :xact_id);
 240 INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$<record  xmlns="http://www.loc.gov/MARC21/slim">
 241   <leader>00218nz  a2200097n  4500</leader>
 242   <controlfield tag="001">D000138Q000382</controlfield>
 243   <controlfield tag="003">DNLM</controlfield>
 244   <controlfield tag="005">20160202000000.0</controlfield>
 245   <controlfield tag="008">990101 n ancnnbabn           n ana      </controlfield>
 246   <datafield tag="040" ind1=" " ind2=" ">
 247     <subfield code="a">DNLM</subfield>
 248     <subfield code="c">DNLM</subfield>
 249   </datafield>
 250   <datafield tag="150" ind1=" " ind2=" ">
 251     <subfield code="a">Acidosis</subfield>
 252     <subfield code="x">microbiology</subfield>
 253   </datafield>
 254 </record>$$, :xact_id);
 255 INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$<record  xmlns="http://www.loc.gov/MARC21/slim">
 256   <leader>00215nz  a2200097n  4500</leader>
 257   <controlfield tag="001">D000138Q000175</controlfield>
 258   <controlfield tag="003">DNLM</controlfield>
 259   <controlfield tag="005">20160202000000.0</controlfield>
 260   <controlfield tag="008">990101 n ancnnbabn           n ana      </controlfield>
 261   <datafield tag="040" ind1=" " ind2=" ">
 262     <subfield code="a">DNLM</subfield>
 263     <subfield code="c">DNLM</subfield>
 264   </datafield>
 265   <datafield tag="150" ind1=" " ind2=" ">
 266     <subfield code="a">Acidosis</subfield>
 267     <subfield code="x">diagnosis</subfield>
 268   </datafield>
 269 </record>$$, :xact_id);
 270 INSERT INTO authority.record_entry(marc, last_xact_id) VALUES ($$<record  xmlns="http://www.loc.gov/MARC21/slim">
 271   <leader>00221nz  a2200097n  4500</leader>
 272   <controlfield tag="001">D000138Q000503</controlfield>
 273   <controlfield tag="003">DNLM</controlfield>
 274   <controlfield tag="005">20160202000000.0</controlfield>
 275   <controlfield tag="008">990101 n ancnnbabn           n ana      </controlfield>
 276   <datafield tag="040" ind1=" " ind2=" ">
 277     <subfield code="a">DNLM</subfield>
 278     <subfield code="c">DNLM</subfield>
 279   </datafield>
 280   <datafield tag="150" ind1=" " ind2=" ">
 281     <subfield code="a">Acidosis</subfield>
 282     <subfield code="x">physiopathology</subfield>
 283   </datafield>
 284 </record>$$, :xact_id);