-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathdatabase_tables
More file actions
924 lines (922 loc) · 75.1 KB
/
database_tables
File metadata and controls
924 lines (922 loc) · 75.1 KB
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
FYI: This task ONLY works on MYSQL databases.
Table: abstracts
+-----------------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| entry_1_by_uid | varchar(255) | YES | | NULL | |
| entry_2_by_uid | varchar(255) | YES | | NULL | |
| merged_by_uid | varchar(255) | YES | | NULL | |
| study_subject_id | int(11) | YES | | NULL | |
| bmb_report_found | smallint(6) | YES | | NULL | |
| bmb_test_date | date | YES | | NULL | |
| bmb_percentage_blasts_known | smallint(6) | YES | | NULL | |
| bmb_percentage_blasts | varchar(25) | YES | | NULL | |
| bmb_comments | text | YES | | NULL | |
| bma_report_found | smallint(6) | YES | | NULL | |
| bma_test_date | date | YES | | NULL | |
| bma_percentage_blasts_known | smallint(6) | YES | | NULL | |
| bma_percentage_blasts | varchar(25) | YES | | NULL | |
| bma_comments | text | YES | | NULL | |
| ccs_report_found | smallint(6) | YES | | NULL | |
| ccs_test_date | date | YES | | NULL | |
| ccs_peroxidase | varchar(25) | YES | | NULL | |
| ccs_sudan_black | varchar(25) | YES | | NULL | |
| ccs_periodic_acid_schiff | varchar(25) | YES | | NULL | |
| ccs_chloroacetate_esterase | varchar(25) | YES | | NULL | |
| ccs_non_specific_esterase | varchar(25) | YES | | NULL | |
| ccs_alpha_naphthyl_butyrate_esterase | varchar(25) | YES | | NULL | |
| ccs_toluidine_blue | varchar(25) | YES | | NULL | |
| ccs_bcl_2 | varchar(25) | YES | | NULL | |
| ccs_other | varchar(25) | YES | | NULL | |
| dfc_report_found | smallint(6) | YES | | NULL | |
| dfc_test_date | date | YES | | NULL | |
| dfc_numerical_data_available | smallint(6) | YES | | NULL | |
| marker_bmk | varchar(25) | YES | | NULL | |
| marker_bml | varchar(25) | YES | | NULL | |
| marker_cd10 | varchar(25) | YES | | NULL | |
| marker_cd11b | varchar(25) | YES | | NULL | |
| marker_cd11c | varchar(25) | YES | | NULL | |
| marker_cd13 | varchar(25) | YES | | NULL | |
| marker_cd14 | varchar(25) | YES | | NULL | |
| marker_cd15 | varchar(25) | YES | | NULL | |
| marker_cd16 | varchar(25) | YES | | NULL | |
| marker_cd19 | varchar(25) | YES | | NULL | |
| marker_cd19_cd10 | varchar(25) | YES | | NULL | |
| marker_cd1a | varchar(25) | YES | | NULL | |
| marker_cd2 | varchar(25) | YES | | NULL | |
| marker_cd20 | varchar(25) | YES | | NULL | |
| marker_cd21 | varchar(25) | YES | | NULL | |
| marker_cd22 | varchar(25) | YES | | NULL | |
| marker_cd23 | varchar(25) | YES | | NULL | |
| marker_cd24 | varchar(25) | YES | | NULL | |
| marker_cd25 | varchar(25) | YES | | NULL | |
| marker_cd3 | varchar(25) | YES | | NULL | |
| marker_cd33 | varchar(25) | YES | | NULL | |
| marker_cd34 | varchar(25) | YES | | NULL | |
| marker_cd38 | varchar(25) | YES | | NULL | |
| marker_cd3_cd4 | varchar(25) | YES | | NULL | |
| marker_cd3_cd8 | varchar(25) | YES | | NULL | |
| marker_cd4 | varchar(25) | YES | | NULL | |
| marker_cd40 | varchar(25) | YES | | NULL | |
| marker_cd41 | varchar(25) | YES | | NULL | |
| marker_cd45 | varchar(25) | YES | | NULL | |
| marker_cd5 | varchar(25) | YES | | NULL | |
| marker_cd56 | varchar(25) | YES | | NULL | |
| marker_cd57 | varchar(25) | YES | | NULL | |
| marker_cd61 | varchar(25) | YES | | NULL | |
| marker_cd7 | varchar(25) | YES | | NULL | |
| marker_cd71 | varchar(25) | YES | | NULL | |
| marker_cd8 | varchar(25) | YES | | NULL | |
| marker_cd9 | varchar(25) | YES | | NULL | |
| marker_cdw65 | varchar(25) | YES | | NULL | |
| marker_glycophorin_a | varchar(25) | YES | | NULL | |
| marker_hla_dr | varchar(25) | YES | | NULL | |
| marker_igm | varchar(25) | YES | | NULL | |
| marker_sig | varchar(25) | YES | | NULL | |
| marker_tdt | varchar(25) | YES | | NULL | |
| other_markers | text | YES | | NULL | |
| marker_comments | text | YES | | NULL | |
| tdt_report_found | smallint(6) | YES | | NULL | |
| tdt_test_date | date | YES | | NULL | |
| tdt_found_where | varchar(25) | YES | | NULL | |
| tdt_result | varchar(25) | YES | | NULL | |
| tdt_numerical_result | varchar(25) | YES | | NULL | |
| ploidy_report_found | smallint(6) | YES | | NULL | |
| ploidy_test_date | date | YES | | NULL | |
| ploidy_found_where | varchar(25) | YES | | NULL | |
| ploidy_hypodiploid | varchar(25) | YES | | NULL | |
| ploidy_pseudodiploid | varchar(25) | YES | | NULL | |
| ploidy_hyperdiploid | varchar(25) | YES | | NULL | |
| ploidy_diploid | varchar(25) | YES | | NULL | |
| ploidy_dna_index | varchar(25) | YES | | NULL | |
| ploidy_other_dna_measurement | text | YES | | NULL | |
| ploidy_notes | text | YES | | NULL | |
| hla_report_found | smallint(6) | YES | | NULL | |
| hla_test_date | date | YES | | NULL | |
| hla_results | text | YES | | NULL | |
| cgs_report_found | smallint(6) | YES | | NULL | |
| cgs_test_date | date | YES | | NULL | |
| cgs_normal | smallint(6) | YES | | NULL | |
| cgs_conventional_karyotype_done | smallint(6) | YES | | NULL | |
| cgs_hospital_fish_done | smallint(6) | YES | | NULL | |
| cgs_hyperdiploidy_detected | smallint(6) | YES | | NULL | |
| cgs_hyperdiploidy_by | varchar(25) | YES | | NULL | |
| cgs_hyperdiploidy_number_of_chromosomes | varchar(25) | YES | | NULL | |
| cgs_t12_21 | smallint(6) | YES | | NULL | |
| cgs_inv16 | smallint(6) | YES | | NULL | |
| cgs_t1_19 | smallint(6) | YES | | NULL | |
| cgs_t8_21 | smallint(6) | YES | | NULL | |
| cgs_t9_22 | smallint(6) | YES | | NULL | |
| cgs_t15_17 | smallint(6) | YES | | NULL | |
| cgs_trisomy_4 | smallint(6) | YES | | NULL | |
| cgs_trisomy_5 | smallint(6) | YES | | NULL | |
| cgs_trisomy_10 | smallint(6) | YES | | NULL | |
| cgs_trisomy_17 | smallint(6) | YES | | NULL | |
| cgs_trisomy_21 | smallint(6) | YES | | NULL | |
| cgs_t4_11_q21_q23 | smallint(6) | YES | | NULL | |
| cgs_deletion_6q | smallint(6) | YES | | NULL | |
| cgs_deletion_9p | smallint(6) | YES | | NULL | |
| cgs_t16_16_p13_q22 | smallint(6) | YES | | NULL | |
| cgs_trisomy_8 | smallint(6) | YES | | NULL | |
| cgs_trisomy_x | smallint(6) | YES | | NULL | |
| cgs_trisomy_6 | smallint(6) | YES | | NULL | |
| cgs_trisomy_14 | smallint(6) | YES | | NULL | |
| cgs_trisomy_18 | smallint(6) | YES | | NULL | |
| cgs_monosomy_7 | smallint(6) | YES | | NULL | |
| cgs_deletion_16_q22 | smallint(6) | YES | | NULL | |
| cgs_others | text | YES | | NULL | |
| cgs_conventional_karyotyping_results | text | YES | | NULL | |
| cgs_hospital_fish_results | text | YES | | NULL | |
| cgs_comments | text | YES | | NULL | |
| omg_abnormalities_found | smallint(6) | YES | | NULL | |
| omg_test_date | date | YES | | NULL | |
| omg_p16 | varchar(25) | YES | | NULL | |
| omg_p15 | varchar(25) | YES | | NULL | |
| omg_p53 | varchar(25) | YES | | NULL | |
| omg_ras | varchar(25) | YES | | NULL | |
| omg_all1 | varchar(25) | YES | | NULL | |
| omg_wt1 | varchar(25) | YES | | NULL | |
| omg_bcr | varchar(25) | YES | | NULL | |
| omg_etv6 | varchar(25) | YES | | NULL | |
| omg_fish | varchar(25) | YES | | NULL | |
| em_report_found | smallint(6) | YES | | NULL | |
| em_test_date | date | YES | | NULL | |
| em_comments | text | YES | | NULL | |
| cbc_report_found | smallint(6) | YES | | NULL | |
| cbc_test_date | date | YES | | NULL | |
| cbc_hemoglobin | varchar(25) | YES | | NULL | |
| cbc_leukocyte_count | varchar(25) | YES | | NULL | |
| cbc_number_of_blasts | varchar(25) | YES | | NULL | |
| cbc_percentage_blasts | varchar(25) | YES | | NULL | |
| cbc_platelet_count | varchar(25) | YES | | NULL | |
| csf_report_found | smallint(6) | YES | | NULL | |
| csf_test_date | date | YES | | NULL | |
| csf_blasts_present | smallint(6) | YES | | NULL | |
| csf_cytology | text | YES | | NULL | |
| csf_number_of_blasts | varchar(25) | YES | | NULL | |
| csf_pb_contamination | smallint(6) | YES | | NULL | |
| csf_rbc | varchar(25) | YES | | NULL | |
| csf_wbc | varchar(25) | YES | | NULL | |
| ob_skin_report_found | smallint(6) | YES | | NULL | |
| ob_skin_date | date | YES | | NULL | |
| ob_skin_leukemic_cells_present | smallint(6) | YES | | NULL | |
| ob_lymph_node_report_found | smallint(6) | YES | | NULL | |
| ob_lymph_node_date | date | YES | | NULL | |
| ob_lymph_node_leukemic_cells_present | smallint(6) | YES | | NULL | |
| ob_liver_report_found | smallint(6) | YES | | NULL | |
| ob_liver_date | date | YES | | NULL | |
| ob_liver_leukemic_cells_present | smallint(6) | YES | | NULL | |
| ob_other_report_found | smallint(6) | YES | | NULL | |
| ob_other_date | date | YES | | NULL | |
| ob_other_site_organ | varchar(255) | YES | | NULL | |
| ob_other_leukemic_cells_present | smallint(6) | YES | | NULL | |
| cxr_report_found | smallint(6) | YES | | NULL | |
| cxr_test_date | date | YES | | NULL | |
| cxr_result | varchar(25) | YES | | NULL | |
| cxr_mediastinal_mass_description | text | YES | | NULL | |
| cct_report_found | smallint(6) | YES | | NULL | |
| cct_test_date | date | YES | | NULL | |
| cct_result | varchar(25) | YES | | NULL | |
| cct_mediastinal_mass_description | text | YES | | NULL | |
| as_report_found | smallint(6) | YES | | NULL | |
| as_test_date | date | YES | | NULL | |
| as_normal | smallint(6) | YES | | NULL | |
| as_sphenomegaly | smallint(6) | YES | | NULL | |
| as_hepatomegaly | smallint(6) | YES | | NULL | |
| as_lymphadenopathy | smallint(6) | YES | | NULL | |
| as_other_abdominal_masses | smallint(6) | YES | | NULL | |
| as_ascities | smallint(6) | YES | | NULL | |
| as_other_abnormal_findings | text | YES | | NULL | |
| ts_report_found | smallint(6) | YES | | NULL | |
| ts_test_date | date | YES | | NULL | |
| ts_findings | text | YES | | NULL | |
| hpr_report_found | smallint(6) | YES | | NULL | |
| hpr_test_date | date | YES | | NULL | |
| hpr_hepatomegaly | smallint(6) | YES | | NULL | |
| hpr_splenomegaly | smallint(6) | YES | | NULL | |
| hpr_down_syndrome_phenotype | smallint(6) | YES | | NULL | |
| height | varchar(10) | YES | | NULL | |
| height_units | varchar(5) | YES | | NULL | |
| weight | varchar(10) | YES | | NULL | |
| weight_units | varchar(5) | YES | | NULL | |
| ds_report_found | smallint(6) | YES | | NULL | |
| ds_test_date | date | YES | | NULL | |
| ds_clinical_diagnosis | text | YES | | NULL | |
| cp_report_found | smallint(6) | YES | | NULL | |
| cp_induction_protocol_used | smallint(6) | YES | | NULL | |
| cp_induction_protocol_name_and_number | varchar(255) | YES | | NULL | |
| cp_therapeutic_agents | text | YES | | NULL | |
| bma07_report_found | smallint(6) | YES | | NULL | |
| bma07_test_date | date | YES | | NULL | |
| bma07_classification | varchar(25) | YES | | NULL | |
| bma07_inconclusive_results | tinyint(1) | YES | | NULL | |
| bma07_percentage_of_blasts | varchar(25) | YES | | NULL | |
| bma14_report_found | smallint(6) | YES | | NULL | |
| bma14_test_date | date | YES | | NULL | |
| bma14_classification | varchar(25) | YES | | NULL | |
| bma14_inconclusive_results | tinyint(1) | YES | | NULL | |
| bma14_percentage_of_blasts | varchar(25) | YES | | NULL | |
| bma28_report_found | smallint(6) | YES | | NULL | |
| bma28_test_date | date | YES | | NULL | |
| bma28_classification | varchar(25) | YES | | NULL | |
| bma28_inconclusive_results | tinyint(1) | YES | | NULL | |
| bma28_percentage_of_blasts | varchar(25) | YES | | NULL | |
| clinical_remission | smallint(6) | YES | | NULL | |
| leukemia_class | varchar(25) | YES | | NULL | |
| other_all_leukemia_class | varchar(25) | YES | | NULL | |
| other_aml_leukemia_class | varchar(25) | YES | | NULL | |
| icdo_classification_number | varchar(25) | YES | | NULL | |
| icdo_classification_description | text | YES | | NULL | |
| leukemia_lineage | varchar(25) | YES | | NULL | |
| pe_report_found | smallint(6) | YES | | NULL | |
| pe_test_date | date | YES | | NULL | |
| pe_gingival_infiltrates | smallint(6) | YES | | NULL | |
| pe_leukemic_skin_infiltrates | smallint(6) | YES | | NULL | |
| pe_lymphadenopathy | smallint(6) | YES | | NULL | |
| pe_lymphadenopathy_description | text | YES | | NULL | |
| pe_splenomegaly | smallint(6) | YES | | NULL | |
| pe_splenomegaly_size | varchar(255) | YES | | NULL | |
| pe_hepatomegaly | smallint(6) | YES | | NULL | |
| pe_hepatomegaly_size | varchar(255) | YES | | NULL | |
| pe_testicular_mass | smallint(6) | YES | | NULL | |
| pe_other_soft_tissue | smallint(6) | YES | | NULL | |
| pe_other_soft_tissue_location | varchar(255) | YES | | NULL | |
| pe_other_soft_tissue_size | varchar(255) | YES | | NULL | |
| pe_neurological_abnormalities | text | YES | | NULL | |
| pe_other_abnormal_findings | text | YES | | NULL | |
| abstracted_by | varchar(255) | YES | | NULL | |
| abstracted_on | date | YES | | NULL | |
| reviewed_by | varchar(255) | YES | | NULL | |
| reviewed_on | date | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+-----------------------------------------+--------------+------+-----+---------+----------------+
Table: addresses
+----------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| study_subject_id | int(11) | YES | MUL | NULL | |
| current_address | int(11) | YES | | 1 | |
| address_at_diagnosis | int(11) | YES | | NULL | |
| other_data_source | varchar(255) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
| notes | text | YES | | NULL | |
| data_source | varchar(255) | YES | | NULL | |
| line_1 | varchar(255) | YES | | NULL | |
| line_2 | varchar(255) | YES | | NULL | |
| city | varchar(255) | YES | | NULL | |
| state | varchar(255) | YES | | NULL | |
| zip | varchar(10) | YES | | NULL | |
| external_address_id | int(11) | YES | | NULL | |
| county | varchar(255) | YES | | NULL | |
| unit | varchar(255) | YES | | NULL | |
| country | varchar(255) | YES | | NULL | |
| needs_geocoded | tinyint(1) | YES | MUL | 1 | |
| geocoding_failed | tinyint(1) | YES | | 0 | |
| longitude | float | YES | | NULL | |
| latitude | float | YES | | NULL | |
| geocoding_response | text | YES | | NULL | |
| address_type | varchar(255) | YES | | NULL | |
+----------------------+--------------+------+-----+---------+----------------+
Table: alternate_contacts
+------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| study_subject_id | int(11) | YES | MUL | NULL | |
| name | varchar(255) | YES | | NULL | |
| relation | varchar(255) | YES | | NULL | |
| line_1 | varchar(255) | YES | | NULL | |
| line_2 | varchar(255) | YES | | NULL | |
| city | varchar(255) | YES | | NULL | |
| state | varchar(255) | YES | | NULL | |
| zip | varchar(255) | YES | | NULL | |
| phone_number_1 | varchar(255) | YES | | NULL | |
| phone_number_2 | varchar(255) | YES | | NULL | |
| notes | text | YES | | NULL | |
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
+------------------+--------------+------+-----+---------+----------------+
Table: bc_requests
+------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| study_subject_id | int(11) | YES | | NULL | |
| sent_on | date | YES | | NULL | |
| status | varchar(255) | YES | | NULL | |
| notes | text | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
| is_found | tinyint(1) | YES | | NULL | |
| returned_on | date | YES | | NULL | |
+------------------+--------------+------+-----+---------+----------------+
Table: birth_data
+-----------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| study_subject_id | int(11) | YES | MUL | NULL | |
| master_id | varchar(255) | YES | | NULL | |
| found_in_state_db | varchar(255) | YES | | NULL | |
| birth_state | varchar(255) | YES | | NULL | |
| match_confidence | varchar(255) | YES | | NULL | |
| case_control_flag | varchar(255) | YES | | NULL | |
| length_of_gestation_weeks | int(11) | YES | | NULL | |
| father_race_ethn_1 | int(11) | YES | | NULL | |
| father_race_ethn_2 | int(11) | YES | | NULL | |
| father_race_ethn_3 | int(11) | YES | | NULL | |
| mother_race_ethn_1 | int(11) | YES | | NULL | |
| mother_race_ethn_2 | int(11) | YES | | NULL | |
| mother_race_ethn_3 | int(11) | YES | | NULL | |
| abnormal_conditions | varchar(255) | YES | | NULL | |
| apgar_1min | int(11) | YES | | NULL | |
| apgar_5min | int(11) | YES | | NULL | |
| apgar_10min | int(11) | YES | | NULL | |
| birth_order | int(11) | YES | | NULL | |
| birth_type | varchar(255) | YES | | NULL | |
| birth_weight_gms | decimal(8,2) | YES | | NULL | |
| complications_labor_delivery | varchar(255) | YES | | NULL | |
| complications_pregnancy | varchar(255) | YES | | NULL | |
| county_of_delivery | varchar(255) | YES | | NULL | |
| daily_cigarette_cnt_1st_tri | int(11) | YES | | NULL | |
| daily_cigarette_cnt_2nd_tri | int(11) | YES | | NULL | |
| daily_cigarette_cnt_3rd_tri | int(11) | YES | | NULL | |
| daily_cigarette_cnt_3mo_preconc | int(11) | YES | | NULL | |
| dob | date | YES | | NULL | |
| first_name | varchar(255) | YES | | NULL | |
| middle_name | varchar(255) | YES | | NULL | |
| last_name | varchar(255) | YES | | NULL | |
| father_industry | varchar(255) | YES | | NULL | |
| father_dob | date | YES | | NULL | |
| father_hispanic_origin_code | varchar(255) | YES | | NULL | |
| father_first_name | varchar(255) | YES | | NULL | |
| father_middle_name | varchar(255) | YES | | NULL | |
| father_last_name | varchar(255) | YES | | NULL | |
| father_occupation | varchar(255) | YES | | NULL | |
| father_yrs_educ | int(11) | YES | | NULL | |
| fetal_presentation_at_birth | varchar(255) | YES | | NULL | |
| forceps_attempt_unsuccessful | varchar(255) | YES | | NULL | |
| last_live_birth_on | date | YES | | NULL | |
| last_menses_on | date | YES | | NULL | |
| last_termination_on | date | YES | | NULL | |
| length_of_gestation_days | int(11) | YES | | NULL | |
| live_births_now_deceased | int(11) | YES | | NULL | |
| live_births_now_living | int(11) | YES | | NULL | |
| local_registrar_district | varchar(255) | YES | | NULL | |
| local_registrar_no | varchar(255) | YES | | NULL | |
| method_of_delivery | varchar(255) | YES | | NULL | |
| month_prenatal_care_began | varchar(255) | YES | | NULL | |
| mother_residence_line_1 | varchar(255) | YES | | NULL | |
| mother_residence_city | varchar(255) | YES | | NULL | |
| mother_residence_county | varchar(255) | YES | | NULL | |
| mother_residence_county_ef | varchar(255) | YES | | NULL | |
| mother_residence_state | varchar(255) | YES | | NULL | |
| mother_residence_zip | varchar(255) | YES | | NULL | |
| mother_weight_at_delivery | int(11) | YES | | NULL | |
| mother_birthplace | varchar(255) | YES | | NULL | |
| mother_birthplace_state | varchar(255) | YES | | NULL | |
| mother_dob | date | YES | | NULL | |
| mother_first_name | varchar(255) | YES | | NULL | |
| mother_middle_name | varchar(255) | YES | | NULL | |
| mother_maiden_name | varchar(255) | YES | | NULL | |
| mother_height | int(11) | YES | | NULL | |
| mother_hispanic_origin_code | varchar(255) | YES | | NULL | |
| mother_industry | varchar(255) | YES | | NULL | |
| mother_occupation | varchar(255) | YES | | NULL | |
| mother_received_wic | varchar(255) | YES | | NULL | |
| mother_weight_pre_pregnancy | int(11) | YES | | NULL | |
| mother_yrs_educ | int(11) | YES | | NULL | |
| ob_gestation_estimate_at_delivery | int(11) | YES | | NULL | |
| prenatal_care_visit_count | int(11) | YES | | NULL | |
| sex | varchar(255) | YES | | NULL | |
| state_registrar_no | varchar(255) | YES | | NULL | |
| term_count_20_plus_weeks | int(11) | YES | | NULL | |
| term_count_pre_20_weeks | int(11) | YES | | NULL | |
| vacuum_attempt_unsuccessful | varchar(255) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
| control_number | int(11) | YES | | NULL | |
| father_ssn | varchar(255) | YES | | NULL | |
| mother_ssn | varchar(255) | YES | | NULL | |
| birth_data_file_name | varchar(255) | YES | | NULL | |
| childid | int(11) | YES | | NULL | |
| deceased | varchar(255) | YES | | NULL | |
| case_dob | date | YES | | NULL | |
| ccls_import_notes | text | YES | | NULL | |
| study_subject_changes | text | YES | | NULL | |
| derived_state_file_no_last6 | varchar(6) | YES | | NULL | |
| derived_local_file_no_last6 | varchar(6) | YES | | NULL | |
+-----------------------------------+--------------+------+-----+---------+----------------+
Table: blood_spot_requests
+------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| study_subject_id | int(11) | YES | | NULL | |
| sent_on | date | YES | | NULL | |
| returned_on | date | YES | | NULL | |
| is_found | tinyint(1) | YES | | NULL | |
| status | varchar(255) | YES | | NULL | |
| notes | text | YES | | NULL | |
| request_type | varchar(255) | YES | | NULL | |
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
+------------------+--------------+------+-----+---------+----------------+
Table: candidate_controls
+------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| birth_datum_id | int(11) | YES | | NULL | |
| related_patid | varchar(5) | YES | | NULL | |
| study_subject_id | int(11) | YES | | NULL | |
| assigned_on | date | YES | | NULL | |
| reject_candidate | tinyint(1) | NO | | 0 | |
| rejection_reason | varchar(255) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+------------------+--------------+------+-----+---------+----------------+
Table: counties
+--------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | YES | | NULL | |
| fips_code | varchar(5) | YES | | NULL | |
| state_abbrev | varchar(2) | YES | MUL | NULL | |
| usc_code | varchar(2) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+--------------+--------------+------+-----+---------+----------------+
Table: enrollments
+-----------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| study_subject_id | int(11) | YES | MUL | NULL | |
| project_id | int(11) | YES | MUL | NULL | |
| is_candidate | int(11) | YES | | NULL | |
| is_eligible | int(11) | YES | | NULL | |
| ineligible_reason_id | int(11) | YES | | NULL | |
| other_ineligible_reason | varchar(255) | YES | | NULL | |
| consented | int(11) | YES | | NULL | |
| consented_on | date | YES | | NULL | |
| refusal_reason_id | int(11) | YES | | NULL | |
| other_refusal_reason | varchar(255) | YES | | NULL | |
| is_chosen | int(11) | YES | | NULL | |
| reason_not_chosen | varchar(255) | YES | | NULL | |
| terminated_participation | int(11) | YES | | NULL | |
| terminated_reason | varchar(255) | YES | | NULL | |
| is_complete | int(11) | YES | | NULL | |
| completed_on | date | YES | | NULL | |
| notes | text | YES | | NULL | |
| use_smp_future_rsrch | int(11) | YES | | NULL | |
| use_smp_future_cancer_rsrch | int(11) | YES | | NULL | |
| use_smp_future_other_rsrch | int(11) | YES | | NULL | |
| share_smp_with_others | int(11) | YES | | NULL | |
| contact_for_related_study | int(11) | YES | | NULL | |
| provide_saliva_smp | int(11) | YES | | NULL | |
| receive_study_findings | int(11) | YES | | NULL | |
| refused_by_physician | tinyint(1) | YES | | NULL | |
| refused_by_family | tinyint(1) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
| assigned_for_interview_at | datetime | YES | | NULL | |
| interview_completed_on | date | YES | | NULL | |
| tracing_status | varchar(255) | YES | | NULL | |
| vaccine_authorization_received_at | datetime | YES | | NULL | |
+-----------------------------------+--------------+------+-----+---------+----------------+
Table: guides
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| controller | varchar(255) | YES | MUL | NULL | |
| action | varchar(255) | YES | | NULL | |
| body | text | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+------------+--------------+------+-----+---------+----------------+
Table: hospitals
+-----------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| organization_id | int(11) | YES | MUL | NULL | |
| has_irb_waiver | tinyint(1) | NO | | 0 | |
| is_active | tinyint(1) | NO | | 1 | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+-----------------+------------+------+-----+---------+----------------+
Table: icf_master_ids
+------------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| icf_master_id | varchar(9) | YES | UNI | NULL | |
| assigned_on | date | YES | | NULL | |
| study_subject_id | int(11) | YES | UNI | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+------------------+------------+------+-----+---------+----------------+
Table: ineligible_reasons
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| position | int(11) | YES | | NULL | |
| key | varchar(255) | NO | UNI | NULL | |
| description | varchar(255) | YES | UNI | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+-------------+--------------+------+-----+---------+----------------+
Table: languages
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| position | int(11) | YES | | NULL | |
| key | varchar(255) | NO | UNI | NULL | |
| description | varchar(255) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
| code | int(11) | YES | UNI | NULL | |
+-------------+--------------+------+-----+---------+----------------+
Table: medical_record_requests
+------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| study_subject_id | int(11) | YES | | NULL | |
| sent_on | date | YES | | NULL | |
| returned_on | date | YES | | NULL | |
| is_found | tinyint(1) | YES | | NULL | |
| status | varchar(255) | YES | | NULL | |
| notes | text | YES | | NULL | |
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
+------------------+--------------+------+-----+---------+----------------+
Table: operational_event_types
+----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| position | int(11) | YES | | NULL | |
| key | varchar(255) | NO | UNI | NULL | |
| description | varchar(255) | YES | UNI | NULL | |
| event_category | varchar(255) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+----------------+--------------+------+-----+---------+----------------+
Table: operational_events
+---------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| operational_event_type_id | int(11) | YES | MUL | NULL | |
| occurred_at | datetime | YES | | NULL | |
| study_subject_id | int(11) | YES | MUL | NULL | |
| project_id | int(11) | YES | MUL | NULL | |
| description | varchar(255) | YES | | NULL | |
| notes | text | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+---------------------------+--------------+------+-----+---------+----------------+
Table: organizations
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| position | int(11) | YES | | NULL | |
| key | varchar(255) | NO | UNI | NULL | |
| name | varchar(255) | YES | UNI | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+------------+--------------+------+-----+---------+----------------+
Table: pages
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| position | int(11) | YES | | NULL | |
| parent_id | int(11) | YES | MUL | NULL | |
| hide_menu | tinyint(1) | YES | | 0 | |
| path | varchar(255) | YES | UNI | NULL | |
| title_en | varchar(255) | YES | | NULL | |
| title_es | varchar(255) | YES | | NULL | |
| menu_en | varchar(255) | YES | | NULL | |
| menu_es | varchar(255) | YES | | NULL | |
| body_en | text | YES | | NULL | |
| body_es | text | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+------------+--------------+------+-----+---------+----------------+
Table: patients
+------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| study_subject_id | int(11) | YES | UNI | NULL | |
| diagnosis_date | date | YES | | NULL | |
| organization_id | int(11) | YES | MUL | NULL | |
| admit_date | date | YES | | NULL | |
| sample_was_collected | int(11) | YES | | NULL | |
| admitting_oncologist | varchar(255) | YES | | NULL | |
| was_ca_resident_at_diagnosis | int(11) | YES | | NULL | |
| was_previously_treated | int(11) | YES | | NULL | |
| was_under_15_at_dx | int(11) | YES | | NULL | |
| raf_zip | varchar(10) | YES | | NULL | |
| raf_county | varchar(255) | YES | | NULL | |
| hospital_no | varchar(25) | YES | MUL | NULL | |
| other_diagnosis | varchar(255) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
| diagnosis | varchar(255) | YES | | NULL | |
+------------------------------+--------------+------+-----+---------+----------------+
Table: phone_numbers
+-------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| position | int(11) | YES | | NULL | |
| study_subject_id | int(11) | YES | MUL | NULL | |
| phone_number | varchar(255) | YES | | NULL | |
| is_primary | tinyint(1) | YES | | NULL | |
| current_phone | int(11) | YES | | 1 | |
| other_data_source | varchar(255) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
| phone_type | varchar(255) | YES | | NULL | |
| data_source | varchar(255) | YES | | NULL | |
+-------------------+--------------+------+-----+---------+----------------+
Table: projects
+----------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| position | int(11) | YES | | NULL | |
| began_on | date | YES | | NULL | |
| ended_on | date | YES | | NULL | |
| key | varchar(255) | NO | UNI | NULL | |
| description | varchar(255) | YES | UNI | NULL | |
| eligibility_criteria | text | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
| label | varchar(255) | YES | | NULL | |
+----------------------+--------------+------+-----+---------+----------------+
Table: races
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| position | int(11) | YES | | NULL | |
| key | varchar(255) | NO | UNI | NULL | |
| description | varchar(255) | YES | UNI | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
| code | int(11) | YES | UNI | NULL | |
+-------------+--------------+------+-----+---------+----------------+
Table: refusal_reasons
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| position | int(11) | YES | | NULL | |
| key | varchar(255) | NO | UNI | NULL | |
| description | varchar(255) | YES | UNI | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+-------------+--------------+------+-----+---------+----------------+
Table: roles
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| position | int(11) | YES | | NULL | |
| name | varchar(255) | YES | UNI | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+------------+--------------+------+-----+---------+----------------+
Table: roles_users
+---------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| role_id | int(11) | YES | MUL | NULL | |
| user_id | int(11) | YES | MUL | NULL | |
+---------+---------+------+-----+---------+-------+
Table: sample_locations
+-----------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| organization_id | int(11) | YES | MUL | NULL | |
| is_active | tinyint(1) | NO | | 1 | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+-----------------+------------+------+-----+---------+----------------+
Table: sample_transfers
+--------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| sample_id | int(11) | YES | | NULL | |
| source_org_id | int(11) | YES | | NULL | |
| destination_org_id | int(11) | YES | | NULL | |
| sent_on | date | YES | | NULL | |
| status | varchar(255) | YES | | NULL | |
| notes | text | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+--------------------+--------------+------+-----+---------+----------------+
Table: sample_types
+---------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| position | int(11) | YES | | NULL | |
| parent_id | int(11) | YES | MUL | NULL | |
| key | varchar(255) | NO | UNI | NULL | |
| description | varchar(255) | YES | UNI | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
| for_new_sample | tinyint(1) | NO | | 1 | |
| t2k_sample_type_id | int(11) | YES | | NULL | |
| gegl_sample_type_id | varchar(255) | YES | | NULL | |
+---------------------+--------------+------+-----+---------+----------------+
Table: samples
+------------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| parent_sample_id | int(11) | YES | | NULL | |
| sample_type_id | int(11) | YES | | NULL | |
| project_id | int(11) | YES | | NULL | |
| study_subject_id | int(11) | YES | MUL | NULL | |
| organization_id | int(11) | YES | | NULL | |
| aliquot_or_sample_on_receipt | varchar(255) | YES | | NULL | |
| sent_to_subject_at | datetime | YES | | NULL | |
| collected_from_subject_at | datetime | YES | | NULL | |
| shipped_to_ccls_at | datetime | YES | | NULL | |
| received_by_ccls_at | datetime | YES | | NULL | |
| sent_to_lab_at | datetime | YES | | NULL | |
| received_by_lab_at | datetime | YES | | NULL | |
| external_id | varchar(255) | YES | | NULL | |
| external_id_source | varchar(255) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
| notes | text | YES | | NULL | |
| sample_format | varchar(255) | YES | | NULL | |
| sample_temperature | varchar(255) | YES | | NULL | |
+------------------------------+--------------+------+-----+---------+----------------+
Table: schema_migrations
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| version | varchar(255) | NO | PRI | NULL | |
+---------+--------------+------+-----+---------+-------+
Table: states
+-------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| position | int(11) | YES | | NULL | |
| code | varchar(255) | NO | UNI | NULL | |
| name | varchar(255) | NO | UNI | NULL | |
| fips_country_code | varchar(2) | NO | MUL | NULL | |
| fips_state_code | varchar(2) | NO | UNI | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+-------------------+--------------+------+-----+---------+----------------+
Table: study_subjects
+-----------------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| hispanicity | int(11) | YES | | NULL | |
| reference_date | date | YES | | NULL | |
| sex | varchar(255) | YES | | NULL | |
| do_not_contact | tinyint(1) | NO | | 0 | |
| mother_yrs_educ | int(11) | YES | | NULL | |
| father_yrs_educ | int(11) | YES | | NULL | |
| birth_type | varchar(255) | YES | | NULL | |
| mother_hispanicity | int(11) | YES | | NULL | |
| father_hispanicity | int(11) | YES | | NULL | |
| mother_hispanicity_mex | int(11) | YES | | NULL | |
| father_hispanicity_mex | int(11) | YES | | NULL | |
| mom_is_biomom | int(11) | YES | | NULL | |
| dad_is_biodad | int(11) | YES | | NULL | |
| first_name | varchar(255) | YES | | NULL | |
| middle_name | varchar(255) | YES | | NULL | |
| last_name | varchar(255) | YES | | NULL | |
| dob | date | YES | | NULL | |
| died_on | date | YES | | NULL | |
| mother_first_name | varchar(255) | YES | | NULL | |
| mother_middle_name | varchar(255) | YES | | NULL | |
| mother_maiden_name | varchar(255) | YES | | NULL | |
| mother_last_name | varchar(255) | YES | | NULL | |
| father_first_name | varchar(255) | YES | | NULL | |
| father_middle_name | varchar(255) | YES | | NULL | |
| father_last_name | varchar(255) | YES | | NULL | |
| guardian_first_name | varchar(255) | YES | | NULL | |
| guardian_middle_name | varchar(255) | YES | | NULL | |
| guardian_last_name | varchar(255) | YES | | NULL | |
| other_guardian_relationship | varchar(255) | YES | | NULL | |
| mother_race_code | int(11) | YES | | NULL | |
| father_race_code | int(11) | YES | | NULL | |
| maiden_name | varchar(255) | YES | | NULL | |
| birth_year | varchar(4) | YES | | NULL | |
| birth_city | varchar(255) | YES | | NULL | |
| birth_state | varchar(255) | YES | | NULL | |
| birth_country | varchar(255) | YES | | NULL | |
| other_mother_race | varchar(255) | YES | | NULL | |
| other_father_race | varchar(255) | YES | | NULL | |
| childid | int(11) | YES | UNI | NULL | |
| patid | varchar(4) | YES | MUL | NULL | |
| case_control_type | varchar(1) | YES | | NULL | |
| orderno | int(11) | YES | | NULL | |
| related_childid | varchar(255) | YES | | NULL | |
| related_case_childid | varchar(255) | YES | | NULL | |
| subjectid | varchar(6) | YES | UNI | NULL | |
| matchingid | varchar(6) | YES | MUL | NULL | |
| familyid | varchar(6) | YES | MUL | NULL | |
| state_id_no | varchar(255) | YES | UNI | NULL | |
| childidwho | varchar(10) | YES | | NULL | |
| studyid | varchar(14) | YES | UNI | NULL | |
| newid | varchar(6) | YES | | NULL | |
| icf_master_id | varchar(9) | YES | UNI | NULL | |
| state_registrar_no | varchar(255) | YES | UNI | NULL | |
| local_registrar_no | varchar(255) | YES | UNI | NULL | |
| is_matched | tinyint(1) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
| phase | int(11) | YES | MUL | NULL | |
| hispanicity_mex | int(11) | YES | | NULL | |
| case_icf_master_id | varchar(9) | YES | | NULL | |
| mother_icf_master_id | varchar(9) | YES | | NULL | |
| subject_type | varchar(20) | YES | MUL | NULL | |
| vital_status | varchar(20) | YES | MUL | NULL | |
| cdcid | int(11) | YES | | NULL | |
| samples_count | int(11) | YES | | 0 | |
| operational_events_count | int(11) | YES | | 0 | |
| addresses_count | int(11) | YES | | 0 | |
| phone_numbers_count | int(11) | YES | | 0 | |
| interviews_count | int(11) | YES | | 0 | |
| needs_reindexed | tinyint(1) | YES | MUL | 0 | |
| abstracts_count | int(11) | YES | | 0 | |
| enrollments_count | int(11) | YES | | 0 | |
| replication_id | int(11) | YES | MUL | NULL | |
| guardian_relationship | varchar(255) | YES | | NULL | |
+-----------------------------+--------------+------+-----+---------+----------------+
Table: subject_languages
+------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| study_subject_id | int(11) | YES | MUL | NULL | |
| language_code | int(11) | YES | | NULL | |
| other_language | varchar(255) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+------------------+--------------+------+-----+---------+----------------+
Table: subject_races
+------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| study_subject_id | int(11) | YES | MUL | NULL | |
| race_code | int(11) | YES | | NULL | |
| is_primary | tinyint(1) | NO | | 0 | |
| other_race | varchar(255) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+------------------+--------------+------+-----+---------+----------------+
Table: users
+-----------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| uid | varchar(255) | YES | UNI | NULL | |
| sn | varchar(255) | YES | MUL | NULL | |
| displayname | varchar(255) | YES | | NULL | |
| mail | varchar(255) | YES | | NULL | |
| telephonenumber | varchar(255) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+-----------------+--------------+------+-----+---------+----------------+
Table: zip_codes
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| zip_code | varchar(5) | NO | UNI | NULL | |
| city | varchar(255) | NO | | NULL | |
| state | varchar(255) | NO | | NULL | |
| zip_class | varchar(255) | NO | | NULL | |
| county_id | int(11) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+------------+--------------+------+-----+---------+----------------+