hyper erd

Tables (3)

Analysis_Reports

  • id — SERIAL
  • company_id — INTEGER — Foreign key → Companies.id — NOT NULL
  • title — VARCHAR(500)
  • rcept_no — VARCHAR(20)
  • rcept_dt — VARCHAR(10)
  • report_type — VARCHAR(50)
  • basic_info — JSONB
  • status — VARCHAR(50)
  • created_at — TIMESTAMP

Companies

  • id — SERIAL
  • company_name — VARCHAR(255) — NOT NULL
  • corp_code — VARCHAR(20)
  • stock_code — VARCHAR(20)
  • industry — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Source_Materials

  • id — SERIAL
  • report_id — INTEGER — Foreign key → Analysis_Reports.id — NOT NULL
  • chunk_type — VARCHAR(20) — NOT NULL
  • section_path — TEXT
  • sequence_order — INTEGER — 문서
  • raw_content — TEXT
  • table_metadata — JSONB
  • embedding — vector(768) — HuggingFace
  • metadata — JSONB
  • created_at — TIMESTAMP