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