TableName:@Bank Code 10 10 True False Name 10 20 True False Index Code EndOfTable TableName:@OutDoorC Year 10 4 True False SNoYear 10 10 True False Name 10 50 True False Sex 10 1 True False FHName 10 50 True False Add1 10 40 True False Add2 10 40 True False Add3 10 40 True False UserCode 10 10 True False UserName 10 12 True False Procedure 1 1 False False Consult 1 1 False False Day 10 2 True False Month 10 2 True False SNoMonth 10 5 True False RefDr 10 10 True False salutation 10 10 True True AgePeriod 10 10 True False TimeHR 10 2 True False TimeMin 10 2 True False PatientCode 10 10 True False OldPatientCode 10 10 True False Age 10 5 True False FYear 10 4 True False PhoneNo 10 30 True False RegNo 10 10 True False IsEmergency 1 1 False False Index OldPatientCode PatientCode SNoYear EndOfTable TableName:@IndoorReceipt TransactionType 10 10 True False ReceiptNo 10 10 True False PatientCode 10 10 True False ReceiptAmount 7 8 False False UserName 10 12 True False UserCode 10 10 True False ReceiptDateDay 10 2 True False ReceiptDateMonth 10 2 True False ReceiptDateYear 10 4 True False DiscountAmount 7 8 False False Year 10 4 True False Index EndOfTable TableName:@Bank Code 10 10 True False Name 10 40 True False EndOfTable TableName:@Compinfo CName 10 50 True True Address1 10 40 True True Address2 10 40 True False Address3 10 40 True False Pin 10 6 True False Fax 10 15 True False Phone1 10 15 True False Phone2 10 15 True False email 10 50 True False StartDate 10 2 True False StartMonth 10 2 True False StartYear 10 4 True False EndDate 10 2 True False EndMonth 10 2 True False EndYear 10 4 True False Accessed 7 8 False False Process 1 1 False False SlNo 10 30 True False TakeFees 1 1 False False Co_Code 4 4 False 0 False UserName 10 12 True False UserCode 10 10 True False HindiFontName 10 50 True False PrintHeader 1 1 False False AdmitPatientDirect 1 1 False False MakeIndoorBillDirect 1 1 False False MakeIndoorProperBill 1 1 False False RegFeesValidDays 3 2 False False RegFees 7 8 False False RegFeesMorningEveningFees 7 8 False False InvestigationFeesSelf 1 1 False False InvestigationFeesOfDiagnosticCenter 1 1 False False ChargeRegFeesForOutDoor 1 1 False False ChargeRegFeesForIndoor 1 1 False False RegFeesNightFees 7 8 False False lastlogday 10 2 True False lastlogmonth 10 2 True False lastlogyear 10 4 True False ReceiptOnDOSPrinter 1 1 False False ReportsOnDOSPrinter 1 1 False False ChargeFileCharges 1 1 False False FileChargeAmount 10 10 True False RegistrationNo 10 70 True False DischargeWithoutClearingAccount 1 1 False False PrepareFinalBillOnDischarge 1 1 False False PrintSingleBill 1 1 False False UseForLab 1 1 False False Index Co_Code UserCode EndOfTable TableName:@crptFields2 Col1 10 50 True False Col3 10 50 True False Col4 10 50 True False col5 10 50 True False col6 10 50 True False Col7 10 50 True False col8 10 50 True False col9 10 250 True False col10 10 50 True False Col11 6 4 False False Col12 6 4 False False Col2 10 150 True False Index EndOfTable TableName:@Client Code 10 10 True False Name 10 50 True " " False Add1 10 50 True " " False Add2 10 50 True " " False Add3 10 50 True " " False Phone 10 50 True " " False Mobile 10 50 True " " False Fax 10 50 True " " False Email 10 50 True " " False City 10 50 True " " False Degree 10 50 True " " False HospClinic 10 50 True " " False Category 10 50 True " " False RegNo 10 50 True " " False State 10 50 True " " False Salutation 10 50 True " " False Pin 10 10 True False Tag 1 1 False False Index Code EndOfTable TableName:@ScannedDocument PatientCode 10 10 False False DateDay 10 2 False False DateMonth 10 2 False False DateYear 10 4 False False FYear 10 4 False False UserName 10 12 False False UserCode 10 10 False False DocumentHeading 10 150 True False DocumentFilePath 10 150 True False ScannedID 4 4 False False Index EndOfTable TableName:@PrescriptionSimple BodyDiscomfort 12 0 True False Discontinuation 12 0 True False CheifComplaints 12 0 True False PastHistory 12 0 True False PersonalHistory 12 0 True False FamilyHistory 12 0 True False SystematicExamination 12 0 True False Investigation 12 0 True False Diagnosis 12 0 True False Advise 12 0 True False PatientCode 10 10 True False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False FYear 10 4 True False UserName 10 12 True False UserCode 10 10 True False DoctorCode 10 10 False False PrescriptionDays 10 10 False False Index EndOfTable TableName:@Registration IsEmergency 1 1 False False Year 10 4 False False RegistrationNo 10 10 False False Name 10 50 True False Sex 10 1 False False FHName 10 50 True False Add1 10 40 True False Add2 10 40 True False Add3 10 40 True False UserCode 10 10 False False UserName 10 12 False False Day 10 2 False False Month 10 2 False False salutation 10 10 False False AgePeriod 10 10 False False Code 10 10 False False Age 10 5 True False FYear 10 4 False False CasteCode 10 10 True False PhoneNo 10 30 True False Nationality 10 30 True False AadharNo 10 50 True False Index EndOfTable TableName:@Questionairre SlNo 3 2 False False Name 12 0 False False AnsMarks1 3 2 False False AnsMarks2 3 2 False False AnsMarks3 3 2 False False AnsMarks4 3 2 False False Code 3 2 False False Index EndOfTable TableName:@PresQuestionairre PatientCode 10 10 False False DateDay 10 2 False False DateMonth 10 2 False False DateYear 10 4 False False SlNo 3 2 False False QuestionCode 10 10 False False UserName 10 12 False False UserCode 10 10 False False AnswerNo 3 2 False False AnswerMarks 3 2 False False Index EndOfTable TableName:@Address Code 10 10 True False Name 10 50 True " " False Add1 10 50 True " " False Add2 10 50 True " " False Add3 10 50 True " " False Phone 10 50 True " " False Mobile 10 50 True " " False Fax 10 50 True " " False Email 10 50 True " " False City 10 50 True " " False Degree 10 50 True " " False HospClinic 10 50 True " " False Category 10 50 True " " False RegNo 10 50 True " " False State 10 50 True " " False Salutation 10 50 True " " False Pin 10 10 True False Tag 1 1 False False Index EndOfTable TableName:@Advice Code 10 10 True False Name 10 40 True False NameEnglish 10 250 True False NameHindi 10 250 True False UserName 10 12 True False UserCode 10 10 True False Index Code UserCode EndOfTable TableName:@Anaesthesia Code 10 10 True False Name 10 50 True False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False Index Code UserCode EndOfTable TableName:@AutoEquipmentCharges RoomTypeCode 10 10 True False SlNo 3 2 False False EquipmentCode 10 10 True False RoomCode 10 10 True False Index EndOfTable TableName:@Bed Code 10 10 True False Name 10 40 True False ShortName 10 6 True False BedNo 2 1 False False RoomCode 10 10 True False Rate 7 8 False False Full 1 1 False False UserName 10 12 True False UserCode 10 10 True False NursingRate 7 8 False 0 False DoctorRate 7 8 False 0 False AutoStartEquipment 1 1 False False False BedVisible 1 1 False False Index BedNo Code UserCode EndOfTable TableName:@Caste Code 10 10 True False Name 10 50 True False Index EndOfTable TableName:@Category Code 10 10 True False Name 10 50 True False Tag 1 1 False False Index Code EndOfTable TableName:@crptFields Col1 10 50 True " " False Col3 10 50 True " " False Col4 10 50 True " " False col5 10 50 True " " False col6 10 50 True " " False Col7 10 50 True " " False col8 10 50 True " " False col9 10 50 True " " False col10 10 50 True " " False Col11 6 4 False 0 False Col12 6 4 False 0 False Col2 10 150 True " " False Index EndOfTable TableName:@DailyCheckUp Code 10 10 True False Name 10 40 True False ShortName 10 10 True False StartValue 7 8 False 0 False Gap 7 8 False 0 False EndValue 7 8 False 0 False StartValue2 7 8 False 0 False Gap2 7 8 False 0 False EndValue2 7 8 False 0 False SlNo 4 4 False 0 False AllowedValues 3 2 False 0 False UserName 10 12 True False UserCode 10 10 True False Index Code UserCode EndOfTable TableName:@DataForAnalysisAddress Code 10 10 True False Name 10 50 True False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False Index Code UserCode EndOfTable TableName:@DataForAnalysisAge Code 10 10 True False Name 10 50 True False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False AgeGreaterThan 3 2 False False AgeLessThanEqualTo 3 2 False False AgeCaption 10 10 True False Index Code UserCode EndOfTable TableName:@DataForAnalysisSex Code 10 10 True False Name 10 50 True False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False Index Code UserCode EndOfTable TableName:@Diagnosis Code 10 10 True False Name 10 50 True False UserName 10 12 True False UserCode 10 10 True False Index Code EndOfTable TableName:@Diagnostic Code 10 10 True False Name 10 50 True False Discount 6 4 False False Tag 1 1 False False ShortName 10 5 True False UserName 10 12 True False UserCode 10 10 True False Index Code UserCode EndOfTable TableName:@Disease DiseaseCode 10 255 True False Name 10 255 True False Code 10 10 True False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False Indoor 1 1 False False Outdoor 1 1 False False Index Code DiseaseCode EndOfTable TableName:@Disease1 Code 10 10 True False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False DiseaseCode 10 10 True False Name 10 100 True False Index Code UserCode EndOfTable TableName:@Doctor Code 10 10 True True Name 10 50 True False Add1 10 40 True False Add2 10 40 True False Add3 10 40 True False Pin 10 6 True False Phone 10 20 True False Fax 10 20 True False EMail 10 30 True False Comm 6 4 False False Add4 10 40 True False Consultant 1 1 False False False Fees 6 4 False 0 False Tag 1 1 False False Mobile 10 20 True False UserName 10 12 True False UserCode 10 10 True False Anaesthetist 1 1 False False Gynaecologist 1 1 False False NightFees 7 8 False False RegNo 10 15 True False Qualification 10 15 True False Specialist 10 20 True False Index Code UserCode EndOfTable TableName:@DrUnit Code 10 10 True False Name 10 20 True False Day1 3 2 False False Day2 3 2 False False Day3 3 2 False False FirstSunday 3 2 False False SecondSunday 3 2 False False ThirdSunday 3 2 False False Index Code EndOfTable TableName:@Equipment Code 10 10 True False Name 10 50 True False Fixed 1 1 False False Amount 6 4 False False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False HourlyCharges 1 1 False False DailyCharges 1 1 False False FirstTimeExtraCharge 1 1 False False FirstTimeExtraAmount 7 8 False False Index Code UserCode EndOfTable TableName:@EquipmentCharges EquipmentCode 10 10 True False PatientCode 10 10 True False BedCode 10 10 True False MonthStart 10 2 True False YearStart 10 4 True False DateEnd 10 2 True False MonthEnd 10 2 True False YearEnd 10 4 True False Rate 7 8 False False UserCode 10 10 True False UserStopName 10 12 True False UserStopCode 10 10 True False SlNo 3 2 False False UserName 10 12 True False DateStart 10 2 True False Year 10 4 True False HourStart 10 2 True False MinuteStart 10 2 True False HourEnd 10 2 True False MinuteEnd 10 2 True False Index EndOfTable TableName:@ExaminationActual Code 10 10 True False Name 10 50 True False ExaminationCode 10 10 True False ExaminationSubCode 10 50 True False Left 1 1 False False Right 1 1 False False UserName 10 12 True False UserCode 10 10 True False Index Code ExaminationCode ExaminationSubCode EndOfTable TableName:@ExaminationFromWhen Code 10 10 True False Name 10 50 True False UserName 10 12 True False UserCode 10 10 True False Index Code EndOfTable TableName:@ExaminationMaster Code 10 10 True False Name 10 50 True False UserName 10 12 True False UserCode 10 10 True False Index Code EndOfTable TableName:@ExaminationSubMaster Code 10 10 True False Name 10 50 True False ExaminationCode 10 50 True False UserName 10 12 True False UserCode 10 10 True False Index Code ExaminationCode EndOfTable TableName:@Expense Code 10 10 True False Day 10 2 True False Month 10 2 True False Year 10 4 True False ExpenseCode 10 10 True False Description 10 100 True False Amount 6 4 False False SlNo 3 2 False False UserCode 10 10 True False UserName 10 12 True False Index EndOfTable TableName:@Facility Code 10 4 True False Name 10 50 True False Report 1 1 False False AddF 1 1 False False EditF 1 1 False False DeleteF 1 1 False False ViewF 1 1 False False SerialNo 3 2 False False Index Code EndOfTable TableName:@FacilityOther Discharge 1 1 False False DischargeTicket 1 1 False False ViewFinalBill 1 1 False False PrintFinalBill 1 1 False False Index EndOfTable TableName:@HProc Code 10 10 True False Name 10 50 True False Fees 6 4 False False Tag 1 1 False False FixedRate 1 1 False False UserName 10 12 True False UserCode 10 10 True False Index Code UserCode EndOfTable TableName:@Income Code 10 10 True False Day 10 2 True False Month 10 2 True False Year 10 4 True False ExpenseCode 10 10 True False Description 10 100 True False Amount 6 4 False False SlNo 3 2 False False UserCode 10 10 True False UserName 10 12 True False Index EndOfTable TableName:@IncomeExpense Code 10 10 True False Name 10 50 True False Tag 1 1 False False Income 1 1 False False Expense 1 1 False False UserName 10 12 True False UserCode 10 10 True False Index Code UserCode EndOfTable TableName:@Indoor Code 10 10 True False IPDNo 10 10 True False IPDNavjeevan 10 10 True False RegNo 10 10 True False Name 10 50 True False Add1 10 40 True False Add2 10 40 True False Add3 10 40 True False Pin 10 6 True False Phone 10 15 True False DateAdmDate 10 2 True False DateAdmMonth 10 2 True False DateAdmYear 10 4 True False DateDiscDate 10 2 True False DateDiscMonth 10 2 True False DateDiscYear 10 4 True False Discount 7 8 False False Free 1 1 False False AdmCondition 10 50 True False ResultCondition 10 50 True False Consultant 10 10 True False OutcomeDelivery 10 50 True False AgePeriod 10 10 True False Sex 10 1 True False Room 10 10 True False Bed 10 10 True False ProvDiag 10 50 True False FinalDiag 10 50 True False AdmBy 10 10 True False DiscBy 10 50 True False UserCode 10 255 True False UserName 10 12 True False Remark 10 100 True False AdmTimeHr 2 1 False False AdmTimeMin 2 1 False False DiscTimeHr 2 1 False False DiscTimeMin 2 1 False False RefCode 10 10 True False Salutation 10 10 True False FHName 10 50 True False OperativeProcedure 10 50 True False Year 10 4 True False DiseaseCode 10 10 True "" False Age 10 5 True False CasteCode 10 10 True False CategoryCode 10 10 True False Registered 1 1 False False Referred 1 1 False False RegMorning 1 1 False False RegEvening 1 1 False False Amount 7 8 False False UnitCode 10 10 True False CardNo 10 40 True False WardName 10 10 True False UnitName 10 10 True False Index Code EndOfTable TableName:@IndoorBill BillNo 10 10 True False BillDateDay 10 2 True False BillDateMonth 10 2 True False BillDateYear 10 4 True False PatientCode 10 10 True False DiscountAmount 7 8 False False TotalAmount 7 8 False False GrandTotalAmount 7 8 False False UserName 10 12 True False UserCode 10 10 True False Year 10 4 True False Index EndOfTable TableName:@IndoorBillDetail BillNo 10 10 True False Slno 3 2 False False DiagCode 10 10 True False InvCode 10 10 True False Qty 7 8 False False Rate 7 8 False False Amount 7 8 False False TypeCode 3 2 False False Description 10 50 True False Year 10 4 True False UserCode 10 10 True False UserName 10 12 True False Index UserCode EndOfTable TableName:@IndoorComm DoctorCode 10 10 True False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False IPDNo 10 10 True False BillAmount 7 8 False False PAmount 7 8 False False CAmount 7 8 False False SlNo 6 4 False False PatientCode 10 10 True False Year 10 4 True False UserName 10 12 True False UserCode 10 10 True False Index UserCode EndOfTable TableName:@IndoorDueAfterDischarge PatientCode 10 10 False False UserName 10 12 False False UserCode 10 10 False False Year 10 4 False False DueAmount 7 8 False False Index EndOfTable TableName:@IndoorFinalBill BillNo 10 10 False False BillDateDay 10 2 False False BillDateMonth 10 2 False False BillDateYear 10 4 False False PatientCode 10 10 False False UserName 10 12 False False UserCode 10 10 False False Year 10 4 False False Index EndOfTable TableName:@IndoorReceipt ReceiptNo 10 10 True False PatientCode 10 10 True False ReceiptAmount 7 8 False False UserName 10 12 True False UserCode 10 10 True False ReceiptDateDay 10 2 True False ReceiptDateMonth 10 2 True False ReceiptDateYear 10 4 True False DiscountAmount 7 8 False False Year 10 4 True False Index EndOfTable TableName:@IndoorRefund PatientCode 10 10 True False Code 10 10 True False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False Amount 7 8 False False Remark 10 50 True False UserName 10 12 True False UserCode 10 10 True False Year 10 4 True False Index Code EndOfTable TableName:@IndoorTicket CaseSummary 12 0 True False TreatmentGiven 12 0 True False Investigation 12 0 True False ConditionDischarge 12 0 True False TreatmentAdvised 12 0 True False PatientCode 10 10 True False UserName 10 12 True False UserCode 10 10 True False Index UserCode EndOfTable TableName:@Investigation Code 10 10 True False Name 10 50 True False Amount 6 4 False False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False Lab 1 1 False False ECG 1 1 False False Sonography 1 1 False False Index Code UserCode EndOfTable TableName:@InvestigationCharges InvCode 10 10 True False DiagCode 10 10 True False Amount 6 4 False False UserName 10 12 True False UserCode 10 10 True False Index EndOfTable TableName:@MAddressBookArea Code 10 10 True False Name 10 50 True False Tag 1 1 False False Index Code EndOfTable TableName:@MAddressBookCity Code 10 10 True False Name 10 50 True False Tag 1 1 False False Index Code EndOfTable TableName:@MAddressBookState Code 10 10 True False Name 10 50 True False Tag 1 1 False False Index Code EndOfTable TableName:@MCompound Code 10 10 True False Name 10 50 True False UserName 10 12 True False UserCode 10 10 True False Index Code UserCode EndOfTable TableName:@Medicine Code 10 10 True False Name 10 50 True False ShortName 10 10 True False MedicineTypeCode 10 10 True False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False OpeningQty 5 8 False False Index Code UserCode EndOfTable TableName:@MedicineAgeGroups Code 10 10 True False FromAgeGroup 7 8 False False ToAgeGroup 7 8 False False OrderView 3 2 False False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False Index EndOfTable TableName:@MedicineCompound MCompoundCode 10 10 True False MedicineCode 10 10 True False CQtyCode 10 10 True False Qty 7 8 False 0 False Name 10 50 True False QtyMeasurement 10 20 True False SlNo 3 2 False 0 False UserName 10 12 True False UserCode 10 10 True False Index EndOfTable TableName:@MedicineDueReceipt PatientCode 10 10 True False UserName 10 12 True False UserCode 10 10 True False Amount 7 8 False False Day 10 2 True False Month 10 2 True False Year 10 4 True False Code 10 10 True False FYear 10 4 True False Index EndOfTable TableName:@MedicinePatient PatientCode 10 10 True False IndoorNo 10 10 True False OutDoorNo 10 10 True False MedicineCode 10 10 True False Code 10 20 True False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False UserName 10 12 True False UserCode 10 10 True False Index EndOfTable TableName:@MedicinePending PatientCode 10 10 True False UserName 10 12 True False UserCode 10 10 True False Amount 7 8 False False Code 10 10 True False Day 10 2 True False Month 10 2 True False Year 10 4 True False FYear 10 4 True False Index EndOfTable TableName:@MedicinePrescription PatientCode 10 10 True False MedicinePatientCode 10 20 True False MedicineCode 10 10 True False QtyCode 10 10 True False Qty 7 8 False False TimesCode 10 10 True False DayFrom 7 8 False False DayTo 7 8 False False Days 3 2 False False ProcessCode 10 10 True False WhenToTakeCode 10 10 True False Process 10 100 True False WhenToTake 10 100 True False MedicineTimes 10 100 True False SlNo 3 2 False False UserName 10 12 True False UserCode 10 10 True False Index UserCode EndOfTable TableName:@MedicinePrescriptionTimes TimesCode 10 10 True False MedicinePatientCode 10 20 True False MedicineCode 10 10 True False SlNo 3 2 False False UserName 10 12 True False UserCode 10 10 True False Index EndOfTable TableName:@MedicineProcessToTake Code 10 10 True False Name 10 50 True False Tag 1 1 False False NameEnglish 10 250 True False NameHindi 10 250 True False UserName 10 12 True False UserCode 10 10 True False Index EndOfTable TableName:@MedicineProcessWhen Code 10 10 True False Name 10 50 True False NameEnglish 10 250 True False NameHindi 10 250 True False QtyInOneDay 7 8 False 0 False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False QtyAtOneTime 7 8 False 0 False NoOfTimesInOneDay 7 8 False 0 False Index Code EndOfTable TableName:@MedicineQty QtyCode 10 10 True False Qty 7 8 False False MedicineCode 10 10 True False TimesCode 10 10 True False AgeGroupFrom 7 8 False False AgeGroupTo 7 8 False False DayFrom 3 2 False False DayTo 3 2 False False Days 3 2 False False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False Index EndOfTable TableName:@MedicineQtyMeasurements Code 10 10 True False Name 10 50 True False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False Countable 1 1 False False ShortName 10 10 True False Index EndOfTable TableName:@MedicineTimesToTake Code 10 10 True False Name 10 50 True False ViewOrder 3 2 False False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False Index EndOfTable TableName:@MedicineType Code 10 10 True False Name 10 50 True False ShortName 10 10 True False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False QtyCode 10 10 True False Index EndOfTable TableName:@MedicineWhenToTake Code 10 10 True False Name 10 100 True False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False Index EndOfTable TableName:@MInsuranceCompany Code 10 10 True False Name 10 100 True False Index EndOfTable TableName:@Mqty Code 10 10 True False Name 10 50 True False ShortName 10 10 True False UserName 10 12 True False UserCode 10 10 True False Index EndOfTable TableName:@MSysAccessObjects Data 9 241 False False ID 4 4 False False Index EndOfTable TableName:@MSysACEs Index EndOfTable TableName:@MSysModules Index EndOfTable TableName:@MSysModules2 Flags 4 4 False False Form 11 0 False False Module 11 0 False False Name 10 255 False False ReplicationVersion 4 4 False False Type 4 4 False False TypeInfo 11 0 False False Version 4 4 False False Index EndOfTable TableName:@MSysObjects Index EndOfTable TableName:@MSysQueries Index EndOfTable TableName:@MSysRelationships Index EndOfTable TableName:@NoticeBoard Code 10 10 True False FromCode 10 10 True False ToCode 10 10 True False Message 10 150 True False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False Index EndOfTable TableName:@OperationDistribution BillNo 10 10 True False PatientCode 10 10 True False OperationAmount 7 8 False False AssistantDoctor 1 1 False False MainDoctor 1 1 False False Amount 7 8 False False SlNo 3 2 False False DoctorCode 10 10 True False FYear 10 4 True False Index EndOfTable TableName:@Organisation Code 10 10 True False Name 10 50 True False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False Index Code UserCode EndOfTable TableName:@OutDoor ReceiptByCode 10 10 True False Year 10 4 True False SNoYear 10 10 True False Name 10 50 True False Sex 10 1 True False FHName 10 50 True False PhoneNo 10 30 True False Add1 10 40 True False Add2 10 40 True False Add3 10 40 True False UserCode 10 10 True False UserName 10 12 True False Procedure 1 1 False False Consult 1 1 False False Day 10 2 True False Month 10 2 True False SNoMonth 10 5 True False RefDr 10 10 True False salutation 10 10 True True AgePeriod 10 10 True False TimeHR 10 2 True False TimeMin 10 2 True False PatientCode 10 10 True False OldPatientCode 10 10 True False DiseaseCode 10 10 True "" False ClientCode 10 10 True "" False Age 10 5 True False FYear 10 4 True False UnitCode 10 10 True False CasteCode 10 10 True False CardNo 10 40 True False Nationality 10 30 True False RegNo 10 10 True False ReceiptByCode 10 10 True False Index OldPatientCode PatientCode SNoYear EndOfTable TableName:@OutDoorCategory Code 10 10 True False Name 10 50 True False Fees 7 8 False False FormForFreeMedicine 1 1 False False Free 1 1 False False PrintFreeForm 1 1 False False CardNo 1 1 False False Index Code EndOfTable TableName:@OutDoorConsult SnoYear 10 10 True False SNoOldYear 10 10 True False Day 10 2 True False Month 10 2 True False Year 10 4 True False BillNo 10 10 True False RefDr 10 10 True False ConDr 10 10 True False ConFees 6 4 False False RegFees 6 4 False False FeesUserCode 10 10 True False FeesUserName 10 12 True False UserCode 10 10 True False UserName 10 12 True False SNoMonth 10 5 True False Remarks 10 100 True False Discount 7 8 False False TimeMin 2 1 False False TimeHr 2 1 False False PatientCode 10 10 True False OldPatientCode 10 10 True False FYear 10 4 True False Index OldPatientCode PatientCode EndOfTable TableName:@OutDoorDiscount SLNo 10 10 True False OPDNo 10 10 True False Amount 7 8 False False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False Remark 10 50 True False UserName 10 12 True False UserCode 10 10 True False PatientCode 10 10 True False FYear 10 4 True False Index PatientCode EndOfTable TableName:@OutDoorInvestigationOnly Year 10 4 True False SNoYear 10 10 True False Name 10 50 True False Sex 10 1 True False FHName 10 50 True False Add1 10 40 True False Add2 10 40 True False Add3 10 40 True False UserCode 10 10 True False UserName 10 12 True False Procedure 1 1 False False Consult 1 1 False False Day 10 2 True False Month 10 2 True False SNoMonth 10 5 True False RefDr 10 10 True False salutation 10 10 True False AgePeriod 10 10 True False TimeHR 10 2 True False TimeMin 10 2 True False PatientCode 10 10 True False OldPatientCode 10 10 True False DiseaseCode 10 10 True False ClientCode 10 10 True "" False Age 10 5 True False FYear 10 4 True False PhoneNo 10 30 True False Nationality 10 30 True False RegNo 10 10 True False ReceiptByCode 10 10 True False Index OldPatientCode PatientCode SNoYear EndOfTable TableName:@OutDoorInvestigationOnlyDiscount SLNo 10 10 True False OPDNo 10 10 True False Amount 7 8 False False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False Remark 10 50 True False UserName 10 12 True False UserCode 10 10 True False PatientCode 10 10 True False FYear 10 4 True False Index PatientCode EndOfTable TableName:@OutDoorInvestigationOnlyRefund SlNo 10 10 True False OPDNo 10 10 True False Amount 7 8 False False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False Remark 10 50 True False UserName 10 12 True False UserCode 10 10 True False PatientCode 10 10 True False FYear 10 4 True False Index PatientCode EndOfTable TableName:@OutDoorProc SNoYear 10 10 True False Printed 1 1 False False Year 10 4 True False FeesUserCode 10 10 True False FeesUserName 10 12 True False SNoMonth 10 5 True False Month 10 2 True False Day 10 50 True False BillNo 10 10 True False UserCode 10 12 True False UserName 10 12 True False SnoOldYear 10 10 True False Remarks 10 100 True False BillFees 6 4 False False ConDr 10 10 True False Discount 7 8 False False PatientCode 10 10 True False OldPatientCode 10 10 True False FYear 10 4 True False ReceiptByCode 10 10 True False Index OldPatientCode PatientCode SNoYear EndOfTable TableName:@OutDoorProcBill SnoYear 10 10 True False ProcCode 10 10 True False ProcFees 6 4 False False UserCode 10 12 True False UserName 10 10 True False SlNo 3 2 False False TypeCode 3 2 False False ShowedToDoctor 1 1 False False FYear 10 4 True False PatientCode 10 10 True False DiagCode 10 10 True False Index PatientCode SnoYear EndOfTable TableName:@OutDoorProcBillC SnoYear 10 10 True False ProcCode 10 10 True False ProcFees 6 4 False False UserCode 10 12 True False UserName 10 10 True False SlNo 3 2 False False TypeCode 3 2 False False ShowedToDoctor 1 1 False False FYear 10 4 True False PatientCode 10 10 True False Index PatientCode SnoYear EndOfTable TableName:@OutDoorProcBillInvestigationOnly SnoYear 10 10 True False ProcCode 10 10 True False ProcFees 6 4 False False UserCode 10 12 True False UserName 10 10 True False SlNo 3 2 False False TypeCode 3 2 False False ShowedToDoctor 1 1 False False FYear 10 4 True False PatientCode 10 10 True False DiagCode 10 10 True False Index PatientCode SnoYear EndOfTable TableName:@OutDoorProcC SNoYear 10 10 True False Printed 1 1 False False Year 10 4 True False FeesUserCode 10 10 True False FeesUserName 10 12 True False SNoMonth 10 5 True False Month 10 2 True False Day 10 50 True False BillNo 10 10 True False UserCode 10 12 True False UserName 10 12 True False SnoOldYear 10 10 True False Remarks 10 100 True False BillFees 6 4 False False ConDr 10 10 True False Discount 7 8 False False PatientCode 10 10 True False OldPatientCode 10 10 True False FYear 10 4 True False Index OldPatientCode PatientCode SNoYear EndOfTable TableName:@OutDoorProcInvestigationOnly SNoYear 10 10 True False Printed 1 1 False False Year 10 4 True False FeesUserCode 10 10 True False FeesUserName 10 12 True False SNoMonth 10 5 True False Month 10 2 True False Day 10 50 True False BillNo 10 10 True False UserCode 10 12 True False UserName 10 12 True False SnoOldYear 10 10 True False Remarks 10 100 True False BillFees 6 4 False False ConDr 10 10 True False Discount 7 8 False False PatientCode 10 10 True False OldPatientCode 10 10 True False FYear 10 4 True False ReceiptByCode 10 10 True False Index OldPatientCode PatientCode SNoYear EndOfTable TableName:@OutDoorRefund SlNo 10 10 True False OPDNo 10 10 True False Amount 7 8 False False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False Remark 10 50 True False UserName 10 12 True False UserCode 10 10 True False PatientCode 10 10 True False FYear 10 4 True False Index PatientCode EndOfTable TableName:@PresAdvice AdviceCode 10 10 True False PatientCode 10 10 True False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False SlNo 3 2 False 0 False UserName 10 12 True False UserCode 10 10 True False Index DailyCheckUpcode PatientCode UserCode EndOfTable TableName:@PresDailyCheckup DailyCheckUpcode 10 10 True False PatientCode 10 10 True False Result 10 50 True False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False SlNo 3 2 False 0 False UserName 10 12 True False UserCode 10 10 True False Index PatientCode PresDailyCheckUpcode UserCode EndOfTable TableName:@PresDiagnosis DiagCode 10 10 True False PatientCode 10 10 True False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False SlNo 3 2 False 0 False UserName 10 12 True False UserCode 10 10 True False Index DailyCheckUpcode PatientCode UserCode EndOfTable TableName:@PresExamination PatientCode 10 10 True False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False SlNo 3 2 False 0 False ExMainCode 10 10 True False ExSubCode 10 10 True False ExaminationCode 10 10 True False FromWhen 10 100 True False UserName 10 12 True False UserCode 10 10 True False ExaminationText 10 200 True False Index ExaminationCode ExMainCode ExSubCode PatientCode UserCode EndOfTable TableName:@PresMedicine MedicineCode 10 10 True False PatientCode 10 10 True False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False SlNo 3 2 False 0 False WhenToTakeCode 10 10 True False HowToTakeCode 10 10 True False Days 3 2 False 0 False TotalMedicine 7 8 False 0 False UserName 10 12 True False UserCode 10 10 True False Index DailyCheckUpcode HowToTakeCode PatientCode UserCode WhenToTakeCode EndOfTable TableName:@PresOther PatientCode 10 10 True False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False ShowDaysAfter 3 2 False 0 False ShowDateDay 10 2 True False ShowDateMonth 10 2 True False ShowDateYear 10 4 True False UserName 10 12 True False UserCode 10 10 True False Index PatientCode UserCode EndOfTable TableName:@PresTest TestCode 10 10 True False PatientCode 10 10 True False Result 10 100 True False DateDay 10 2 True False DateMonth 10 2 True False DateYear 10 4 True False SlNo 3 2 False 0 False DiagCode 10 10 True False UserName 10 12 True False UserCode 10 10 True False Index DailyCheckUpcode DiagCode PatientCode UserCode EndOfTable TableName:@ReportPrescription SlNo 3 2 False 0 False Heading 10 50 True " " False Description 10 200 True " " False SubDesc1 10 50 True " " False SubDesc2 10 50 True " " False PatientCode 10 10 True " " False Index EndOfTable TableName:@Room Code 10 10 True False Name 10 40 True False ShortName 10 6 True False RoomTypeCode 10 10 True False Rate 7 8 False False RoomNo 2 1 False False UserName 10 12 True False UserCode 10 10 True False NursingRate 7 8 False 0 False DoctorRate 7 8 False 0 False RoomNoLastNo 2 1 False False Index Code UserCode EndOfTable TableName:@RoomCharges PatientCode 10 10 True False Roomcode 10 10 True False DateInDate 10 2 True False DateInMonth 10 2 True False DateInYear 10 4 True False DateOutMonth 10 2 True False DateOutDate 10 2 True False DateOutYear 10 4 True False TimeInHr 2 1 False False TimeInMin 2 1 False False TimeOutHr 2 1 False False TimeOutMin 2 1 False False RoomRate 7 8 False False UserCode 10 10 True False UserName 10 12 True False RoomAmount 7 8 False 0 False Discharge 1 1 False True False ChangeRoom 1 1 False False False CalculatedDays 7 8 False 0 False SlNo 3 2 False 0 False Final 1 1 False False Year 10 50 True False NursingRate 7 8 False 0 False DoctorRate 7 8 False 0 False NursingAmount 7 8 False 0 False DoctorAmount 7 8 False 0 False Index EndOfTable TableName:@RoomType Code 10 10 True False Name 10 40 True False Rate 7 8 False False ShortName 10 6 True False UserName 10 12 True False UserCode 10 10 True False Tag 1 1 False False NursingRate 7 8 False 0 False DoctorRate 7 8 False 0 False Index code UserCode EndOfTable TableName:@TakeYear YearOfOperation 10 4 True False StartDate 10 2 True False StartMonth 10 2 True False StartYear 10 4 True False EndDate 10 2 True False EndMonth 10 2 True False EndYear 10 4 True False Index EndOfTable TableName:@User Code 10 10 True False Name 10 50 True False Add1 10 40 True False Add2 10 40 True False Add3 10 40 True False Pin 10 6 True False Phone 10 20 True False Fax 10 20 True False EMail 10 30 True False Add4 10 40 True False UserName 10 12 True False UserPassWord 10 12 True False Tag 1 1 False False LoggedIn 1 1 False False SavingOutdoor 1 1 False False OrderSavingOutDoor 4 4 False False Index Code EndOfTable TableName:@UserRights UserCode 10 10 True False ViewR 1 1 False False AddR 1 1 False False EditR 1 1 False False DeleteR 1 1 False False FacilityCode 10 5 True False Index EndOfTable TableName:@UserRightsOther Discharge 1 1 False False DischargeTicket 1 1 False False ViewFinalBill 1 1 False False PrintFinalBill 1 1 False False UserCode 10 10 True False ViewRoomCharge 1 1 False False ModifyRoomCharge 1 1 False False Index EndOfTable TableName:@Vaccination Code 10 10 True False Name 10 50 True False Amount 6 4 False False Tag 1 1 False False UserName 10 12 True False UserCode 10 10 True False AgeCaption 10 50 True False VaccineAge 10 5 True False AgePeriodDays 1 1 False False AgePeriodMonths 1 1 False False AgePeriodYears 1 1 False False VaccineTypeRegular 1 1 False False VaccineTypeOptional 1 1 False False Index Code UserCode EndOfTable EndOfDatabase