PBM-AgentAI

Tables (12)

commands

  • id — BIGINT — Primary key — NOT NULL — auto
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — auto
  • raw_text — TEXT
  • parsed_json — JSON
  • status — ENUM('PENDING', 'PROCESSING', 'COMPLETED', 'FAILED')
  • missing_fields_json — JSON — GPT가 파악한 누락 조건 목록
  • collected_answers_json — JSON — 사용자가 선택한 답변 누적
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

conditions

  • id — BIGINT — Primary key — NOT NULL — auto
  • command_id — BIGINT — Foreign key → commands.id — NOT NULL — auto
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — auto
  • platform — VARCHAR(30)
  • keyword — VARCHAR(100)
  • max_price — BIGINT
  • mode — ENUM('ALERT_ONLY', 'AUTO_PAYMENT')
  • is_active — BOOLEAN
  • max_execution_count — INT
  • current_execution_count — INT
  • last_checked_at — DATETIME
  • option_json — JSON — 플랫폼별 추가 옵션
  • expired_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • priority — INT

image_searches

  • id — BIGINT — Primary key — NOT NULL — auto
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — auto
  • image_url — VARCHAR(500)
  • recognized_brand — VARCHAR(100) — Gemini가 인식한 브랜드명
  • recognized_model — VARCHAR(100) — Gemini가 인식한 모델명
  • search_results_json — JSON — 쇼핑몰 검색 결과(URL+가격)
  • created_at — DATETIME

monitor_targets

  • id — BIGINT — Primary key — NOT NULL
  • platform — VARCHAR(30) — NOT NULL — NAVER
  • normalized_keyword — VARCHAR(150) — NOT NULL — 공백/대소문자
  • fetch_interval_minutes — INT — NOT NULL — 공유
  • last_fetched_at — TIMESTAMPTZ — 마지막
  • next_fetch_at — TIMESTAMPTZ — 다음
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

notification_settings

  • id — BIGINT — Primary key — NOT NULL — auto
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — auto
  • mode — ENUM('ALERT_ONLY', 'AUTO_PAYMENT')
  • telegram_chat_id — VARCHAR(100)
  • telegram_enabled — BOOLEAN
  • email — VARCHAR(100)
  • email_enabled — BOOLEAN
  • timezone — VARCHAR(50) — 사용자 타임존
  • quiet_hours_start — TIME — 방해금지 시작 시간
  • quiet_hours_end — TIME — 방해금지 종료 시간
  • created_at — DATETIME
  • updated_at — DATETIME

notifications

  • id — BIGINT — Primary key — NOT NULL — auto
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — auto
  • message — TEXT
  • type — ENUM('PRICE_ALERT', 'PAYMENT_SUCCESS', 'PAYMENT_FAILED', 'SYSTEM')
  • channel — ENUM('TELEGRAM', 'EMAIL', 'WEB')
  • is_read — BOOLEAN
  • read_at — DATETIME
  • retry_count — INT
  • failed_reason — TEXT
  • sent_at — DATETIME
  • created_at — DATETIME

payment_settings

  • id — BIGINT — Primary key — NOT NULL — auto
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — auto
  • monthly_linit — BIGINT — 월 자동결제 한도
  • max_per_transaction — BIGINT — 건당 최대 결제 금액
  • allowed_platforms — JSON — 허용 플랫폼 목록
  • created_at — DATETIME
  • updated_at — DATETIME

payments

  • id — BIGINT — Primary key — NOT NULL — auto
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — auto
  • conditions_id — BIGINT — Foreign key → conditions.id — NOT NULL — auto
  • product_name — VARCHAR(200)
  • platform — VARCHAR(30)
  • amount — BIGINT
  • currency — ENUM('KRW', 'USD', 'PBMT')
  • fee — BIGINT — 수수료
  • tx_hash — VARCHAR(200)
  • status — ENUM('PENDING', 'SUCCESS', 'FAILED', 'CANCELLED')
  • failure_reason — TEXT — 실패 사유
  • retry_count — INT — 재시도 횟수
  • refunded_at — DATETIME — 환불 시간
  • paid_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

price_history

  • id — BIGINT — Primary key — NOT NULL — auto
  • condition_id — BIGINT — Foreign key → conditions.id — NOT NULL — auto
  • product_name — VARCHAR(200)
  • platform — VARCHAR(30)
  • price — BIGINT
  • original_price — BIGINT
  • currency — ENUM('KRW', 'USD', 'PBMT')
  • is_lowest_price — BOOLEAN
  • source — ENUM('API', 'EXTENSION')
  • product_url — VARCHAR(100)
  • collected_at — DATETIME

products

  • id — BIGINT — Primary key — NOT NULL
  • monitor_target_id — BIGINT — Foreign key → monitor_targets.id — NOT NULL — FK
  • platform — VARCHAR(30) — NOT NULL — NAVER
  • external_product_id — VARCHAR(120) — NOT NULL — 플랫폼이
  • title — VARCHAR(255) — 상품명
  • product_url — VARCHAR(500) — 상품
  • image_url — VARCHAR(500) — 대표
  • mall_name — VARCHAR(120) — 쇼핑몰명
  • last_seen_at — TIMESTAMPTZ — 마지막으로
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

recommendations

  • id — BIGINT — Primary key — NOT NULL — auto
  • category — VARCHAR(50)
  • product_name — VARCHAR(200)
  • rank — INT
  • pros — TEXT — 장점
  • cons — TEXT — 단점
  • youtuber — VARCHAR(100)
  • video_url — VARCHAR(500)
  • analysis_date — DATE — 분석 기준 날짜
  • created_at — DATETIME
  • updated_at — DATETIME — 수정일

users

  • id — BIGINT — Primary key — NOT NULL — auto
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • pbm_wallet_address — VARCHAR(100)
  • role — ENUM('USER', 'ADMIN')
  • is_active — BOOLEAN
  • login_failed_count — INT
  • locked_until — DATETIME
  • last_login_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME