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 — 논리명:가격임계(원)