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