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)
- Key (id) — autoincrement — Primary key — NOT NULL
- Field (email) — email — [email protected] [email protected] [email protected] [email protected] [email protected] itcent…
- Field (password)
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