팔감

테이블 (32)

block

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • title — VARCHAR(200) — NOT NULL
  • summary — TEXT
  • business_division — VARCHAR(30) — NOT NULL — allowed: LIVING_SOLUTION, KITCHEN_SOLUTION, BUILTIN_COOKING, COMPONENT_SOLUTION
  • relation_type — VARCHAR(20) — allowed: FUTURE, INNOVATION, STABLE, EXPANSION
  • keywords — JSON — NOT NULL — jsonb; default:
  • created_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • updated_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • external_key — VARCHAR(200)

block_analysis

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • block_id — BIGINT — 외래 키 → block.id — NOT NULL — FK -> block.id
  • version — INT — NOT NULL
  • overall_score — DECIMAL(5, 2)
  • lg_connection — JSON — jsonb
  • why_trending — JSON — NOT NULL — jsonb; default:
  • competitor_startup — JSON — NOT NULL — jsonb; default:
  • analyzed_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • coverage — DECIMAL(3, 2)

block_axis_assessment

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • block_analysis_id — BIGINT — 외래 키 → block_analysis.id — NOT NULL — FK -> block_analysis.id
  • axis — VARCHAR(20) — NOT NULL — allowed: PAIN, ATTENTION, PRODUCT, TECHNOLOGY, COMMITMENT
  • score — SMALLINT
  • status — VARCHAR(20) — NOT NULL — allowed: UNASSESSED, INSUFFICIENT, SUPPORTED, MIXED, COUNTER_ONLY
  • rationale — TEXT

block_customer_evidence

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • snapshot_id — BIGINT — 외래 키 → block_detail_snapshot.id — NOT NULL — FK -> block_detail_snapshot.id
  • display_order — INT — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • evidence_date — DATE
  • summary — TEXT — NOT NULL
  • url — TEXT — NOT NULL
  • source_type — VARCHAR(30) — allowed: COMMUNITY_POST, QA_POST, BLOG_POST, BLOG_REVIEW, MARKETPLACE_REVIEW, VIDEO_REVIEW, NEWS_ARTICLE, OFFICIAL_PROD…
  • source_role — VARCHAR(20) — allowed: DISCOVERY, INTERESTED, THIRD_PARTY
  • channel — VARCHAR(100)
  • canonical_key — VARCHAR(500)
  • duplicate_of_canonical_key — VARCHAR(500)

block_customer_evidence_axis

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • snapshot_id — BIGINT — 외래 키 → block_detail_snapshot.id — NOT NULL — FK -> block_detail_snapshot.id
  • display_order — SMALLINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • score — DECIMAL(5, 2) — NOT NULL
  • reason — TEXT — NOT NULL
  • tone — VARCHAR(30) — NOT NULL

block_detail_snapshot

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • block_id — BIGINT — 외래 키 → block.id — NOT NULL — FK -> block.id
  • version — INT — NOT NULL
  • formula_version — VARCHAR(100) — NOT NULL
  • dataset_version — VARCHAR(100) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — allowed: PENDING, PARTIAL, READY, NOT_COMPARABLE
  • status_reason — TEXT
  • overall_score — DECIMAL(5, 2)
  • overall_summary — TEXT
  • customer_evidence_score — DECIMAL(5, 2)
  • market_score — DECIMAL(5, 2)
  • market_size_relative_score — DECIMAL(9, 6)
  • recent_growth_relative_score — DECIMAL(9, 6)
  • forecast_growth_relative_score — DECIMAL(9, 6)
  • fit_score — DECIMAL(9, 6)
  • competition_gap_score — DECIMAL(9, 6)
  • lg_opportunity_score — DECIMAL(5, 2)
  • technology_fit_score — DECIMAL(5, 2)
  • customer_channel_fit_score — DECIMAL(5, 2)
  • portfolio_fit_score — DECIMAL(5, 2)
  • market_name — VARCHAR(200)
  • market_scope — TEXT
  • current_size_year — INT
  • current_size_value — DECIMAL(20, 4)
  • current_size_unit — VARCHAR(50)
  • historical_cagr — DECIMAL(9, 4)
  • historical_cagr_note — TEXT
  • recent_growth — DECIMAL(9, 4)
  • recent_growth_period — VARCHAR(100)
  • forecast_cagr — DECIMAL(9, 4)
  • market_source_name — VARCHAR(500)
  • market_source_url — TEXT
  • judgment — TEXT
  • business — TEXT
  • customer_task — TEXT
  • product_gap — TEXT
  • competitor_activity — TEXT
  • channels — JSON — NOT NULL — jsonb; default:
  • related_products — JSON — NOT NULL — jsonb; default:
  • related_technologies — JSON — NOT NULL — jsonb; default:
  • internal_checks — JSON — NOT NULL — jsonb; default: {}
  • analyzed_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • created_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • updated_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • market_taxonomy — TEXT
  • market_mapping_level — VARCHAR(100)
  • market_mapping_rationale — TEXT
  • market_scope_type — VARCHAR(20) — allowed: DIRECT, ADJACENT, UNRESOLVED
  • market_research_status — VARCHAR(20) — allowed: COMPLETE, PARTIAL, FAILED
  • market_research_status_reason — TEXT
  • market_geography — VARCHAR(100)
  • market_currency — VARCHAR(3)
  • market_base_year — INT
  • market_context_missing_reason — TEXT
  • previous_size_year — INT
  • previous_size_value — DECIMAL(20, 4)
  • previous_size_unit — VARCHAR(50)
  • previous_size_missing_reason — TEXT
  • current_size_missing_reason — TEXT
  • recent_growth_missing_reason — TEXT
  • … +5

