# 数据库表结构说明

本文档详细描述了项目中使用的数据库表结构，包括各表的字段说明和示例数据。

## t_blood_glucose_data（血糖数据表）

### 表结构
| 字段名 | 类型 | 描述 |
|--------|------|------|
| id | BIGINT | 主键ID |
| user_id | BIGINT | 用户ID |
| measure_time | DATETIME | 测量时间 |
| type | VARCHAR | 血糖测量类型 |
| value | DECIMAL | 血糖值 |
| create_user | BIGINT | 创建者ID |
| create_time | DATETIME | 创建时间 |
| update_user | BIGINT | 更新者ID |
| update_time | DATETIME | 更新时间 |
| version | INT | 版本号（乐观锁） |
| remark | VARCHAR | 备注 |

### 示例数据
```
"id"	"user_id"	"measure_time"	"type"	"value"	"create_user"	"create_time"	"update_user"	"update_time"	"version"	"remark"
"1988502746686595073"	"1988147181088956418"	"12/11/2025 00:00:00"	"空腹"	"6"	"1"	"12/11/2025 15:02:54"	"1"	"12/11/2025 15:02:54"	"0"	
"1988502766861197314"	"1988147181088956418"	"12/11/2025 00:00:00"	"随机"	"7.6"	"1"	"12/11/2025 15:02:59"	"1"	"12/11/2025 15:02:59"	"0"	
"1988502817008295937"	"1988147181088956418"	"5/11/2025 00:00:00"	"空腹"	"5.4"	"1"	"12/11/2025 15:03:11"	"1"	"12/11/2025 15:03:11"	"0"	
"1988502842404806657"	"1988147181088956418"	"5/11/2025 00:00:00"	"随机"	"8.8"	"1"	"12/11/2025 15:03:17"	"1"	"12/11/2025 15:03:17"	"0"	
```

## t_blood_pressure_data（血压数据表）

### 表结构
| 字段名 | 类型 | 描述 |
|--------|------|------|
| id | BIGINT | 主键ID |
| user_id | BIGINT | 用户ID |
| systolic_pressure | INT | 收缩压(mmHg) |
| diastolic_pressure | INT | 舒张压(mmHg) |
| measure_time | DATETIME | 测量时间 |
| create_user | BIGINT | 创建者ID |
| create_time | DATETIME | 创建时间 |
| update_user | BIGINT | 更新者ID |
| update_time | DATETIME | 更新时间 |
| version | INT | 版本号（乐观锁） |
| remark | VARCHAR | 备注 |

### 示例数据
```
"id"	"user_id"	"systolic_pressure"	"diastolic_pressure"	"measure_time"	"create_user"	"create_time"	"update_user"	"update_time"	"version"	"remark"
"1988500010511409154"	"1988147181088956418"	"120"	"80"	"12/11/2025 00:00:00"	"1"	"12/11/2025 14:52:02"	"1"	"12/11/2025 14:52:02"	"0"	
```

## t_heart_rate_data（心率数据表）

### 表结构
| 字段名 | 类型 | 描述 |
|--------|------|------|
| id | BIGINT | 主键ID |
| user_id | BIGINT | 用户ID |
| heart_rate | INT | 心率(次/分钟) |
| measure_time | DATETIME | 测量时间 |
| create_user | BIGINT | 创建者ID |
| create_time | DATETIME | 创建时间 |
| update_user | BIGINT | 更新者ID |
| update_time | DATETIME | 更新时间 |
| version | INT | 版本号（乐观锁） |
| remark | VARCHAR | 备注 |

### 示例数据
```
"id"	"user_id"	"heart_rate"	"measure_time"	"create_user"	"create_time"	"update_user"	"update_time"	"version"	"remark"
"1988498386246213634"	"1988147181088956418"	"72"	"12/11/2025 00:00:00"	"1"	"12/11/2025 14:45:34"	"1"	"12/11/2025 14:45:34"	"0"	
"1988498431406284802"	"1988147181088956418"	"54"	"11/11/2025 00:00:00"	"1"	"12/11/2025 14:45:45"	"1"	"12/11/2025 14:45:45"	"0"	
```

