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 — 업데이트