1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
| code - spin
|
| alter table man_agv_model
| add need_undocking int(1) default 0 null comment '断开充电{1:是,0:否}' after mqtt_topic;
|
| alter table man_agv_model
| add backup_action int(1) default 0 null comment '背篓动作{1:是,0:否}' after need_undocking;
|
| man_segment: start_time, end_time,
|
| alter table man_segment
| add roller_waiting int(1) default 0 null comment '滚筒线等待' after end_time;
| man_segment_log
|
| alter table man_sta
| add capacity int null comment '槽位数' after angle;
| alter table man_sta
| add occ_cnt int null comment '占用数' after capacity;
| alter table man_sta
| add rsv_in_cnt int null comment '预约放货量' after occ_cnt;
| alter table man_sta
| add rsv_out_cnt int null comment '预约取货量' after rsv_in_cnt;
|
|
|
| -- auto-generated definition
| create table man_sta_reserve_log
| (
| id bigint not null comment 'ID',
| uuid varchar(255) null comment '标识',
| sta_id bigint not null comment '站点[man_sta]',
| task_id bigint not null comment '任务[man_task]',
| segment_id bigint null comment '作业[man_segment]',
| agv_id bigint not null comment 'AGV[man_agv]',
| name varchar(255) null comment '名称(*)',
| type varchar(255) not null comment '预约类型',
| qty int not null comment '预约数量',
| state varchar(255) not null comment '预约状态',
| reason varchar(255) null comment '原因',
| expire_time timestamp null comment '过期时间',
| waiting_at timestamp null comment '开始等待时间',
| confirmed_at timestamp null comment '确认完成时间',
| cancelled_at timestamp null comment '取消时间',
| uniq_key varchar(255) null comment '幂等键',
| status int(1) default 1 not null comment '状态{1:正常,0:冻结}',
| deleted int(1) default 0 not null comment '是否删除{1:是,0:否}',
| tenant_id int null comment '租户[sys_tenant]',
| create_by bigint null comment '添加人员[sys_user]',
| create_time timestamp default CURRENT_TIMESTAMP not null comment '添加时间',
| update_by bigint null comment '修改人员[sys_user]',
| update_time timestamp default CURRENT_TIMESTAMP null comment '修改时间',
| memo varchar(255) null comment '备注'
| )
| charset = utf8;
|
|
|
| -- auto-generated definition
| create table man_sta_reserve_log
| (
| id bigint not null comment 'ID',
| uuid varchar(255) null comment '标识',
| sta_id bigint not null comment '站点[man_sta]',
| task_id bigint not null comment '任务[man_task]',
| segment_id bigint null comment '作业[man_segment]',
| agv_id bigint not null comment 'AGV[man_agv]',
| name varchar(255) null comment '名称(*)',
| type varchar(255) not null comment '预约类型',
| qty int not null comment '预约数量',
| state varchar(255) not null comment '预约状态',
| reason varchar(255) null comment '原因',
| expire_time timestamp null comment '过期时间',
| waiting_at timestamp null comment '开始等待时间',
| confirmed_at timestamp null comment '确认完成时间',
| cancelled_at timestamp null comment '取消时间',
| uniq_key varchar(255) null comment '幂等键',
| status int(1) default 1 not null comment '状态{1:正常,0:冻结}',
| deleted int(1) default 0 not null comment '是否删除{1:是,0:否}',
| tenant_id int null comment '租户[sys_tenant]',
| create_by bigint null comment '添加人员[sys_user]',
| create_time timestamp default CURRENT_TIMESTAMP not null comment '添加时间',
| update_by bigint null comment '修改人员[sys_user]',
| update_time timestamp default CURRENT_TIMESTAMP null comment '修改时间',
| memo varchar(255) null comment '备注'
| )
| charset = utf8;
|
| -- menu
| 194,menu.staReserve,55,menu.equipment,55,menu.equipment,/manager/staReserve,staReserve,null,null,0,null,AccessTime,101,null,1,1,0,null,null,2025-12-26 10:56:42,2,null
| 195,Query StaReserve,194,null,null,null,null,null,null,null,1,manager:staReserve:list,null,0,null,1,1,0,null,null,null,null,null
| 196,Create StaReserve,194,null,null,null,null,null,null,null,1,manager:staReserve:save,null,1,null,1,1,0,null,null,null,null,null
| 197,Update StaReserve,194,null,null,null,null,null,null,null,1,manager:staReserve:update,null,2,null,1,1,0,null,null,null,null,null
| 198,Delete StaReserve,194,null,null,null,null,null,null,null,1,manager:staReserve:remove,null,3,null,1,1,0,null,null,null,null,null
|
|
