invoice_project
Tables (11)
document_history (Untitled6)
- document_id (Key) — bigserial — Primary key — NOT NULL — pk
- user_id (Key2) — varchar(20) — Foreign key → user_tbl.user_id — NOT NULL — fk
- invoice_id (Key3) — bigint — Foreign key → invoice_tbl.invoice_id — NOT NULL — fk
- ocr_raw_id (Key4) — bigserial — Foreign key → ocr_raw_tbl.ocr_raw_id — NOT NULL — fk
- file_name (Field) — varchar(150)
- file_route (Field2) — varchar(150)
- document_status (Field3) — varchar(30) — (ocr_failed,parser_failed,validation_failed,partial_success,success)
- document_status_reason (Field4) — varchar(300)
- created_at (Field5) — timestamp
invoice_item_tbl (CopyOfUntitled4)
- invoice_item_id (Key) — bigserial — Primary key — NOT NULL — pk
- invoice_id (Key2) — bigint — Foreign key → invoice_tbl.invoice_id — NOT NULL — fk
- item_description (Field) — text — 상품이름과 정보 일부
- quantity (Field2) — numeric(12,4)
- unit (Field3) — varchar(10) — 수량의 단위
- unit_price (Field4) — numeric(17,4)
- total_value (Field5) — numeric(16,2)
- currency (Field6) — varchar(10)
- country_of_origin (Field7) — varchar(50)
- hs_code (Field8) — varchar(20)
- gross_weight (Field9) — varchar(50)
- net_weight (Field10) — varchar(50)
- measurement (Field11) — varchar(50)
- shipping_mark (Field12) — text
invoice_tbl (Untitled2)
- invoice_id (Key) — bigint — Primary key — NOT NULL — pk
- invoice_no (Field) — varchar(30) — unique
- invoice_date (Field2) — timestamp — not null
- contract_no (Field3) — varchar(30)
- purchase_order_no (Field4) — varchar(30)
- approval_exists (Field5) — boolean
- created_at (Field6)
ocr_corrected_tbl (CopyOfUntitled3)
- ocr_corrected_id (Key) — bigserial — Primary key — NOT NULL — pk
- ocr_raw_id (Key2) — bigserial — Foreign key → ocr_raw_tbl.ocr_raw_id — NOT NULL — fk
- ocr_corrected_text (Field) — text — alias,jaro까지 완료후
- ocr_corrected_status (Field2) — varchar(10) — (success,fail,partial)
- ocr_corrected_status_reason (Field3) — varchar(300)
- created_at (Field4) — timestamp
ocr_raw_tbl (Untitled3)
- ocr_raw_id (Key) — bigserial — Primary key — NOT NULL — pk
- ocr_raw_text (Field) — text — 원문전부 저장
- origin_file_name (Field2) — varchar(100)
- ocr_file_route (Field3) — varchar(150)
- confidence_score (Field4) — numeric(5,2) — 98.29같은
- created_at (Field5) — timestamp
parser_result_tbl (CopyOfCopyOfUntitled3)
- parser_result_id (Key) — bigserial — Primary key — NOT NULL — pk
- ocr_corrected_id (Key2) — bigserial — Foreign key → ocr_corrected_tbl.ocr_corrected_id — NOT NULL — fk
- parser_result_json (Field) — jsonb
- parser_status (Field2) — varchar(10) — (success,fail,partial)
- parser_status_reason (Field3) — varchar(300)
- created_at (Field4) — timestamp
participant_tbl (Untitled4)
- participant_id (Key) — bigserial — Primary key — NOT NULL — pk
- invoice_id (Key2) — bigint — Foreign key → invoice_tbl.invoice_id — NOT NULL — fk
- participant_name (Field) — varchar(100) — 회사이름
- status (Field2) — varchar(20) — (seller,buyer,insurer,notify_party)
- address (Field3) — varchar(300)
- country (Field4) — varchar(50)
- contact (Field5) — varchar(150) — 이메일, 전화번호 모두 한번에 저장
payment_tbl (Untitled5)
- payment_id (Key) — bigserial — Primary key — NOT NULL — pk
- invoice_id (Key2) — bigint — Foreign key → invoice_tbl.invoice_id — NOT NULL — pk
- payment_type (Field) — char(5) — (L/C,T/T,D/A,D/C)
- payment_terms (Field2) — varchar(80) — payment_type뒤의 문자열과 함께 저장
- currency (Field3) — varchar(10) — usd,krw등
- total_amount (Field4) — numeric(18,2) — (소숫점자리 2개까지+조단위)
transport_tbl (CopyOfCopyOfUntitled4)
- transport_id (Key) — bigserial — Primary key — NOT NULL — pk
- invoice_id (Key2) — bigint — Foreign key → invoice_tbl.invoice_id — NOT NULL — fk
- port_of_loading (Field) — varchar(150) — 공항,항구 겸용
- port_of_discharge (Field2) — varchar(150) — 공항,항구겸용
- departure_date (Field3) — date
- eta (Field4) — date
- vessel (Field5) — varchar(50)
- incoterms (Field6) — varchar(10) — fca,cif등등..
- incoterms_location (Field7) — varchar(100)
- transport_doc_type (Field8) — varchar(20) — (B/L,AWB,SEAWAYBILL)
- transport_doc_no (Field9) — varchar(50)
user_tbl (Untitled)
- user_id (Key) — varchar(20) — Primary key — NOT NULL — pk
- password (Field) — char(60) — not null
- created_at (Field2) — date — not null
- updated_at (Field3) — date — null
validation_tbl (CopyOfCopyOfCopyOfUntitled3)
- validation_id (Key) — bigserial — Primary key — NOT NULL — pk
- parser_result_id (Key2) — bigserial — Foreign key → parser_result_tbl.parser_result_id — NOT NULL — fk
- invoice_id (Key3) — bigint — Foreign key → invoice_tbl.invoice_id — NOT NULL — pk
- validation_status (Field) — varchar(10) — (success,fail,partial)
- validation_status_reason (Field2) — varchar(300)
- created_at (Field3) — timestamp