test2

Tables (13)

alert

  • alert_id — bigint — Primary key — NOT NULL — 논리명:알람ID | PK
  • url — varchar(768) — Foreign key → url.url — NOT NULL — 논리명:URL | FK→url
  • sap_id — varchar(64) — Foreign key → sap.sap_id — 논리명:SAPID | 스냅샷/조인용
  • partner_id — varchar(64) — 논리명:거래처ID | 스냅샷/조인용
  • team_id — varchar(64) — 논리명:팀ID | 스냅샷/조인용
  • alert_type — varchar(64) — NOT NULL — 논리명:알람유형
  • threshold_value — decimal(12, 2) — 논리명:기준값(할인이면%%, 가격이면원)
  • observed_value — decimal(12, 2) — 논리명:관측값
  • status — varchar(32) — NOT NULL — 논리명:상태
  • detected_at — datetime(3) — NOT NULL — 논리명:발생일시

alert_recipient

  • alert_id — bigint — Foreign key → alert.alert_id — NOT NULL — 논리명:알람ID | PK+FK→alert
  • member_id — int — Foreign key → member.member_id — NOT NULL — 논리명:구성원ID | PK+FK→member

brand

  • brand_id — varchar(64) — Primary key — NOT NULL — 논리명:브랜드ID | PK
  • brand_name — varchar(255) — NOT NULL — 논리명:브랜드이름

crawl_raw

  • raw_id — bigint — Primary key — NOT NULL — 논리명:수집ID | PK
  • url — text — NOT NULL — 논리명:URL
  • platform — varchar(64) — 논리명:플랫폼
  • status — varchar(64) — NOT NULL — 논리명:수집상태
  • sap_id — varchar(64) — SAP ID 스냅샷
  • platform_product_code — varchar(128) — 플랫폼 상품코드 스냅샷
  • product_name — varchar(512) — 논리명:제품명
  • regular_price — bigint — 논리명:정가(원)
  • public_sale_price — bigint — 논리명:공개판매가(원)
  • selected_price — bigint — 논리명:채택가격(원)
  • discount_rate — varchar(16) — 논리명:할인율(퍼센트, 예: 28%)
  • price_type — varchar(64) — 논리명:가격유형
  • condition_expr — varchar(255) — 논리명:조건식
  • discount_condition_expr — varchar(32) — 논리명:할인율기준 (예: <30%, 미만=정상)
  • alert_satisfied — tinyint(1) — NOT NULL — 논리명:알람조건충족
  • price_suspect — tinyint(1) — NOT NULL — 논리명:가격의심여부
  • error_message — text — 논리명:에러메시지
  • monitor_log_id — varchar(128) — 논리명:모니터로그ID
  • screenshot_path — text — 논리명:스크린샷경로
  • crawled_at — datetime(3) — NOT NULL — 논리명:수집일시

incident

  • incident_id — bigint — Primary key — NOT NULL — 논리명:이벤트ID | PK
  • incident_key — varchar(255) — NOT NULL — 논리명:이벤트키 | url+이슈유형 등 고유키
  • url — varchar(768) — NOT NULL — 논리명:URL
  • sap_id — varchar(64) — Foreign key → sap.sap_id — SAP ID
  • product_id — bigint — 논리명:상품ID | FK→product(선택)
  • product_name — varchar(512) — 논리명:상품명
  • partner_id — varchar(64) — 논리명:거래처ID
  • platform — varchar(64) — 논리명:채널/플랫폼
  • channel_detail — varchar(255) — 논리명:채널상세
  • issue_type — varchar(64) — NOT NULL — 논리명:이상유형 | discount_threshold, employee_price 등
  • status — varchar(32) — NOT NULL — 논리명:상태 | open/escalated/resolved/reopened
  • threshold_value — decimal(12, 2) — 논리명:기준값
  • observed_value — decimal(12, 2) — 논리명:최근관측값
  • worst_value — decimal(12, 2) — 논리명:최악관측값
  • hit_count — int — NOT NULL — 논리명:지속관측횟수
  • first_seen_at — datetime(3) — NOT NULL — 논리명:최초발견
  • last_seen_at — datetime(3) — NOT NULL — 논리명:최근확인
  • resolved_at — datetime(3) — 논리명:해결일시
  • last_notified_at — datetime(3) — 논리명:최근알림일시
  • owner_member_id — int — 논리명:담당자 | FK→member(선택)
  • note — text — 논리명:메모
  • created_at — datetime(3) — NOT NULL — 논리명:생성일시
  • updated_at — datetime(3) — NOT NULL — 논리명:수정일시