## t_physical_data（体格数据表）

### 表结构
| 字段名 | 类型 | 描述 |
|--------|------|------|
| id | BIGINT | 主键ID |
| user_id | BIGINT | 用户ID |
| height | DECIMAL | 身高(cm) |
| weight | DECIMAL | 体重(kg) |
| measure_time | DATETIME | 测量时间 |
| create_user | BIGINT | 创建者ID |
| create_time | DATETIME | 创建时间 |
| update_user | BIGINT | 更新者ID |
| update_time | DATETIME | 更新时间 |
| version | INT | 版本号（乐观锁） |
| remark | VARCHAR | 备注 |

### 示例数据
```
"id"	"user_id"	"height"	"weight"	"measure_time"	"create_user"	"create_time"	"update_user"	"update_time"	"version"	"remark"
"1988449152629252097"	"1988147181088956418"	"155"	"65"	"9/11/2025 00:00:00"	"1"	"12/11/2025 11:29:56"	"1"	"12/11/2025 11:29:56"	"0"	
"1988456421005795330"	"1988147181088956418"	"177"	"90"	"12/11/2025 00:00:00"	"1"	"12/11/2025 11:58:49"	"1"	"12/11/2025 11:58:49"	"0"	
"1989581733017985026"	"1988147181088956418"	"170"	"78"	"15/11/2025 00:00:00"	"1"	"15/11/2025 14:30:24"	"1"	"15/11/2025 14:30:24"	"0"	
```

## t_user_binding（用户绑定关系表）

### 表结构
| 字段名 | 类型 | 描述 |
|--------|------|------|
| id | BIGINT | 主键ID |
| patient_user_id | BIGINT | 患者用户ID |
| bound_user_id | BIGINT | 被绑定用户ID（医生或家属） |
| binding_type | VARCHAR | 绑定类型（DOCTOR-医生, FAMILY-家属） |
| status | INT | 绑定状态（1-有效，0-无效） |
| create_user | BIGINT | 创建者ID |
| create_time | DATETIME | 创建时间 |
| update_user | BIGINT | 更新者ID |
| update_time | DATETIME | 更新时间 |
| version | INT | 版本号（乐观锁） |
| remark | VARCHAR | 备注 |

### 示例数据
```
"id"	"patient_user_id"	"bound_user_id"	"binding_type"	"status"	"create_user"	"create_time"	"update_user"	"update_time"	"version"	"remark"
"1990104700034510849"	"1988147181088956418"	"1988172854356631553"	"DOCTOR"	"1"	"1"	"17/11/2025 01:08:30"	"1"	"17/11/2025 01:08:30"	"0"	
"1990322533418975234"	"1988147181088956418"	"1988196438584090626"	"FAMILY"	"1"	"1"	"17/11/2025 15:34:05"	"1"	"17/11/2025 15:34:05"	"0"	
```

## t_user_info（用户信息表）

### 表结构
| 字段名 | 类型 | 描述 |
|--------|------|------|
| id | BIGINT | 主键ID |
| version | INT | 版本号（乐观锁） |
| create_user | BIGINT | 创建者ID |
| create_time | DATETIME | 创建时间 |
| update_user | BIGINT | 更新者ID |
| update_time | DATETIME | 更新时间 |
| remark | VARCHAR | 备注 |
| username | VARCHAR | 用户名（可选） |
| password | VARCHAR | 密码（可选） |
| role | INT | 角色（1-管理员, 2-医生, 3-患者, 4-患者家属） |
| wx_openid | VARCHAR | 微信ID（可选） |
| avatar | VARCHAR | 头像（可选） |
| nickname | VARCHAR | 昵称（可选） |
| sex | INT | 性别（1-男, 2-女） |
| phone | VARCHAR | 手机号（可选） |
| age | INT | 年龄（可选） |
| address | VARCHAR | 地址（可选） |