block_evidence

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • block_id — BIGINT — 외래 키 → block.id — NOT NULL — FK -> block.id
  • channel_id — BIGINT — 외래 키 → channel.id — NOT NULL — FK -> channel.id
  • source_title — VARCHAR(500)
  • source_url — TEXT — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL — allowed: ORIGINAL, SEARCH_RESULT
  • content — TEXT
  • published_at — TIMESTAMP — timestamptz (UTC)
  • collected_at — TIMESTAMP — NOT NULL — timestamptz (UTC)

block_lg_opportunity_internal_check

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • snapshot_id — BIGINT — 외래 키 → block_detail_snapshot.id — NOT NULL — FK -> block_detail_snapshot.id
  • check_type — VARCHAR(100) — NOT NULL
  • check_status — VARCHAR(30) — NOT NULL
  • note — TEXT

block_lg_opportunity_observation

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • snapshot_id — BIGINT — 외래 키 → block_detail_snapshot.id — NOT NULL — FK -> block_detail_snapshot.id
  • observation_id — VARCHAR(200) — NOT NULL
  • capability_taxonomy — VARCHAR(200) — NOT NULL
  • company — VARCHAR(200) — NOT NULL
  • subject_kind — VARCHAR(20) — NOT NULL — allowed: PRODUCT, TECHNOLOGY
  • name — VARCHAR(500) — NOT NULL
  • observation_status — VARCHAR(20) — NOT NULL — allowed: CONFIRMED, UNKNOWN
  • capability_match — BOOLEAN
  • url — TEXT — NOT NULL
  • retrieved_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • document_sha256 — VARCHAR(64)
  • review_version — VARCHAR(100) — NOT NULL
  • quote — TEXT
  • source_role — VARCHAR(20) — NOT NULL
  • competitor_slot — SMALLINT

block_market_citation

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • snapshot_id — BIGINT — 외래 키 → block_detail_snapshot.id — NOT NULL — FK -> block_detail_snapshot.id
  • display_order — INT — NOT NULL
  • cited_for — VARCHAR(30) — NOT NULL — allowed: SCOPE_MAPPING, PREVIOUS_SIZE, CURRENT_SIZE, RECENT_GROWTH, HISTORICAL_CAGR, FORECAST_CAGR
  • source_name — VARCHAR(500) — NOT NULL
  • source_url — TEXT — NOT NULL
  • citation — TEXT — NOT NULL
  • captured_at — TIMESTAMP — timestamptz (UTC)

block_market_series

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • snapshot_id — BIGINT — 외래 키 → block_detail_snapshot.id — NOT NULL — FK -> block_detail_snapshot.id
  • display_order — INT — NOT NULL
  • series_year — INT — NOT NULL
  • value — DECIMAL(20, 4) — NOT NULL
  • unit — VARCHAR(50) — NOT NULL

block_mega_trend

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • block_id — BIGINT — 외래 키 → block.id — NOT NULL — FK -> block.id
  • mega_trend_id — BIGINT — 외래 키 → mega_trend.id — NOT NULL — FK -> mega_trend.id
  • display_order — SMALLINT — NOT NULL — default: 1

block_snapshot_channel

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • snapshot_id — BIGINT — 외래 키 — NOT NULL — FK -> block_detail_snapshot.id
  • channel_id — BIGINT — 외래 키 — NOT NULL — FK -> channel.id

