헬린이케어

테이블 (16)

category

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

check

  • check_date — VARCHAR(255)
  • mbr_id — varchar2(16) — 외래 키 → member.mbr_id
  • check_state — VARCHAR(255)
  • check_num — VARCHAR(255)

goal

  • mbr_id — varchar2(16) — 외래 키 → member.mbr_id
  • goal_weight — number
  • goal_fatper — number
  • goal_date — date

levelup

  • levelup_success_state — VARCHAR(255)
  • mbr_id — varchar2(16) — 외래 키 → member.mbr_id
  • exercise_type2 — varchar2(30) — 외래 키 → 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) — 외래 키 → 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) — 기본 키 — NOT NULL
  • mbr_id — varchar2(16) — 외래 키 → 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) — 기본 키 — NOT NULL
  • mbr_id — varchar2(16) — 외래 키 → 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) — 기본 키 — NOT NULL
  • mbr_id — varchar2(16) — 외래 키 → member.mbr_id
  • exercise_type — varchar2(30) — 외래 키 → 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) — 외래 키 → member.mbr_id
  • exercise_type — varchar2(30) — 외래 키 → category.exercise_type
  • part — VARCHAR(255)
  • weight — VARCHAR(255)
  • time — VARCHAR(255)
  • set — VARCHAR(255)
  • rank — VARCHAR(255)

권한 (CopyOfUntitled3)

  • 권한 (member_authority) — number — 기본 키
  • 권한명 (authonity_name) — varchar(10)
  • 권한설명 (authonity_explanation) — varchar(100)

사용자 (Untitled)

  • 사용자 아이디 (member_id) — varchar(15) — 기본 키 — NOT NULL
  • 역할코드 (member_role) — number — 외래 키 → 사용자 역할.역할코드 — NOT NULL
  • 비밀번호 (member_pw) — varchar(12)
  • 비밀번호 힌트 (member_hin) — varchar(15)
  • 비밀번호 정답 (member_su) — varchar(10)
  • 이메일 (member_em) — varchar(30)
  • 닉네임 (member_na) — varchar(20)
  • 사용자 상태 (member_login) — number — NOT NULL
  • 이메일 수신여부 (member_email) — number
  • 성별 (member_sex) — number
  • 생년월일 (member_br) — number

사용자 역할 (CopyOfUntitled)

  • 역할코드 (member_role) — number — 외래 키 → 역할.역할코드

역할 (CopyOfCopyOfUntitled)

  • 역할코드 (member_role) — number — 기본 키
  • 역할명 (role_name) — varchar(10)

역할별권한 (CopyOfCopyOfCopyOfUntitled)

  • 역할코드 (member_role) — number — 외래 키 → 역할.역할코드
  • 권한 (member_authority) — number — 외래 키 → 권한.권한