API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 11th, 2019
165
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.15 KB | None | 0 0
raw download clone embed print report
  1. mysql> desc import
  2. -> ;
  3. +-----------------------------------------------+------------+------+-----+---------+-------+
  4. | Field | Type | Null | Key | Default | Extra |
  5. +-----------------------------------------------+------------+------+-----+---------+-------+
  6. | import_uid | bigint(20) | YES | | NULL | |
  7. | (Attribute) Hospital ID | text | YES | | NULL | |
  8. | (Attribute) HCT ID | text | YES | | NULL | |
  9. | (Attribute) OVC Household ID | text | YES | | NULL | |
  10. | (Identifier) Old AMPATH Medical Record Number | text | YES | | NULL | |
  11. | (Attribute) Crisis Camp Location | text | YES | | NULL | |
  12. | (Identifier) MTRH SCC Number | text | YES | | NULL | |
  13. | org.openmrs.PersonAddress.subregion | text | YES | | NULL | |
  14. | (Identifier) HCT ID | text | YES | | NULL | |
  15. | org.openmrs.PersonAddress.townshipDivision | text | YES | | NULL | |
  16. | org.openmrs.Patient.birthdateEstimated | text | YES | | NULL | |
  17. | org.openmrs.PersonAddress.stateProvince | text | YES | | NULL | |
  18. | org.openmrs.PersonAddress.preferred | text | YES | | NULL | |
  19. | (Attribute) Partner Contact Phone Number | text | YES | | NULL | |
  20. | (Attribute) Next of Kin | text | YES | | NULL | |
  21. | (Attribute) Tribe | text | YES | | NULL | |
  22. | (Attribute) Birthplace | text | YES | | NULL | |
  23. | org.openmrs.PersonName.prefix | text | YES | | NULL | |
  24. | (Identifier) MTRH Casualty Number | text | YES | | NULL | |
  25. | (Attribute) Test or Fake Patient | text | YES | | NULL | |
  26. | org.openmrs.Patient.personId | text | YES | | NULL | |
  27. | org.openmrs.PersonName.familyNamePrefix | text | YES | | NULL | |
  28. | org.openmrs.PersonName.personNameId | text | YES | | NULL | |
  29. | org.openmrs.PersonAddress.latitude | text | YES | | NULL | |
  30. | org.openmrs.PersonAddress.longitude | text | YES | | NULL | |
  31. | org.openmrs.PersonAddress.address2 | text | YES | | NULL | |
  32. | org.openmrs.Patient.deathDate | text | YES | | NULL | |
  33. | org.openmrs.PersonAddress.address1 | text | YES | | NULL | |
  34. | org.openmrs.PersonAddress.country | text | YES | | NULL | |
  35. | (Attribute) Partner Age | text | YES | | NULL | |
  36. | (Identifier) MTRH ENT Number | text | YES | | NULL | |
  37. | (Attribute) Next of Kin Contact Phone Number | text | YES | | NULL | |
  38. | (Identifier) MTRH IP Number | text | YES | | NULL | |
  39. | (Attribute) Next of Kin Gender | text | YES | | NULL | |
  40. | (Attribute) Health Center | text | YES | | NULL | |
  41. | (Identifier) MTRH X-Ray Number | text | YES | | NULL | |
  42. | org.openmrs.PersonName.id | text | YES | | NULL | |
  43. | (Attribute) Ten Cell Leader | text | YES | | NULL | |
  44. | org.openmrs.PersonAddress.uuid | text | YES | | NULL | |
  45. | org.openmrs.Patient.gender | text | YES | | NULL | |
  46. | org.openmrs.PersonName.familyName2 | text | YES | | NULL | |
  47. | (Attribute) TB District Registration Number | text | YES | | NULL | |
  48. | (Identifier) MTCT Plus ID | text | YES | | NULL | |
  49. | (Attribute) Mother's Name | text | YES | | NULL | |
  50. | org.openmrs.PersonName.degree | text | YES | | NULL | |
  51. | org.openmrs.Patient.dead | text | YES | | NULL | |
  52. | (Attribute) Next of Kin Age | text | YES | | NULL | |
  53. | (Identifier) Invalid X Number (version 1.0) | text | YES | | NULL | |
  54. | (Identifier) MTRH CWC Number | text | YES | | NULL | |
  55. | (Identifier) MTRH Staff PF Number | text | YES | | NULL | |
  56. | org.openmrs.PersonName.uuid | text | YES | | NULL | |
  57. | org.openmrs.PersonName.givenName | text | YES | | NULL | |
  58. | (Identifier) AMRS Medical Record Number | text | YES | | NULL | |
  59. | org.openmrs.PersonAddress.postalCode | text | YES | | NULL | |
  60. | (Attribute) ANC NUMBER | text | YES | | NULL | |
  61. | (Identifier) MTRH Eye Clinic Number | text | YES | | NULL | |
  62. | (Attribute) District of Birth | text | YES | | NULL | |
  63. | (Identifier) X Number | text | YES | | NULL | |
  64. | (Attribute) Partner Gender | text | YES | | NULL | |
  65. | org.openmrs.PersonAddress.countyDistrict | text | YES | | NULL | |
  66. | (Identifier) AMRS Universal ID | text | YES | | NULL | |
  67. | (Attribute) HCT Household ID | text | YES | | NULL | |
  68. | org.openmrs.Patient.birthdate | text | YES | | NULL | |
  69. | org.openmrs.Patient.uuid | text | YES | | NULL | |
  70. | (Identifier) MTRH Memorial Number | text | YES | | NULL | |
  71. | (Attribute) pMTCT ID | text | YES | | NULL | |
  72. | (Identifier) ACTG Study ID | text | YES | | NULL | |
  73. | org.openmrs.Patient.patientId | text | YES | | NULL | |
  74. | org.openmrs.PersonName.middleName | text | YES | | NULL | |
  75. | (Identifier) MTRH Dental Number | text | YES | | NULL | |
  76. | org.openmrs.PersonAddress.cityVillage | text | YES | | NULL | |
  77. | (Attribute) Race | text | YES | | NULL | |
  78. | (Identifier) KENYAN NATIONAL ID NUMBER | text | YES | | NULL | |
  79. | org.openmrs.PersonAddress.id | text | YES | | NULL | |
  80. | org.openmrs.PersonName.familyName | text | YES | | NULL | |
  81. | (Attribute) Contact Phone Number | text | YES | | NULL | |
  82. | org.openmrs.PersonAddress.personAddressId | text | YES | | NULL | |
  83. | (Attribute) Citizenship | text | YES | | NULL | |
  84. | org.openmrs.PersonAddress.neighborhoodCell | text | YES | | NULL | |
  85. | (Identifier) MTRH OPD Number | text | YES | | NULL | |
  86. | (Attribute) Civil Status | text | YES | | NULL | |
  87. | (Identifier) MTRH ORTHO Number | text | YES | | NULL | |
  88. | org.openmrs.PersonName.familyNameSuffix | text | YES | | NULL | |
  89. | (Attribute) Partner Name | text | YES | | NULL | |
  90. | (Attribute) Point of HIV Testing | text | YES | | NULL | |
  91. | org.openmrs.PersonAddress.region | text | YES | | NULL | |
  92. | org.openmrs.PersonName.preferred | text | YES | | NULL | |
  93. | (Identifier) INVALID CHECK DIGIT | text | YES | | NULL | |
  94. | (Identifier) pMTCT ID | text | YES | | NULL | |
  95. | (Identifier) MTRH CARE Number | text | YES | | NULL | |
  96. | (Identifier) MTRH FP Number | text | YES | | NULL | |
  97. | (Identifier) MTRH ANC Number | text | YES | | NULL | |
  98. | (Identifier) MTRH Amenity Number | text | YES | | NULL | |
  99. | org.openmrs.Patient.id | text | YES | | NULL | |
  100. +-----------------------------------------------+------------+------+-----+---------+-------+
  101. 94 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!