device_management_2.0

Tables (27)

Copy Of Untitled (software_applications)

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

Untitled (device_license)

  • Key (license_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Key (device_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL

Untitled (accesory_staff)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Key (asset_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Key (staff_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Field (remark)
  • Field (timestamps) — timestamp
  • Field (softdelete) — timestamp

Untitled (assets)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Field (asset_type) — morph
  • Field (asset_id) — morph
  • Key (asset_category_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Field (quantity) — integer
  • Field (min_quantity) — integer

Untitled (accessories)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Key (device_model_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — string
  • Field (quantity) — int
  • Field (min_quantity) — int
  • Field (total) — int
  • Field (remark) — text

Untitled (purchase_transaction_items)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Key (purchase_transaction_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • Field (item_type) — class
  • Field (item_id) — id
  • Field (quantity) — number
  • Field (uom) — string
  • Field (unit_price) — double
  • Field (gross_amount) — float
  • Field (tax_percentage) — double
  • Field2 (net_amount) — double
  • Field (remark) — text

Untitled (suppliers)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Field (name) — string
  • Field (address) — string
  • Field (website) — string
  • Field (email) — string
  • Field (phone) — string
  • Field (no)

Untitled (purchase_transactions)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Key (supplier_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • id (user_id) — autoincrement — Foreign key → users.id — NOT NULL
  • Field (amount) — double
  • Field (transaction_date) — date
  • Field (remark) — text

Untitled (locations)

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

Untitled (departments)

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

Untitled (staffs)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Field (name) — string
  • Field (phone) — string
  • Field (email) — string
  • Field (is_user) — boolean
  • Key (department_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL

Untitled (asset_groups)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Field (name) — string — devices licenses accessories consumables components

Untitled (storage_units)

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

Untitled (brand_asset_category)

  • id (brand_id) — autoincrement — Foreign key → brands.id — NOT NULL
  • Key (asset_category_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL

Untitled (licenses)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Key (software_application_id) — autoincrement — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (key) — string
  • Field (activation_email) — email
  • Field (activated_at) — date
  • Field (expired_at) — date
  • Field (unit_price) — integer
  • Field (quantity) — integer
  • Field (remark) — text

Untitled (devices)

  • Key (id) — autoincrement — Primary key — NOT NULL
  • Key (model_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • id (brand_id) — autoincrement — Foreign key → brands.id — NOT NULL
  • id (cpu_id) — autoincrement — Foreign key → cpus.id — NOT NULL
  • id (gpu_id) — autoincrement — Foreign key → gpus.id — NOT NULL
  • id (ram_id) — autoincrement — Foreign key → rams.id — NOT NULL
  • id (storage_id) — autoincrement — Foreign key → storages.id — NOT NULL
  • id (status_id) — pk — Foreign key → device_statuses.id — NOT NULL
  • Field (windows_license) — string
  • Field (office_license) — string
  • Field (express_no) — string
  • Field (service_tag) — string
  • Field (warranty) — number(in month)
  • Field (antivirus_acc) — string
  • Field (label) — string
  • Field (remark) — text
  • Field (wifi_mac) — mac
  • Field (lan_mac) — mac
  • id (assigned_to) — autoincrement — Foreign key → users.id — NOT NULL
  • Field (assigned_date) — date

Untitled (device_models)

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

Untitled (asset_categories)

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

attachments

  • id — autoincrement — Primary key — NOT NULL
  • Field

brands

  • id — autoincrement — Primary key — NOT NULL
  • name — string

cpus

  • id — autoincrement — Primary key — NOT NULL
  • brand_id — autoincrement — Foreign key → brands.id — NOT NULL
  • model — string
  • speed — string — 2.0GHz, 1.8 Ghz 2.0GHz, 1.8 Ghz
  • core_count — number — 1,2,4,8
  • thread_count — number

device_statuses

  • id — pk — Primary key — NOT NULL
  • name — string — on user in order waiting stored disposed repair
  • Field

gpus

  • id — autoincrement — Primary key — NOT NULL
  • brand_id — autoincrement — Foreign key → brands.id — NOT NULL
  • Field (model) — string

rams

  • id — autoincrement — Primary key — NOT NULL
  • type_id (accessory_type_id) — autoincrement — Foreign key → types.id — NOT NULL
  • Key (storage_unit_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • capacity — number
  • speed — (in Mhz)
  • configuration (channel_no) — number
  • Field (remark) — text

storages

  • id — autoincrement — Primary key — NOT NULL
  • type_id (accessory_type_id) — autoincrement — Foreign key → types.id — NOT NULL
  • Key (storage_unit_id) — autoincrement — Foreign key → Untitled.Key — NOT NULL
  • capacity — number
  • Field (remark) — text

types (accessory_types)

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

users

  • id — autoincrement — Primary key — NOT NULL
  • Field