EMODIA_
Tables (20)
auth_group
- id — int — Primary key — NOT NULL
- name — varchar(150) — NOT NULL
auth_group_permissions
- id — bigint — Primary key — NOT NULL
- group_id — int — Foreign key → auth_group.id — NOT NULL
- permission_id — int — Foreign key → auth_permission.id — NOT NULL
auth_permission
- id — int — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- content_type_id — int — Foreign key → django_content_type.id — NOT NULL
- codename — varchar(100) — NOT NULL
auth_user
- id — int — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- last_login — datetime(6)
- is_superuser — tinyint(1) — NOT NULL
- username — varchar(150) — NOT NULL
- first_name — varchar(150) — NOT NULL
- last_name — varchar(150) — NOT NULL
- email — varchar(254) — NOT NULL
- is_staff — tinyint(1) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- date_joined — datetime(6) — NOT NULL
auth_user_groups
- id — bigint — Primary key — NOT NULL
- user_id — int — Foreign key → auth_user.id — NOT NULL
- group_id — int — Foreign key → auth_group.id — NOT NULL
auth_user_user_permissions
- id — bigint — Primary key — NOT NULL
- user_id — int — Foreign key → auth_user.id — NOT NULL
- permission_id — int — Foreign key → auth_permission.id — NOT NULL
authtoken_token
- key — varchar(40) — Primary key — NOT NULL
- created — datetime(6) — NOT NULL
- user_id — int — Foreign key → auth_user.id — NOT NULL
django_admin_log
- id — int — Primary key — NOT NULL
- action_time — datetime(6) — NOT NULL
- object_id — longtext
- object_repr — varchar(200) — NOT NULL
- action_flag — smallint — NOT NULL
- change_message — longtext — NOT NULL
- content_type_id — int — Foreign key → django_content_type.id
- user_id — int — Foreign key → auth_user.id — NOT NULL
django_content_type
- id — int — Primary key — NOT NULL
- app_label — varchar(100) — NOT NULL
- model — varchar(100) — NOT NULL
django_migrations
- id — bigint — Primary key — NOT NULL
- app — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- applied — datetime(6) — NOT NULL
django_session
- session_key — varchar(40) — Primary key — NOT NULL
- session_data — longtext — NOT NULL
- expire_date — datetime(6) — NOT NULL
emodia_emotionrecord
- id — bigint — Primary key — NOT NULL
- date — date — NOT NULL
- emotion — varchar(20) — NOT NULL
- emotion_score — int — NOT NULL
- memo — longtext
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- sports_id — bigint — Foreign key → emodia_sports.id
- user_id — int — Foreign key → auth_user.id — NOT NULL
- intensity — int
- mood_after — varchar(50)
- tags — json
- voice_of_mind — longtext
emodia_emotionvideo
- id — bigint — Primary key — NOT NULL
- video — varchar(100) — NOT NULL
- created_at — datetime(6) — NOT NULL
- sports_id — bigint — Foreign key → emodia_sports.id
- body_part — varchar(20)
- difficulty — varchar(20)
- duration_minutes — int
- exercise_type — varchar(50)
- original_filename — varchar(255)
emodia_expertposetemplate
- id — bigint — Primary key — NOT NULL
- exercise_phase — varchar(20) — NOT NULL
- quality_level — varchar(20) — NOT NULL
- keypoints — json — NOT NULL
- description — longtext — NOT NULL
- created_by — varchar(100) — NOT NULL
- created_at — datetime(6) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- features — json
- sports_id — bigint — Foreign key → emodia_sports.id — NOT NULL
emodia_feedbackrating
- id — bigint — Primary key — NOT NULL
- is_helpful — tinyint(1) — NOT NULL
- accuracy_rating — int
- comment — longtext — NOT NULL
- created_at — datetime(6) — NOT NULL
- pose_frame_id — bigint — Foreign key → emodia_poseframe.id — NOT NULL
- user_id — int — Foreign key → auth_user.id — NOT NULL
emodia_mlmodel
- id — bigint — Primary key — NOT NULL
- model_type — varchar(50) — NOT NULL
- version — varchar(50) — NOT NULL
- model_file — varchar(100) — NOT NULL
- accuracy — double
- precision — double
- recall — double
- f1_score — double
- training_samples — int — NOT NULL
- trained_at — datetime(6) — NOT NULL
- trained_by — varchar(100) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- notes — longtext — NOT NULL
- sports_id — bigint — Foreign key → emodia_sports.id — NOT NULL
emodia_poseframe
- id — bigint — Primary key — NOT NULL
- timestamp — double — NOT NULL
- keypoints — json — NOT NULL
- feedback — json
- session_id — bigint — Foreign key → emodia_workoutsession.id — NOT NULL
emodia_sports
- id — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
emodia_workoutsession
- id — bigint — Primary key — NOT NULL
- start_time — datetime(6) — NOT NULL
- end_time — datetime(6)
- duration — int — NOT NULL
- sports_id — bigint — Foreign key → emodia_sports.id — NOT NULL
- user_id — int — Foreign key → auth_user.id — NOT NULL
profiles_profile
- id — bigint — Primary key — NOT NULL
- main_goal — varchar(50)
- routine_time — time(6)
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- user_id — int — Foreign key → auth_user.id — NOT NULL
- routine_days — json