# 阿巴阿巴-垃圾分类

**Repository Path**: KissedBySnow/garbage

## Basic Information

- **Project Name**: 阿巴阿巴-垃圾分类
- **Description**: No description available
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 3
- **Forks**: 0
- **Created**: 2020-09-09
- **Last Updated**: 2022-07-26

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

---
typora-root-url: ./img
---

# 阿巴阿巴-垃圾分类

## TODO

- 垃圾表增加 query_count 字段，记录查询次数。同时建立查询关键字 Log 表，关联垃圾表，用于改善查询体验。

## 功能梳理

- 登录
- 注册
- 垃圾查询
    - 垃圾类别
- 站点查询
    - 负责人信息
- 投诉
- 报修

## Page

![MBP 2022-02-20 20.52.54](/MBP 2022-02-20 20.52.54.png)

## Table

### sys_User 用户

- 登入模块
- ==注册模块==

| Column     | Description | Type    | Length | Primary Key |
| ---------- | ----------- | ------- | ------ | ----------- |
| id         | UserId      | int     | 11     | T           |
| name       |             | varchar | 255    |             |
| username   |             | varchar | 255    |             |
| password   |             | varchar | 255    |             |
| permission |             | varchar | 255    |             |

- permission
    - root
    - admin
    - user

### t_Garbage 垃圾

| Column  | Description                                      | Type    | Length | Primary Key |
| ------- | ------------------------------------------------ | ------- | ------ | ----------- |
| id      | RubbishId                                        | int     | 11     | T           |
| type_id | 对应分类表的 id                                  | int     | 11     |             |
| name    | 学名或俗称（普通话），有俗称时用俗称，反之用学名 | varchar | 20     |             |
| alias   | 别名                                             | varchar | 255    |             |

### dict_type 垃圾分类

| Column | Description  | Type    | Length | Primary Key |
| ------ | ------------ | ------- | ------ | ----------- |
| id     | RCategoryId  | int     | 11     | T           |
| name   | 类名         | varchar | 20     |             |
| style  | 前端显示样式 | varchar | 255    |             |

| id   | name     |
| ---- | -------- |
| 1    | 可回收物 |
| 2    | 干垃圾   |
| 4    | 湿垃圾   |
| 8    | 有害垃圾 |

> 干垃圾大部分又可分为可回收♻️和有害

### dict_Garbage Site 垃圾站点信息

| Column         | Description | Type    | Length | Primary Key |
| -------------- | ----------- | ------- | ------ | ----------- |
| id             | SiteId      | int     | 11     | T           |
| name           | SiteName    | varchar | 255    |             |
| ~~address_id~~ |             |         |        |             |
| address        |             | varchar | 255    |             |

### dict_Person 负责人信息表 :white_check_mark:

| Column  | Description | Type    | Length | Primary Key |
| ------- | ----------- | ------- | ------ | ----------- |
| id      | PersonId    | int     | 11     | T           |
| site_id |             | int     | 11     |             |
| name    | PersonName  | varchar | 255    |             |
| tel     |             | decimal | 11     |             |

### ~~dict_Address 地址表~~ :white_check_mark:

地址表还是废弃比较好，结构简单的地址表意义不大，后期可用性差。

| Column | Description | Type | Length | Primary Key |
| ------ | ----------- | ---- | ------ | ----------- |
| id     | AddressId   | int  | 11     | T           |
| level1 |             |      |        |             |
| level2 |             |      |        |             |

### t_Complaint 投诉

| Column         | Description | Type    | Length | Primary Key |
| -------------- | ----------- | ------- | ------ | ----------- |
| id             | ComplaintId | int     | 11     | T           |
| user_id        |             | int     | 11     |             |
| ~~address_id~~ |             | varchar | 255    |             |
| remark         |             | varchar | 255    |             |

### t_Repair 维修

| Column         | Description | Type    | Length | Primary Key |
| -------------- | ----------- | ------- | ------ | ----------- |
| id             | RepairId    | int     | 11     | T           |
| user_id        |             | int     | 11     |             |
| ~~address_id~~ |             | varchar | 255    |             |
| remark         |             | varchar | 255    |             |