모수/인벤토리분석

테이블 (7)

population_parameter_inventory_analysis_history (모수/인벤 분석 히스토리)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • created_by (Key2) — varchar(15) — NOT NULL
  • created_at (Key3) — datetime — NOT NULL
  • inventory (Key5) — bigint — NOT NULL
  • population_parameter_count (Key4) — bigint — NOT NULL
  • region (Key6) — longtext — NOT NULL

population_parameter_inventory_segment (Untitled)

  • id (Key) — int — 기본 키 — NOT NULL
  • history (Key2) — bigint — 외래 키 → population_parameter_inventory_analysis_history.id — NOT NULL
  • segment (Field) — longtext

product (상품)

  • 기존컬럼유지 (Field)
  • inventory_multiplier (Field2) — int

product_history (상품 히스토리)

  • 기존컬럼유지 (Field)
  • content에 배율 추가 (Field2)

stb_seg_info_kt (KT 모수)

  • stb_id (Key) — varchar(100) — NOT NULL
  • region_id (Key2) — int — NOT NULL
  • segment_id (Key3) — bigint — NOT NULL

stb_seg_info_skb (SKB 모수)

  • stb_id (Key) — varchar(100) — NOT NULL
  • region_id (Key2) — int — NOT NULL
  • segment_id (Key3) — bigint — NOT NULL

stb_seg_info_uplus (UPLUS 모수)

  • stb_id (Key) — varchar(100) — NOT NULL
  • region_id (Key2) — int — NOT NULL
  • segment_id (Key3) — bigint — NOT NULL