incident_observation

  • observation_id — bigint — Primary key — NOT NULL — 논리명:관측ID | PK
  • incident_id — bigint — Foreign key → incident.incident_id — NOT NULL — 논리명:이벤트ID | FK→incident
  • raw_id — bigint — 논리명:수집ID | crawl_raw.raw_id(선택)
  • run_id — varchar(64) — 논리명:모니터링런ID
  • observed_at — datetime(3) — NOT NULL — 논리명:관측일시
  • crawl_status — varchar(64) — 논리명:수집상태 | ok/warning/error
  • alert_satisfied — tinyint(1) — NOT NULL — 논리명:이상여부 | 1=이상관측
  • threshold_value — decimal(12, 2) — 논리명:기준값
  • observed_value — decimal(12, 2) — 논리명:관측값
  • selected_price — bigint — 논리명:채택가격(원)
  • regular_price — bigint — 논리명:정가(원)
  • discount_rate — varchar(16) — 논리명:할인율
  • is_worsened — tinyint(1) — NOT NULL — 논리명:악화여부
  • notify_action — varchar(32) — NOT NULL — 논리명:알림액션 | none/new/update/escalate/resolve/reopen
  • product_name — varchar(512) — 논리명:상품명스냅샷
  • platform — varchar(64) — 논리명:채널스냅샷
  • error_message — text — 논리명:에러메시지
  • payload_json — json — 논리명:추가스냅샷JSON
  • created_at — datetime(3) — NOT NULL — 논리명:생성일시

member

  • member_id — int — Primary key — NOT NULL — 논리명:구성원ID | PK
  • member_name — varchar(255) — NOT NULL — 논리명:구성원이름
  • team_id — varchar(64) — Foreign key → team.team_id — 논리명:팀ID | FK→team

member_channel

  • member_id — int — Foreign key → member.member_id — NOT NULL — 논리명:구성원ID | PK+FK→member
  • partner_id — varchar(64) — Foreign key → partner.partner_id — NOT NULL — 논리명:거래처ID | PK+FK→partner

partner

  • partner_id — varchar(64) — Primary key — NOT NULL — 논리명:거래처ID | PK
  • partner_name — varchar(255) — NOT NULL — 논리명:거래처이름
  • channel_detail — varchar(255) — 논리명:채널상세
  • team_id — varchar(64) — Foreign key → team.team_id — 논리명:팀ID | FK→team

product

  • product_id — bigint — Primary key — NOT NULL — 논리명:상품ID | PK
  • product_name — varchar(512) — NOT NULL — 논리명:상품명
  • discount_threshold — decimal(8, 2) — 논리명:할인임계 | %
  • price_threshold — bigint — 논리명:가격임계(원)
  • brand_id — varchar(64) — Foreign key → brand.brand_id — 논리명:브랜드ID | FK→brand

sap

  • sap_id — varchar(64) — Primary key — NOT NULL — 논리명:SAPID | PK
  • sap_name — varchar(512) — 논리명:SAP명
  • product_id — bigint — Foreign key → product.product_id — NOT NULL — 논리명:상품ID | FK→product
  • brand_id — varchar(64) — Foreign key → brand.brand_id — 논리명:브랜드ID | FK→brand
  • regular_price — bigint — 논리명:기준가(부가세포함,원)

team

  • team_id — varchar(64) — Primary key — NOT NULL — 논리명:팀ID | PK
  • team_name — varchar(255) — NOT NULL — 논리명:팀이름

url

  • url — varchar(768) — Primary key — NOT NULL — 논리명:URL | PK
  • sap_id — varchar(64) — Foreign key → sap.sap_id — NOT NULL — 논리명:SAPID | FK→sap
  • platform_product_code — varchar(128) — 플랫폼 상품코드
  • partner_id — varchar(64) — Foreign key → partner.partner_id — 논리명:거래처ID | FK→partner
  • team_id — varchar(64) — Foreign key → team.team_id — 논리명:팀ID | FK→team
  • product_id — bigint — Foreign key → product.product_id — 논리명:상품ID | FK→product
  • discount_threshold — decimal(8, 2) — 논리명:할인임계 | URL예외 %
  • price_threshold — bigint — 논리명:가격임계(원)