| id |
int(10)
|
|
|
|
| asset_tag |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| asset_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| device_id |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| category_id |
int(10)
|
|
|
|
| branch_id |
int(10)
|
|
|
|
| warehouse_id |
int(10)
|
|
|
|
| brand |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| model |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| serial_number |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| device_hostname |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| extension_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| ip_address |
varchar(45)
|
utf8mb4_unicode_ci
|
|
|
| mac_address |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| device_password_encrypted |
text
|
utf8mb4_unicode_ci
|
|
|
| processor |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| ram_details |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| storage_details |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| cartridge_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| nvr_channels |
smallint(5)
|
|
|
|
| hdd_slots |
smallint(5)
|
|
|
|
| total_storage |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| playback_days |
smallint(5)
|
|
|
|
| area_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| camera_type |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| camera_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| port_details |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| screen_size |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| issued_date |
date
|
|
|
|
| imsi_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| sim_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| iqama_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| designation |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| phone_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| working_status |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| previous_user |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| imei_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| purpose |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| handover_date |
date
|
|
|
|
| charger |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| head_phone |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| admin_id |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| server_ip |
varchar(45)
|
utf8mb4_unicode_ci
|
|
|
| server_port |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| specification |
text
|
utf8mb4_unicode_ci
|
|
|
| operating_system |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| windows_key |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| office_key |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| monitor_id |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| pc_id |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| other_specs |
text
|
utf8mb4_unicode_ci
|
|
|
| location_id |
int(10)
|
|
|
|
| assigned_to_name |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| assigned_date |
date
|
|
|
|
| purchase_order_id |
int(10)
|
|
|
|
| external_po_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| supplier_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| purchase_date |
date
|
|
|
|
| purchase_cost |
decimal(15,2)
|
|
|
|
| warranty_expiry |
date
|
|
|
|
| license_renewal_date |
date
|
|
|
|
| asset_status |
enum('In Use', 'Available', 'Under Repair', 'Retired', 'Disposed', 'Lost')
|
utf8mb4_unicode_ci
|
|
|
| condition_status |
enum('New', 'Good', 'Fair', 'Poor', 'Damaged')
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
