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