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