dd
Tables (32)
block
- id — BIGINT — Primary key — 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- block_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- block_analysis_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- snapshot_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- snapshot_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- block_id — BIGINT — Foreign key → 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
- input_bundle_sha256 — CHAR(64)
- canonical_content_sha256 — CHAR(64)
- analyzed_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
- created_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
- updated_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
block_evidence
- id — BIGINT — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- block_id — BIGINT — Foreign key → block.id — NOT NULL — FK -> block.id
- channel_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- snapshot_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- snapshot_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- snapshot_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- snapshot_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- block_id — BIGINT — Foreign key → block.id — NOT NULL — FK -> block.id
- mega_trend_id — BIGINT — Foreign key → mega_trend.id — NOT NULL — FK -> mega_trend.id
- display_order — SMALLINT — NOT NULL — default: 1
block_snapshot_channel
- id — BIGINT — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- snapshot_id — BIGINT — Foreign key → block_detail_snapshot.id — NOT NULL — FK -> block_detail_snapshot.id
- channel_id — BIGINT — Foreign key → channel.id — NOT NULL — FK -> channel.id
block_snapshot_lg_narrative
- id — BIGINT — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- snapshot_id — BIGINT — Foreign key → block_detail_snapshot.id — 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- snapshot_id — BIGINT — Foreign key → block_detail_snapshot.id — 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- snapshot_id — BIGINT — Foreign key → block_detail_snapshot.id — 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- snapshot_id — BIGINT — Foreign key → block_detail_snapshot.id — 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- user_id — BIGINT — Foreign key → users.id — NOT NULL — FK -> users.id
- block_id — BIGINT — Foreign key → block.id — NOT NULL — FK -> block.id
- created_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
channel
- id — BIGINT — Primary key — 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- block_id — BIGINT — Foreign key → block.id — NOT NULL — FK -> block.id
- user_id — BIGINT — Foreign key → 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 — Primary key — 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- run_id — BIGINT — Foreign key → competitive_positioning_run.id — NOT NULL — FK -> competitive_positioning_run.id
- block_id — BIGINT — Foreign key → block.id — NOT NULL — FK -> block.id
- company_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- observation_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- run_id — BIGINT — Foreign key → competitive_positioning_run.id — NOT NULL — FK -> competitive_positioning_run.id
- block_id — BIGINT — Foreign key → 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 — Primary key — 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 — Primary key — 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- user_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- positioning_map_id — BIGINT — Foreign key → positioning_map.id — NOT NULL — FK -> positioning_map.id
- block_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- user_id — BIGINT — Foreign key → users.id — NOT NULL — FK -> users.id
- block_id — BIGINT — Foreign key → block.id — NOT NULL — FK -> block.id
- viewed_at — TIMESTAMP — NOT NULL — timestamptz (UTC)
refresh_tokens
- id — BIGINT — Primary key — NOT NULL — PK, Postgres BIGINT GENERATED ALWAYS AS IDENTITY
- user_id — BIGINT — Foreign key → 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 — Primary key — 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 — Primary key — 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)