| data_type โผ | database | is_primary | name | table |
|---|---|---|---|---|
| varchar | drugge8_pitf | False | InsuranceSecondaryPayer | insurance_information |
| varchar | drugge8_pitf | False | SponsorState | insurance_information |
| varchar | drugge8_pitf | False | hsa_desc | human_surface_anatomy |
| varchar | drugge8_pitf | False | OtherInsuranceNo | insurance_information |
| varchar | drugge8_pitf | False | InsurancePayerAddr1 | insurance_information |
| varchar | drugge8_pitf | False | SponsorCity | insurance_information |
| varchar | drugge8_pitf | False | Malignant | derm_van |
| varchar | drugge8_pitf | False | DxCode | derm_van |
| varchar | drugge8_pitf | False | ScanRules | insurance_information |
| varchar | drugge8_pitf | False | OtherInsuranceYes | insurance_information |
| varchar | drugge8_pitf | False | acct_first | derm_path_accts |
| varchar | drugge8_pitf | False | InsurancePayerType | insurance_information |
| varchar | drugge8_pitf | False | InsurancePayerCity | insurance_information |
| varchar | drugge8_pitf | False | SponsorAddr2 | insurance_information |
| varchar | drugge8_pitf | False | init | derm_van |
| varchar | drugge8_pitf | False | lesion | derm_path_lesions |
| varchar | drugge8_pitf | False | ctext_contents | consent_text |
| varchar | drugge8_pitf | False | Dx | derm_van |
| varchar | drugge8_pitf | False | PathMelanocytic | derm_van |
| varchar | drugge8_pitf | False | InsurancePlan | insurance_information |
| varchar | drugge8_pitf | False | desc | holidays |
| varchar | drugge8_pitf | False | StockerDx | derm_van |
| varchar | drugge8_pitf | False | body_site | derm_path |
| varchar | drugge8_pitf | False | pCRA_5A | data_cra1 |
| varchar | drugge8_pitf | False | InsurancePayerNumber | insurance_information |
| varchar | drugge8_pitf | False | InsuranceGroupName | insurance_information |
| varchar | drugge8_pitf | False | acct_pswd | derm_path_accts |
| varchar | drugge8_pitf | False | InsurancePayerAddr2 | insurance_information |
| varchar | drugge8_pitf | False | InsurancePayerState | insurance_information |
| varchar | drugge8_pitf | False | SponsorAddr1 | insurance_information |
| varchar | drugge8_pitf | False | camera | derm_path |
| varchar | drugge8_pitf | False | derm_id | derm_path_imgs |
| varchar | drugge8_pitf | False | image | derm_path_imgs |
| varchar | drugge8_pitf | False | lesion_id | derm_path_lesions |
| varchar | drugge8_pitf | False | system | consent_sign |
| varchar | drugge8_pitf | False | ctext_subtitle | consent_text |
| varchar | drugge8_pitf | False | Body_Site | derm_van |
| varchar | drugge8_pitf | False | st_file | contours_skin_table |
| varchar | drugge8_pitf | False | PathDx | derm_van |
| varchar | drugge8_pitf | False | Melanocytic | derm_van |
| varchar | drugge8_pitf | False | PathMalignant | derm_van |
| varchar | drugge8_pitf | False | hsa_name | human_surface_anatomy |
| varchar | drugge8_pitf | False | Notes | derm_van |
| varchar | drugge8_pitf | False | DermId | derm_van |
| varchar | drugge8_pitf | False | Coments | derm_van |
| varchar | drugge8_pitf | False | pCRA_Name | data_cra1 |
| varchar | drugge8_pitf | False | pCRA_3A | data_cra1 |
| varchar | drugge8_pitf | False | pCRA_5B | data_cra1 |
| varchar | drugge8_pitf | False | pCRA_4A | data_cra1 |
| varchar | drugge8_pitf | False | pCRA_4B | data_cra1 |
| varchar | drugge8_pitf | False | pCRA_7A | data_cra1 |
| varchar | drugge8_pitf | False | InsuranceName | insurance_information |
| varchar | drugge8_pitf | False | pCRA_Level | data_cra1 |
| varchar | drugge8_pitf | False | pCRA_9A | data_cra1 |
| varchar | drugge8_pitf | False | pAddr_Zip | cache |
| varchar | drugge8_pitf | False | patient_Number | deceased_listing |
| varchar | drugge8_pitf | False | patient_LastName | demotest |
| varchar | drugge8_pitf | False | patient_FirstName | demotest |
| varchar | drugge8_pitf | False | acct_name | derm_path_accts |
| varchar | drugge8_pitf | False | clinical_dx | derm_path |
| varchar | drugge8_pitf | False | SponsorName | insurance_information |
| varchar | drugge8_pitf | False | SponsorSex | insurance_information |
| varchar | drugge8_pitf | False | conf_cat_desc | configuration_categories |
| varchar | drugge8_pitf | False | pCRA_1A | data_cra1 |
| varchar | drugge8_pitf | False | access_ip | derm_path_accts |
| varchar | drugge8_pitf | False | acct_title | derm_path_accts |
| varchar | drugge8_pitf | False | guardian_name | consent_sign |
| varchar | drugge8_pitf | False | pCurrMed_Name | cache_page3_currmed |
| varchar | drugge8_pitf | False | pCurrMed_Strength | cache_page3_currmed |
| varchar | drugge8_pitf | False | pCurrMed_FirstUse | cache_page3_currmed |
| varchar | drugge8_pitf | False | pAddr_Addr1 | cache_page1 |
| varchar | drugge8_pitf | False | ip | consent_sign |
| varchar | drugge8_pitf | False | patient_Number | cache |
| varchar | drugge8_pitf | False | ctext_title | consent_text |
| varchar | drugge8_pitf | False | st_sizes | contours_skin_table |
| varchar | drugge8_pitf | False | Sex | derm_van |
| varchar | drugge8_pitf | False | pPInfo_Height | cache_page2 |
| varchar | drugge8_pitf | False | st_path | contours_skin_table |
| varchar | drugge8_pitf | False | pAppt_ScanContactNumber | demotest |
| varchar | drugge8_pitf | False | st_comments | contours_skin_table |
| varchar | drugge8_pitf | False | pAddr_City | cache_page1 |
| varchar | drugge8_pitf | False | pPInfo_Hair | cache_page2 |
| varchar | drugge8_pitf | False | pCRA_2A | cache_page4 |
| varchar | drugge8_pitf | False | pCRA_Hair | data_cra1 |
| varchar | drugge8_pitf | False | patient_LastName | cache |
| varchar | drugge8_pitf | False | PathDxCode | derm_van |
| varchar | drugge8_pitf | False | pAddr_Zip | cache_page1 |
| varchar | drugge8_pitf | False | wg_file | contours_wigits |
| varchar | drugge8_pitf | False | pCRA_Eye | data_cra1 |
| varchar | drugge8_pitf | False | t_file | contours_threshold |
| varchar | drugge8_pitf | False | pAddr_Home | cache_page1 |
| varchar | drugge8_pitf | False | pCRA_Gender | data_cra1 |
| varchar | drugge8_pitf | False | pat_number | control_points |
| varchar | drugge8_pitf | False | cp_group_name | control_points |
| varchar | drugge8_pitf | False | patient_FirstName | cache |
| varchar | drugge8_pitf | False | pHist_Notice | cache_page2 |
| varchar | drugge8_pitf | False | pCRA_2A | data_cra1 |
| varchar | drugge8_pitf | False | pPInfo_DOB | cache |
| varchar | drugge8_pitf | False | pAddr_Cell | cache_page1 |
| varchar | drugge8_pitf | False | pCRA_3B | data_cra1 |
| varchar | drugge8_pitf | False | pCRA_8A | cache_page4 |
| varchar | drugge8_pitf | False | pHist_PriorTreatment | cache_page2 |
| varchar | drugge8_pitf | False | pCRA_9A | cache_page4 |
| varchar | drugge8_pitf | False | pAddr_Fax | cache_page1 |
| varchar | drugge8_pitf | False | pCRA_6A | data_cra1 |
| varchar | drugge8_pitf | False | patient_FirstName | cache_page1 |
| varchar | drugge8_pitf | False | pCRA_TotalScores | cache_page4 |
| varchar | drugge8_pitf | False | pCRA_8A | data_cra1 |
| varchar | drugge8_pitf | False | pPInfo_Email | cache_page1 |
| varchar | drugge8_pitf | False | pCos_Procedure_Type | cache_page2 |
| varchar | drugge8_pitf | False | pCos_Surgery | cache_page2 |
| varchar | drugge8_pitf | False | pPInfo_SSN | cache_page1 |
| varchar | drugge8_pitf | False | pCos_Surgery_Type | cache_page2 |
| varchar | drugge8_pitf | False | pCRA_Reminder | data_cra1 |
| varchar | drugge8_pitf | False | pContact_Referring | cache_page1 |
| varchar | drugge8_pitf | False | List_Description | deceased_listing |
| varchar | drugge8_pitf | False | patient_Number | demotest |
| varchar | drugge8_pitf | False | patient_ID | demotest |
| varchar | drugge8_pitf | False | derm_id | derm_path |
| varchar | drugge8_pitf | False | patient_LastName | cache_page1 |
| varchar | drugge8_pitf | False | pContact_Primary | cache_page1 |
| varchar | drugge8_pitf | False | pAddr_Home | demotest |
| varchar | drugge8_pitf | False | pContact_Suggest | cache_page1 |
| varchar | drugge8_pitf | False | pHist_BloodThinning | cache_page3 |
| varchar | drugge8_pitf | False | pFHist_Diabetes | cache_page3 |
| varchar | drugge8_pitf | False | pAppt_Show | demotest |
| varchar | drugge8_pitf | False | pReminder_LabResult | cache_page1 |
| varchar | drugge8_pitf | False | pPInfo_DOB | cache_page1 |
| varchar | drugge8_pitf | False | pAppt_ScanContactNumber | canceled_appointments |
| varchar | drugge8_pitf | False | conf_cat_name | configuration_categories |
| varchar | drugge8_pitf | False | acct_last | derm_path_accts |
| varchar | drugge8_pitf | False | pReminder_Appt | cache_page1 |
| varchar | drugge8_pitf | False | event | consent_log |
| varchar | drugge8_pitf | False | patient_name | consent_sign |
| varchar | drugge8_pitf | False | pPInfo_Gender | cache_page1 |
| varchar | drugge8_pitf | False | pPInfo_Email | cache |
| varchar | drugge8_pitf | False | pAcne_1A | cache_page7 |
| varchar | drugge8_pitf | False | pAcne_2A_Other | cache_page7 |
| varchar | drugge8_pitf | False | pAcne_2B_Most | cache_page7 |
| varchar | drugge8_pitf | False | pAcne_2B_Least | cache_page7 |
| varchar | drugge8_pitf | False | pAcne_2B_Part | cache_page7 |
| varchar | drugge8_pitf | False | pAcne_3A | cache_page7 |
| varchar | drugge8_pitf | False | pCurrMed_Freq | cache_page3_currmed |
| varchar | drugge8_pitf | False | pAcne_5A | cache_page7 |
| varchar | drugge8_pitf | False | location | consent_sign |
| varchar | drugge8_pitf | False | pAcne_7A | cache_page7 |
| varchar | drugge8_pitf | False | pPInfo_Occupation | cache_page2 |
| varchar | drugge8_pitf | False | pAcne_8A | cache_page7 |
| varchar | drugge8_pitf | False | pMedAllergy_Name | cache_page3_medallergy |
| varchar | drugge8_pitf | False | pAcne_9A | cache_page7 |
| varchar | drugge8_pitf | False | pAddr_Addr2 | cache_page1 |
| varchar | drugge8_pitf | False | pAcne_10A | cache_page7 |
| varchar | drugge8_pitf | False | pPInfo_Status | cache_page2 |
| varchar | drugge8_pitf | False | st_box | contours_skin_table |
| varchar | drugge8_pitf | False | pFHealth_Relationship | cache_page3_relative |
| varchar | drugge8_pitf | False | pAcne_2A | cache_page7_pacne_2a |
| varchar | drugge8_pitf | False | pFHealth_Age | cache_page3_relative |
| varchar | drugge8_pitf | False | pAcne_4A_Med | cache_page7_pacne_4a |
| varchar | drugge8_pitf | False | pAcne_4A_Duration | cache_page7_pacne_4a |
| varchar | drugge8_pitf | False | pAcne_4A_Rate | cache_page7_pacne_4a |
| varchar | drugge8_pitf | False | pPInfo_Weight | cache_page2 |
| varchar | drugge8_pitf | False | pAcne_6A | cache_page7_pacne_6a |
| varchar | drugge8_pitf | False | pCRA_1A | cache_page4 |
| varchar | drugge8_pitf | False | pCRA_Level | cache_page9 |
| varchar | drugge8_pitf | False | pCRA_Reminder | cache_page9 |
| varchar | drugge8_pitf | False | pReminder_MonthlySelfExam | cache_page9 |
| varchar | drugge8_pitf | False | pReminder_Scan | cache_page9 |
| varchar | drugge8_pitf | False | pReminder_Email | cache_page9 |
| varchar | drugge8_pitf | False | pPInfo_Eyes | cache_page2 |
| varchar | drugge8_pitf | False | pAddr_State | cache_page1 |
| varchar | drugge8_pitf | False | pCRA_3A | cache_page4 |
| varchar | drugge8_pitf | False | filename | call_records |
| varchar | drugge8_pitf | False | file_path | call_records |
| varchar | drugge8_pitf | False | caller_phone | call_records |
| varchar | drugge8_pitf | False | caller_name | call_records |
| varchar | drugge8_pitf | False | pCRA_3B | cache_page4 |
| varchar | drugge8_pitf | False | pAppt_Comments | canceled_appointments |
| varchar | drugge8_pitf | False | pHist_Location | cache_page2 |
| varchar | drugge8_pitf | False | pCRA_4A | cache_page4 |
| varchar | drugge8_pitf | False | t_comments | contours_threshold |
| varchar | drugge8_pitf | False | pHist_LocDescription | cache_page2 |
| varchar | drugge8_pitf | False | sentiment | call_records |
| varchar | drugge8_pitf | False | mood | call_records |
| varchar | drugge8_pitf | False | pCRA_4B | cache_page4 |
| varchar | drugge8_pitf | False | pHist_AcneTreatment | cache_page2 |
| varchar | drugge8_pitf | False | wg_comments | contours_wigits |
| varchar | drugge8_pitf | False | status | call_records |
| varchar | drugge8_pitf | False | pCRA_5A | cache_page4 |
| varchar | drugge8_pitf | False | pHist_Cause | cache_page2 |
| varchar | drugge8_pitf | False | pAppt_Show | canceled_appointments |
| varchar | drugge8_pitf | False | pCRA_5B | cache_page4 |
| varchar | drugge8_pitf | False | pAddr_Work | cache_page1 |
| varchar | drugge8_pitf | False | patient_ID | canceled_appointments |
| varchar | drugge8_pitf | False | patient_Number | canceled_appointments |
| varchar | drugge8_pitf | False | patient_FirstName | canceled_appointments |
| varchar | drugge8_pitf | False | pCRA_6A | cache_page4 |
| varchar | drugge8_pitf | False | patient_LastName | canceled_appointments |
| varchar | drugge8_pitf | False | pAddr_Home | canceled_appointments |
| varchar | drugge8_pitf | False | pCRA_7A | cache_page4 |
| varchar | drugge8_pitf | False | InsuranceSecondaryIDNumber | insurance_information |