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