CREATE TABLE IF NOT EXISTS t_todo (
|
todo_id BIGINT AUTO_INCREMENT PRIMARY KEY,
|
content VARCHAR(200) NOT NULL,
|
owner_id BIGINT NOT NULL,
|
owner_name VARCHAR(100) NOT NULL,
|
creator_id BIGINT NOT NULL,
|
creator_name VARCHAR(100) NOT NULL,
|
status VARCHAR(20) NOT NULL DEFAULT '待处理',
|
created_at_utc DATETIME(3) NOT NULL,
|
operated_at_utc DATETIME(3) NOT NULL,
|
handle_remark VARCHAR(500) NULL,
|
INDEX idx_todo_owner_status (owner_id, status),
|
INDEX idx_todo_operated (operated_at_utc)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户待办事项';
|
