Skip to content

Instantly share code, notes, and snippets.

@swvitaliy

swvitaliy/mdlg_dbmap.yaml

Created December 9, 2021 13:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save swvitaliy/e57b941cb1353c34cc1d2148a3cce6d2 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save swvitaliy/e57b941cb1353c34cc1d2148a3cce6d2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment