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