pps-mono-repo-rfp

Tables (8)

rfp_ai_execution_gpus

  • id — SERIAL
  • ai_execution_id — INTEGER — NOT NULL — AI
  • ai_execution_resource_id — INTEGER — NOT NULL — AI
  • gpu_index — INTEGER — NOT NULL — nvidia-smi
  • gpu_model — VARCHAR(200) — NOT NULL — GPU
  • vram_gb — NUMERIC(6, 2) — NOT NULL — VRAM
  • interface — VARCHAR(50) — 인터페이스
  • created_at — TIMESTAMP — NOT NULL — 생성

rfp_ai_executions

  • id — SERIAL
  • session_id — INTEGER — Foreign key → rfp_processing_sessions.id — NOT NULL — 처리
  • celery_task_uuid — VARCHAR(36) — Celery
  • model_name — VARCHAR(200) — NOT NULL — 사용한
  • input_prompt — TEXT — NOT NULL — AI
  • response — TEXT — AI
  • created_at — TIMESTAMP — NOT NULL — 실행

rfp_ai_token_usages

  • id — SERIAL
  • ai_execution_id — INTEGER — Foreign key → rfp_ai_executions.id — NOT NULL — AI
  • input_tokens — INTEGER — NOT NULL — 입력
  • output_tokens — INTEGER — NOT NULL — 출력
  • total_tokens — INTEGER — NOT NULL — 총

rfp_async_tasks

  • id — SERIAL
  • session_id — INTEGER — Foreign key → rfp_processing_sessions.id — NOT NULL — 처리
  • celery_task_uuid — VARCHAR(36) — NOT NULL — Celery
  • task_status — VARCHAR(20) — NOT NULL — PENDING/RUNNING/FAILED/SUCCESS
  • task_name — VARCHAR(200) — 작업
  • task_display_name — VARCHAR(200) — 작업
  • created_at — TIMESTAMP — NOT NULL — 작업
  • finished_at — TIMESTAMP — 작업
  • duration_seconds — INTEGER — 작업

rfp_images

  • id — SERIAL
  • image_uuid — VARCHAR(36) — NOT NULL — 이미지
  • file_format — VARCHAR(50) — NOT NULL — 파일
  • processing_session_id — INTEGER — Foreign key → rfp_processing_sessions.id — NOT NULL — 처리
  • source_file_id — INTEGER — Foreign key → rfp_source_files.id — 원본
  • source_file_name — VARCHAR(500) — 원본
  • extension — VARCHAR(10) — NOT NULL — 이미지
  • file_size — INTEGER — 파일
  • minio_bucket — VARCHAR(100) — NOT NULL — MinIO
  • minio_path — VARCHAR(1000) — NOT NULL — MinIO
  • created_at — TIMESTAMP — NOT NULL — 생성

rfp_processing_errors

  • id — SERIAL
  • session_id — INTEGER — Foreign key → rfp_processing_sessions.id — NOT NULL — 처리
  • error_message — TEXT — NOT NULL — 에러
  • created_at — TIMESTAMP — NOT NULL — 에러

rfp_processing_sessions

  • id — SERIAL
  • processing_uuid — VARCHAR(36) — NOT NULL — 외부
  • source_file_id — INTEGER — Foreign key → rfp_source_files.id — NOT NULL — 원본
  • stage_type — VARCHAR(50) — NOT NULL — 처리
  • status — VARCHAR(20) — NOT NULL — PENDING/RUNNING/SUCCESS/FAILED
  • started_at — TIMESTAMP — 처리
  • completed_at — TIMESTAMP — 처리
  • duration_seconds — INTEGER — 처리

rfp_source_files

  • id — SERIAL
  • file_format — VARCHAR(50) — NOT NULL — 파일
  • file_uuid — VARCHAR(36) — NOT NULL — 파일
  • original_file_name — VARCHAR(500) — NOT NULL — 원본
  • file_size — INTEGER — 파일
  • file_extension — VARCHAR(50) — 파일
  • minio_bucket — VARCHAR(100) — NOT NULL — MinIO
  • minio_path — VARCHAR(1000) — NOT NULL — MinIO
  • bid_ntce_no — VARCHAR(100) — 입찰공고번호
  • source_type — VARCHAR(50) — 수집
  • source_url — VARCHAR(1000) — 원본
  • ingested_at — TIMESTAMP — NOT NULL — 수집
  • created_at — TIMESTAMP — NOT NULL — 생성
  • updated_at — TIMESTAMP — NOT NULL — 업데이트