dddd

Tables (11)

agent_messages

  • message_id — text — Primary key — NOT NULL — 메시지ID
  • session_id — text — Foreign key → agent_sessions.session_id — NOT NULL — 소속세션ID
  • task_run_id — text — 연결된TaskRunID
  • step_run_id — text — 연결된StepRunID
  • event_id — text — 연결된이벤트ID
  • event_type — text — 이벤트종류
  • message_sequence — bigint — NOT NULL — 세션내메시지순번
  • role — text — NOT NULL — 메시지역할
  • content — jsonb — NOT NULL — 메시지내용(JSON)
  • provider_name — text — 모델제공자
  • model_name — text — 사용모델명
  • metadata — jsonb — NOT NULL — 메시지부가정보(JSON)
  • created_at — timestamptz — NOT NULL — 생성시각

agent_sessions

  • session_id — text — Primary key — NOT NULL — 세션ID
  • owner_key — text — NOT NULL — 사용자/소유자ID
  • session_key — text — NOT NULL — 외부sessionId
  • task_run_id — text — 연결된TaskRunID
  • parent_session_id — text — Foreign key → agent_sessions.session_id — 부모세션ID
  • parent_step_run_id — text — 분기된StepRunID
  • agent_profile_id — text — 사용한agentprofile
  • agent_profile_version — integer — NOT NULL — profile버전
  • agent_config_snapshot — jsonb — NOT NULL — 실행당시agent설정(JSON)
  • session_role — text — NOT NULL — 세션역할
  • status — text — NOT NULL — 세션상태
  • title — text — 세션제목
  • metadata — jsonb — NOT NULL — 세션부가정보(JSON)
  • created_at — timestamptz — NOT NULL — 생성시각
  • updated_at — timestamptz — NOT NULL — 수정시각
  • ended_at — timestamptz — 종료시각

ai_agent_profiles

  • profile_id — text — Primary key — NOT NULL — profileID
  • owner_key — text — NOT NULL — 사용자/소유자ID
  • profile_key — text — NOT NULL — profile이름키
  • profile_version — integer — NOT NULL — profile버전
  • agent_type — text — NOT NULL — agent종류
  • provider_name — text — 모델제공자
  • model_name — text — 기본모델명
  • config_snapshot — jsonb — NOT NULL — agent설정(JSON)
  • delegation_policy — jsonb — NOT NULL — 위임정책(JSON)
  • created_at — timestamptz — NOT NULL — 생성시각
  • updated_at — timestamptz — NOT NULL — 수정시각

ai_agent_templates

  • template_id — text — Primary key — NOT NULL — templateID
  • owner_key — text — NOT NULL — 사용자/소유자ID
  • template_key — text — NOT NULL — template이름키
  • template_version — integer — NOT NULL — template버전
  • default_agent_type — text — NOT NULL — 기본agent종류
  • default_config_snapshot — jsonb — NOT NULL — 기본agent설정(JSON)
  • default_policy — jsonb — NOT NULL — 기본위임정책(JSON)
  • created_at — timestamptz — NOT NULL — 생성시각
  • updated_at — timestamptz — NOT NULL — 수정시각

approval_requests

  • approval_id — text — Primary key — NOT NULL — 승인요청ID
  • task_run_id — text — NOT NULL — 소속TaskRunID
  • step_run_id — text — NOT NULL — 소속StepRunID
  • tool_call_id — text — 승인대상tool호출
  • status — text — NOT NULL — 승인상태
  • request_payload — jsonb — NOT NULL — 승인요청내용(JSON)
  • response_payload — jsonb — NOT NULL — 승인응답내용(JSON)
  • created_at — timestamptz — NOT NULL — 생성시각
  • resolved_at — timestamptz — 처리완료시각

provider_oauth_states

  • provider_name — text — Primary key — NOT NULL — Provider이름
  • state — text — Primary key — NOT NULL — OAuthstate값
  • redirect_uri — text — NOT NULL — 인증후복귀URL
  • code_verifier_secret_ref — text — PKCEverifier참조
  • status — text — NOT NULL — OAuth상태
  • expires_at — timestamptz — NOT NULL — 만료시각
  • created_at — timestamptz — NOT NULL — 생성시각
  • consumed_at — timestamptz — 사용완료시각