### 示例数据
```
"id"	"version"	"create_user"	"create_time"	"update_user"	"update_time"	"remark"	"username"	"password"	"role"	"wx_openid"	"avatar"	"nickname"	"sex"	"phone"	"age"	"address"
"1988147181088956418"	"23"	"1"	"11/11/2025 15:30:01"	"1"	"17/11/2025 15:13:57"				"3"	"oMrLJ4upWlkcM8ngNnj849sF_sZg"	"1988147181088956418/1763179829156.jpeg"	"患者test"	"1"	"19792741433"	"22"	"重庆市 重庆市"
"1988172854356631553"	"17"	"1"	"11/11/2025 17:12:02"	"1"	"17/11/2025 15:13:51"				"2"	"oMrLJ4upWlkcM8ngNnj849sF_sZg"	"1988172854356631553/1763182966320.jpeg"	"医生test"	"1"		"21"	
"1988196438584090626"	"4"	"1"	"11/11/2025 18:45:45"	"1"	"17/11/2025 15:14:01"				"4"	"oMrLJ4upWlkcM8ngNnj849sF_sZg"	"1988196438584090626/1763181495049.jpeg"	"家属test"	"1"	"19723123111"	"22"	"重庆市 重庆市"
"1988218156098805762"	"0"	"1"	"11/11/2025 20:12:02"	"1"	"11/11/2025 20:12:02"				"3"	"oMrLJ4tt491gE-__o36x3SrJ0kVg"						
"1989589966487068673"	"0"	"1"	"15/11/2025 15:03:07"	"1"	"15/11/2025 15:03:07"				"2"	"oMrLJ4tt491gE-__o36x3SrJ0kVg"						
```

## t_user_token（用户认证表）

### 表结构
| 字段名 | 类型 | 描述 |
|--------|------|------|
| id | BIGINT | 主键ID |
| version | INT | 版本号（乐观锁） |
| create_user | BIGINT | 创建者ID |
| create_time | DATETIME | 创建时间 |
| update_user | BIGINT | 更新者ID |
| update_time | DATETIME | 更新时间 |
| remark | VARCHAR | 备注 |
| user_id | BIGINT | 用户ID |
| token | VARCHAR | 认证令牌 |
| expire_time | DATETIME | 过期时间 |

### 示例数据
```
"id"	"version"	"create_user"	"create_time"	"update_user"	"update_time"	"remark"	"user_id"	"token"	"expire_time"
"1988147181156065282"	"37"	"1"	"11/11/2025 15:30:01"	"1"	"11/11/2025 15:30:01"		"1988147181088956418"	"7deed423fcc94515b74ab603ab237c00"	"20/11/2025 15:33:51"
"1988172854419546114"	"14"	"1"	"11/11/2025 17:12:02"	"1"	"11/11/2025 17:12:02"		"1988172854356631553"	"eb49edc2a2464871a0f51604bc4e10e2"	"20/11/2025 17:43:26"
"1988196438584090627"	"9"	"1"	"11/11/2025 18:45:45"	"1"	"11/11/2025 18:45:45"		"1988196438584090626"	"56ba488c953f42549fb1e6cbe1f12450"	"20/11/2025 15:32:19"
"1988218156098805763"	"0"	"1"	"11/11/2025 20:12:02"	"1"	"11/11/2025 20:12:02"		"1988218156098805762"	"9cde389298664619aaae9c65cf7ab325"	"14/11/2025 20:12:02"
"1989589966487068674"	"0"	"1"	"15/11/2025 15:03:07"	"1"	"15/11/2025 15:03:07"		"1989589966487068673"	"3b34609dac4548b0a1d66f057a6fee2c"	"18/11/2025 15:03:07"
```