-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdb_init.R
1561 lines (1480 loc) · 56.7 KB
/
db_init.R
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
library(RSQLite)
library(tibble)
# setwd("~/zarathu/eCRF-SMCcath")
# Create a connection object with SQLite
conn <- dbConnect(
RSQLite::SQLite(),
"data/data.sqlite3"
)
# Create a query to prepare the 'mtcars' table with additional 'uid', 'id',
# & the 4 created/modified columns
create_rct_query <- "CREATE TABLE rct (
-- Initial Add
pid TEXT PRIMARY KEY,
'Group' TEXT,
Center TEXT,
DM TEXT,
AMI_Type TEXT,
-- Demographics --
Initial TEXT,
Birthday DATE,
Age TEXT,
Sex TEXT,
Agree_Date DATE,
Index_PCI_Date DATE,
Withdrawal TEXT,
SGLT TEXT,
Withdrawal_date DATE,
Withdrawal_reason TEXT,
-- Admission --
Date_adm DATE,
Height TEXT,
Weight TEXT,
BMI TEXT,
BSA_adm TEXT,
SBP_adm TEXT,
DBP_adm TEXT,
HR_adm TEXT,
Diagnosis_adm TEXT,
CCS_adm TEXT,
BC_adm TEXT,
Diagnosis_other_adm TEXT,
Diagnosis_comment_adm TEXT,
HTN TEXT,
Diabetes_adm TEXT,
Diabetes_detail_adm TEXT,
Hld_adm TEXT,
Smoking TEXT,
FHC_adm TEXT,
CRF_adm TEXT,
PCI_adm TEXT,
PCABG_adm TEXT,
PCVA_adm TEXT,
PCHF_adm TEXT,
Pvd_adm TEXT,
PNTB_adm TEXT,
TMT_adm TEXT,
TMT_Date_adm DATE,
TMT_detail_adm TEXT,
MSPECT_adm TEXT,
MSPECT_Date_adm DATE,
MSPECT_detail_adm TEXT,
APET_adm TEXT,
APET_Date_adm DATE,
APET_detail_adm TEXT,
CMR_adm TEXT,
CMR_Date_adm DATE,
CMR_detail_adm TEXT,
EEcho_adm TEXT,
EEcho_Date_adm DATE,
EEcho_detail_adm TEXT,
Corona_adm TEXT,
Corona_date_adm DATE,
Corona_BB_adm TEXT,
Corona_Nitrate_adm TEXT,
EchoCG_adm TEXT,
EchoCG_date_adm DATE,
EchoCG_LVEF_adm TEXT,
EchoCG_LVWMA_adm TEXT,
ECG_Rhythm_adm TEXT,
ECG_Rhythm_others_adm TEXT,
Lab_Date_adm DATE,
WBC_adm TEXT,
TC_adm TEXT,
Hb_adm TEXT,
TG_adm TEXT,
HDL_adm TEXT,
Platelet_adm TEXT,
LDL_adm TEXT,
BUN_adm TEXT,
Cr_adm TEXT,
FG_adm TEXT,
MDRD_adm TEXT,
HbA1C_adm TEXT,
AST_adm TEXT,
hs_CRP_adm TEXT,
ALT_adm TEXT,
NT_Pro_BNP_adm TEXT,
hCG_adm TEXT,
BCK_adm TEXT,
PCK_adm TEXT,
BCKMB_adm TEXT,
PCKMB_adm TEXT,
BTroT_adm TEXT,
PTroT_adm TEXT,
Aspirin_adm TEXT,
Clopidogrel_adm TEXT,
Prasugrel_adm TEXT,
Ticagrelor_adm TEXT,
Nicorandil_adm TEXT,
Wafarin_adm TEXT,
NOAC_adm TEXT,
NOAC_name_adm TEXT,
NOAC_dose_adm TEXT,
BB_adm TEXT,
BB_name_adm TEXT,
BB_dose_adm TEXT,
DPP4_adm TEXT,
DPP4_name_adm TEXT,
DPP4_dose_adm TEXT,
Metformin_adm TEXT,
Metformin_dose_adm TEXT,
Sulf_adm TEXT,
Sulf_name_adm TEXT,
Sulf_dose_adm TEXT,
Thia_adm TEXT,
Thia_name_adm TEXT,
Thia_dose_adm TEXT,
GLP_adm TEXT,
GLP_name_adm TEXT,
GLP_dose_adm TEXT,
Alpha_adm TEXT,
Alpha_name_adm TEXT,
Alpha_dose_adm TEXT,
Statin_adm TEXT,
Statin_name_adm TEXT,
Statin_dose_adm TEXT,
ACE_adm TEXT,
ACE_name_adm TEXT,
ACE_dose_adm TEXT,
Nitrate_adm TEXT,
Calcium_adm TEXT,
Calcium_name_adm TEXT,
Calcium_dose_adm TEXT,
Trimetazidine_adm TEXT,
Insulin_adm TEXT,
Echo_Date_adm DATE,
LVIDs_adm TEXT,
LVEDV_adm TEXT,
LVESV_adm TEXT,
LA_adm TEXT,
LAVI_adm TEXT,
A_adm TEXT,
EA_adm TEXT,
DT_adm TEXT,
ep_adm TEXT,
ap_adm TEXT,
Eep_adm TEXT,
RVSP_adm TEXT,
RAP_adm TEXT,
LVEF_adm TEXT,
Strain_adm TEXT,
CMR_Date_POST_adm DATE,
-- Angiographics
Date_ang DATE,
Aspirin_ang TEXT,
Aspirin_loading_ang TEXT,
Aspirin_detail_ang TEXT,
Clopidogrel_ang TEXT,
Clopidogrel_loading_ang TEXT,
Clopidogrel_detail_ang TEXT,
Prasugrel_ang TEXT,
Prasugrel_loading_ang TEXT,
Prasugrel_detail_ang TEXT,
Ticagrelor_ang TEXT,
Ticagrelor_loading_ang TEXT,
Ticagrelor_detail_ang TEXT,
Procedure_type_ang TEXT,
Procedure_dose_ang TEXT,
Disease_extent_ang TEXT,
Left_main_ang TEXT,
start_hour_ang TEXT,
start_min_ang TEXT,
end_hour_ang TEXT,
end_min_ang TEXT,
time_ang TEXT,
Catheter_diagnostic_ang TEXT,
Catheter_guiding_ang TEXT,
staged_PCI_ang TEXT,
stagedPCI_count_ang TEXT,
Gp_ang TEXT,
Gp_detail_ang TEXT,
Cul_cnt_ang TEXT,
Non_Cul_cnt_ang TEXT,
stagedPCI_1_ang DATE,
stagedPCI_2_ang DATE,
stagedPCI_1_procedure_ang TEXT,
stagedPCI_2_procedure_ang TEXT,
stagedPCI_1_procedure_dose_ang TEXT,
stagedPCI_2_procedure_dose_ang TEXT,
start_hour_PCI_1_ang TEXT,
start_hour_PCI_2_ang TEXT,
start_min_PCI_1_ang TEXT,
start_min_PCI_2_ang TEXT,
end_hour_PCI_1_ang TEXT,
end_hour_PCI_2_ang TEXT,
end_min_PCI_1_ang TEXT,
end_min_PCI_2_ang TEXT,
time_PCI_1_ang TEXT,
time_PCI_2_ang TEXT,
Diagnostic_PCI_1_ang TEXT,
Diagnostic_PCI_2_ang TEXT,
Guiding_PCI_1_ang TEXT,
Guiding_PCI_2_ang TEXT,
-- Culprit1
Vessel_cul1 TEXT,
Lesion_cul1 TEXT,
Lesion_segment_1_cul1 TEXT,
Lesion_VeS_1_cul1 TEXT,
Lesion_segment_2_cul1 TEXT,
Lesion_VeS_2_cul1 TEXT,
Lesion_segment_3_cul1 TEXT,
Lesion_VeS_3_cul1 TEXT,
Lesion_Type_cul1 TEXT,
FFR_cul1 TEXT,
FFR_pre_cul1 TEXT,
FFR_post_cul1 TEXT,
Image_cul1 TEXT,
Pre_stent_cul1 TEXT,
Post_stent_cul1 TEXT,
Intervention_cul1 TEXT,
Intervention_cnt_cul1 TEXT,
Intervention1_treat_cul1 TEXT,
Intervention1_segment_cul1 TEXT,
Intervention1_name_cul1 TEXT,
Intervention1_diameter_cul1 TEXT,
Intervention1_length_cul1 TEXT,
Intervention1_pressure_cul1 TEXT,
Intervention2_treat_cul1 TEXT,
Intervention2_segment_cul1 TEXT,
Intervention2_name_cul1 TEXT,
Intervention2_diameter_cul1 TEXT,
Intervention2_length_cul1 TEXT,
Intervention2_pressure_cul1 TEXT,
Intervention3_treat_cul1 TEXT,
Intervention3_segment_cul1 TEXT,
Intervention3_name_cul1 TEXT,
Intervention3_diameter_cul1 TEXT,
Intervention3_length_cul1 TEXT,
Intervention3_pressure_cul1 TEXT,
Intervention4_treat_cul1 TEXT,
Intervention4_segment_cul1 TEXT,
Intervention4_name_cul1 TEXT,
Intervention4_diameter_cul1 TEXT,
Intervention4_length_cul1 TEXT,
Intervention4_pressure_cul1 TEXT,
Intervention5_treat_cul1 TEXT,
Intervention5_segment_cul1 TEXT,
Intervention5_name_cul1 TEXT,
Intervention5_diameter_cul1 TEXT,
Intervention5_length_cul1 TEXT,
Intervention5_pressure_cul1 TEXT,
Intervention6_treat_cul1 TEXT,
Intervention6_segment_cul1 TEXT,
Intervention6_name_cul1 TEXT,
Intervention6_diameter_cul1 TEXT,
Intervention6_length_cul1 TEXT,
Intervention6_pressure_cul1 TEXT,
Intervention7_treat_cul1 TEXT,
Intervention7_segment_cul1 TEXT,
Intervention7_name_cul1 TEXT,
Intervention7_diameter_cul1 TEXT,
Intervention7_length_cul1 TEXT,
Intervention7_pressure_cul1 TEXT,
Intervention8_treat_cul1 TEXT,
Intervention8_segment_cul1 TEXT,
Intervention8_name_cul1 TEXT,
Intervention8_diameter_cul1 TEXT,
Intervention8_length_cul1 TEXT,
Intervention8_pressure_cul1 TEXT,
Intervention9_treat_cul1 TEXT,
Intervention9_segment_cul1 TEXT,
Intervention9_name_cul1 TEXT,
Intervention9_diameter_cul1 TEXT,
Intervention9_length_cul1 TEXT,
Intervention9_pressure_cul1 TEXT,
Intervention10_treat_cul1 TEXT,
Intervention10_segment_cul1 TEXT,
Intervention10_name_cul1 TEXT,
Intervention10_diameter_cul1 TEXT,
Intervention10_length_cul1 TEXT,
Intervention10_pressure_cul1 TEXT,
Intervention_ab_cul1 TEXT,
Intervention_ab_diameter_cul1 TEXT,
Intervention_ab_length_cul1 TEXT,
Intervention_ab_pressure_cul1 TEXT,
Intervention_Rota_cul1 TEXT,
Intervention_cd_cul1 TEXT,
Intervention_cl_cul1 TEXT,
Intervention_SRS_cul1 TEXT,
Intervention_NR_cul1 TEXT,
Intervention_D_cul1 TEXT,
Intervention_AC_cul1 TEXT,
Intervention_O_cul1 TEXT,
Intervention_O_detail_cul1 TEXT,
-- Intervention_P_cul1 TEXT,
Intervention_CPS_cul1 TEXT,
Intervention_CPS_detail_cul1 TEXT,
Trombosuction_cul1 TEXT,
Perforation_cul1 TEXT,
-- Culprit2
Vessel_cul2 TEXT,
Lesion_cul2 TEXT,
Lesion_segment_1_cul2 TEXT,
Lesion_VeS_1_cul2 TEXT,
Lesion_segment_2_cul2 TEXT,
Lesion_VeS_2_cul2 TEXT,
Lesion_segment_3_cul2 TEXT,
Lesion_VeS_3_cul2 TEXT,
Lesion_Type_cul2 TEXT,
FFR_cul2 TEXT,
FFR_pre_cul2 TEXT,
FFR_post_cul2 TEXT,
Image_cul2 TEXT,
Pre_stent_cul2 TEXT,
Post_stent_cul2 TEXT,
Intervention_cul2 TEXT,
Intervention_cnt_cul2 TEXT,
Intervention1_treat_cul2 TEXT,
Intervention1_segment_cul2 TEXT,
Intervention1_name_cul2 TEXT,
Intervention1_diameter_cul2 TEXT,
Intervention1_length_cul2 TEXT,
Intervention1_pressure_cul2 TEXT,
Intervention2_treat_cul2 TEXT,
Intervention2_segment_cul2 TEXT,
Intervention2_name_cul2 TEXT,
Intervention2_diameter_cul2 TEXT,
Intervention2_length_cul2 TEXT,
Intervention2_pressure_cul2 TEXT,
Intervention3_treat_cul2 TEXT,
Intervention3_segment_cul2 TEXT,
Intervention3_name_cul2 TEXT,
Intervention3_diameter_cul2 TEXT,
Intervention3_length_cul2 TEXT,
Intervention3_pressure_cul2 TEXT,
Intervention4_treat_cul2 TEXT,
Intervention4_segment_cul2 TEXT,
Intervention4_name_cul2 TEXT,
Intervention4_diameter_cul2 TEXT,
Intervention4_length_cul2 TEXT,
Intervention4_pressure_cul2 TEXT,
Intervention5_treat_cul2 TEXT,
Intervention5_segment_cul2 TEXT,
Intervention5_name_cul2 TEXT,
Intervention5_diameter_cul2 TEXT,
Intervention5_length_cul2 TEXT,
Intervention5_pressure_cul2 TEXT,
Intervention6_treat_cul2 TEXT,
Intervention6_segment_cul2 TEXT,
Intervention6_name_cul2 TEXT,
Intervention6_diameter_cul2 TEXT,
Intervention6_length_cul2 TEXT,
Intervention6_pressure_cul2 TEXT,
Intervention7_treat_cul2 TEXT,
Intervention7_segment_cul2 TEXT,
Intervention7_name_cul2 TEXT,
Intervention7_diameter_cul2 TEXT,
Intervention7_length_cul2 TEXT,
Intervention7_pressure_cul2 TEXT,
Intervention8_treat_cul2 TEXT,
Intervention8_segment_cul2 TEXT,
Intervention8_name_cul2 TEXT,
Intervention8_diameter_cul2 TEXT,
Intervention8_length_cul2 TEXT,
Intervention8_pressure_cul2 TEXT,
Intervention9_treat_cul2 TEXT,
Intervention9_segment_cul2 TEXT,
Intervention9_name_cul2 TEXT,
Intervention9_diameter_cul2 TEXT,
Intervention9_length_cul2 TEXT,
Intervention9_pressure_cul2 TEXT,
Intervention10_treat_cul2 TEXT,
Intervention10_segment_cul2 TEXT,
Intervention10_name_cul2 TEXT,
Intervention10_diameter_cul2 TEXT,
Intervention10_length_cul2 TEXT,
Intervention10_pressure_cul2 TEXT,
Intervention_ab_cul2 TEXT,
Intervention_ab_diameter_cul2 TEXT,
Intervention_ab_length_cul2 TEXT,
Intervention_ab_pressure_cul2 TEXT,
Intervention_Rota_cul2 TEXT,
Intervention_cd_cul2 TEXT,
Intervention_cl_cul2 TEXT,
Intervention_SRS_cul2 TEXT,
Intervention_NR_cul2 TEXT,
Intervention_D_cul2 TEXT,
Intervention_AC_cul2 TEXT,
Intervention_O_cul2 TEXT,
Intervention_O_detail_cul2 TEXT,
-- Intervention_P_cul2 TEXT,
Intervention_CPS_cul2 TEXT,
Intervention_CPS_detail_cul2 TEXT,
Trombosuction_cul2 TEXT,
Perforation_cul2 TEXT,
-- Non-Culprit1
Vessel_culn1 TEXT,
Lesion_culn1 TEXT,
Lesion_segment_1_culn1 TEXT,
Lesion_VeS_1_culn1 TEXT,
Lesion_segment_2_culn1 TEXT,
Lesion_VeS_2_culn1 TEXT,
Lesion_segment_3_culn1 TEXT,
Lesion_VeS_3_culn1 TEXT,
Lesion_Type_culn1 TEXT,
FFR_culn1 TEXT,
FFR_pre_culn1 TEXT,
FFR_post_culn1 TEXT,
Image_culn1 TEXT,
Pre_stent_culn1 TEXT,
Post_stent_culn1 TEXT,
Intervention_culn1 TEXT,
Intervention_cnt_culn1 TEXT,
Intervention1_treat_culn1 TEXT,
Intervention1_segment_culn1 TEXT,
Intervention1_name_culn1 TEXT,
Intervention1_diameter_culn1 TEXT,
Intervention1_length_culn1 TEXT,
Intervention1_pressure_culn1 TEXT,
Intervention2_treat_culn1 TEXT,
Intervention2_segment_culn1 TEXT,
Intervention2_name_culn1 TEXT,
Intervention2_diameter_culn1 TEXT,
Intervention2_length_culn1 TEXT,
Intervention2_pressure_culn1 TEXT,
Intervention3_treat_culn1 TEXT,
Intervention3_segment_culn1 TEXT,
Intervention3_name_culn1 TEXT,
Intervention3_diameter_culn1 TEXT,
Intervention3_length_culn1 TEXT,
Intervention3_pressure_culn1 TEXT,
Intervention4_treat_culn1 TEXT,
Intervention4_segment_culn1 TEXT,
Intervention4_name_culn1 TEXT,
Intervention4_diameter_culn1 TEXT,
Intervention4_length_culn1 TEXT,
Intervention4_pressure_culn1 TEXT,
Intervention5_treat_culn1 TEXT,
Intervention5_segment_culn1 TEXT,
Intervention5_name_culn1 TEXT,
Intervention5_diameter_culn1 TEXT,
Intervention5_length_culn1 TEXT,
Intervention5_pressure_culn1 TEXT,
Intervention6_treat_culn1 TEXT,
Intervention6_segment_culn1 TEXT,
Intervention6_name_culn1 TEXT,
Intervention6_diameter_culn1 TEXT,
Intervention6_length_culn1 TEXT,
Intervention6_pressure_culn1 TEXT,
Intervention7_treat_culn1 TEXT,
Intervention7_segment_culn1 TEXT,
Intervention7_name_culn1 TEXT,
Intervention7_diameter_culn1 TEXT,
Intervention7_length_culn1 TEXT,
Intervention7_pressure_culn1 TEXT,
Intervention8_treat_culn1 TEXT,
Intervention8_segment_culn1 TEXT,
Intervention8_name_culn1 TEXT,
Intervention8_diameter_culn1 TEXT,
Intervention8_length_culn1 TEXT,
Intervention8_pressure_culn1 TEXT,
Intervention9_treat_culn1 TEXT,
Intervention9_segment_culn1 TEXT,
Intervention9_name_culn1 TEXT,
Intervention9_diameter_culn1 TEXT,
Intervention9_length_culn1 TEXT,
Intervention9_pressure_culn1 TEXT,
Intervention10_treat_culn1 TEXT,
Intervention10_segment_culn1 TEXT,
Intervention10_name_culn1 TEXT,
Intervention10_diameter_culn1 TEXT,
Intervention10_length_culn1 TEXT,
Intervention10_pressure_culn1 TEXT,
Intervention_ab_culn1 TEXT,
Intervention_ab_diameter_culn1 TEXT,
Intervention_ab_length_culn1 TEXT,
Intervention_ab_pressure_culn1 TEXT,
Intervention_Rota_culn1 TEXT,
Intervention_cd_culn1 TEXT,
Intervention_cl_culn1 TEXT,
Intervention_SRS_culn1 TEXT,
Intervention_NR_culn1 TEXT,
Intervention_D_culn1 TEXT,
Intervention_AC_culn1 TEXT,
Intervention_O_culn1 TEXT,
Intervention_O_detail_culn1 TEXT,
-- Intervention_P_culn1 TEXT,
Intervention_CPS_culn1 TEXT,
Intervention_CPS_detail_culn1 TEXT,
Trombosuction_culn1 TEXT,
Perforation_culn1 TEXT,
-- Non-Culprit2
Vessel_culn2 TEXT,
Lesion_culn2 TEXT,
Lesion_segment_1_culn2 TEXT,
Lesion_VeS_1_culn2 TEXT,
Lesion_segment_2_culn2 TEXT,
Lesion_VeS_2_culn2 TEXT,
Lesion_segment_3_culn2 TEXT,
Lesion_VeS_3_culn2 TEXT,
Lesion_Type_culn2 TEXT,
FFR_culn2 TEXT,
FFR_pre_culn2 TEXT,
FFR_post_culn2 TEXT,
Image_culn2 TEXT,
Pre_stent_culn2 TEXT,
Post_stent_culn2 TEXT,
Intervention_culn2 TEXT,
Intervention_cnt_culn2 TEXT,
Intervention1_treat_culn2 TEXT,
Intervention1_segment_culn2 TEXT,
Intervention1_name_culn2 TEXT,
Intervention1_diameter_culn2 TEXT,
Intervention1_length_culn2 TEXT,
Intervention1_pressure_culn2 TEXT,
Intervention2_treat_culn2 TEXT,
Intervention2_segment_culn2 TEXT,
Intervention2_name_culn2 TEXT,
Intervention2_diameter_culn2 TEXT,
Intervention2_length_culn2 TEXT,
Intervention2_pressure_culn2 TEXT,
Intervention3_treat_culn2 TEXT,
Intervention3_segment_culn2 TEXT,
Intervention3_name_culn2 TEXT,
Intervention3_diameter_culn2 TEXT,
Intervention3_length_culn2 TEXT,
Intervention3_pressure_culn2 TEXT,
Intervention4_treat_culn2 TEXT,
Intervention4_segment_culn2 TEXT,
Intervention4_name_culn2 TEXT,
Intervention4_diameter_culn2 TEXT,
Intervention4_length_culn2 TEXT,
Intervention4_pressure_culn2 TEXT,
Intervention5_treat_culn2 TEXT,
Intervention5_segment_culn2 TEXT,
Intervention5_name_culn2 TEXT,
Intervention5_diameter_culn2 TEXT,
Intervention5_length_culn2 TEXT,
Intervention5_pressure_culn2 TEXT,
Intervention6_treat_culn2 TEXT,
Intervention6_segment_culn2 TEXT,
Intervention6_name_culn2 TEXT,
Intervention6_diameter_culn2 TEXT,
Intervention6_length_culn2 TEXT,
Intervention6_pressure_culn2 TEXT,
Intervention7_treat_culn2 TEXT,
Intervention7_segment_culn2 TEXT,
Intervention7_name_culn2 TEXT,
Intervention7_diameter_culn2 TEXT,
Intervention7_length_culn2 TEXT,
Intervention7_pressure_culn2 TEXT,
Intervention8_treat_culn2 TEXT,
Intervention8_segment_culn2 TEXT,
Intervention8_name_culn2 TEXT,
Intervention8_diameter_culn2 TEXT,
Intervention8_length_culn2 TEXT,
Intervention8_pressure_culn2 TEXT,
Intervention9_treat_culn2 TEXT,
Intervention9_segment_culn2 TEXT,
Intervention9_name_culn2 TEXT,
Intervention9_diameter_culn2 TEXT,
Intervention9_length_culn2 TEXT,
Intervention9_pressure_culn2 TEXT,
Intervention10_treat_culn2 TEXT,
Intervention10_segment_culn2 TEXT,
Intervention10_name_culn2 TEXT,
Intervention10_diameter_culn2 TEXT,
Intervention10_length_culn2 TEXT,
Intervention10_pressure_culn2 TEXT,
Intervention_ab_culn2 TEXT,
Intervention_ab_diameter_culn2 TEXT,
Intervention_ab_length_culn2 TEXT,
Intervention_ab_pressure_culn2 TEXT,
Intervention_Rota_culn2 TEXT,
Intervention_cd_culn2 TEXT,
Intervention_cl_culn2 TEXT,
Intervention_SRS_culn2 TEXT,
Intervention_NR_culn2 TEXT,
Intervention_D_culn2 TEXT,
Intervention_AC_culn2 TEXT,
Intervention_O_culn2 TEXT,
Intervention_O_detail_culn2 TEXT,
-- Intervention_P_culn2 TEXT,
Intervention_CPS_culn2 TEXT,
Intervention_CPS_detail_culn2 TEXT,
Trombosuction_culn2 TEXT,
Perforation_culn2 TEXT,
-- Non-Culprit3
Vessel_culn3 TEXT,
Lesion_culn3 TEXT,
Lesion_segment_1_culn3 TEXT,
Lesion_VeS_1_culn3 TEXT,
Lesion_segment_2_culn3 TEXT,
Lesion_VeS_2_culn3 TEXT,
Lesion_segment_3_culn3 TEXT,
Lesion_VeS_3_culn3 TEXT,
Lesion_Type_culn3 TEXT,
FFR_culn3 TEXT,
FFR_pre_culn3 TEXT,
FFR_post_culn3 TEXT,
Image_culn3 TEXT,
Pre_stent_culn3 TEXT,
Post_stent_culn3 TEXT,
Intervention_culn3 TEXT,
Intervention_cnt_culn3 TEXT,
Intervention1_treat_culn3 TEXT,
Intervention1_segment_culn3 TEXT,
Intervention1_name_culn3 TEXT,
Intervention1_diameter_culn3 TEXT,
Intervention1_length_culn3 TEXT,
Intervention1_pressure_culn3 TEXT,
Intervention2_treat_culn3 TEXT,
Intervention2_segment_culn3 TEXT,
Intervention2_name_culn3 TEXT,
Intervention2_diameter_culn3 TEXT,
Intervention2_length_culn3 TEXT,
Intervention2_pressure_culn3 TEXT,
Intervention3_treat_culn3 TEXT,
Intervention3_segment_culn3 TEXT,
Intervention3_name_culn3 TEXT,
Intervention3_diameter_culn3 TEXT,
Intervention3_length_culn3 TEXT,
Intervention3_pressure_culn3 TEXT,
Intervention4_treat_culn3 TEXT,
Intervention4_segment_culn3 TEXT,
Intervention4_name_culn3 TEXT,
Intervention4_diameter_culn3 TEXT,
Intervention4_length_culn3 TEXT,
Intervention4_pressure_culn3 TEXT,
Intervention5_treat_culn3 TEXT,
Intervention5_segment_culn3 TEXT,
Intervention5_name_culn3 TEXT,
Intervention5_diameter_culn3 TEXT,
Intervention5_length_culn3 TEXT,
Intervention5_pressure_culn3 TEXT,
Intervention6_treat_culn3 TEXT,
Intervention6_segment_culn3 TEXT,
Intervention6_name_culn3 TEXT,
Intervention6_diameter_culn3 TEXT,
Intervention6_length_culn3 TEXT,
Intervention6_pressure_culn3 TEXT,
Intervention7_treat_culn3 TEXT,
Intervention7_segment_culn3 TEXT,
Intervention7_name_culn3 TEXT,
Intervention7_diameter_culn3 TEXT,
Intervention7_length_culn3 TEXT,
Intervention7_pressure_culn3 TEXT,
Intervention8_treat_culn3 TEXT,
Intervention8_segment_culn3 TEXT,
Intervention8_name_culn3 TEXT,
Intervention8_diameter_culn3 TEXT,
Intervention8_length_culn3 TEXT,
Intervention8_pressure_culn3 TEXT,
Intervention9_treat_culn3 TEXT,
Intervention9_segment_culn3 TEXT,
Intervention9_name_culn3 TEXT,
Intervention9_diameter_culn3 TEXT,
Intervention9_length_culn3 TEXT,
Intervention9_pressure_culn3 TEXT,
Intervention10_treat_culn3 TEXT,
Intervention10_segment_culn3 TEXT,
Intervention10_name_culn3 TEXT,
Intervention10_diameter_culn3 TEXT,
Intervention10_length_culn3 TEXT,
Intervention10_pressure_culn3 TEXT,
Intervention_ab_culn3 TEXT,
Intervention_ab_diameter_culn3 TEXT,
Intervention_ab_length_culn3 TEXT,
Intervention_ab_pressure_culn3 TEXT,
Intervention_Rota_culn3 TEXT,
Intervention_cd_culn3 TEXT,
Intervention_cl_culn3 TEXT,
Intervention_SRS_culn3 TEXT,
Intervention_NR_culn3 TEXT,
Intervention_D_culn3 TEXT,
Intervention_AC_culn3 TEXT,
Intervention_O_culn3 TEXT,
Intervention_O_detail_culn3 TEXT,
-- Intervention_P_culn3 TEXT,
Intervention_CPS_culn3 TEXT,
Intervention_CPS_detail_culn3 TEXT,
Trombosuction_culn3 TEXT,
Perforation_culn3 TEXT,
-- Non-Culprit4
Vessel_culn4 TEXT,
Lesion_culn4 TEXT,
Lesion_segment_1_culn4 TEXT,
Lesion_VeS_1_culn4 TEXT,
Lesion_segment_2_culn4 TEXT,
Lesion_VeS_2_culn4 TEXT,
Lesion_segment_3_culn4 TEXT,
Lesion_VeS_3_culn4 TEXT,
Lesion_Type_culn4 TEXT,
FFR_culn4 TEXT,
FFR_pre_culn4 TEXT,
FFR_post_culn4 TEXT,
Image_culn4 TEXT,
Pre_stent_culn4 TEXT,
Post_stent_culn4 TEXT,
Intervention_culn4 TEXT,
Intervention_cnt_culn4 TEXT,
Intervention1_treat_culn4 TEXT,
Intervention1_segment_culn4 TEXT,
Intervention1_name_culn4 TEXT,
Intervention1_diameter_culn4 TEXT,
Intervention1_length_culn4 TEXT,
Intervention1_pressure_culn4 TEXT,
Intervention2_treat_culn4 TEXT,
Intervention2_segment_culn4 TEXT,
Intervention2_name_culn4 TEXT,
Intervention2_diameter_culn4 TEXT,
Intervention2_length_culn4 TEXT,
Intervention2_pressure_culn4 TEXT,
Intervention3_treat_culn4 TEXT,
Intervention3_segment_culn4 TEXT,
Intervention3_name_culn4 TEXT,
Intervention3_diameter_culn4 TEXT,
Intervention3_length_culn4 TEXT,
Intervention3_pressure_culn4 TEXT,
Intervention4_treat_culn4 TEXT,
Intervention4_segment_culn4 TEXT,
Intervention4_name_culn4 TEXT,
Intervention4_diameter_culn4 TEXT,
Intervention4_length_culn4 TEXT,
Intervention4_pressure_culn4 TEXT,
Intervention5_treat_culn4 TEXT,
Intervention5_segment_culn4 TEXT,
Intervention5_name_culn4 TEXT,
Intervention5_diameter_culn4 TEXT,
Intervention5_length_culn4 TEXT,
Intervention5_pressure_culn4 TEXT,
Intervention6_treat_culn4 TEXT,
Intervention6_segment_culn4 TEXT,
Intervention6_name_culn4 TEXT,
Intervention6_diameter_culn4 TEXT,
Intervention6_length_culn4 TEXT,
Intervention6_pressure_culn4 TEXT,
Intervention7_treat_culn4 TEXT,
Intervention7_segment_culn4 TEXT,
Intervention7_name_culn4 TEXT,
Intervention7_diameter_culn4 TEXT,
Intervention7_length_culn4 TEXT,
Intervention7_pressure_culn4 TEXT,
Intervention8_treat_culn4 TEXT,
Intervention8_segment_culn4 TEXT,
Intervention8_name_culn4 TEXT,
Intervention8_diameter_culn4 TEXT,
Intervention8_length_culn4 TEXT,
Intervention8_pressure_culn4 TEXT,
Intervention9_treat_culn4 TEXT,
Intervention9_segment_culn4 TEXT,
Intervention9_name_culn4 TEXT,
Intervention9_diameter_culn4 TEXT,
Intervention9_length_culn4 TEXT,
Intervention9_pressure_culn4 TEXT,
Intervention10_treat_culn4 TEXT,
Intervention10_segment_culn4 TEXT,
Intervention10_name_culn4 TEXT,
Intervention10_diameter_culn4 TEXT,
Intervention10_length_culn4 TEXT,
Intervention10_pressure_culn4 TEXT,
Intervention_ab_culn4 TEXT,
Intervention_ab_diameter_culn4 TEXT,
Intervention_ab_length_culn4 TEXT,
Intervention_ab_pressure_culn4 TEXT,
Intervention_Rota_culn4 TEXT,
Intervention_cd_culn4 TEXT,
Intervention_cl_culn4 TEXT,
Intervention_SRS_culn4 TEXT,
Intervention_NR_culn4 TEXT,
Intervention_D_culn4 TEXT,
Intervention_AC_culn4 TEXT,
Intervention_O_culn4 TEXT,
Intervention_O_detail_culn4 TEXT,
-- Intervention_P_culn4 TEXT,
Intervention_CPS_culn4 TEXT,
Intervention_CPS_detail_culn4 TEXT,
Trombosuction_culn4 TEXT,
Perforation_culn4 TEXT,
-- Outcomes
Discharge_out DATE,
General_out TEXT,
General_detail_out TEXT,
General_detail_others_out TEXT,
Aspirin_out TEXT,
Clopidogrel_out TEXT,
Prasugrel_out TEXT,
Ticagrelor_out TEXT,
Nicorandil_out TEXT,
Wafarin_out TEXT,
NOAC_out TEXT,
NOAC_name_out TEXT,
NOAC_dose_out TEXT,
BB_out TEXT,
BB_name_out TEXT,
BB_dose_out TEXT,
DPP4_out TEXT,
DPP4_name_out TEXT,
DPP4_dose_out TEXT,
Metformin_out TEXT,
Metformin_dose_out TEXT,
Sulf_out TEXT,
Sulf_name_out TEXT,
Sulf_dose_out TEXT,
Thia_out TEXT,
Thia_name_out TEXT,
Thia_dose_out TEXT,
GLP_out TEXT,
GLP_name_out TEXT,
GLP_dose_out TEXT,
Alpha_out TEXT,
Alpha_name_out TEXT,
Alpha_dose_out TEXT,
Statin_out TEXT,
Statin_name_out TEXT,
Statin_dose_out TEXT,
ACE_out TEXT,
ACE_name_out TEXT,
ACE_dose_out TEXT,
Nitrate_out TEXT,
Calcium_out TEXT,
Calcium_name_out TEXT,
Calcium_dose_out TEXT,
Trimetazidine_out TEXT,
Insulin_out TEXT,
Events_out TEXT,
Events_detail_out TEXT,
Death_date_out DATE,
Death_cause_out TEXT,
MI_date_out DATE,
MI_Segment_out TEXT,
MI_Type_out TEXT,
MI_Pre_out TEXT,
MI_ST_out TEXT,
MI_TL_out TEXT,
MI_TV_out TEXT,
MI_Treat_out TEXT,
MI_After_out TEXT,
RV_date_out DATE,
RV_Segment_out TEXT,
RV_CD_out TEXT,
RV_ID_out TEXT,
RV_Treat_out TEXT,
RV_TL_out TEXT,
RV_TV_out TEXT,
RV_AVP_out TEXT,
ST_date_out DATE,
ST_Segment_out TEXT,
ST_Type_out TEXT,
ST_ARC_out TEXT,
ST_Clinical_out TEXT,
ST_Clinical_other_out TEXT,
CVA_date_out DATE,
CVA_Type_out TEXT,
CVA_VIS_out TEXT,
Bleed_count_out TEXT,
Bleed1_date_out DATE,
BARC1_Type_out TEXT,
BARC1_ST_out TEXT,
BARC1_HT_out TEXT,
BARC1_Origin_out TEXT,
BARC1_AT_out TEXT,
Bleed2_date_out DATE,
BARC2_Type_out TEXT,
BARC2_ST_out TEXT,
BARC2_HT_out TEXT,
BARC2_Origin_out TEXT,
BARC2_AT_out TEXT,
Comment_out TEXT,
-- Event --
-- Last_FU_Date DATE,
-- Death TEXT,
-- Death_Date DATE,
-- MI TEXT,
-- MI_Date DATE,
-- TVMI TEXT,
-- TVMI_Date DATE,
-- TLR TEXT,
-- TLR_Date DATE,
-- TVR TEXT,
-- TVR_Date DATE,
-- Readmission_Total TEXT,
-- Readmission_Total_Date DATE,
-- TLF TEXT,
-- TLF_Date DATE,
-- Lab --
-- Lab_Date DATE,
-- WBC TEXT,
-- Hb TEXT,
-- Plt TEXT,
-- Cholesterol TEXT,
-- TG TEXT,
-- LDL TEXT,
-- HDL TEXT,
-- BUN TEXT,
-- Creatinine TEXT,
-- eCFR TEXT,
-- Bilirubin TEXT,
-- AST TEXT,
-- ALT TEXT,
-- hsCRP TEXT,
-- HbA1c TEXT,
-- Pre_CK_MB TEXT,
-- Pre_cTnT TEXT,
-- Post_Peak_CK_MB TEXT,
-- Post_Peak_cTnT TEXT,
-- NT_proBNP_Baseline TEXT,
-- Lactic_Acid_Pre TEXT,
-- Lactic_Acid_Peak TEXT,
-- M1 --
FU_M1 TEXT,
Visit_Date_M1 DATE,
Visit_M1 TEXT,
Reason_M1 TEXT,
Other_M1 TEXT,
LastFU_M1 DATE,
SBP_M1 TEXT,
DBP_M1 TEXT,
HRT_M1 TEXT,
Event_M1 TEXT,
Cardiac_Status_M1 TEXT,
CCS_M1 TEXT,
Other_Cardiac_Status_M1 TEXT,
-- Readmission_M1 TEXT,
-- Readmission_Date_M1 DATE,
-- Readmission_reason_M1 TEXT,
-- Readmission_reason_text_M1 TEXT,
ECG_Rhythm_M1 TEXT,
ECG_Rhythm_Other_M1 TEXT,
Stress_ECG_M1 TEXT,
Stress_ECG_Date_M1 DATE,
Stress_ECG_Detail_M1 TEXT,
Lab_Date_M1 DATE,
WBC_M1 TEXT,
TC_M1 TEXT,
Hb_M1 TEXT,
TG_M1 TEXT,
HDL_M1 TEXT,
Platelet_M1 TEXT,
LDL_M1 TEXT,
BUN_M1 TEXT,
Cr_M1 TEXT,
FG_M1 TEXT,
MDRD_M1 TEXT,
HbA1C_M1 TEXT,
AST_M1 TEXT,
hs_CRP_M1 TEXT,
ALT_M1 TEXT,
NT_Pro_BNP_M1 TEXT,
Aspirin_M1 TEXT,
Clopidogrel_M1 TEXT,
Prasugrel_M1 TEXT,
Ticagrelor_M1 TEXT,
Nicorandil_M1 TEXT,
Wafarin_M1 TEXT,