dd

Tables (50)

activity_events

  • id — uuid — Primary key — NOT NULL
  • program_id — text — Foreign key → programs.id
  • project_id — text — Foreign key → projects.id
  • entity_type — text — NOT NULL
  • entity_id — text — NOT NULL
  • action — text — NOT NULL
  • actor — text
  • title — text
  • summary — text
  • changes — jsonb — NOT NULL
  • created_at — timestamp — NOT NULL

asset_access_logs

  • id — uuid — Primary key — NOT NULL
  • assistant_run_id — uuid — Foreign key → assistant_runs.id
  • asset_node_id — uuid — Foreign key → asset_nodes.id — NOT NULL
  • access_type — text — NOT NULL
  • tool_name — text
  • created_at — timestamp — NOT NULL

asset_chunks

  • id — uuid — Primary key — NOT NULL
  • asset_node_id — uuid — Foreign key → asset_nodes.id — NOT NULL
  • chunk_index — integer — NOT NULL
  • chunk_text — text — NOT NULL
  • summary — text
  • keywords — jsonb — NOT NULL
  • embedding — USER-DEFINED
  • token_count — integer
  • created_at — timestamp — NOT NULL
  • chunk_type — text — NOT NULL

asset_facets

  • id — uuid — Primary key — NOT NULL
  • asset_node_id — uuid — Foreign key → asset_nodes.id — NOT NULL
  • scope_type — text — NOT NULL
  • scope_key — text
  • facet_type — text — NOT NULL
  • facet_value — text — NOT NULL
  • facet_label — text
  • confidence — numeric
  • source — text — NOT NULL
  • metadata — jsonb — NOT NULL
  • created_at — timestamp — NOT NULL

asset_nodes

  • id — uuid — Primary key — NOT NULL
  • source_id — uuid — Foreign key → asset_sources.id
  • node_type — text — NOT NULL
  • title — text — NOT NULL
  • uri — text
  • mime_type — text
  • content_text — text
  • metadata — jsonb — NOT NULL
  • program_id — text — Foreign key → programs.id
  • project_id — text — Foreign key → projects.id
  • task_id — uuid — Foreign key
  • parent_node_id — uuid — Foreign key → asset_nodes.id
  • version_tag — text
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL

asset_sources

  • id — uuid — Primary key — NOT NULL
  • source_type — text — NOT NULL
  • name — text — NOT NULL
  • connection_ref — text
  • program_id — text — Foreign key → programs.id
  • project_id — text — Foreign key → projects.id
  • sync_policy — jsonb — NOT NULL
  • is_active — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

assistant_actions

  • id — uuid — Primary key — NOT NULL
  • run_id — uuid — Foreign key → assistant_runs.id
  • action_type — text — NOT NULL
  • payload — jsonb — NOT NULL
  • status — text — NOT NULL
  • executed_at — timestamp
  • created_at — timestamp — NOT NULL

assistant_memories

  • id — uuid — Primary key — NOT NULL
  • scope_type — text — NOT NULL
  • scope_id — text — NOT NULL
  • memory_type — text — NOT NULL
  • content — text — NOT NULL
  • metadata — jsonb — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL

assistant_runs

  • id — uuid — Primary key — NOT NULL
  • session_id — uuid — Foreign key → assistant_sessions.id
  • user_input — text — NOT NULL
  • intent_type — text
  • tool_plan — jsonb — NOT NULL
  • retrieved_context — jsonb — NOT NULL
  • evidence_pack — jsonb — NOT NULL
  • answer_text — text
  • confidence_score — numeric
  • status — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • hop_count — integer — NOT NULL
  • cost_usd — numeric
  • prompt_tokens — integer
  • completion_tokens — integer

assistant_sessions

  • id — uuid — Primary key — NOT NULL
  • scope_type — text — NOT NULL
  • scope_id — text — NOT NULL
  • active_goal_id — uuid — Foreign key → goals.id
  • title — text
  • created_by — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

comments

  • id — uuid — Primary key — NOT NULL
  • project_id — text — Foreign key → projects.id — NOT NULL
  • entity_type — text — NOT NULL
  • entity_id — uuid — NOT NULL
  • content — text — NOT NULL
  • author — text — NOT NULL
  • created_at — timestamp — NOT NULL

