health

Tables (11)

category

  • exercise_type — varchar2(30)
  • part — varchar2(30)

check

  • check_date — VARCHAR(255)
  • mbr_id — varchar2(16) — Foreign key → member.mbr_id
  • check_state — VARCHAR(255)
  • check_num — VARCHAR(255)

goal

  • mbr_id — varchar2(16) — Foreign key → member.mbr_id
  • goal_weight — number
  • goal_fatper — number
  • goal_date — date

levelup

  • levelup_success_state — VARCHAR(255)
  • mbr_id — varchar2(16) — Foreign key → member.mbr_id
  • exercise_type2 — varchar2(30) — Foreign key → category.exercise_type
  • levelup_register_state — VARCHAR(255)
  • levelup_date — VARCHAR(255)
  • part — VARCHAR(255)
  • levelup_video — VARCHAR(255)
  • Field — VARCHAR(255)

mbr_point_record

  • point_date — VARCHAR(255)
  • mbr_id — varchar2(16) — Foreign key → member.mbr_id
  • point_value — VARCHAR(255)
  • point_contents — VARCHAR(255)
  • point_kind — VARCHAR(255)

member

  • mbr_id — varchar2(16)
  • mbr_pw — varchar2(16)
  • mbr_nm — varchar2(10)
  • mbr_birth — date
  • mbr_email — varchar2(50)
  • mbr_pw_hint — varchar2(100)
  • mbr_pw_answer — varchar2(100)
  • mbr_photo — VARCHAR(255)
  • goal_register — VARCHAR(255)
  • mbr_join — date
  • admin — VARCHAR(255)
  • secession — VARCHAR(255)

member_state

  • member_state_date — VARCHAR(255) — Primary key — NOT NULL
  • mbr_id — varchar2(16) — Foreign key → member.mbr_id
  • mbr_gender — VARCHAR(255)
  • mbr_age — VARCHAR(255)
  • mbr_height — VARCHAR(255)
  • mbr_weight — VARCHAR(255)
  • member_fatper — VARCHAR(255)
  • average_rank — VARCHAR(255)
  • Field — VARCHAR(255)

point

  • mbr_point — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field — VARCHAR(255)

post

  • post_id — VARCHAR(255) — Primary key — NOT NULL
  • mbr_id — varchar2(16) — Foreign key → member.mbr_id
  • main — VARCHAR(255)
  • sub — VARCHAR(255)
  • title — VARCHAR(255)
  • post_date — VARCHAR(255)
  • post_contents — VARCHAR(255)
  • post_edit_date — VARCHAR(255)
  • answer_state — VARCHAR(255)
  • available — VARCHAR(255)
  • views — VARCHAR(255)
  • Field — VARCHAR(255)

practice_date

  • practice_id — VARCHAR(255) — Primary key — NOT NULL
  • mbr_id — varchar2(16) — Foreign key → member.mbr_id
  • exercise_type — varchar2(30) — Foreign key → category.exercise_type
  • practice_date — VARCHAR(255)
  • part — VARCHAR(255)
  • weight — VARCHAR(255)
  • time — VARCHAR(255)
  • set — VARCHAR(255)

practice_db

  • mbr_id — varchar2(16) — Foreign key → member.mbr_id
  • exercise_type — varchar2(30) — Foreign key → category.exercise_type
  • part — VARCHAR(255)
  • weight — VARCHAR(255)
  • time — VARCHAR(255)
  • set — VARCHAR(255)
  • rank — VARCHAR(255)