Query
CREATE TABLE installation_job_equipment (
id INTEGER PRIMARY KEY AUTOINCREMENT,
job_id INTEGER NOT NULL,
equipment_name VARCHAR(255) NOT NULL,
quantity INTEGER DEFAULT 1,
serial_number VARCHAR(100),
status VARCHAR(50) DEFAULT 'prepared',
notes TEXT,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (job_id) REFERENCES installation_jobs(id)
)