device_management

Tables (29)

Copy Of Copy Of Copy Of Copy Of Copy Of Untitled23 (operating_systems)

  • Key (id) — auto — Primary key — NOT NULL
  • Field (name) — string — windows linux maxOs
  • Field

Copy Of Copy Of Copy Of Copy Of Untitled2 (os_versions)

  • Key (id) — auto — Primary key — NOT NULL
  • Key (os_id) — auto — Foreign key → Copy Of Copy Of Copy Of Copy Of Copy Of Untitled23.Key — NOT NULL
  • Field (name) — string — For Windows: Windows 10 Pro Windows 11 Home Windows Server 2019 For macOS: macOS Big Sur (Version 11.0) macOS Monterey…
  • Field

Copy Of Copy Of Copy Of Copy Of Untitled4 (gpu_families)

  • Key (id) — Primary key — NOT NULL
  • Field (name) — HD GRAPHICS 530 R7 M440

Copy Of Copy Of Copy Of Untitled22 (specifications)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Key (device_id) — autoincrement — Foreign key → devices'\.Key — NOT NULL
  • Key (model_id) — autoincrement — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Key (brand_id) — autoincrement — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL
  • Key (cpu_id) — auto — Foreign key → Untitled.Key — NOT NULL
  • Key (gpu_id) — auto — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL
  • Key (rom_id) — Foreign key → Copy Of Copy Of Untitled42.Key — NOT NULL
  • Key (ram_id) — autoincrement — Foreign key → Copy Of Untitled6.Key — NOT NULL

Copy Of Copy Of Copy Of Untitled3 (cpu_families)

  • Key (id) — Primary key — NOT NULL
  • Field (name) — 7500 series, 7130 series

Copy Of Copy Of Copy Of Untitled4 (gpu_generations)

  • Key (id) — Primary key — NOT NULL
  • Field (name) — 1080, 760, 680

Copy Of Copy Of Untitled (gpus)

  • Key (id) — auto — Primary key — NOT NULL
  • Key (gpu_families_id) — Foreign key → Copy Of Copy Of Copy Of Copy Of Untitled4.Key — NOT NULL
  • Key (gpu_manufacturer_id) — Foreign key → Copy Of Untitled4.Key — NOT NULL
  • Key (gpu_generation_id) — Foreign key → Copy Of Copy Of Copy Of Untitled4.Key — NOT NULL
  • Key (gpu_brand_id) — Foreign key → Copy Of Copy Of Untitled4.Key — NOT NULL
  • Field (label) — string
  • Field

Copy Of Copy Of Untitled2 (brands)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Field (name) — string

Copy Of Copy Of Untitled3 (cpu_generations)

  • Key (id) — Primary key — NOT NULL
  • Field (name) — First-generation Intel Core i7 (Nehalem architecture) Second-generation Intel Core i7 (Sandy Bridge architecture) Third…

Copy Of Copy Of Untitled4 (gpu_brands)

  • Key (id) — Primary key — NOT NULL
  • Field (name) — palit msi default manufacturer

Copy Of Copy Of Untitled42 (roms)

  • Key (id) — Primary key — NOT NULL
  • Key (rom_manufacturer_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Field (label) — intel - skip brands amd nvidia
  • Field (storage_capacity) — string
  • Field

Copy Of Untitled2 (models)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Field (name) — string

Copy Of Untitled3 (cpu_categories)

  • Key (id) — Primary key — NOT NULL
  • Field (name) — i5 i7 r9 etc

Copy Of Untitled4 (gpu_manufacturers)

  • Key (id) — Primary key — NOT NULL
  • Field (name) — intel - skip brands amd nvidia

Copy Of Untitled6 (rams)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Field (name) — string — kingston adata Intel: Intel is a major semiconductor manufacturer that produces various types of memory chips, includin…
  • Field (capacity) — string — 4GB to 64GB or more.
  • Field (speed) — string — RAM speed is often specified in MHz (e.g., 2666MHz, 3200MHz)
  • Field

Untitled (device_statuses)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Field (name) — string — on user in order waiting stored disposed repair

Untitled (purchase_records)

  • Key (id) — Primary key — NOT NULL
  • Key (purchase_type_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Key (purchase_email_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Key (device_id) — autoincrement — Foreign key → devices'\.Key — NOT NULL
  • Field (key) — string
  • Field (active_date) — date
  • Field (expiry_date) — date
  • Field (purchase_date) — int
  • Field (unit_price) — int
  • Field (quantity) — int
  • Field (is_active) — boolean
  • Field (invoice_no) — string
  • Field (do_no) — string
  • Field (quotation) — int
  • Field

Untitled (purchase_types)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Field (name) — string — microsoft 365 office 2016 bitdefender mcafee

Untitled (purchase_emails)

Untitled (server_environments)

  • Key (id) — auto — Primary key — NOT NULL
  • Field (name) — string
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (rom_manufacturers)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Field (name) — string — kingston adata Intel: Intel is a major semiconductor manufacturer that produces various types of memory chips, includin…
  • Field

Untitled (cpu_manufacturers)

  • Key (id) — Primary key — NOT NULL
  • Field (name) — intel amd etc

Untitled (location_user)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Key (user_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Key (location_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (locations)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Field (name) — string
  • Field

Untitled (departments)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Field (name) — string
  • Field

Untitled (cpus)

  • Key (id) — auto — Primary key — NOT NULL
  • Key (cpu_category_id) — Foreign key → Copy Of Untitled3.Key — NOT NULL
  • Key (cpu_manufacturer_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (cpu_family_id) — Foreign key → Copy Of Copy Of Copy Of Untitled3.Key — NOT NULL
  • Key (cpu_generation_id) — Foreign key → Copy Of Copy Of Untitled3.Key — NOT NULL
  • Field (label) — string

Untitled (users)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Key (department_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled2 (portals)

  • Key (id) — auto — Primary key — NOT NULL
  • Key (server_environment_id) — auto — Foreign key → Untitled.Key — NOT NULL
  • Field (....) — ....

devices'\ (devices)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Key (device_status_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Key (os_version_id) — auto — Foreign key → Copy Of Copy Of Copy Of Copy Of Untitled2.Key — NOT NULL
  • Key (user_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Field2 (label) — string
  • Field (code) — string
  • Field (mac_address)
  • Field (express_no) — string
  • Field (service_tag) — string
  • Field (warranty) — string
  • Field2 (price) — integer
  • Field (received_at) — date