e105
Tables (50)
agent_messages
- message_id — text — Primary key — NOT NULL
- session_id — text — Foreign key → agent_sessions.session_id — NOT NULL
- task_run_id — text
- step_run_id — text
- event_id — text
- event_type — text
- message_sequence — int8 — NOT NULL
- role — text — NOT NULL
- content — jsonb — NOT NULL
- provider_name — text
- model_name — text
- metadata — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
agent_profiles
- id — int8 — Primary key — NOT NULL
- created_at — timestamp(6)
- model — varchar(100)
- name — varchar(100) — NOT NULL
- owner_user_id — int8 — NOT NULL
- status — varchar(30) — NOT NULL
- system_prompt — text
- type — varchar(30) — NOT NULL
- updated_at — timestamp(6)
- workspace_key — varchar(100)
- ARCHIVED::character — varying)::text)))
- SUBAGENT::character — varying)::text)))
agent_sessions
- session_id — text — Primary key — NOT NULL
- owner_key — text — NOT NULL
- session_key — text — NOT NULL
- task_run_id — text
- parent_session_id — text — Foreign key → agent_sessions.session_id
- parent_step_run_id — text
- agent_profile_id — text
- agent_profile_version — int4 — NOT NULL
- agent_config_snapshot — jsonb — NOT NULL
- session_role — text — NOT NULL
- status — text — NOT NULL
- title — text
- metadata — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- ended_at — timestamptz
- session_source — text — NOT NULL
- history_version — int8 — NOT NULL
- running_task_run_id — text
- workspace_key — text
- owner_user_id — int8 — Foreign key → users.id
- settings — jsonb — NOT NULL
- archived_at — timestamptz
- deleted_at — timestamptz
- deleted_by — int8 — Foreign key → users.id
- purge_after — timestamptz
ai_agent_instruction_bundles
- bundle_id — text — Primary key — NOT NULL
- profile_id — text — Foreign key → ai_agent_profiles.profile_id — NOT NULL
- owner_key — text — NOT NULL
- owner_user_id — int8 — Foreign key → users.id
- session_id — text — Foreign key → agent_sessions.session_id
- mode — text — NOT NULL
- entry_document_key — text — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
ai_agent_profiles
- profile_id — text — Primary key — NOT NULL
- owner_key — text — NOT NULL
- profile_key — text — NOT NULL
- profile_version — int4 — NOT NULL
- agent_type — text — NOT NULL
- provider_name — text
- model_name — text
- config_snapshot — jsonb — NOT NULL
- delegation_policy — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- owner_user_id — int8 — Foreign key → users.id
- session_id — text — Foreign key → agent_sessions.session_id
- template_key — text
ai_agent_skill_settings
- profile_id — text — Foreign key → ai_agent_profiles.profile_id — NOT NULL
- skill_id — text — Foreign key → ai_skill_catalog.skill_id — NOT NULL
- enabled — bool — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
ai_agent_templates
- template_id — text — Primary key — NOT NULL
- owner_key — text — NOT NULL
- template_key — text — NOT NULL
- template_version — int4 — NOT NULL
- default_agent_type — text — NOT NULL
- default_config_snapshot — jsonb — NOT NULL
- default_policy — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
ai_command_usage_records
- id — int8 — Primary key — NOT NULL
- cached_input_tokens — int8
- created_at — timestamp(6)
- currency — varchar(10) — NOT NULL
- estimated_cost_usd — numeric(20, 10)
- input_tokens — int8 — NOT NULL
- metadata — jsonb
- model — varchar(100) — NOT NULL
- output_tokens — int8 — NOT NULL
- provider_name — varchar(50) — NOT NULL
- reasoning_tokens — int8
- request_id — varchar(100)
- session_id — varchar(100)
- step_run_id — varchar(100)
- task_run_id — varchar(100) — NOT NULL
- total_tokens — int8 — NOT NULL
- user_id — int8 — NOT NULL
ai_skill_catalog
- skill_id — text — Primary key — NOT NULL
- name — text — NOT NULL
- display_name — text — NOT NULL
- description — text — NOT NULL
- source_type — text — NOT NULL
- source_path — text
- version — int4 — NOT NULL
- default_enabled — bool — NOT NULL
- metadata — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
ai_token_usage_logs
- id — int8 — Primary key — NOT NULL
- auth_type — varchar(30) — NOT NULL
- cached_input_tokens — int8 — NOT NULL
- created_at — timestamp(6)
- input_tokens — int8 — NOT NULL
- metadata — jsonb
- model — varchar(100) — NOT NULL
- output_tokens — int8 — NOT NULL
- provider_name — varchar(50) — NOT NULL
- raw_usage — jsonb
- reasoning_tokens — int8 — NOT NULL
- response_id — varchar(100)
- step_run_id — varchar(100)
- task_run_id — varchar(100)
- total_tokens — int8 — NOT NULL
- user_id — int8 — NOT NULL
ai_user_skill_settings
- owner_key — text — Primary key — NOT NULL
- skill_id — text — Foreign key → ai_skill_catalog.skill_id — NOT NULL
- owner_user_id — int8 — Foreign key → users.id
- enabled — bool — NOT NULL
- config_snapshot — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
approval_requests
- approval_id — text — Primary key — NOT NULL
- task_run_id — text — NOT NULL
- step_run_id — text — NOT NULL
- tool_call_id — text
- status — text — NOT NULL
- request_payload — jsonb — NOT NULL
- response_payload — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- resolved_at — timestamptz
- owner_user_id — int8 — Foreign key → users.id
bridge_devices
- id — int8 — Primary key — NOT NULL
- created_at — timestamp(6)
- device_name — varchar(60) — NOT NULL
- last_seen_at — timestamp(6)
- revoked_at — timestamp(6)
- token_hash — varchar(64) — NOT NULL
- updated_at — timestamp(6)
- user_id — int8 — Foreign key → users.id — NOT NULL
building_mappings
- id — int8 — Primary key — NOT NULL
- created_at — timestamp(6)
- floor — int4 — NOT NULL
- session_id — varchar(100) — NOT NULL
- updated_at — timestamp(6)
- user_id — int8 — Foreign key → users.id — NOT NULL
integration_credentials
- id — int8 — Primary key — NOT NULL
- created_at — timestamp(6)
- credential_key — varchar(100) — NOT NULL
- integration_id — int8 — NOT NULL
- secret_value — text — NOT NULL
- status — varchar(30) — NOT NULL
- updated_at — timestamp(6)
- DELETED::character — varying)::text)))
integrations
- id — int8 — Primary key — NOT NULL
- created_at — timestamp(6)
- name — varchar(100) — NOT NULL
- owner_user_id — int8 — NOT NULL
- provider — varchar(30) — NOT NULL
- status — varchar(30) — NOT NULL
- updated_at — timestamp(6)
- workspace_key — varchar(100)
- GITHUB::character — varying
- GOOGLE::character — varying
- NOTION::character — varying
- SLACK::character — varying)::text)))
- DELETED::character — varying)::text)))
iot_devices
- id — int8 — Primary key — NOT NULL
- created_at — timestamp(6)
- device_id — varchar(80) — NOT NULL
- display_name — varchar(100)
- last_seen_at — timestamp(6)
- status — varchar(20) — NOT NULL
- updated_at — timestamp(6)
- user_id — int8 — Foreign key → users.id — NOT NULL
- INACTIVE::character — varying)::text)))
mattermost_channels
- id — int8 — Primary key — NOT NULL
- alias — varchar(40) — NOT NULL
- created_at — timestamp(6)
- is_default — bool — NOT NULL
- display_name — varchar(60) — NOT NULL
- updated_at — timestamp(6)
- webhook_url — varchar(512) — NOT NULL
- user_id — int8 — Foreign key → users.id — NOT NULL
measurement_logs
- log_id — int8 — Primary key — NOT NULL
- category — varchar(255)
- measured_at — timestamp(6)
- user_id — int8 — Foreign key → users.id
- PROFILE::character — varying
- VITAL::character — varying
- SLEEP::character — varying
- ALL::character — varying)::text)))
openai_oauth_states
- id — int8 — Primary key — NOT NULL
- consumed_at — timestamp(6)
- created_at — timestamp(6)
- encrypted_code_verifier — varchar(1000) — NOT NULL
- expires_at — timestamp(6) — NOT NULL
- redirect_uri — varchar(500) — NOT NULL
- state — varchar(120) — NOT NULL
- status — varchar(30) — NOT NULL
- user_id — int8 — NOT NULL
- CONSUMED::character — varying
- EXPIRED::character — varying)::text)))
openai_provider_connections
- id — int8 — Primary key — NOT NULL
- created_at — timestamp(6)
- encrypted_access_token — varchar(30000) — NOT NULL
- encrypted_refresh_token — varchar(30000)
- expires_at — timestamp(6)
- metadata — jsonb
- provider_name — varchar(50) — NOT NULL
- scope_text — varchar(500) — NOT NULL
- token_type — varchar(30)
- updated_at — timestamp(6)
- user_id — int8 — NOT NULL
physical_profiles
- profile_id — int8 — Primary key — NOT NULL
- body_fat_pct — float8
- height_cm — float8
- muscle_mass_kg — float8
- weight_kg — float8
- log_id — int8 — Foreign key → measurement_logs.log_id
product_sessions
- id — int8 — Primary key — NOT NULL
- created_at — timestamp(6)
- main_agent_profile_id — int8
- status — varchar(30) — NOT NULL
- title — varchar(100) — NOT NULL
- updated_at — timestamp(6)
- user_id — int8 — NOT NULL
- workspace_key — varchar(100)
- ARCHIVED::character — varying)::text)))
provider_oauth_states
- provider_name — text — Primary key — NOT NULL
- state — text — Primary key — NOT NULL
- redirect_uri — text — NOT NULL
- code_verifier_secret_ref — text
- status — text — NOT NULL
- expires_at — timestamptz — NOT NULL
- created_at — timestamptz — NOT NULL
- consumed_at — timestamptz
provider_tokens
- provider_name — text — Primary key — NOT NULL
- token_secret_ref — text — NOT NULL
- refresh_secret_ref — text
- token_type — text
- scope_text — text — NOT NULL
- expires_at — timestamptz
- token_metadata — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
run_anchors
- task_run_id — text — Primary key — NOT NULL
- session_id — text — Foreign key → agent_sessions.session_id
- owner_key — text — NOT NULL
- session_key — text
- current_step_run_id — text
- durable_status — text — NOT NULL
- anchor_generation — int8 — NOT NULL
- revision — int8 — NOT NULL
- event_epoch — int8 — NOT NULL
- last_durable_sequence — int8 — NOT NULL
- agent_profile_id — text
- agent_profile_version — int4
- agent_config_snapshot — jsonb — NOT NULL
- anchor_payload — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- owner_user_id — int8 — Foreign key → users.id
- queue_status — text — NOT NULL
- claim_owner — text
- queued_at — timestamptz — NOT NULL
- claimed_at — timestamptz
- lease_expires_at — timestamptz
- heartbeat_at — timestamptz
- next_attempt_at — timestamptz
- attempts — int4 — NOT NULL
- last_claim_error — text
schema_migrations
- migration_id — text — Primary key — NOT NULL
- applied_at — timestamptz — NOT NULL
session_command_receipts
- client_command_id — text — Primary key — NOT NULL
- session_id — text — Foreign key → agent_sessions.session_id — NOT NULL
- owner_key — text — NOT NULL
- owner_user_id — int8 — Foreign key → users.id
- command_signature — text — NOT NULL
- response_payload — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
session_prototype_artifacts
- artifact_id — text — Primary key — NOT NULL
- session_id — text — Foreign key → agent_sessions.session_id — NOT NULL
- owner_key — text — NOT NULL
- title — text — NOT NULL
- framework — text — NOT NULL
- styling — text — NOT NULL
- design_preset_id — text
- active_version_id — text
- status — text — NOT NULL
- is_active — bool — NOT NULL
- metadata — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
session_sub_agents
- id — int8 — Primary key — NOT NULL
- agent_profile_id — int8 — NOT NULL
- created_at — timestamp(6)
- session_id — int8 — NOT NULL
sleep_records
- sleep_id — int8 — Primary key — NOT NULL
- duration_minutes — int4
- sleep_score — int4
- log_id — int8 — Foreign key → measurement_logs.log_id
step_anchors
- step_run_id — text — Primary key — NOT NULL
- task_run_id — text — Foreign key → run_anchors.task_run_id — NOT NULL
- parent_step_run_id — text — Foreign key → step_anchors.step_run_id
- worker_session_id — text — Foreign key → agent_sessions.session_id
- step_order — int4 — NOT NULL
- step_type — text — NOT NULL
- durable_status — text — NOT NULL
- anchor_generation — int8 — NOT NULL
- revision — int8 — NOT NULL
- anchor_payload — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
user_memories
- id — int8 — Primary key — NOT NULL
- access_count — int8
- confidence — float8 — NOT NULL
- content — text — NOT NULL
- created_at — timestamp(6)
- embedding_text — text
- evidence — text
- expires_at — timestamp(6)
- importance — float8 — NOT NULL
- invalidated_at — timestamp(6)
- last_accessed_at — timestamp(6)
- last_used_at — timestamp(6)
- memory_type — varchar(50) — NOT NULL
- metadata — jsonb
- scope_type — varchar(30)
- source_message_id — varchar(100)
- source_session_key — varchar(100)
- source_task_run_id — varchar(100)
- status — varchar(30) — NOT NULL
- store_type — varchar(30)
- summary — varchar(500)
- superseded_by_memory_id — int8
- update_reason — varchar(500)
- updated_at — timestamp(6)
- used_count — int8
- usefulness_score — float8
- user_id — int8 — NOT NULL
- valid_from — timestamp(6)
- valid_until — timestamp(6)
- embedding — public.vector
- PROFILE::character — varying
- CONTEXT::character — varying
- PROJECT_CONTEXT::character — varying
- INSTRUCTION::character — varying
- PROCEDURE::character — varying
- FACT::character — varying)::text)))
- WORKSPACE::character — varying
- SESSION::character — varying
- RESOURCE::character — varying)::text)))
- INACTIVE::character — varying
- DELETED::character — varying
- PENDING::character — varying)::text)))
- AGENT_MEMORY::character — varying)::text)))
user_memory_events
- id — int8 — Primary key — NOT NULL
- created_at — timestamp(6)
- event_type — varchar(30) — NOT NULL
- memory_id — int8 — NOT NULL
- message_id — varchar(100)
- metadata — jsonb
- request_id — varchar(100)
- score — float8
- task_run_id — varchar(100)
- user_id — int8 — NOT NULL
- RECALLED::character — varying
- UPDATED::character — varying
- MERGED::character — varying
- INVALIDATED::character — varying
- DELETED::character — varying
- USED::character — varying)::text)))
users
- id — int8 — Primary key — NOT NULL
- created_at — timestamp(6)
- kakao_id — int8 — NOT NULL
- nickname — varchar(100)
- profile_image — varchar(255)
- updated_at — timestamp(6)
vital_logs
- vital_id — int8 — Primary key — NOT NULL
- diastolic_bp — float8
- heart_rate_bpm — int4
- systolic_bp — float8
- log_id — int8 — Foreign key → measurement_logs.log_id
work_counters
- session_id — text — Foreign key → agent_sessions.session_id — NOT NULL
- next_number — int8 — NOT NULL
work_items
- work_id — text — Primary key — NOT NULL
- identifier — text — NOT NULL
- session_id — text — Foreign key → agent_sessions.session_id — NOT NULL
- owner_key — text — NOT NULL
- owner_user_id — int8 — Foreign key → users.id
- title — text — NOT NULL
- description — text
- status — text — NOT NULL
- assignee_agent_id — text
- parent_id — text — Foreign key → work_items.work_id
- source — text — NOT NULL
- raw_user_input — text
- execution_instruction — text
- expected_deliverable — text
- acceptance_criteria — jsonb — NOT NULL
- constraints_payload — jsonb — NOT NULL
- metadata — jsonb — NOT NULL
- client_request_id — text
- active_run_id — text
- latest_run_id — text
- archived_at — timestamptz
- deleted_at — timestamptz
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- started_at — timestamptz
- completed_at — timestamptz
- flow_order — int4
work_labels
- label_id — text — Primary key — NOT NULL
- session_id — text — Foreign key → agent_sessions.session_id — NOT NULL
- owner_key — text — NOT NULL
- name — text — NOT NULL
- color — text — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
work_products
- product_id — text — Primary key — NOT NULL
- work_id — text — Foreign key → work_items.work_id — NOT NULL
- title — text — NOT NULL
- summary — text
- product_type — text — NOT NULL
- status — text — NOT NULL
- review_state — text — NOT NULL
- uri — text
- metadata — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
work_read_states
- owner_user_id — int8 — Foreign key → users.id — NOT NULL
- work_id — text — Foreign key → work_items.work_id — NOT NULL
- last_read_at — timestamptz — NOT NULL
- archived_at — timestamptz
work_recovery_actions
- action_id — text — Primary key — NOT NULL
- work_id — text — Foreign key → work_items.work_id — NOT NULL
- action_type — text — NOT NULL
- status — text — NOT NULL
- reason — text — NOT NULL
- idempotency_key — text — NOT NULL
- task_run_id — text
- payload — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- resolved_at — timestamptz
work_relations
- relation_type — text — Primary key — NOT NULL
- source_work_id — text — Foreign key → work_items.work_id — NOT NULL
- target_work_id — text — Foreign key → work_items.work_id — NOT NULL
- created_at — timestamptz — NOT NULL
work_runs
- task_run_id — text — Primary key — NOT NULL
- work_id — text — Foreign key → work_items.work_id — NOT NULL
- run_kind — text — NOT NULL
- status — text — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
work_thread_interactions
- interaction_id — text — Primary key — NOT NULL
- work_id — text — Foreign key → work_items.work_id — NOT NULL
- kind — text — NOT NULL
- status — text — NOT NULL
- title — text
- body — text
- payload — jsonb — NOT NULL
- response — jsonb — NOT NULL
- continuation_policy — text — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
work_wake_requests
- wake_id — text — Primary key — NOT NULL
- work_id — text — Foreign key → work_items.work_id — NOT NULL
- root_work_id — text — Foreign key → work_items.work_id
- reason — text — NOT NULL
- status — text — NOT NULL
- requested_by_task_run_id — text
- task_run_id — text
- attempts — int4 — NOT NULL
- last_error — text
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- claimed_at — timestamptz
- completed_at — timestamptz
- next_attempt_at — timestamptz
worker_handoffs
- handoff_id — text — Primary key — NOT NULL
- task_run_id — text — Foreign key → run_anchors.task_run_id — NOT NULL
- parent_step_run_id — text — Foreign key → step_anchors.step_run_id — NOT NULL
- parent_session_id — text — Foreign key → agent_sessions.session_id
- worker_session_id — text — Foreign key → agent_sessions.session_id
- worker_profile_id — text
- worker_profile_version — int4
- status — text — NOT NULL
- input_payload — jsonb — NOT NULL
- result_summary — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- accepted_at — timestamptz
- completed_at — timestamptz
workflow_templates
- template_id — text — Primary key — NOT NULL
- owner_key — text — NOT NULL
- owner_user_id — int8 — Foreign key → users.id
- name — text — NOT NULL
- description — text — NOT NULL
- graph — jsonb — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- session_id — text — Foreign key → agent_sessions.session_id
workspace_members
- id — int8 — Primary key — NOT NULL
- created_at — timestamp(6)
- role — varchar(30) — NOT NULL
- status — varchar(30) — NOT NULL
- updated_at — timestamp(6)
- user_id — int8 — NOT NULL
- workspace_id — int8 — NOT NULL
- MEMBER::character — varying)::text)))
- REMOVED::character — varying)::text)))
workspaces
- id — int8 — Primary key — NOT NULL
- created_at — timestamp(6)
- name — varchar(100) — NOT NULL
- owner_user_id — int8 — NOT NULL
- status — varchar(30) — NOT NULL
- updated_at — timestamp(6)
- workspace_key — varchar(100) — NOT NULL
- ARCHIVED::character — varying)::text)))