심사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