# HexCampus

**Repository Path**: dipper_room/hex-campus

## Basic Information

- **Project Name**: HexCampus
- **Description**: 校园信息共享平台vue3+springboot
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: test-combination
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 3
- **Forks**: 1
- **Created**: 2025-03-24
- **Last Updated**: 2025-10-04

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

### 前端端口5173，后端端口6005，mysql端口3306

### 数据库

```sql
CREATE DATABASE hex_campus;

USE hex_campus;

CREATE TABLE users (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(255) NOT NULL UNIQUE,
  email VARCHAR(255) ,
  password VARCHAR(255) NOT NULL
);

CREATE TABLE notes (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    content LONGTEXT NOT NULL
);

CREATE TABLE note_image_urls (
    note_id BIGINT NOT NULL,
    image_url VARCHAR(1000),
    FOREIGN KEY (note_id) REFERENCES notes(id)
);

CREATE TABLE note_attachment_urls (
    note_id BIGINT NOT NULL,
    attachment_url VARCHAR(1000),
    FOREIGN KEY (note_id) REFERENCES notes(id)
);

CREATE TABLE books (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    price VARCHAR(255) NOT NULL,
    user_id BIGINT NOT NULL,
    description VARCHAR(255) NOT NULL,
    image_url VARCHAR(255),
    FOREIGN KEY (user_id) REFERENCES users(id) -- 定义外键约束
);

CREATE TABLE profiles (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    user_id BIGINT NOT NULL UNIQUE,
    name VARCHAR(255),
    grade VARCHAR(255),
    college VARCHAR(255),
    contact VARCHAR(255), 
    address VARCHAR(255),
    bio VARCHAR(500), 
    avatar_url VARCHAR(255),
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE -- 外键约束
);

// 新建一个用户名admin，密码123456的测试用户
INSERT INTO `users` (`username`, `email`, `password`) VALUES ('admin', 'email', '123456');
```