provider_tokens

  • provider_name — text — Primary key — NOT NULL — Provider이름
  • token_secret_ref — text — NOT NULL — accesstoken비밀참조
  • refresh_secret_ref — text — refreshtoken비밀참조
  • token_type — text — 토큰타입
  • scope_text — text — NOT NULL — 권한scope
  • expires_at — timestamptz — 만료시각
  • token_metadata — jsonb — NOT NULL — 토큰부가정보(JSON)
  • created_at — timestamptz — NOT NULL — 생성시각
  • updated_at — timestamptz — NOT NULL — 수정시각

run_anchors

  • task_run_id — text — Primary key — NOT NULL — TaskRunID
  • session_id — text — Foreign key → agent_sessions.session_id — 대표세션ID
  • owner_key — text — NOT NULL — 사용자/소유자ID
  • session_key — text — 외부sessionId
  • entry_handler_key — text — 시작handler
  • current_step_run_id — text — 현재StepRunID
  • durable_status — text — NOT NULL — 저장된실행상태
  • anchor_generation — bigint — NOT NULL — anchor세대번호
  • revision — bigint — NOT NULL — 상태변경번호
  • event_epoch — bigint — NOT NULL — 이벤트epoch
  • last_durable_sequence — bigint — NOT NULL — 마지막저장이벤트순번
  • agent_profile_id — text — 사용한agentprofile
  • agent_profile_version — integer — profile버전
  • agent_config_snapshot — jsonb — NOT NULL — 실행당시agent설정(JSON)
  • anchor_payload — jsonb — NOT NULL — TaskRun상태원본(JSON)
  • created_at — timestamptz — NOT NULL — 생성시각
  • updated_at — timestamptz — NOT NULL — 수정시각

schema_migrations

  • migration_id — text — Primary key — NOT NULL — migrationID
  • applied_at — timestamptz — NOT NULL — 적용시각

step_anchors

  • step_run_id — text — Primary key — NOT NULL — StepRunID
  • task_run_id — text — Foreign key → run_anchors.task_run_id — NOT NULL — 소속TaskRunID
  • parent_step_run_id — text — Foreign key → step_anchors.step_run_id — 부모StepRunID
  • worker_session_id — text — Foreign key → agent_sessions.session_id — worker세션ID
  • step_order — integer — NOT NULL — 단계순서
  • step_type — text — NOT NULL — 단계타입
  • handler_key — text — 처리handler
  • durable_status — text — NOT NULL — 저장된단계상태
  • anchor_generation — bigint — NOT NULL — anchor세대번호
  • revision — bigint — NOT NULL — 상태변경번호
  • anchor_payload — jsonb — NOT NULL — StepRun상태원본(JSON)
  • created_at — timestamptz — NOT NULL — 생성시각
  • updated_at — timestamptz — NOT NULL — 수정시각

worker_handoffs

  • handoff_id — text — Primary key — NOT NULL — 위임ID
  • task_run_id — text — Foreign key → run_anchors.task_run_id — NOT NULL — 소속TaskRunID
  • parent_step_run_id — text — Foreign key → step_anchors.step_run_id — NOT NULL — 위임한StepRunID
  • parent_session_id — text — Foreign key → agent_sessions.session_id — 위임한세션ID
  • worker_session_id — text — Foreign key → agent_sessions.session_id — worker세션ID
  • worker_profile_id — text — workerprofile
  • worker_profile_version — integer — workerprofile버전
  • status — text — NOT NULL — 위임상태
  • input_payload — jsonb — NOT NULL — worker입력(JSON)
  • result_summary — jsonb — NOT NULL — worker결과요약(JSON)
  • created_at — timestamptz — NOT NULL — 생성시각
  • accepted_at — timestamptz — 수락시각
  • completed_at — timestamptz — 완료시각