pps-mono-repo

테이블 (8)

rfp 원본 파일 (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_path — VARCHAR(1000) — NOT NULL
  • bid_ntce_no — VARCHAR(100)
  • source_type — VARCHAR(50)
  • source_url — VARCHAR(1000)
  • ingested_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

rfp_ai_execution_gpus

  • id — SERIAL
  • ai_execution_id — INTEGER — NOT NULL
  • ai_execution_resource_id — INTEGER — NOT NULL
  • gpu_index — INTEGER — NOT NULL
  • gpu_model — VARCHAR(200) — NOT NULL
  • vram_gb — NUMERIC(6, 2) — NOT NULL
  • interface — VARCHAR(50)
  • created_at — TIMESTAMP

rfp_ai_executions

  • id — SERIAL
  • session_id — INTEGER — NOT NULL
  • celery_task_uuid — VARCHAR(36)
  • model_name — VARCHAR(200) — NOT NULL
  • input_prompt — TEXT — NOT NULL
  • response — TEXT
  • created_at — TIMESTAMP

rfp_ai_token_usages

  • id — SERIAL
  • ai_execution_id — INTEGER — NOT NULL
  • input_tokens — INTEGER — NOT NULL
  • output_tokens — INTEGER — NOT NULL
  • total_tokens — INTEGER — NOT NULL

rfp_async_tasks

  • id — SERIAL
  • session_id — INTEGER — NOT NULL
  • celery_task_uuid — VARCHAR(36) — NOT NULL
  • task_status — VARCHAR(20) — NOT NULL
  • task_name — VARCHAR(200)
  • task_display_name — VARCHAR(200)
  • created_at — TIMESTAMP
  • 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 — NOT NULL
  • source_file_id — INTEGER
  • source_file_name — VARCHAR(500)
  • extension — VARCHAR(10) — NOT NULL
  • file_size — INTEGER
  • minio_bucket — VARCHAR(100)
  • minio_path — VARCHAR(1000)
  • created_at — TIMESTAMP

rfp_processing_errors

  • id — SERIAL
  • session_id — INTEGER — NOT NULL
  • error_message — TEXT — NOT NULL
  • created_at — TIMESTAMP

rfp_processing_sessions

  • id — SERIAL
  • processing_uuid — VARCHAR(36) — NOT NULL
  • source_file_id — INTEGER — NOT NULL
  • stage_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • started_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • duration_seconds — INTEGER