| id |
int(10)
|
|
|
|
| items_id |
int(10)
|
|
|
|
| itemtype |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| entities_id |
int(10)
|
|
|
|
| is_recursive |
tinyint(4)
|
|
|
|
| buy_date |
date
|
|
|
|
| use_date |
date
|
|
|
|
| warranty_duration |
int(11)
|
|
|
|
| warranty_info |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| suppliers_id |
int(10)
|
|
|
|
| order_number |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| delivery_number |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| immo_number |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| value |
decimal(20,4)
|
|
|
|
| warranty_value |
decimal(20,4)
|
|
|
|
| sink_time |
int(11)
|
|
|
|
| sink_type |
int(11)
|
|
|
|
| sink_coeff |
float
|
|
|
|
| comment |
text
|
utf8mb4_unicode_ci
|
|
|
| bill |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| budgets_id |
int(10)
|
|
|
|
| alert |
int(11)
|
|
|
|
| order_date |
date
|
|
|
|
| delivery_date |
date
|
|
|
|
| inventory_date |
date
|
|
|
|
| warranty_date |
date
|
|
|
|
| date_mod |
timestamp
|
|
|
|
| date_creation |
timestamp
|
|
|
|
| decommission_date |
timestamp
|
|
|
|
| businesscriticities_id |
int(10)
|
|
|
|
