상품관리
테이블 (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