kobiznet-erd1

Tables (7)

TB_BUYER_DICT (바이어별단어사전)

    TB_COMPANY_DICT (업체별단어사전)

      TB_EDMS_RES (EDMS_MBL문서)

      • PAPER_CD (문서종류) — VARCHAR — Foreign key → TB_MAPPING_RES.PAPER_CD
      • PAPER_NM (문서이름) — VARCHAR — Foreign key → TB_MAPPING_RES.PAPER_NM
      • COLUMN (항목) — VARCHAR — Foreign key → TB_MAPPING_RES.COLUMN
      • VALUE (값) — VARCHAR
      • REG_DT (등록일자) — DATETIME
      • UPD_DT (수정일자) — DATETIME

      TB_MAPPING_RES (매핑결과)

      • PAPER_CD (문서종류) — VARCHAR — Foreign key → TB_OCR_RES.PAPER_CD
      • PAPER_NM (문서이름) — VARCHAR — Foreign key → TB_OCR_RES.PAPER_NM
      • COLUMN (항목) — VARCHAR — Foreign key → TB_OCR_RES.COLUMN
      • VALUE (값) — VARCHAR
      • REG_DT (등록일자) — DATETIME
      • UPD_DT (수정일자) — DATETIME

      TB_OCR_RES (OCR결과)

      • PAPER_CD (문서종류) — VARCHAR — Primary key
      • PAPER_NM (문서이름) — VARCHAR — Primary key
      • COLUMN (항목) — VARCHAR — Primary key
      • VALUE (값) — VARCHAR
      • REG_DT (등록일자) — DATETIME
      • UPD_DT (수정일자) — DATETIME

      TB_ORDER_DICT (주문별단어사전)

        TB_SYNONYM (문서동의어사전)

        • PAPER_CD (문서종류) — VARCHAR — Foreign key → TB_OCR_RES.PAPER_CD
        • COLUMN (항목) — VARCHAR — Foreign key → TB_OCR_RES.COLUMN
        • SYN (동일어) — VARCHAR
        • REG_DT (등록일자) — DATETIME
        • UPD_DT (수정일자) — DATETIME