심사ON

테이블 (6)

DISEASE_CODE (질병코드)

  • KCOD_CODE (Key) — VARCHER — 기본 키 — NOT NULL
  • DISEASE_NAME (Field2) — VARCHER
  • DESCRIPTION (Field) — VARCHER

DOCUMENT (증빙자료)

  • DOCUMENT_ID (Key) — VARCHER — 기본 키 — NOT NULL
  • DOCUMENT_TYPE (Field) — VARCHER
  • FILE_NAME (Field2) — VARCHER
  • CASE_NO (Key2) — VARCHER — 외래 키 → REVIEW_CASE.CASE_NO — NOT NULL
  • SUBMITTED_AT (Field4) — DATETIME
  • SUBMITTED_YN (Field3) — CHAR

EMPLOYEES (사원)

  • EMP_NO (Key) — VARCHER — 기본 키 — NOT NULL
  • EMP_NAME (Field) — VARCHER
  • DEPT_ID (Field6) — VARCHER
  • POSITION (Field2) — VARCHER
  • EMAIL (Field3) — VARCHER
  • COMP_TEL (Field4) — VARCHER
  • HIRE_DATE (Field5) — DATE

REVIEW_CASE (심사건)

  • CASE_NO (Key) — VARCHER — 기본 키 — NOT NULL
  • EMP_NO (Key2) — VARCHER — 외래 키 → EMPLOYEES.EMP_NO — NOT NULL
  • STATUS (Field) — VARCHER
  • CLAIM_AMOUNT (Field2) — DECIMAL
  • PAYMENT_AMOUNT (Field3) — DECIMAL
  • REVIEW_RESULT (Field4) — VARCHAR
  • CREATED_AT (Field5) — DATETIME
  • UPDATED_AT (Field6) — DATETIME
  • COMPLETED_AT (Field7) — DATETIME

REVIEW_CASE_DISEASE (Untitled)

  • CASE_NO (Key) — VARCHER — 외래 키 → REVIEW_CASE.CASE_NO — NOT NULL
  • KCOD_CODE (Key2) — VARCHER — 외래 키 → DISEASE_CODE.KCOD_CODE — NOT NULL
  • Field — VARCHER

REVIEW_LOG (Untitled2)

  • LOG_ID (Key) — VARCHER — 기본 키 — NOT NULL
  • MEMO (Field) — VARCHER
  • CREATED_AT (Field2) — DATETIME
  • CASE_NO (Key2) — VARCHER — 외래 키 → REVIEW_CASE.CASE_NO — NOT NULL