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)))