PC Asset Management
Tables (4)
Untitled (pc_spec)
- Key (pc_id) — VARCHAR — Foreign key → Untitled2.Key — NOT NULL
- Key — Foreign key → Untitled2.Key — NOT NULL
- Field (maker) — VARCHAR
- Field (model) — VARCHAR
- Field (CPU) — VARCHAR
- Field (RAM) — VARCHAR
Untitled (pc_status)
- Key (pc_id) — VARCHAR — Foreign key → Untitled2.Key — NOT NULL
- Key — Foreign key → Untitled2.Key — NOT NULL
- Field (status_id) — VARCHAR
- Field (status) — VARCHAR
- Field (updated_at) — DATETIME
- Field (updated_by) — VARCHAR
Untitled2 (pcs)
- Key (pc_id) — VARCHAR — Primary key — NOT NULL
- Key (pc_name) — VARCHAR — Primary key — NOT NULL
- Field (pc_type) — VARCHAR
- Field (active) — INT
- User_ID (user_id) — INT — Foreign key → Users.User_ID
Users (users)
- User_ID (user_id) — INT — Primary key — NOT NULL
- Field3 (employee_id) — INT
- First_NAME (first_name) — VARCHAR
- Field2 (last_name) — VARCHAR
- Field5 (email) — VARCHAR
- Field4 (active) — INT