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)