todo网站需求分析

[liaogx123]

[liaogx123]

todo-project简单需求分析：

1. 网站默认包含四个panel(面板)todo, doing, cancle, done 并且还可以自己添加新的panel
2. 在每个模块中可以添加或者修改item(todo项), 删除, 每条item可以在模块之间移动, 后续会有item预警.
3. 后续会添加用户并且多人协作。

[liaogx123]

mysql

DROP TABLE IF EXISTS `item`;
CREATE TABLE `item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `image` varchar(50) DEFAULT NULL,
  `context` varchar(100) DEFAULT NULL,
  `createtime` date DEFAULT NULL,
  `endtime` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `panel`;
CREATE TABLE `panel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `panel_item`;
CREATE TABLE `panel_item` (
  `id` int(11) DEFAULT NULL,
  `panelid` int(11) NOT NULL DEFAULT '0',
  `itemid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`panelid`,`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[BUGLAN]

todo project 数据库设计

CREATE TABLE if not exists `item`
(
    `id`          int(11)                                                            NOT NULL AUTO_INCREMENT comment '主键',
    `name`        varchar(20)                                                        not null comment 'todo项的名称',
    `image`       varchar(50)  default ''                                            not null comment 'todo项的图片',
    `description` varchar(255) default ''                                            not null comment 'todo项的描述',
    `create_time` timestamp    default current_timestamp                             not null comment '创建时间',
    `update_time` timestamp    default current_timestamp on update current_timestamp not null comment '修改时间',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  collate utf8mb4_unicode_ci comment 'todo项';

CREATE TABLE if not exists `panel`
(
    `id`          int(11)                                                         NOT NULL AUTO_INCREMENT comment '主键',
    `name`        varchar(20)                                                     not null comment '面板的名称',
    `create_time` timestamp default current_timestamp                             not null comment '创建时间',
    `update_time` timestamp default current_timestamp on update current_timestamp not null comment '修改时间',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  collate utf8mb4_unicode_ci comment '面板';

CREATE TABLE if not exists `panel_item`
(
    `id`          int(11)                                                         NOT NULL AUTO_INCREMENT comment '主键',
    `panel_id`    int(11)   default 0                                             not null comment '关联#panel.id',
    `item_id`     int(11)   default 0                                             not null comment '关联#item.id',
    `create_time` timestamp default current_timestamp                             not null comment '创建时间',
    `update_time` timestamp default current_timestamp on update current_timestamp not null comment '修改时间',
    PRIMARY KEY (`id`),
    index idx_panel_id (`panel_id`),
    index idx_item_id (`panel_id`)

) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  collate utf8mb4_unicode_ci comment 'todo项和panel关联表';

[liaogx123]

前后端交互接口

###Accept代表发送端（客户端）希望接受的数据类型,{}括号中的是返回参数示例
###获取todo页面下所有panel
GET http://localhost:8080/todo
Accept: application/json
Cache-Control: no-cache
{
“panel”;
}

###获取所有panel中所有item
GET http://localhost:8080/todo
Accept: application/json
Cache-Control: no-cache
{
“item”;
}

###新增panel
POST http://localhost:8080/panel
Accept: application/json
Cache-Control: no-cache
{
"code":200,
"message" :"添加成功"
}

###某个panel增加item
POST http://localhost:8080/item
Accept: application/json
Cache-Control: no-cache
{
"code":200,
"message" :"添加成功"
}

###修改某个panel
PUT http://localhost:8080/panel
Accept: application/json
Cache-Control: no-cache
{
“panel”;
}

###修改某个item
PUT http://localhost:8080/item
Accept: application/json
Cache-Control: no-cache
{
“item”;
}

###删除某个panel
DELETE http://localhost:8080/panel
Accept: application/json
Cache-Control: no-cache
{
"code" :200,
"message”：“删除成功”
}

DELETE http://localhost:8080/item
Accept: application/json
Cache-Control: no-cache
{
"code":200,
"message": "删除成功"
}

[BUGLAN]

@liaogx123 markdown格式, 代码块