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