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)