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