{
  "dBType" : "MYSQL5",
  "name" : "MySQL5",
  "getPSDEDataQueryCodeExps" : [ {
    "expression" : "t1.`BOOKCHILD1S`",
    "name" : "BOOKCHILD1S"
  }, {
    "expression" : "t1.`BOOKCHILD2S`",
    "name" : "BOOKCHILD2S"
  }, {
    "expression" : "t1.`BOOKCHILD3S`",
    "name" : "BOOKCHILD3S"
  }, {
    "expression" : "t1.`BOOKCHILD4S`",
    "name" : "BOOKCHILD4S"
  }, {
    "expression" : "t1.`BOOKCHILD5S`",
    "name" : "BOOKCHILD5S"
  }, {
    "expression" : "t1.`FIELD18`",
    "name" : "FIELD18"
  }, {
    "expression" : "t1.`FIELD24`",
    "name" : "FIELD24"
  }, {
    "expression" : "t1.`FIELD9`",
    "name" : "FIELD9"
  }, {
    "expression" : "t1.`BOOKID`",
    "name" : "BOOKID"
  }, {
    "expression" : "t1.`BOOKNAME`",
    "name" : "BOOKNAME"
  }, {
    "expression" : "t1.`CREATEDATE`",
    "name" : "CREATEDATE"
  }, {
    "expression" : "t1.`CREATEMAN`",
    "name" : "CREATEMAN"
  }, {
    "expression" : "t1.`DATE`",
    "name" : "DATE"
  }, {
    "expression" : "t1.`DEPTID`",
    "name" : "DEPTID"
  }, {
    "expression" : "t1.`END`",
    "name" : "END"
  }, {
    "expression" : "t1.`FIELD`",
    "name" : "FIELD"
  }, {
    "expression" : "t1.`FIELD10`",
    "name" : "FIELD10"
  }, {
    "expression" : "t1.`FIELD11`",
    "name" : "FIELD11"
  }, {
    "expression" : "t1.`FIELD12`",
    "name" : "FIELD12"
  }, {
    "expression" : "t1.`FIELD13`",
    "name" : "FIELD13"
  }, {
    "expression" : "t1.`FIELD14`",
    "name" : "FIELD14"
  }, {
    "expression" : "t1.`FIELD15`",
    "name" : "FIELD15"
  }, {
    "expression" : "t1.`FIELD16`",
    "name" : "FIELD16"
  }, {
    "expression" : "t1.`FIELD17`",
    "name" : "FIELD17"
  }, {
    "expression" : "t1.`FIELD19`",
    "name" : "FIELD19"
  }, {
    "expression" : "t1.`FIELD2`",
    "name" : "FIELD2"
  }, {
    "expression" : "t1.`FIELD20`",
    "name" : "FIELD20"
  }, {
    "expression" : "t1.`FIELD21`",
    "name" : "FIELD21"
  }, {
    "expression" : "t1.`FIELD22`",
    "name" : "FIELD22"
  }, {
    "expression" : "t1.`FIELD23`",
    "name" : "FIELD23"
  }, {
    "expression" : "t1.`FIELD25`",
    "name" : "FIELD25"
  }, {
    "expression" : "t1.`FIELD26`",
    "name" : "FIELD26"
  }, {
    "expression" : "t1.`FIELD27`",
    "name" : "FIELD27"
  }, {
    "expression" : "t1.`FIELD28`",
    "name" : "FIELD28"
  }, {
    "expression" : "t1.`FIELD29`",
    "name" : "FIELD29"
  }, {
    "expression" : "t1.`FIELD3`",
    "name" : "FIELD3"
  }, {
    "expression" : "t1.`FIELD30`",
    "name" : "FIELD30"
  }, {
    "expression" : "t1.`FIELD31`",
    "name" : "FIELD31"
  }, {
    "expression" : "t1.`FIELD32`",
    "name" : "FIELD32"
  }, {
    "expression" : "t1.`FIELD33`",
    "name" : "FIELD33"
  }, {
    "expression" : "t1.`FIELD34`",
    "name" : "FIELD34"
  }, {
    "expression" : "t1.`FIELD35`",
    "name" : "FIELD35"
  }, {
    "expression" : "t1.`FIELD36`",
    "name" : "FIELD36"
  }, {
    "expression" : "t1.`FIELD37`",
    "name" : "FIELD37"
  }, {
    "expression" : "t1.`FIELD38`",
    "name" : "FIELD38"
  }, {
    "expression" : "t1.`FIELD39`",
    "name" : "FIELD39"
  }, {
    "expression" : "t1.`FIELD4`",
    "name" : "FIELD4"
  }, {
    "expression" : "t1.`FIELD40`",
    "name" : "FIELD40"
  }, {
    "expression" : "t1.`FIELD41`",
    "name" : "FIELD41"
  }, {
    "expression" : "t1.`FIELD42`",
    "name" : "FIELD42"
  }, {
    "expression" : "t1.`FIELD43`",
    "name" : "FIELD43"
  }, {
    "expression" : "t1.`FIELD44`",
    "name" : "FIELD44"
  }, {
    "expression" : "t1.`FIELD45`",
    "name" : "FIELD45"
  }, {
    "expression" : "t1.`FIELD5`",
    "name" : "FIELD5"
  }, {
    "expression" : "t1.`FIELD6`",
    "name" : "FIELD6"
  }, {
    "expression" : "t1.`FIELD7`",
    "name" : "FIELD7"
  }, {
    "expression" : "t1.`FIELD8`",
    "name" : "FIELD8"
  }, {
    "expression" : "t1.`ORGID`",
    "name" : "ORGID"
  }, {
    "expression" : "t1.`PBOOKID`",
    "name" : "PBOOKID"
  }, {
    "expression" : "t1.`PHONEID`",
    "name" : "PHONEID"
  }, {
    "expression" : "t1.`TYPE`",
    "name" : "TYPE"
  }, {
    "expression" : "t1.`UPDATEDATE`",
    "name" : "UPDATEDATE"
  }, {
    "expression" : "t1.`UPDATEMAN`",
    "name" : "UPDATEMAN"
  } ],
  "queryCode" : "SELECT\nt1.`BOOKID`,\nt1.`BOOKNAME`,\nt1.`CREATEDATE`,\nt1.`CREATEMAN`,\nt1.`DATE`,\nt1.`DEPTID`,\nt1.`END`,\nt1.`FIELD`,\nt1.`FIELD10`,\nt1.`FIELD11`,\nt1.`FIELD12`,\nt1.`FIELD13`,\nt1.`FIELD14`,\nt1.`FIELD15`,\nt1.`FIELD16`,\nt1.`FIELD17`,\nt1.`FIELD19`,\nt1.`FIELD2`,\nt1.`FIELD20`,\nt1.`FIELD21`,\nt1.`FIELD22`,\nt1.`FIELD23`,\nt1.`FIELD25`,\nt1.`FIELD26`,\nt1.`FIELD27`,\nt1.`FIELD28`,\nt1.`FIELD29`,\nt1.`FIELD3`,\nt1.`FIELD30`,\nt1.`FIELD31`,\nt1.`FIELD32`,\nt1.`FIELD33`,\nt1.`FIELD34`,\nt1.`FIELD35`,\nt1.`FIELD36`,\nt1.`FIELD37`,\nt1.`FIELD38`,\nt1.`FIELD39`,\nt1.`FIELD4`,\nt1.`FIELD40`,\nt1.`FIELD41`,\nt1.`FIELD42`,\nt1.`FIELD43`,\nt1.`FIELD44`,\nt1.`FIELD45`,\nt1.`FIELD5`,\nt1.`FIELD6`,\nt1.`FIELD7`,\nt1.`FIELD8`,\nt1.`ORGID`,\nt1.`PBOOKID`,\nt1.`PHONEID`,\nt1.`TYPE`,\nt1.`UPDATEDATE`,\nt1.`UPDATEMAN`\nFROM `T_BOOK` t1 \n",
  "id" : "PSMODULES/common/PSDATAENTITIES/Book/PSDEDATAQUERIES/Default/PSDEDQCODES/MYSQL5.json"
}