healthcare

테이블 (8)

ExerciseProgram

  • exercise_program_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT

InbodyData

  • id — BIGINT — 기본 키 — NOT NULL
  • user_number — VARCHAR(255)
  • date — VARCHAR(255)
  • time — VARCHAR(255)
  • sex — VARCHAR(10)
  • birth_year — INT
  • weight — DOUBLE
  • body_fat — DOUBLE
  • skeletal_muscle_mass — DOUBLE
  • body_fat_percentage — DOUBLE
  • inbody_score — INT
  • weight_control — DOUBLE
  • fat_control — DOUBLE
  • muscle_control — DOUBLE
  • basal_metabolic_rate — INT
  • visceral_fat_level — INT
  • obesity — INT

Member

  • member_id — BIGINT — 기본 키 — NOT NULL
  • username — VARCHAR(255)
  • email — VARCHAR(255)
  • role — VARCHAR(255)
  • social_platform — VARCHAR(255)
  • height — FLOAT
  • weight — FLOAT
  • age — INT
  • gender — VARCHAR(255)
  • goal — VARCHAR(255)
  • year_of_birth — INT

NutritionIntake

  • nutrition_intake_id — BIGINT — 기본 키 — NOT NULL

PhysicalStats

  • member_id — BIGINT — 외래 키 → Member.member_id — NOT NULL
  • exercise_type — VARCHAR(255)
  • weight — DECIMAL(5,2) — NOT NULL
  • height — DECIMAL(5,2) — NOT NULL

SubscriptionKeys

  • id — BIGINT — 기본 키 — NOT NULL
  • web_push_data_id — BIGINT — 외래 키 → WebPushData.id — NOT NULL
  • key_name — VARCHAR(255)
  • key_value — VARCHAR(255)

WebPushData

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — VARCHAR(255)
  • time — VARCHAR(255)
  • endpoint — VARCHAR(255)
  • expiration_time — BIGINT

매치데이터 (Untitled)

  • member_id — BIGINT — 외래 키 → Member.member_id — NOT NULL
  • id (id2) — BIGINT — 외래 키 → InbodyData.id — NOT NULL