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