inventory_records

Tables (3)

pb_inventory_records (Untitled)

  • id — Primary key — NOT NULL
  • item_id (품목 id) — Foreign key → pb_items.id — NOT NULL
  • date (날짜)
  • created_at (기록시점)
  • last_modified_at (수정시점)
  • quantity (입고/재고량)
  • type (입고/재고)

pb_item_price_history (Untitled3)

  • id — Primary key — NOT NULL
  • item_id (품목 id) — Foreign key → pb_items.id — NOT NULL
  • price (가격)
  • date (날짜)

pb_items (Untitled2)

  • id (품목 id) — Primary key — NOT NULL
  • name (품목 이름)
  • unit (측정단위)