3rd

Tables (3)

Bank_Interest_Rate (Untitled2)

  • id (Key) — bigserial — Primary key — NOT NULL
  • bank_name (Field) — text — NOT NULL — 은행이름
  • product_name (Field2) — text — NOT NULL — 상품이름
  • product_category (Field3) — text — 상품분류(예금/적금/대출)
  • rate_type (Field4) — text — 금리 유형(기본/우대)
  • rate_condition (Field5) — text — 금리 조건
  • interest_rate (Field6) — text — 금리
  • source_file (Field7) — text — NOT NULL — 출처(문서)
  • created_at (Field8) — timestamptz — 생성시각

Documents (Untitled)

  • id (PK) — serial4 — Primary key — NOT NULL
  • doc_id (Field) — varchar(255) — NOT NULL — 문서 id
  • chunk_id (Field2) — varchar(255) — NOT NULL — 문서 청크 식별자
  • embedding (Field3) — public.vector — 임베딩 벡터
  • contnet (Field4) — text — NOT NULL — 상품별 정보 취합
  • bank_name (Field5) — varchar(100) — NOT NULL — 은행명(우리은행/국민은행)
  • document_name (Field6) — text — NOT NULL — 출처(문서)
  • product_type (Field7) — varchar(50) — NOT NULL — 상품유형(예금/적금/대출)
  • product_name (Field8) — varchar(255) — NOT NULL — 상품이름
  • clause (Field9) — varchar(255) — 조항 번호
  • clause_name (Field10) — varchar(255) — 조항이름
  • craeated_at (Field11) — timestamp — 생성시각
  • updated_at (Field12) — timestamp — 수정시각

Loan_Info (CopyOfUntitled2)

  • id (Key2) — bigserial — Foreign key → Bank_Interest_Rate.id — NOT NULL
  • product_category (Field3) — text — 상품분류(대출)
  • product_detail_category (Field4) — text — 대출상품 세부 분류
  • loan_target (Field5) — text — 대출대상
  • loan_conditions (Field6) — text — 대출조건
  • loan_period (Field9) — text — 대출기간
  • loan_limit (Field10) — text — 대출한도
  • source_file (Field7) — text — NOT NULL — 출처(문서)
  • created_at (Field8) — timestamptz — 생성시각