| id |
int(10)
|
|
|
|
| name |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| asset_tag |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| model_id |
int(11)
|
|
|
|
| serial |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| purchase_date |
date
|
|
|
|
| asset_eol_date |
date
|
|
|
|
| eol_explicit |
tinyint(1)
|
|
|
|
| purchase_cost |
decimal(20,2)
|
|
|
|
| order_number |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| assigned_to |
int(11)
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| image |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| physical |
tinyint(1)
|
|
|
|
| deleted_at |
timestamp
|
|
|
|
| status_id |
int(11)
|
|
|
|
| archived |
tinyint(1)
|
|
|
|
| warranty_months |
int(11)
|
|
|
|
| depreciate |
tinyint(1)
|
|
|
|
| supplier_id |
int(11)
|
|
|
|
| requestable |
tinyint(4)
|
|
|
|
| rtd_location_id |
int(11)
|
|
|
|
| accepted |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| last_checkout |
datetime
|
|
|
|
| last_checkin |
datetime
|
|
|
|
| expected_checkin |
date
|
|
|
|
| company_id |
int(10)
|
|
|
|
| assigned_type |
varchar(191)
|
utf8mb4_unicode_ci
|
|
|
| last_audit_date |
datetime
|
|
|
|
| next_audit_date |
date
|
|
|
|
| location_id |
int(11)
|
|
|
|
| checkin_counter |
int(11)
|
|
|
|
| checkout_counter |
int(11)
|
|
|
|
| requests_counter |
int(11)
|
|
|
|
| byod |
tinyint(1)
|
|
|
|
| _snipeit_memoria_ram_2 |
text
|
utf8mb4_unicode_ci
|
|
|
| _snipeit_procesador_3 |
text
|
utf8mb4_unicode_ci
|
|
|
| _snipeit_disco_duro_4 |
text
|
utf8mb4_unicode_ci
|
|
|
| _snipeit_sistema_operativo_5 |
text
|
utf8mb4_unicode_ci
|
|
|
| _snipeit_anydesk_6 |
text
|
utf8mb4_unicode_ci
|
|
|
| _snipeit_concesionarias_7 |
text
|
utf8mb4_unicode_ci
|
|
|
