test1

Tables (7)

audit_log

  • id — INT — Primary key — NOT NULL
  • entity_type — VARCHAR(50) — NOT NULL
  • entity_id — INT — NOT NULL
  • item_label_snapshot — VARCHAR(200)
  • field_name — VARCHAR(100)
  • change_type — VARCHAR(50) — NOT NULL
  • old_value — TEXT
  • new_value — TEXT
  • delta — DECIMAL(12,2)
  • changed_by — VARCHAR(100) — NOT NULL
  • changed_by_user_id — INT — Foreign key → users.id
  • changed_at — DATETIME — NOT NULL

categories

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

item_serial_numbers

  • id — INT — Primary key — NOT NULL
  • item_id — INT — Foreign key → items.id — NOT NULL
  • serial_number — VARCHAR(200) — NOT NULL
  • is_delivered — TINYINT(1) — NOT NULL
  • delivered_at — DATETIME
  • created_at — DATETIME — NOT NULL

item_subcategories

  • item_id — INT — Foreign key → items.id — NOT NULL
  • subcategory_id — INT — Foreign key → subcategories.id — NOT NULL

items

  • id — INT — Primary key — NOT NULL
  • category_id — INT — Foreign key → categories.id — NOT NULL
  • model_name — VARCHAR(200) — NOT NULL
  • spec — VARCHAR(500)
  • quantity — INT — NOT NULL
  • purchase_source — VARCHAR(200)
  • last_modified_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_at — DATETIME

subcategories

  • id — INT — Primary key — NOT NULL
  • category_id — INT — Foreign key → categories.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_active — TINYINT(1) — NOT NULL