Health Application
Tables (12)
Copy Of Untitled (avg_inbody)
- Field (left_hand) — float
- Field (left_leg) — float
- Field (right_hand) — float
- Field (right_leg) — float
- Field (body) — float
- Field (height) — float
Untitled (Inbody)
- Key (pid) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- avatar_id — varchar(255) — Foreign key → avatar.avatar_id — NOT NULL
- Key (badge_id) — int(20) — Foreign key → avatar.Key — NOT NULL
- Key (group_id) — int(20) — Foreign key → avatar.Key — NOT NULL
- Field (left_hand) — float
- Field (left_leg) — float
- Field (right_hand) — float
- Field (right_leg) — float
- Field (body) — float
Untitled (group)
- Key (group_id) — int(20) — Primary key — NOT NULL
- Field (group_name) — varchar(255) — NOT NULL
- Field (group_winner) — varchar(255) — 내기하는 기능에 사용
- Field (group_info) — text
Untitled (exercise_kind)
- Key (exer_id) — bigint(20) — Primary key — NOT NULL
- Field (exer_kind) — varchar(20) — NOT NULL
- Field (gym_code) — varchar(20)
- Field (exe_weight) — int(20)
- Field (exe_calories) — int(20) — NOT NULL
Untitled (badge)
- Key (badge_id) — int(20) — Primary key — NOT NULL
- Field (badge_name) — varchar(255) — NOT NULL
- Field (badge_info) — text
- Field (bedge_pic) — varchar(255)
- Field (count) — bigint(50) — NOT NULL — 얼마나 많은 사람들이 이 뱃지를 갖고있는지
Untitled (exe_weight)
- Key (weight_id) — int(20) — Primary key — NOT NULL
- Key (exer_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (weight) — int(5) — NOT NULL
Untitled (event)
- Key2 (event_id) — int(4) — Primary key — NOT NULL
- gym_code — varchar(20) — Foreign key → gym.gym_code — NOT NULL
- Field (event_name) — varchar(255) — NOT NULL
- Field (event_text) — text
- Field (event_picture) — varchar(255)
- Field (winner_id) — varchar(255)
Untitled (exercise_process)
- Key (exercise_id) — int(20) — Primary key — NOT NULL
- Key (pid) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Key (exer_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (gym_code) — varchar(20)
- Field (continuous) — int(20) — NOT NULL
- Field (count) — int(20)
- Field (exe_weight) — int(20)
Untitled (person)
- Key (pid) — bigint(20) — Primary key — NOT NULL
- Field (height) — int(4)
- Field (weight) — int(4)
- Field (BMI) — int(4)
- Field (info) — varchar(255)
- Field (expect_effect) — int(4) — 예상 근력치
avatar
- avatar_id — varchar(255) — Primary key — NOT NULL
- Key (badge_id) — int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (group_id) — int(20) — Foreign key → Untitled.Key — NOT NULL
- activity_point — bigint(20) — NOT NULL
- Field2 (picture) — varchar(255)
- Field (badge_cnt) — int(4) — NOT NULL
gym
- gym_code — varchar(20) — Primary key — NOT NULL
- Key (exer_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (gym_name) — varchar(20) — NOT NULL
- Field (admin_name) — varchar(20) — NOT NULL
- Field (member_num) — int(20) — NOT NULL
- Field (Is_Event) — smallint(1) — NOT NULL
user
- id — int(20) — Primary key — NOT NULL
- avatar_id — varchar(255) — Foreign key → avatar.avatar_id — NOT NULL
- Key (pid) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- gym_code — varchar(20) — Foreign key → gym.gym_code — NOT NULL
- Key (exer_id) — bigint(20) — Foreign key → gym.Key — NOT NULL
- Key (badge_id) — int(20) — Foreign key → avatar.Key — NOT NULL
- Key (group_id) — int(20) — Foreign key → avatar.Key — NOT NULL
- Field (phone) — int(12) — NOT NULL
- username (person_name) — varchar(15) — NOT NULL
- Field (autorized) — smallint(1) — NOT NULL — 0: 관리자 1: gym 2: gym 등록자 3: 일반 등록자
- Field (password) — varchar(255) — NOT NULL