health

Tables (9)

ATTENDANCE (Untitled2)

  • userID (회원번호) — numeric(4), pk — Foreign key → USER.userID — NOT NULL
  • checkInTime (입실시간) — datetime
  • checkOutTime (퇴실시간) — datetime
  • houseOfUse (이용시간) — datetime

BBS (CopyOfUntitled)

  • bbsID (게시판번호) — varchar(50), pk — Primary key — NOT NULL
  • bbsTitle (게시판제목) — varchar(50)
  • userID (회원번호) — numeric(4), pk — Foreign key → USER.userID — NOT NULL
  • bbsDate (게시판날짜) — datetime
  • bbsContent (게시판내용) — varchar(2048)
  • bbsCheck (조회수) — numeric(4)

EXERCISE (Untitled4)

  • exID (운동번호) — varchar(5) — Primary key — NOT NULL
  • exPart (운동부위) — varchar(10)
  • exName (운동이름) — varchar(20)
  • toolUse (기구사용여부) — boolean

INBODY (Untitled)

  • userID (회원번호) — numeric(4), pk — Foreign key → USER.userID — NOT NULL
  • userGender (성별) — varchar(10)
  • userBirthDate (생년월일) — date
  • inbodyDate (날짜) — datetime
  • height (키) — numeric(3, 2)
  • weight (몸무게) — numeric(3, 2)
  • skeletalMuscleMass (골격근량) — numeric(3, 1)
  • bodyFatMass (체지방량) — numeric(3, 1)
  • bodyWater (체수분) — numeric(2, 1)
  • protein (단백질) — numeric(2, 1)
  • muscleMass (근육량) — numeric(2, 1)
  • leanBodyMass (제지방량) — numeric(2, 1)
  • minerals (무기질) — numeric(2, 1)
  • BMI — numeric(3, 1)
  • waistHipRatio (복부지방률) — numeric(3, 1)
  • BMR (기초대사량) — numeric(3, 1)
  • bodyShape (체형) — varchar(20)

MEMBERSHIP (Untitled5)

  • userID (회원번호) — numeric(4), pk — Foreign key → USER.userID — NOT NULL
  • membershipType (회원권종류) — varchar(10)
  • membershipDate (회원권기간) — datetime
  • membershipPrice (회원권가격) — varchar(20)

PT (Untitled6)

  • userID (회원번호) — numeric(4), pk — Foreign key → USER.userID — NOT NULL
  • ptCode (PT코드) — numeric(4)
  • ptDate (PT기간) — date
  • trainerID (트레이너번호) — numeric(4)
  • ptTime (PT요일) — varchar(10)
  • ptPrice (PT가격) — varchar(20)

TRAINER (Untitled7)

  • trainerID (트레이너번호) — numeric(4), pk — Primary key — NOT NULL
  • trainerName (트레이너이름) — varchar(20)
  • trainerGender (성별) — varchar(10)
  • trainerEmail (이메일) — varchar(40)
  • trainerPhone (전화번호) — varchar(11)
  • trainerBirth (생년월일) — date

USER (Main)

  • userID (회원번호) — numeric(4), pk — Primary key — NOT NULL
  • userPW (비밀번호) — varchar(20)
  • userName (이름) — varchar(20)
  • userGender (성별) — varchar(10)
  • userEmail (이메일) — varchar(40)
  • userPhone (전화번호) — varchar(11)
  • userBirth (생년월일) — date
  • Authority (사용자 권한) — boolean
  • userMembership (회원권여부) — boolean

USERRECORD (Untitled3)

  • exID (운동번호) — varchar(5) — Foreign key → EXERCISE.exID — NOT NULL
  • userID (회원번호) — numeric(4), pk — Foreign key → USER.userID — NOT NULL
  • toolWeght (중량) — varchar(5)
  • exNum (횟수) — number
  • recoEx (추천운동) — varchar(50)