TS-Shinhan

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

ExtractJobLog (추출작업로그)

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

InputDocumentType (인풋문서타입)

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

OutputDocumentType (아웃풋문서타입)

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

PrimaryExtractedValue (초기추출값)

  • id (pk) — int — Primary key — NOT NULL
  • key (키값) — varchar
  • value_type (추춟값 유형) — enum('image', 'text')
  • text_value (텍스트_추출값) — text
  • image_value (이미지_추출값) — Blob
  • job_id (추출작업_아이디) — int — Foreign key → ExtractJobLog.id — NOT NULL
  • doco_type (작업대상문서타입) — int — Foreign key → InputDocumentType.id — NOT NULL