智能健身系统数据库设计文档
1. 系统概述
智能健身系统是一个集会员管理、运动记录、设备管理和数据分析于一体的综合管理系统。
2. 数据库E-R图设计
erDiagram
MEMBERS {
string member_id PK "varchar(15)"
string name "varchar(50)"
string gender "char(1)"
date birth_date
string phone "varchar(15)"
string email "varchar(100)"
string fitness_goal "varchar(20)"
decimal target_weight "numeric(5,2)"
string membership_type "varchar(20)"
date join_date
string status "varchar(10)"
}
SMART_DEVICES {
string device_id PK "varchar(20)"
string device_type "varchar(30)"
string brand "varchar(50)"
string model "varchar(50)"
date purchase_date
string status "varchar(15)"
date last_calibration
decimal accuracy_rating "numeric(3,2)"
}
WORKOUT_DATA {
int data_id PK
string member_id FK "varchar(15)"
string device_id FK "varchar(20)"
string workout_type "varchar(30)"
datetime start_time
datetime end_time
int calories_burned
int avg_heart_rate
int max_heart_rate
int steps_count
decimal distance_km "numeric(8,3)"
int performance_score
}
BODY_METRICS {
int metric_id PK
string member_id FK "varchar(15)"
date measure_date
time measure_time
decimal weight_kg "numeric(5,2)"
decimal body_fat_percent "numeric(4,2)"
decimal muscle_mass_kg "numeric(5,2)"
decimal bmi "numeric(4,2)"
int metabolic_age
int visceral_fat_level
string device_id FK "varchar(20)"
}
MEMBER_AUDIT_LOG {
int log_id PK
string member_id "varchar(15)"
string operation_type "varchar(10)"
datetime operation_time
string operator "varchar(50)"
}
MEMBERS ||--o{ WORKOUT_DATA : "creates"
MEMBERS ||--o{ BODY_METRICS : "records"
SMART_DEVICES ||--o{ WORKOUT_DATA : "used_in"
SMART_DEVICES ||--o{ BODY_METRICS : "measures"
MEMBERS ||--o{ MEMBER_AUDIT_LOG : "audited"
浙公网安备 33010602011771号