mdlg_dbmap.yaml

DoctorScheduleExclusion:
  table: PL_EXCL
  properties:
    Id:
      column: PL_EXCL_ID
    OwnerType:
      column: OWNER_TYPE
    OwnerId:
      column: OWNER_ID
    Name:
      column: NAME
    ExclMemo:
      column: EXCL_MEMO
    UseTime:
      column: USE_TIME
    FromDate:
      column: FROM_DATE
    FromTime:
      column: FROM_TIME
    ToDate:
      column: TO_DATE
    ToTime:
      column: TO_TIME
    PlLegId:
      column: PL_LEG_ID
    DoctorId:
      column: PL_SUBJ_ID
    PlPatgrId:
      column: PL_PATGR_ID
    DateStart:
      column: DATE_START
    DateEnd:
      column: DATE_END
    CreateDateTime:
      column: CREATE_DATE_TIME
    ModifyDateTime:
      column: MODIFY_DATE_TIME

FmOrg:
  table: FM_ORG
  properties:
    Id:
      column: FM_ORG_ID
    Code:
      column: CODE
    Label:
      column: LABEL
    OrgType:
      column: ORG_TYPE
    KrnCreateUserId:
      column: KRN_CREATE_USER_ID
    KrnModifyUserId:
      column: KRN_MODIFY_USER_ID
    KrnCreateDate:
      column: KRN_CREATE_DATE
    KrnModifyDate:
      column: KRN_MODIFY_DATE
    KrnCreateDatabaseId:
      column: KRN_CREATE_DATABASE_ID
    KrnModifyDatabaseId:
      column: KRN_MODIFY_DATABASE_ID

LifeAnamnez:
  table: DATA_LIFE_ANAMNESIS
  properties:
    Id:
      column: DATA287_ID
    DateConsultation:
      column: DATE_CONSULTATION
    MedHistoryId:
      column: MOTCONSU_ID
    Itog:
      column: ITOG

Specialiation:
  table: SPECIALISATION
  properties:
    Id:
      column: SPECIALISATION_ID
    Name:
      column: NAME

DirAnsw:
  table: DIR_ANSW
  properties:
    Id:
      column: DIR_ANSW_ID
    PatdirecId:
      column: PATDIREC_ID
    AnswState:
      column: ANSW_STATE
    PlaneDate:
      column: PLANE_DATE
    PlanningId:
      column: PLANNING_ID
    KrnCreateUserId:
      column: KRN_CREATE_USER_ID
    KrnModifyUserId:
      column: KRN_MODIFY_USER_ID
    KrnCreateDate:
      column: KRN_CREATE_DATE
    KrnModifyDate:
      column: KRN_MODIFY_DATE
    KrnCreateDatabaseId:
      column: KRN_CREATE_DATABASE_ID
    KrnModifyDatabaseId:
      column: KRN_MODIFY_DATABASE_ID
    CancelPay:
      column: CANCEL_PAY

PatientMedcard:
  table: DATA_NUMBER_KART_PATIENTS
  properties:
    Id:
      column: DATA_NUMBER_KART_PATIENTS_ID
    PatientId:
      column: PATIENTS_ID
    MedcardNumber:
      column: NOMER_KARTY

Planning:
  table: PLANNING
  properties:
    Id:
      column: PLANNING_ID
    DoctorId:
      column: PL_SUBJ_ID
    DateCons:
      column: DATE_CONS
    Time:
      column: HEURE
    Duration:
      column: DUREE
    PatientsId:
      column: PATIENTS_ID
    Surname:
      column: NOM
    Name:
      column: PRENOM
    Commentaire:
      column: COMMENTAIRE
    Color:
      column: COLOR
    Font:
      column: FONT
    DurationText:
      column: DUREE_TEXT
    PatientArrivee:
      column: PATIENT_ARRIVEE
    PlGenerId:
      column: PL_GENER_ID
    ServiceId:
      column: PL_EXAM_ID
    MedecinsCreatorId:
      column: MEDECINS_CREATOR_ID
    MedecinsModifyId:
      column: MEDECINS_MODIFY_ID
    CouleurMacro:
      column: COULEUR_MACRO
    Hl7AccessionNumber:
      column: HL7_ACCESSION_NUMBER
    Patronyme:
      column: PATRONYME
    Cancelled:
      column: CANCELLED
    DirAnswLinked:
      column: DIR_ANSW_LINKED
    Status:
      column: STATUS
    DateStart:
      column: DATE_START
    DateEnd:
      column: DATE_END
    Lieu:
      column: LIEU
    PlCabinetsId:
      column: PL_CABINETS_ID
    CreateDateTime:
      column: CREATE_DATE_TIME
    ModifyDateTime:
      column: MODIFY_DATE_TIME
    KrnCreateUserId:
      column: KRN_CREATE_USER_ID
    KrnModifyUserId:
      column: KRN_MODIFY_USER_ID
    KrnCreateDate:
      column: KRN_CREATE_DATE
    KrnModifyDate:
      column: KRN_MODIFY_DATE
    DateCancel:
      column: DATE_CANCEL
    SourcePlanningId:
      column: SOURCE_PLANNING_ID

