troyhunt

Health Now Networks Schema

Apr 7th, 2017
668
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 26. `LeadID` int(11) NOT NULL,
  2. 27. `FirstName` varchar(255) NOT NULL,
  3. 28. `LastName` varchar(255) NOT NULL,
  4. 29. `MiddleName` varchar(255) NOT NULL,
  5. 30. `Address1` varchar(255) NOT NULL,
  6. 31. `Address2` varchar(255) NOT NULL,
  7. 32. `City` varchar(255) NOT NULL,
  8. 33. `State` varchar(255) NOT NULL,
  9. 34. `Zip` int(11) NOT NULL,
  10. 35. `DialedPhoneNumber` int(11) NOT NULL,
  11. 36. `DirectPhoneNumber` varchar(255) NOT NULL,
  12. 37. `Email` varchar(255) NOT NULL,
  13. 38. `Gender` varchar(255) NOT NULL,
  14. 39. `DOB` datetime NOT NULL,
  15. 40. `Age` int(11) NOT NULL,
  16. 41. `PrimaryInsurance` varchar(255) NOT NULL,
  17. 42. `PIPolicyNumber` varchar(255) NOT NULL,
  18. 43. `PICopay` varchar(255) NOT NULL,
  19. 44. `PIPhoneNumber` varchar(255) NOT NULL,
  20. 45. `SecondInsurance` varchar(255) NOT NULL,
  21. 46. `PhysicianNPI` int(11) NOT NULL,
  22. 47. `PhysicianFirstName` varchar(255) NOT NULL,
  23. 48. `PhysicianLastName` varchar(255) NOT NULL,
  24. 49. `PhysicianAddress1` varchar(255) NOT NULL,
  25. 50. `PhysicianAddress2` varchar(255) NOT NULL,
  26. 51. `PhysicianCity` varchar(255) NOT NULL,
  27. 52. `PhysicianState` varchar(255) NOT NULL,
  28. 53. `PhysicianZip` int(11) NOT NULL,
  29. 54. `PhysicianPhone` varchar(255) NOT NULL,
  30. 55. `PhysicianFax` varchar(255) NOT NULL,
  31. 56. `ChallangeQuestion` varchar(255) NOT NULL,
  32. 57. `ChallangeAnswer` varchar(255) NOT NULL,
  33. 58. `AtHomeTesting` varchar(255) NOT NULL,
  34. 59. `EstTestPerDay` int(11) NOT NULL,
  35. 60. `OnInsulin` varchar(255) NOT NULL,
  36. 61. `CurrentMeterName` varchar(255) NOT NULL,
  37. 62. `OtherSuppliesNeeded` varchar(255) NOT NULL,
  38. 63. `ObtainSuppliesBy` varchar(255) NOT NULL,
  39. 64. `SuppliesLastObtained` varchar(255) NOT NULL,
  40. 65. `DoingBusinessAs` varchar(255) NOT NULL,
  41. 66. `CallAgentName` varchar(255) NOT NULL,
  42. 67. `CallAgentComments` varchar(255) NOT NULL,
  43. 68. `CallAgentRating` varchar(255) NOT NULL,
  44. 69. `OptInIP` varchar(255) NOT NULL,
  45. 70. `OptInTime` varchar(255) NOT NULL,
  46. 71. `InsertTime` varchar(255) NOT NULL,
  47. 72. `EmailTime` varchar(255) NOT NULL,
  48. 73. `EmailResponse` varchar(255) NOT NULL,
  49. 74. `EmailTemplateURI` varchar(255) NOT NULL,
  50. 75. `Deleted` int(11) NOT NULL,
  51. 76. `Archived` int(11) NOT NULL,
  52. 77. `Sold` int(11) NOT NULL,
  53. 78. `SleepApnea` varchar(255) NOT NULL,
  54. 79. `PrescribedCPAP` varchar(255) NOT NULL,
  55. 80. `INSType` varchar(255) NOT NULL,
  56. 81. `UID` varchar(255) NOT NULL,
  57. 82. `Groupid` varchar(255) NOT NULL,
  58. 83. `BIN` int(11) NOT NULL,
  59. 84. `PCN` varchar(255) NOT NULL,
  60. 85. `SSN` int(11) NOT NULL,
  61. 86. `ListName` varchar(255) NOT NULL,
  62. 87. `CallAgentID` varchar(255) NOT NULL,
  63. 88. `SessionID` varchar(255) NOT NULL,
  64. 89. `Shipped` int(11) NOT NULL,
  65. 90. `SCID` int(11) NOT NULL,
  66. 91. `OtherInfo` varchar(255) NOT NULL,
  67. 92. `TermDate` varchar(255) NOT NULL,
  68. 93. `EffectDate` varchar(255) NOT NULL,
  69. 94. `PIRXRelationship` varchar(255) NOT NULL,
  70. 95. `PIRXFirstName` varchar(255) NOT NULL,
  71. 96. `PIRXLastName` varchar(255) NOT NULL,
  72. 97. `PIRXZip` varchar(255) NOT NULL,
  73. 98. `PIRXGender` varchar(255) NOT NULL,
  74. 99. `PIRXDOB` varchar(255) NOT NULL,
  75. 100. `PIRXSSN` varchar(255) NOT NULL,
  76. 101. `PIRXPC` varchar(255) NOT NULL,
  77. 102. `InsLeadType` varchar(255) NOT NULL,
  78. 103. `CardPrimaryIns` varchar(255) NOT NULL,
  79. 104. `CardPolicyNumber` varchar(255) NOT NULL,
  80. 105. `CardGroupId` varchar(255) NOT NULL,
  81. 106. `CardBin` varchar(255) NOT NULL,
  82. 107. `CardPcn` varchar(255) NOT NULL,
  83. 108. `CardPhone` varchar(255) NOT NULL,
  84. 109. `ReferenceID` varchar(255) NOT NULL,
  85. 110. `ParentID` varchar(255) NOT NULL,
RAW Paste Data