SQL
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)
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
INTEGER |
✓ | ✓ | Rename | Drop |
job_id |
INTEGER |
Rename | Drop | ||
equipment_name |
VARCHAR(255) |
Rename | Drop | ||
quantity |
INTEGER |
✓ | Rename | Drop | |
serial_number |
VARCHAR(100) |
✓ | Rename | Drop | |
status |
VARCHAR(50) |
✓ | Rename | Drop | |
notes |
TEXT |
✓ | Rename | Drop | |
created_at |
DATETIME |
✓ | Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
job_id |
installation_jobs.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|