company_directory

  • emp_code — text — Primary key — NOT NULL
  • name — text — NOT NULL
  • job_title — text
  • company — text
  • dept — text
  • dept_secondary — text
  • office_phone — text
  • mobile — text
  • email — text
  • duty — text
  • synced_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • photo_url — text
  • fax — text

corp_approval_lines

  • id — uuid — Primary key — NOT NULL
  • skill_slug — text — Foreign key → corp_skills.slug — NOT NULL
  • name — text — NOT NULL
  • is_default — boolean — NOT NULL
  • approvers — jsonb — NOT NULL
  • notes — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • owner_id — text — Foreign key

corp_skill_runs

  • id — uuid — Primary key — NOT NULL
  • skill_slug — text — Foreign key → corp_skills.slug
  • actor — text
  • input — jsonb
  • status — text — NOT NULL
  • result — jsonb
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

corp_skills

  • slug — text — Primary key — NOT NULL
  • name — text — NOT NULL
  • description — text
  • category — text
  • system — text
  • form_id — text
  • entry_url_template — text
  • executor_type — text — NOT NULL
  • executor_path — text
  • input_schema — jsonb — NOT NULL
  • approval_required — boolean — NOT NULL
  • active — boolean — NOT NULL
  • priority — integer — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • auto_run — boolean — NOT NULL

datasets

  • id — uuid — Primary key — NOT NULL
  • project_id — text — Foreign key → projects.id — NOT NULL
  • name — text — NOT NULL
  • description — text
  • source — text
  • data_type — text
  • file_url — text
  • sample_count — integer
  • version — text
  • status — text — NOT NULL
  • labeling_required — boolean — NOT NULL
  • tags — ARRAY
  • registered_by — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

entity_links

  • id — uuid — Primary key — NOT NULL
  • from_type — text — NOT NULL
  • from_id — text — NOT NULL
  • to_type — text — NOT NULL
  • to_id — text — NOT NULL
  • relation_type — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • status — text — NOT NULL
  • confidence — numeric
  • matched_by — text
  • created_by — text

experiments

  • id — uuid — Primary key — NOT NULL
  • project_id — text — Foreign key → projects.id — NOT NULL
  • dataset_id — uuid — Foreign key → datasets.id
  • model_id — uuid — Foreign key → models.id
  • name — text — NOT NULL
  • purpose — text
  • params_json — jsonb
  • metrics_json — jsonb
  • result_summary — text
  • status — text — NOT NULL
  • run_by — text
  • run_url — text
  • started_at — timestamp
  • completed_at — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

goal_checkins

  • id — uuid — Primary key — NOT NULL
  • goal_id — uuid — Foreign key → goals.id — NOT NULL
  • checkin_date — date — NOT NULL
  • summary — text — NOT NULL
  • blockers — text
  • evidence_links — jsonb — NOT NULL
  • next_step_note — text
  • created_by — text
  • created_at — timestamp — NOT NULL

goals

  • id — uuid — Primary key — NOT NULL
  • scope_type — text — NOT NULL
  • scope_id — text — NOT NULL
  • title — text — NOT NULL
  • description — text
  • metric_name — text
  • target_value — text
  • current_value — text
  • deadline — date
  • owner — text
  • priority — text — NOT NULL
  • status — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

ideas

  • id — uuid — Primary key — NOT NULL
  • project_id — text — Foreign key → projects.id — NOT NULL
  • title — text
  • raw_text — text — NOT NULL
  • structured_summary — text
  • hypothesis — text
  • needed_data — text
  • risks — text
  • category — text
  • priority — text
  • status — text — NOT NULL
  • owner — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

intra_menu_catalog

  • menu_id — text — Primary key — NOT NULL
  • menu_name — text — NOT NULL
  • menu_path — text
  • menu_lev — smallint
  • group_id — text
  • category — text
  • prg_id — text
  • prg_url — text
  • syst_se — text
  • inq_auth_yn — text
  • use_yn — text
  • menu_ord — integer
  • parent_menu_id — text
  • entry_url — text
  • notes — text
  • has_skill_slug — text
  • cached_source_id — uuid — Foreign key → asset_sources.id
  • last_seen_at — timestamp — NOT NULL
  • last_synced_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • my_inq_auth_yn — smallint
  • my_auth_checked_at — timestamp