block_snapshot_lg_narrative

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • snapshot_id — BIGINT — 외래 키 — NOT NULL — FK -> block_detail_snapshot.id
  • gap_status — VARCHAR(20) — allowed: UNKNOWN, PROVISIONAL_GAP, CONFIRMED
  • judgment — TEXT
  • business — TEXT
  • customer_task — TEXT
  • product_gap — TEXT
  • competitor_activity — TEXT

block_snapshot_market

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • snapshot_id — BIGINT — 외래 키 — NOT NULL — FK -> block_detail_snapshot.id
  • market_name — VARCHAR(200)
  • market_scope — TEXT
  • market_taxonomy — TEXT
  • market_mapping_level — VARCHAR(100)
  • market_mapping_rationale — TEXT
  • market_scope_type — VARCHAR(20) — allowed: DIRECT, ADJACENT, UNRESOLVED
  • market_research_status — VARCHAR(20) — allowed: COMPLETE, PARTIAL, FAILED
  • market_research_status_reason — TEXT
  • market_geography — VARCHAR(100)
  • market_currency — VARCHAR(3)
  • market_base_year — INT
  • market_context_missing_reason — TEXT
  • historical_cagr — DECIMAL(9, 4)
  • historical_cagr_note — TEXT
  • historical_cagr_period_years — SMALLINT
  • recent_growth — DECIMAL(9, 4)
  • recent_growth_period — VARCHAR(100)
  • recent_growth_missing_reason — TEXT
  • forecast_cagr — DECIMAL(9, 4)
  • forecast_cagr_missing_reason — TEXT
  • previous_size_missing_reason — TEXT
  • current_size_missing_reason — TEXT

block_snapshot_related_item

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • snapshot_id — BIGINT — 외래 키 — NOT NULL — FK -> block_detail_snapshot.id
  • item_type — VARCHAR(20) — NOT NULL — allowed: PRODUCT, TECHNOLOGY
  • name — VARCHAR(500) — NOT NULL
  • display_order — SMALLINT — NOT NULL

block_snapshot_score

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • snapshot_id — BIGINT — 외래 키 — NOT NULL — FK -> block_detail_snapshot.id
  • overall_score — DECIMAL(5, 2)
  • overall_summary — TEXT
  • customer_evidence_score — DECIMAL(5, 2)
  • market_score — DECIMAL(5, 2)
  • market_size_relative_score — DECIMAL(9, 6)
  • recent_growth_relative_score — DECIMAL(9, 6)
  • forecast_growth_relative_score — DECIMAL(9, 6)
  • fit_score — DECIMAL(9, 6)
  • competition_gap_score — DECIMAL(9, 6)
  • lg_opportunity_score — DECIMAL(5, 2)
  • technology_fit_score — DECIMAL(5, 2)
  • customer_channel_fit_score — DECIMAL(5, 2)
  • portfolio_fit_score — DECIMAL(5, 2)

bookmark

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL — FK -> users.id
  • block_id — BIGINT — 외래 키 → block.id — NOT NULL — FK -> block.id
  • created_at — TIMESTAMP — NOT NULL — timestamptz (UTC)

channel

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(20) — NOT NULL — allowed: SOCIAL, COMMUNITY, CROWDFUNDING, COMMERCE, NEWS, AWARD, EXHIBITION, SEARCH

comment

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • block_id — BIGINT — 외래 키 → block.id — NOT NULL — FK -> block.id
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL — FK -> users.id
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • updated_at — TIMESTAMP — NOT NULL — timestamptz (UTC)

competitive_company

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • company_key — VARCHAR(100) — NOT NULL
  • display_name — VARCHAR(100) — NOT NULL
  • is_lg — BOOLEAN — NOT NULL
  • news_aliases — JSON — NOT NULL — jsonb; default:
  • patent_aliases — JSON — NOT NULL — jsonb; default:
  • created_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • updated_at — TIMESTAMP — NOT NULL — timestamptz (UTC)

