TS-Shinhan2

Tables (5)

Dictionary (사전)

  • id (pk) — int — Primary key — NOT NULL
  • name (사용처명) — varchar
  • dictionary (딕셔너리) — json
  • user (유저) — varchar
  • created_at (생성일자) — datetime
  • edited_at (수정일자) — datetime
  • in_use (사용여부) — boolean
  • output_file_type (아웃풋문서타입) — int — Foreign key → OutputDocumentType.id — NOT NULL

ExtractJob (추출작업로그)

  • id (pk) — int — Primary key — NOT NULL
  • user (작업자) — varchar
  • output_doco_type (아웃풋문서타입) — int — Foreign key → OutputDocumentType.id — NOT NULL
  • created_at (만든_날짜) — datetime
  • edited_at (수정_날짜) — datetime

InputDocument (인풋문서타입)

  • id (pk) — int — Primary key — NOT NULL
  • doco_name (파일명) — varchar
  • file_path (파일위치) — varchar
  • type_name_kor (한국어타입명) — varchar
  • created_at (만든_날짜) — datetime
  • edited_at (수정_날짜) — datetime
  • job_id (작업로그아이디) — int — Foreign key → ExtractJob.id — NOT NULL

OutputDocumentType (아웃풋문서타입)

  • id (pk) — int — Primary key — NOT NULL
  • type_name (타입명) — varchar
  • type_name_kor (한국어타입명) — varchar
  • created_at (만든_날짜) — datetime
  • edited_at (수정_날짜) — datetime

PrimaryExtractedValue (초기추출값)

  • id (pk) — int — Primary key — NOT NULL
  • key (키값) — varchar
  • value_type (추춟값 유형) — enum('image', 'text')
  • text_value (텍스트_추출값) — text
  • image_value (이미지_추출값) — Blob
  • doco_id (인풋문서_아이디) — int — Foreign key → InputDocument.id — NOT NULL
  • value_page (추출값_페이지) — int
  • value_pos (밸류_위치값) — array