| id |
int(11)
|
|
|
|
| asset_id |
int(11)
|
|
|
 浏览不相关的值
|
| booking_number |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| employee_id |
int(11)
|
|
|
|
| department_id |
int(11)
|
|
|
|
| purpose |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| booking_date |
date
|
|
|
|
| start_time |
time
|
|
|
|
| end_time |
time
|
|
|
|
| return_time |
timestamp
|
|
|
|
| status |
enum('pending', 'approved', 'in_use', 'returned', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| approved_by |
int(11)
|
|
|
|
| approved_at |
timestamp
|
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| condition_on_return |
enum('good', 'fair', 'damaged')
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
