数据库表结构说明
本文档详细描述了项目中使用的数据库表结构，包括各表的字段说明和示例数据。
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"