labeling_jobs

  • id — uuid — Primary key — NOT NULL
  • project_id — text — Foreign key → projects.id — NOT NULL
  • dataset_id — uuid — Foreign key → datasets.id — NOT NULL
  • name — text — NOT NULL
  • schema_text — text
  • guideline_text — text
  • assignee — text
  • total_items — integer — NOT NULL
  • labeled_count — integer — NOT NULL
  • status — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

llm_calls

  • id — uuid — Primary key — NOT NULL
  • called_at — timestamp — NOT NULL
  • actor — text — Foreign key
  • scope_type — text
  • scope_id — text
  • purpose — text — NOT NULL
  • provider — text — NOT NULL
  • model — text — NOT NULL
  • prompt_tokens — integer
  • completion_tokens — integer
  • cost_usd — numeric
  • duration_ms — integer
  • status — text — NOT NULL
  • error_text — text
  • cached_tokens — integer

llm_defaults

  • purpose — text — Primary key — NOT NULL
  • model — text — Foreign key → llm_pricing.model
  • thinking — boolean
  • updated_by — text — Foreign key
  • updated_at — timestamp

llm_pricing

  • model — text — Primary key — NOT NULL
  • provider — text — NOT NULL
  • input_per_m — numeric — NOT NULL
  • output_per_m — numeric — NOT NULL
  • cache_read_multiplier — numeric
  • cache_write_multiplier — numeric
  • notes — text
  • updated_by — text — Foreign key
  • updated_at — timestamp

llm_result_cache

  • purpose — text — NOT NULL
  • model — text — NOT NULL
  • scope_type — text
  • scope_id — text
  • result — text — NOT NULL
  • hit_count — integer — NOT NULL
  • generated_at — timestamp — NOT NULL
  • expires_at — timestamp — NOT NULL
  • last_hit_at — timestamp

mcp_tokens

  • id — uuid — Primary key — NOT NULL
  • token_hash — text — NOT NULL
  • supabase_user_id — uuid — NOT NULL
  • actor_id — text — Foreign key
  • label — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • last_used_at — timestamp
  • revoked_at — timestamp
  • manifest_id — text — NOT NULL
  • scope_policy — jsonb — NOT NULL

meeting_items

  • id — uuid — Primary key — NOT NULL
  • meeting_id — uuid — Foreign key → meetings.id — NOT NULL
  • title — text — NOT NULL
  • summary — text
  • decision — text
  • action_items — jsonb
  • sort_order — integer — NOT NULL
  • created_at — timestamp — NOT NULL

meetings

  • id — uuid — Primary key — NOT NULL
  • project_id — text — Foreign key → projects.id
  • title — text — NOT NULL
  • date — date
  • attendees — ARRAY
  • raw_notes — text
  • summary — text
  • decisions — jsonb
  • open_questions — jsonb
  • action_items — jsonb
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • program_id — text — Foreign key → programs.id
  • audio_uri — text
  • transcription_status — text
  • transcription_error — text
  • transcription_lang — text
  • transcribed_at — timestamp
  • processed_at — timestamp
  • processed_by — text
  • processed_summary — jsonb
  • audio_local_uri — text
  • audio_mime — text
  • audio_duration_ms — integer
  • realtime_session_id — text
  • recording_started_at — timestamp
  • recording_ended_at — timestamp
  • transcript_segments — jsonb
  • transcript_engine — text
  • transcribe_status — text
  • transcribe_started_at — timestamp
  • transcribe_completed_at — timestamp
  • transcribe_error — text
  • teams_recording_uri — text
  • source_channel_id — uuid — Foreign key
  • speaker_labels — jsonb — NOT NULL
  • metadata — jsonb
  • kind — text
  • subject_domain — text

member_sso_credentials

  • member_id — text — Foreign key — NOT NULL
  • emp_code — text — NOT NULL
  • ciphertext — text — NOT NULL
  • iv — text — NOT NULL
  • auth_tag — text — NOT NULL
  • cmp_id — text — NOT NULL
  • verified_at — timestamp
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • approval_ciphertext — text
  • approval_iv — text
  • approval_auth_tag — text
  • approval_verified_at — timestamp