MedHistory:
  table: MOTCONSU
  properties:
    Id:
      column: MOTCONSU_ID
    PatientId:
      column: PATIENTS_ID
    PlanningId:
      column: PLANNING_ID
    CreateDateTime:
      column: CREATE_DATE_TIME
    DateConsultation:
      column: DATE_CONSULTATION
    FmDepId:
      column: FM_DEP_ID
    Duration:
      column: CONS_DURATION
    Conclusion:
      column: CONCLUSION

PrescriptionsAndRecommendations:
  table: DATA_PRESCR_AND_RECOMMEND
  properties:
    Id:
      column: DATA24_ID
    MedHistoryId:
      column: MOTCONSU_ID
    Recommendations:
      column: REKOMENDACII
    PrescriptionAndRecommendations:
      column: NAZNAHENIQ_I_REKOMENDACII
    MedikamentoznayaTerapiya:
      column: MEDIKAMENTOZNAQ_TERAPIQ
    PatientId:
      column: PATIENTS_ID
    DateCons:
      column: DATE_CONSULTATION
    KrnCreateDate:
      column: KRN_CREATE_DATE

DoctorScheduleExclusionLegend:
  table: PL_LEG
  properties:
    Id:
      column: PL_LEG_ID
    Name:
      column: NAME

Hysterosalpingograph:
  table: DATA_ART_HYSTEROSALPING
  properties:
    Id:
      column: DATA_PMT_ART7_ID
    PatientId:
      column: PATIENTS_ID
    DateCons:
      column: DATE_CONSULTATION
    MedHistoryId:
      column: MOTCONSU_ID
    SostoyanieMatki:
      column: SOSTOYANIE_MATKI
    Gidrosonografiya:
      column: GIDROSONOGRAFIYA
    Kommentariy:
      column: KOMMENTARIY
    SvobodnoProhodimaPr:
      column: SVOBODNO_PROHODIMA_PR
    ZatrudnenoProhodimaPr:
      column: ZATRUDNENO_PROHODIMA_PR
    NeprohodimaVIstmichesko:
      column: NEPROHODIMA_V_ISTMICHESKO
    NeprohodimaVAmpulyarnom:
      column: NEPROHODIMA_V_AMPULYARNOM
    NeprohodimaVIntersticia:
      column: NEPROHODIMA_V_INTERSTICIA
    MeshotchatoeObrazovanie:
      column: MESHOTCHATOE_OBRAZOVANIE_
    PeritubarnyeSpaykiPr:
      column: PERITUBARNYE_SPAYKI_PR
    SvobodnoProhodimaLv:
      column: SVOBODNO_PROHODIMA_LV
    ZatrudnenoProhodimaLv:
      column: ZATRUDNENO_PROHODIMA_LV
    NeprohodimaVIstmichesk1:
      column: NEPROHODIMA_V_ISTMICHESK1
    NeprohodimaVAmpulyarno1:
      column: NEPROHODIMA_V_AMPULYARNO1
    NeprohodimaVInterstici1:
      column: NEPROHODIMA_V_INTERSTICI1
    MeshotchatoeObrazovanie1:
      column: MESHOTCHATOE_OBRAZOVANIE1
    PeritubarnyeSpaykiLv:
      column: PERITUBARNYE_SPAYKI_LV
    PorokRazvitiya:
      column: POROK_RAZVITIYA
    DefektZapolneniya:
      column: DEFEKT_ZAPOLNENIYA

FmDep:
  table: FM_DEP
  properties:
    Id:
      column: FM_DEP_ID
    MainOrgId:
      column: MAIN_ORG_ID

Patient:
  table: PATIENTS
  properties:
    Id:
      column: PATIENTS_ID
    Nom:
      column: NOM
    Prenom:
      column: PRENOM
    Patronyme:
      column: PATRONYME
    Pol:
      column: POL
    MobilTelefon:
      column: MOBIL_TELEFON
    Tel:
      column: TEL
    Address:
      column: ADRES_FAKTIHESKIJ
    MedcardNumber:
      column: NOMER_MEDICISKOJ_KART
    CreateDateTime:
      column: CREATE_DATE_TIME
    ModifyDateTime:
      column: MODIFY_DATE_TIME
    MedecinsId:
      column: MEDECINS_ID
    BirthDate:
      column: NE_LE
    KrnCreateUserId:
      column: KRN_CREATE_USER_ID
    KrnModifyUserId:
      column: KRN_MODIFY_USER_ID
    KrnCreateDate:
      column: KRN_CREATE_DATE
    KrnModifyDate:
      column: KRN_MODIFY_DATE

