26 중커톤
테이블 (4)
User (Untitled)
- user_id (Key) — 기본 키 — NOT NULL
- email (Field) — VARCHAR
- password (Field2) — VARCHAR
- name (Field3) — VARCHAR
- last_period_date (Field4) — DATE
- due_date (Field5) — DATE
- create_at (Field6) — DateTime
- update_at (Field7) — DateTime
- deleted_at (Field8) — DateTime
검사결과지 (Untitled3)
- sheet_id (Key) — 기본 키 — NOT NULL
- user_id (Key2) — 외래 키 → User.user_id — NOT NULL
- test_date (Field2) — Date
- pregnancy_week (Field3) — int
- pregnancy_day (Field4) — int
- hospital_name (Field5) — VARCHAR
- summary_for_mom (Field6) — Text
- summary_for_doctor (Field7) — Text
- abnormal_count (Field8) — int
- create_at (Field9) — DateTime
- update_at (Field10) — DateTime
검사결과지 해석본 (Untitled4)
- sheet_trans_id (Key) — 기본 키 — NOT NULL
- sheet_id (Key2) — 외래 키 → 검사결과지.sheet_id — NOT NULL
- user_id (Key22) — 외래 키 → 검사결과지.user_id — NOT NULL
- test_sheet_id (Field) — int
- test_item_id (Field2) — int
- ocr_label (Field3) — VARCHAR
- number_value (Field4) — float
- text_value (Field5) — VARCHAR
- 단위 (Field6) — VARCHAR
- sheet_normal_min (Field7) — float
- sheet_normal_max (Field8) — float
- normal_range_source (Field9) — VARCHAR
- result_status (Field10)
- is_abnormal (Field11) — int
- brief_for_mom (Field12) — Text
- brief_for_doctor (Field13) — Text
- detail_for_mom (Field14) — Text
- detail_for_doctor (Field15) — Text
- create_at (Field16) — DateTime
- updated_at (Field17) — DateTime
검사항목종류 (Untitled2)
- item_id (Key) — 기본 키 — NOT NULL
- code (Field) — VARCHAR
- name_ko (Field2) — VARCHAR
- name_en (Field3) — VARCHAR
- category (Field4) — VARCHAR
- 단위 (Field5) — VARCHAR
- result_type (Field6)
- normal_min (Field7) — int
- normal_max (Field8) — max
- normal_text (Field9) — VARCHAR
- name_variants (Field10) — JSON
- description_for_mom (Field11) — Text
- is_active (Field12) — int
- create_at (Field13) — DateTime
- update_at (Field14) — DateTime