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