ddzz
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
- 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 — 완료시각