models

  • id — uuid — Primary key — NOT NULL
  • project_id — text — Foreign key → projects.id — NOT NULL
  • name — text — NOT NULL
  • type — text
  • version — text
  • source — text
  • metrics_json — jsonb
  • artifact_path — text
  • notes — text
  • status — text — NOT NULL
  • registered_by — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

notifications

  • id — uuid — Primary key — NOT NULL
  • recipient_id — text — Foreign key — NOT NULL
  • actor_id — text — Foreign key
  • kind — text — NOT NULL
  • severity — text — NOT NULL
  • title — text — NOT NULL
  • body — text
  • entity_type — text — NOT NULL
  • entity_id — text — NOT NULL
  • project_id — text — Foreign key → projects.id
  • href — text — NOT NULL
  • read_at — timestamp
  • created_at — timestamp — NOT NULL

npd_branding_outputs

  • id — uuid — Primary key — NOT NULL
  • product_unit_id — uuid — Foreign key → npd_product_units.id — NOT NULL
  • reverse_target_id — uuid — Foreign key → npd_reverse_targets.id
  • core_positioning — text
  • product_name_candidates — ARRAY
  • japanese_copy_candidates — ARRAY
  • package_direction — text
  • channel_messages — jsonb
  • avoid_messages — ARRAY
  • arrangement_suggestions — ARRAY
  • llm_provider — text
  • llm_model — text
  • created_at — timestamp — NOT NULL

npd_evidence_items

  • id — uuid — Primary key — NOT NULL
  • source — text — NOT NULL
  • source_type — text — NOT NULL
  • source_url — text
  • country — text
  • region — text
  • title — text
  • snippet — text
  • tags — ARRAY
  • numeric_metrics — jsonb
  • confidence — numeric
  • raw_item_id — uuid — Foreign key → npd_raw_items.id
  • collected_at — timestamp — NOT NULL

npd_internal_skus

  • id — uuid — Primary key — NOT NULL
  • sku_code — text — NOT NULL
  • product_name_ko — text — NOT NULL
  • product_name_en — text
  • brand — text
  • sub_brand — text
  • format — text
  • soup_or_dry — text
  • spicy_level — numeric
  • flavor_description — text
  • main_ingredients — ARRAY
  • nutrition — jsonb
  • price_position — text
  • current_export_countries — ARRAY
  • japan_export_status — text
  • brand_role — text
  • notes — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

npd_micro_taste_signals

  • id — uuid — Primary key — NOT NULL
  • signal_name — text — NOT NULL
  • signal_key — text
  • country — text
  • region — text
  • channel — text
  • occasion — text
  • price_band — text
  • taste_keywords — ARRAY
  • behavior_keywords — ARRAY
  • barrier_keywords — ARRAY
  • evidence_sources — ARRAY
  • evidence_count — integer
  • signal_strength — numeric
  • confidence — numeric
  • interpretation — text
  • status — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

npd_npd_validations

  • id — uuid — Primary key — NOT NULL
  • product_unit_id — uuid — Foreign key → npd_product_units.id — NOT NULL
  • taste_fit — numeric
  • channel_fit — numeric
  • occasion_fit — numeric
  • price_fit — numeric
  • barrier_reduction — numeric
  • brand_fit — numeric
  • evidence_confidence — numeric
  • novelty — numeric
  • portfolio_role_fit — numeric
  • cannibalization_risk — numeric
  • final_score — numeric
  • ai_summary — text
  • risks — ARRAY
  • next_validation_tasks — ARRAY
  • llm_provider — text
  • llm_model — text
  • created_at — timestamp — NOT NULL

npd_opportunity_spaces

  • id — uuid — Primary key — NOT NULL
  • name — text — NOT NULL
  • description — text
  • country — text
  • related_signal_ids — ARRAY
  • opportunity_type — text
  • taste_vector — jsonb
  • evidence_summary — text
  • confidence — numeric
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

