# coderhub

**Repository Path**: codefa/coderhub

## Basic Information

- **Project Name**: coderhub
- **Description**: node学习
- **Primary Language**: NodeJS
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2026-01-16
- **Last Updated**: 2026-01-28

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# coderhub

#### 介绍
node学习

#### 软件架构
软件架构说明


#### 安装教程

1.  xxxx
2.  xxxx
3.  xxxx

#### 使用说明

1.  xxxx
2.  xxxx
3.  xxxx

#### 参与贡献

1.  Fork 本仓库
2.  新建 Feat_xxx 分支
3.  提交代码
4.  新建 Pull Request


#### 特技

1.  使用 Readme\_XXX.md 来支持不同的语言，例如 Readme\_en.md, Readme\_zh.md
2.  Gitee 官方博客 [blog.gitee.com](https://blog.gitee.com)
3.  你可以 [https://gitee.com/explore](https://gitee.com/explore) 这个地址来了解 Gitee 上的优秀开源项目
4.  [GVP](https://gitee.com/gvp) 全称是 Gitee 最有价值开源项目，是综合评定出的优秀开源项目
5.  Gitee 官方提供的使用手册 [https://gitee.com/help](https://gitee.com/help)
6.  Gitee 封面人物是一档用来展示 Gitee 会员风采的栏目 [https://gitee.com/gitee-stars/](https://gitee.com/gitee-stars/)


#### 相关的表创建

# 1.user
# CREATE TABLE `user` (
#   `id` int NOT NULL AUTO_INCREMENT,
#   `name` varchar(30) NOT NULL,
#   `password` varchar(50) NOT NULL,
#   `createAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
#   `updateAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
#   `avatar_url` varchar(200) DEFAULT NULL,
#   PRIMARY KEY (`id`),
#   UNIQUE KEY `name` (`name`)
# ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
# 2.moment
# CREATE TABLE `moment` (
#   `id` int NOT NULL AUTO_INCREMENT,
#   `content` varchar(1000) NOT NULL,
#   `user_id` int NOT NULL,
#   `createAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
#   `updateAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
#   PRIMARY KEY (`id`),
#   KEY `user_id` (`user_id`),
#   CONSTRAINT `moment_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
# ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci# 
# 3.label
# CREATE TABLE `label` (
#   `id` int NOT NULL AUTO_INCREMENT,
#   `name` varchar(20) NOT NULL,
#   `createAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
#   `updateAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
#   PRIMARY KEY (`id`),
#   UNIQUE KEY `name` (`name`)
# ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
# 4.moment_label
# CREATE TABLE `moment_label` (
#   `moment_id` int NOT NULL,
#   `label_id` int NOT NULL,
#   `createAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
#   `updateAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
#   PRIMARY KEY (`moment_id`,`label_id`),
#   KEY `label_id` (`label_id`),
#   CONSTRAINT `moment_label_ibfk_1` FOREIGN KEY (`moment_id`) REFERENCES `moment` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
#   CONSTRAINT `moment_label_ibfk_2` FOREIGN KEY (`label_id`) REFERENCES `label` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
# ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
# 5.file
# CREATE TABLE `file` (
#   `id` int NOT NULL AUTO_INCREMENT,
#   `filename` varchar(255) NOT NULL,
#   `mimetype` varchar(30) DEFAULT NULL,
#   `size` int DEFAULT NULL,
#   `moment_id` int NOT NULL,
#   `user_id` int NOT NULL,
#   `createAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
#   `updateAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
#   PRIMARY KEY (`id`),
#   KEY `moment_id` (`moment_id`),
#   KEY `user_id` (`user_id`),
#   CONSTRAINT `file_ibfk_1` FOREIGN KEY (`moment_id`) REFERENCES `moment` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
#   CONSTRAINT `file_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
# ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
# 6.avatar
# CREATE TABLE `avatar` (
#   `id` int NOT NULL AUTO_INCREMENT,
#   `filename` varchar(255) NOT NULL,
#   `mimetype` varchar(30) DEFAULT NULL,
#   `size` int DEFAULT NULL,
#   `user_id` int NOT NULL,
#   `createAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
#   `updateAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
#   PRIMARY KEY (`id`),
#   KEY `user_id` (`user_id`),
#   CONSTRAINT `avatar_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
# ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
# 7.comment
# CREATE TABLE `comment` (
#   `id` int NOT NULL AUTO_INCREMENT,
#   `content` varchar(1000) NOT NULL,
#   `moment_id` int NOT NULL,
#   `user_id` int NOT NULL,
#   `comment_id` int DEFAULT NULL,
#   `createAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
#   `updateAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
#   PRIMARY KEY (`id`),
#   KEY `moment_id` (`moment_id`),
#   KEY `user_id` (`user_id`),
#   KEY `comment_id` (`comment_id`),
#   CONSTRAINT `comment_ibfk_1` FOREIGN KEY (`moment_id`) REFERENCES `moment` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
#   CONSTRAINT `comment_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
#   CONSTRAINT `comment_ibfk_3` FOREIGN KEY (`comment_id`) REFERENCES `comment` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
# ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

# .env文件
# APP_DEPLOY = http://127.0.0.1
# APP_PORT = 8000
# 
# MYSQL_HOST = localhost
# MYSQL_PORT = 3306
# MYSQL_DATABASE = 数据库名称
# MYSQL_USER = root
# MYSQL_PASSWORD = mysql密码