Table Name : PATIENT HISTORY Description : Details of patient Field Name P_ID P_NAME P_age SEX SMOKING OVERWEIGHT

HEREDITARY BAD_CHOLESTROL_L EVEL BLOOD_SUGAR_LEVE L ALCOHOL_INTAKE HIGH_SALT_DIET BLOODPRESSURE SEDENTRY_LIFE_STY LE EXERCISE_HABIT HEART RATE HIGH_SATURATED_FA T_DIET WEIGHTAGE RISKLEVEL DataType Varchar(10) Varchar(25) Int(11) Varchar(10) Varchar(15) Boolean Varchar(6) Varchar(6) Varchar(6) Varchar(10) Varchar(6) Varchar(6) Varchar(6) Varchar(15) Varchar(6) Varchar(6) Double Varchar(6) Foreign Key(Qualification) Description Foreign Key(Doctor)

Table Name : PSS_APPOINTMENTSTATUS Description : Field Name AS_STATUSID AS_STATUS AS_ACTIVE Text Number DataType AutoNumber Description

Table Name : PSS_APPOINTMENTSTUTUS Description : Field Name PA_APPOINTMENTS PA_TEMPLATEID PA_TIMESLOTID PA_PATIENTID PA_DATE PA_STATUS DataType AutoNumber Number Number Number Date/Time Number Description

Table Name : PSS_APPOINTMENT_CANCEL Description : Field Name PAC_CANCELLATIONID PAC_APPOINTMENTID PAC_PATIENTID PAC_REASON DataType AutoNumber Number Number Text Description

Table Name : PSS_ALLERGIES_LOOKUP Description : Field Name AL_ALLERGENID AL_ALLERGENNAME AL_STATUS Text Number DataType AutoNumber Description

Table Name : PSS_ADDRESSBOOK_DETAILS Description : Field Name AB_ADDRESSID AB_FIRSTNAME AB_LASTNAME AB_ADDRESS AB_CITY Text Text Text Text DataType AutoNumber Description

AB_STATE AB_PIN AB_OFFICEPHONE AB_RESPHONE AB_CELLPHONE AB_EMAIL Table Name : PSS_USERTYPE Description : Field Name PST_TYPEID PST_USERTYPENAME PST_TYPEDESCRIPTION PST_STATUS

Text Number Text Text Text Text

DataType AutoNumber Text Text Number

Description

Table Name : PSS_USERCONFIGURATION Description : Field Name PUC_USERID PUC_USERNAME PUC_PASSWORD PUC_USERTYPEID PUC_ACTIVE Text Text Number Number DataType AutoNumber Description

Table Name : PSS_STATE_LOOKUP Description : Field Name PS_STATEID PS_STATENAME PS_SORTORDER PS_ACTIVE Text Number Number DataType Number Description

Table Name : PSS_SCHEDULETEMPLATE_PERDAY Description : Field Name PSTD_TEMPLATESLOTID PSTD_TEMPLATEID PSTD_STARTSLOT PSTD_ENDSLOT PSTD_ENCOUNTERTYPEID DataType AutoNumber Number Number Number Number Description

Table Name : PSS_SCHEDULETEMPLATES Description : Field Name PST_TEMPLATEID PST_TEMPLATENAME PST_STARTTIME PST_ENDTIME PST_COLOR DataType AutoNumber Text Number Number Text Description

Table Name : PSS_SCHEDULE_APPOINTMENTS_TEMP Description : Field Name PSS_APPCOUNTID PSTD_STARTSLOT PSTD_ENDSLOT PATIENTNAME PD_ADDRESS PD_PHONE PE_ENCOUNTERNAME PSTD_TEMPLATESLOTID DTM_DAILYTEMPLATE_ID PA_PATIENTID AS_STATUSID AS_STATUS DataType Number Text Text Text Text Text Text Text Text Text Text Text Description

Table Name : PSS_PROBLEM_LOOKUP Description : Field Name PL_PROBLEMID PL_PROBLEMNAME PL_STATUS Text Number DataType AutoNumber Description

Table Name : PSS_PATIENTVITALDETAILS Description : Field Name PVD_VITALID PVD_VISITID PVD_PATIENTID PVD_BLOODGROUP PVD_BLOODPRESSU RE PVD_TEMPERATURE PVD_PULSE PVD_HEIGHT PVD_WEIGHT PVD_DESCRIPTION PVD_STATUS DataType AutoNumber Number Number Text Text Text Text Text Text Memo Number Description

Table Name : PSS_PATIENTVISITDETAILS Description : Field Name PV_VISITID PV_PATIENTID PV_DATE PV_COMMENT DataType AutoNumber Number Date/Time Memo Description

Table Name : PSS_PATIENTPROBLEMSYMPTOMS Description : Field Name PPS_SYMPTOMID PPS_VISITID PPS_PATIENTID PPS_DESCRIPTION PPS_STATUS DataType AutoNumber Number Number Memo Number Description

Table Name : PSS_PATIENTPROBLEMDIAGNOSIS Description : Field Name PPD_DIAGNOSISID PPD_VISITID PPD_PATIENTID PPD_DESCRIPTION PPD_STATUS DataType AutoNumber Number Number Memo Number Description

Table Name : PSS_PATIENTPROBLEM_MAP Description : Field Name PPM_RECORDID PPM_VISITID PPM_PATIENTID PPM_STATUS PPM_PROBLEM DataType AutoNumber Number Number Number Memo Description

Table Name : PSS_PATIENTDRUG_MAP Description : Field Name PDM_RECORDID PDM_VISITID PDM_PATIENT DataType AutoNumber Number Number Description

PDM_DRUGID PDM_DRUGDOSAGE PDM_DRUGFREQUENCY PDM_PERIOD PDM_STATUS Table Name : PSS_PATIENTDETAILS Description : Field Name PD_PATIENTID PD_FIRSTNAME PD_LASTNAME PD_AGE PD_AGEYEAR PD_GENDER PD_ADDRESS PD_PLACE PD_STATE PD_PHONE PD_MOBILE PD_EMAIL PD_REG_DATE PD_STATUS

Number Number Text Text Number

DataType AutoNumber Text Text Number Number Text Text Text Number Text Text Text Date/Time Number

Description

Table Name : PSS_PATIENTALLERGY_MAP Description : Field Name PAM_RECORDID PAM_VISITID PAM_PATIENTID PAM_STATUS PAM_ALLERGY DataType AutoNumber Number Number Number Memo Description

Table Name : PSS_MANUFACTURER_LOOKUP Description : Field Name ML_MANUFACTURERID ML_MANUFACTURERNAME ML_STATUS DataType AutoNumber Text Number Description

Table Name : PSS_GROUP_LOOKUP Description : Field Name GL_GROUPID GL_GROUPNAME GL_STATUS Text Number DataType AutoNumber Description

Table Name : PSS_ENCOUNTERTYPE_LOOKUP Description : Field Name PE_ENCOUNTERTYPEID PE_ENCOUNTERNAME PE_COLOR Text Text DataType AutoNumber Description

Table Name : PSS_DRUG_LOOKUP Description : Field Name DL_DRUGID DL_DRUGNAME DL_STATUS DL_MANUFACTURERID Text Number Number DataType AutoNumber Description

Table Name : PSS_DAILYTEMPLATE_MAP Description : Field Name DTM_DAILYTEMPLATE_ID DTM_DATE DTM_TEMPLATEID DataType AutoNumber Date/Time Number Description