상품관리

테이블 (5)

상품 (pm_product)

  • product_id — NUMBER — 기본 키 — NOT NULL
  • product_name — VARCHAR2(100) — NOT NULL
  • category — VARCHAR2(50) — NOT NULL
  • price — NUMBER(10, 2) — NOT NULL
  • stock_qty — NUMBER — NOT NULL
  • safety_stock — NUMBER — NOT NULL
  • active_yn — CHAR(1) — NOT NULL
  • created_at — DATE — NOT NULL

안전재고알림 (pm_low_stock)

  • alert_id — NUMBER — 기본 키 — NOT NULL
  • product_id — NUMBER — 외래 키 → 상품.product_id — NOT NULL
  • alert_date — DATE — NOT NULL
  • stock_qty — NUMBER — NOT NULL
  • safety_stock — NUMBER — NOT NULL

일별 판매 집계 (pm_daily_sales)

  • sales_date — DATE — 기본 키 — NOT NULL
  • sale_count — NUMBER — NOT NULL
  • item_count — NUMBER — NOT NULL
  • sales_amount — NUMBER(12, 2) — NOT NULL
  • updated_at — DATE — NOT NULL

재고변경이력 (pm_stock_history)

  • history_id — NUMBER — 기본 키 — NOT NULL
  • product_id — NUMBER — 외래 키 → 상품.product_id — NOT NULL
  • change_qty — NUMBER — NOT NULL
  • stock_after — NUMBER — NOT NULL
  • reason — VARCHAR2(100) — NOT NULL
  • changed_at — DATE — NOT NULL

판매 (pm_sale)

  • sale_id — NUMBER — 기본 키 — NOT NULL
  • product_id — NUMBER — 외래 키 → 상품.product_id — NOT NULL
  • quantity — NUMBER — NOT NULL
  • sale_price — NUMBER(10, 2) — NOT NULL
  • sale_amount — NUMBER(12, 2) — NOT NULL
  • sold_at — DATE — NOT NULL