3.5 KiB
工单列表
-- 检查work_order表结构 -- 2026-01-25
DESC work_order
Field |Type |Null|Key|Default |Extra | -------------+------------+----+---+-----------------+---------------------------+ id |bigint(20) |NO |PRI| |auto_increment | tenant_id |bigint(20) |YES |MUL|1 | | order_id |bigint(20) |YES |MUL|0 | | manager_id |bigint(20) |YES |MUL|0 | | teacher_id |bigint(20) |YES |MUL|0 | | user_id |bigint(20) |YES | |0 | | student_id |bigint(20) |YES | |0 | | work_type |varchar(50) |YES |MUL|assign | | priority |tinyint(4) |YES | |1 | | status |int(11) |YES |MUL|0 | | title |varchar(200)|YES | |陪伴服务工单 | | content |text |YES | | | | solution |text |YES | | | | result |text |YES | | | | assign_time |datetime |YES | | | | complete_time|datetime |YES | | | | create_time |datetime |YES | |CURRENT_TIMESTAMP| | update_time |datetime |YES | |CURRENT_TIMESTAMP|on update CURRENT_TIMESTAMP| work_order_no|varchar(50) |YES | | | | student_name |varchar(50) |YES | | | | teacher_name |varchar(50) |YES | | | | service_type |varchar(50) |YES | | | | service_date |date |YES | | | | time_slot |varchar(50) |YES | | | | address |varchar(500)|YES | | | |
25 row(s) fetched.
水印打卡
DESC check_in_record
Field |Type |Null|Key|Default |Extra | -----------+-------------+----+---+-----------------+--------------+ id |bigint(20) |NO |PRI| |auto_increment| tenant_id |bigint(20) |YES |MUL| | | order_id |bigint(20) |YES |MUL| | | teacher_id |bigint(20) |NO |MUL| | | user_id |bigint(20) |NO |MUL| | | student_id |bigint(20) |YES | | | | check_type |varchar(20) |NO | | | | check_time |datetime |NO |MUL| | | photo_url |varchar(500) |YES | | | | latitude |decimal(10,6)|YES | | | | longitude |decimal(10,6)|YES | | | | address |varchar(200) |YES | | | | device_info|varchar(200) |YES | | | | remark |text |YES | | | | create_time|datetime |YES | |CURRENT_TIMESTAMP| |
15 row(s) fetched.