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