智能健身系统数据库设计文档
1. 系统概述
智能健身系统是一个集会员管理、运动记录、设备管理和数据分析于一体的综合管理系统。
2. 数据库E-R图设计
erDiagramMEMBERS {string member_id PK "varchar(15)"string name "varchar(50)"string gender "char(1)"date birth_datestring 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_datestring 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_datestring status "varchar(15)"date last_calibrationdecimal accuracy_rating "numeric(3,2)"}WORKOUT_DATA {int data_id PKstring member_id FK "varchar(15)"string device_id FK "varchar(20)"string workout_type "varchar(30)"datetime start_timedatetime end_timeint calories_burnedint avg_heart_rateint max_heart_rateint steps_countdecimal distance_km "numeric(8,3)"int performance_score}BODY_METRICS {int metric_id PKstring member_id FK "varchar(15)"date measure_datetime measure_timedecimal 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_ageint visceral_fat_levelstring device_id FK "varchar(20)"}MEMBER_AUDIT_LOG {int log_id PKstring member_id "varchar(15)"string operation_type "varchar(10)"datetime operation_timestring 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"