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 (측정단위)