npd_product_units

  • id — uuid — Primary key — NOT NULL
  • name — text — NOT NULL
  • product_type — text — NOT NULL
  • portfolio_role — text
  • opportunity_space_id — uuid — Foreign key → npd_opportunity_spaces.id
  • base_sku_id — uuid — Foreign key → npd_internal_skus.id
  • format — text
  • target_channel — ARRAY
  • price_band — text
  • taste_vector — jsonb
  • concept_description — text
  • main_barriers — ARRAY
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

npd_products

  • id — uuid — Primary key — NOT NULL
  • source — text — NOT NULL
  • product_name — text — NOT NULL
  • catchcopy — text
  • brand — text
  • manufacturer — text
  • shop_name — text
  • country — text
  • category — text
  • genre_id — text
  • format — text
  • price — numeric
  • currency — text
  • pack_count — integer
  • weight_g — numeric
  • review_count — integer
  • review_average — numeric
  • image_url — text
  • product_url — text
  • availability — text
  • raw_item_id — uuid — Foreign key → npd_raw_items.id
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

npd_raw_items

  • id — uuid — Primary key — NOT NULL
  • source — text — NOT NULL
  • source_type — text — NOT NULL
  • source_url — text
  • raw_title — text
  • raw_text — text
  • raw_json — jsonb
  • language — text
  • country — text
  • collected_at — timestamp — NOT NULL

npd_reverse_targets

  • id — uuid — Primary key — NOT NULL
  • product_unit_id — uuid — Foreign key → npd_product_units.id — NOT NULL
  • target_name — text — NOT NULL
  • channel — ARRAY
  • occasion — ARRAY
  • price_band — text
  • taste_need — ARRAY
  • main_barriers — ARRAY
  • usage_behaviors — ARRAY
  • demographic_hint — text
  • evidence_signal_ids — ARRAY
  • confidence — numeric
  • created_at — timestamp — NOT NULL

npd_signal_evidence_links

  • id — uuid — Primary key — NOT NULL
  • signal_id — uuid — Foreign key → npd_micro_taste_signals.id — NOT NULL
  • evidence_kind — text — NOT NULL
  • evidence_id — uuid — NOT NULL
  • contribution_score — numeric
  • created_at — timestamp — NOT NULL

npd_taste_tags

  • id — uuid — Primary key — NOT NULL
  • target_type — text — NOT NULL
  • target_id — uuid — NOT NULL
  • tag_type — text — NOT NULL
  • tag_value — text — NOT NULL
  • matched_keyword — text
  • score — numeric
  • evidence_text — text
  • evidence_item_id — uuid — Foreign key → npd_evidence_items.id
  • created_at — timestamp — NOT NULL

passkey_credentials

  • id — uuid — Primary key — NOT NULL
  • credential_id — text — NOT NULL
  • public_key — text — NOT NULL
  • counter — bigint — NOT NULL
  • supabase_user_id — uuid — NOT NULL
  • device_label — text — NOT NULL
  • transports — ARRAY
  • created_at — timestamp — NOT NULL
  • last_used_at — timestamp
  • revoked_at — timestamp

pipeline_runs

  • id — uuid — Primary key — NOT NULL
  • kind — text — NOT NULL
  • actor — text
  • scope_type — text
  • scope_id — text
  • status — text — NOT NULL
  • started_at — timestamp — NOT NULL
  • finished_at — timestamp
  • duration_ms — integer
  • summary — jsonb
  • error — text
  • metadata — jsonb
  • created_at — timestamp — NOT NULL

programs

  • id — text — Primary key — NOT NULL
  • name — text — NOT NULL
  • objective — text
  • description — text
  • stage — text — NOT NULL
  • owner — text
  • reporting_period — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

projects

  • id — text — Primary key — NOT NULL
  • name — text — NOT NULL
  • objective — text
  • description — text
  • stage — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • program_id — text — Foreign key → programs.id
  • owner — text
  • status — text
  • summary — text
  • success_metric — text
  • sort_order — integer
  • color — text
  • metadata — jsonb

report_drafts

  • id — uuid — Primary key — NOT NULL
  • project_id — text — Foreign key → projects.id — NOT NULL
  • title — text — NOT NULL
  • type — text — NOT NULL
  • generated_text — text
  • source_ids — jsonb
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • scope_type — text
  • scope_id — text