PlanningUserExt:
  table: PLANNING_USER_EXT
  properties:
    Id:
      column: PLANNING_USER_EXT_ID
    PlanningId:
      column: PLANNING_ID
    KrnCreateDatabaseId:
      column: KRN_CREATE_DATABASE_ID
    KrnModifyDatabaseId:
      column: KRN_MODIFY_DATABASE_ID
    KrnCreateDate:
      column: KRN_CREATE_DATE
    KrnModifyDate:
      column: KRN_MODIFY_DATE

Service:
  table: PL_EXAM
  properties:
    Id:
      column: PL_EXAM_ID
    Name:
      column: NAME
    Duree:
      column: DUREE
    Color:
      column: COLOR
    Font:
      column: FONT
    RecPlanning:
      column: REC_PLANNING

Diagnoz:
  table: DATA_DIAGNOSIS
  properties:
    Id:
      column: DATA22_ID
    MedHistoryId:
      column: MOTCONSU_ID
    Diagnos:
      column: DIAGNOZ

Doctor:
  table: PL_SUBJ
  properties:
    Id:
      column: PL_SUBJ_ID
    Name:
      column: NAME
    PlExamId:
      column: PL_EXAM_ID
    PlAgendId1:
      column: PL_AGEND_ID1
    PlAgendId2:
      column: PL_AGEND_ID2
    PlAgendId3:
      column: PL_AGEND_ID3
    PlAgendId4:
      column: PL_AGEND_ID4
    FmIntorgId:
      column: FM_INTORG_ID
    MedecinsId:
      column: MEDECINS_ID
    SpecialisationId:
      column: SPECIALISATION_ID

Medecins:
  table: MEDECINS
  properties:
    Id:
      column: MEDECINS_ID
    FmOrgId:
      column: FM_ORG_ID

Ekg:
  table: DATA_FUNC_DIAG_ECG
  properties:
    Id:
      column: DATA50_ID
    Ritm:
      column: RITM
    ChastotaSokrashenii:
      column: HASTOTA_SOKRAHENIJ
    Eos:
      column: EOS
    IntervalPQ:
      column: INTERVAL_P_Q
    Qrs:
      column: QRS
    ProchieIzmeneniya:
      column: PROHIE_IZMENENIQ
    Zaklucheniye:
      column: ZAKLYHENIE
    Result:
      column: ELEKTROKARDIOGRAFIHESKOE_
    Qrstc:
      column: QRSTC
    Rr:
      column: RR
    UgolAlfa:
      column: UGOL_AL_FA
    PerehodnayaZona:
      column: PEREHODNAYA_ZONA
    Qt:
      column: QT
    Qtc:
      column: QTC
    DeltaVolna:
      column: DEL_TA_VOLNA
    Rekomendacii:
      column: RECOMENDACII
    MedHistoryId:
      column: MOTCONSU_ID
    PatientId:
      column: PATIENTS_ID
    DateCons:
      column: DATE_CONSULTATION

Patdirec:
  table: PATDIREC
  properties:
    Id:
      column: PATDIREC_ID
    MedecinsCreatorId:
      column: MEDECINS_CREATOR_ID
    PatientsId:
      column: PATIENTS_ID
    PlExamId:
      column: PL_EXAM_ID
    Quantity:
      column: QUANTITY
    QuantityDone:
      column: QUANTITY_DONE
    Description:
      column: DESCRIPTION
    Commentaire:
      column: COMMENTAIRE
    Cancelled:
      column: CANCELLED
    FmOrgId:
      column: FM_ORG_ID
    FmIntorgId:
      column: FM_INTORG_ID
    Standarted:
      column: STANDARTED
    Cito:
      column: CITO
    CreateDateTime:
      column: CREATE_DATE_TIME
    ModifyDateTime:
      column: MODIFY_DATE_TIME
    KrnCreateUserId:
      column: KRN_CREATE_USER_ID
    KrnModifyUserId:
      column: KRN_MODIFY_USER_ID
    KrnCreateDate:
      column: KRN_CREATE_DATE
    KrnModifyDate:
      column: KRN_MODIFY_DATE
    DirState:
      column: DIR_STATE
    BeginDateTime:
      column: BEGIN_DATE_TIME
    QuantityCancel:
      column: QUANTITY_CANCEL
    Manipulative:
      column: MANIPULATIVE
    NeedOpenEditor:
      column: NEED_OPEN_EDITOR
    KeepIntakeTime:
      column: KEEP_INTAKE_TIME
    KrnCreateDatabaseId:
      column: KRN_CREATE_DATABASE_ID
    KrnModifyDatabaseId:
      column: KRN_MODIFY_DATABASE_ID
    QuantityPlanned:
      column: QUANTITY_PLANNED
    PlanningCrId:
      column: PLANNING_CR_ID
    PatdirecKind:
      column: PATDIREC_KIND
    AutoCito:
      column: AUTO_CITO