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