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