competitive_observation

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • run_id — BIGINT — 외래 키 → competitive_positioning_run.id — NOT NULL — FK -> competitive_positioning_run.id
  • block_id — BIGINT — 외래 키 → block.id — NOT NULL — FK -> block.id
  • company_id — BIGINT — 외래 키 → competitive_company.id — NOT NULL — FK -> competitive_company.id
  • metric — VARCHAR(10) — NOT NULL — allowed: PATENT, PRODUCT, NEWS
  • query_tier — VARCHAR(10) — NOT NULL — allowed: CATEGORY, FEATURE
  • value — INT
  • status — VARCHAR(20) — NOT NULL — allowed: COLLECTED, EMPTY, PARTIAL, NOT_CONFIGURED, AUTH_REQUIRED, RATE_LIMITED, ACCESS_BLOCKED, FAILED, ALIAS_UNVERIFI…
  • window_start — TIMESTAMP — timestamptz (UTC)
  • window_end — TIMESTAMP — timestamptz (UTC)
  • query_string — TEXT — NOT NULL
  • collected_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • dedup_method — VARCHAR(50)
  • row_count_raw — INT

competitive_observation_evidence

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • observation_id — BIGINT — 외래 키 → competitive_observation.id — NOT NULL — FK -> competitive_observation.id
  • evidence_type — VARCHAR(20) — NOT NULL — allowed: OFFICIAL_PRODUCT, NEWS_ARTICLE, PATENT_SEARCH
  • url — TEXT — NOT NULL
  • captured_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • note — TEXT

competitive_positioning_coordinate

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • run_id — BIGINT — 외래 키 → competitive_positioning_run.id — NOT NULL — FK -> competitive_positioning_run.id
  • block_id — BIGINT — 외래 키 → block.id — NOT NULL — FK -> block.id
  • patent_activity — DECIMAL(5, 2)
  • product_activity — DECIMAL(5, 2)
  • news_activity — DECIMAL(5, 2)
  • patent_gap — DECIMAL(5, 4)
  • product_gap — DECIMAL(5, 4)
  • news_gap — DECIMAL(5, 4)
  • market_activity_x — DECIMAL(5, 2)
  • lg_deficit_y — DECIMAL(5, 2)
  • status — VARCHAR(20) — NOT NULL — allowed: READY, READY_PARTIAL_BASIS
  • reason — TEXT
  • scope_rationale — TEXT

competitive_positioning_run

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • run_key — VARCHAR(100) — NOT NULL
  • formula_version — VARCHAR(100) — NOT NULL
  • competitor_set_version — VARCHAR(100) — NOT NULL
  • query_version — VARCHAR(100) — NOT NULL
  • news_attribution — VARCHAR(10) — NOT NULL — allowed: STRICT, TOKEN, LOOSE
  • basis — JSON — NOT NULL — jsonb; default:
  • basis_weight — DECIMAL(3, 2) — NOT NULL
  • scale_patent — DECIMAL(12, 4)
  • scale_news — DECIMAL(12, 4)
  • minimum_market_activity — DECIMAL(5, 2) — NOT NULL
  • generated_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • created_at — TIMESTAMP — NOT NULL — timestamptz (UTC)

mega_trend

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • sort_order — INT — NOT NULL — default: 0

positioning_map

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL — FK -> users.id
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • updated_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • coordinate_formula_version — VARCHAR(100)

positioning_map_block

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • positioning_map_id — BIGINT — 외래 키 → positioning_map.id — NOT NULL — FK -> positioning_map.id
  • block_id — BIGINT — 외래 키 → block.id — NOT NULL — FK -> block.id
  • relative_x — DECIMAL(7, 6) — NOT NULL
  • relative_y — DECIMAL(7, 6) — NOT NULL
  • display_order — INT — NOT NULL — default: 0

recent_block_view

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL — FK -> users.id
  • block_id — BIGINT — 외래 키 → block.id — NOT NULL — FK -> block.id
  • viewed_at — TIMESTAMP — NOT NULL — timestamptz (UTC)

refresh_tokens

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL — FK -> users.id
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • revoked_at — TIMESTAMP — timestamptz (UTC)
  • created_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • updated_at — TIMESTAMP — NOT NULL — timestamptz (UTC)

users

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • lg_user_id — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255)
  • business_division — VARCHAR(30) — allowed: LIVING_SOLUTION, KITCHEN_SOLUTION, BUILTIN_COOKING, COMPONENT_SOLUTION
  • last_visited_at — TIMESTAMP — timestamptz (UTC)
  • created_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • updated_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
  • password_hash — VARCHAR(100) — NOT NULL

weekly_insight

  • id — BIGINT — 기본 키 — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
  • business_division — VARCHAR(30) — allowed: LIVING_SOLUTION, KITCHEN_SOLUTION, BUILTIN_COOKING, COMPONENT_SOLUTION
  • week_start — DATE — NOT NULL
  • content — TEXT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL — timestamptz (UTC)