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