바디키_220926
테이블 (50)
APP_apns_devices_TBL
- pid — int — 기본 키 — NOT NULL
- clientid — nvarchar(50)
- appname — nvarchar(50) — NOT NULL
- appversion — nvarchar(50)
- deviceuid — nchar(40) — NOT NULL
- devicetoken — nvarchar(255) — NOT NULL
- devicename — nvarchar(255)
- devicemodel — nvarchar(100)
- deviceversion — nvarchar(25)
- pushbadge — nvarchar(8)
- pushalert — nvarchar(8)
- pushsound — nvarchar(8)
- development — nvarchar(8)
- status — nvarchar(10)
- created — datetime
- modified — datetime
- ostype — nvarchar(8)
- osLanguage — nvarchar(50)
- appLanguage — nvarchar(10)
- pushVersion — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
AccountInfo
- AccountID — nvarchar(50) — 기본 키 — NOT NULL
- AccountPW — varbinary(100) — NOT NULL
- Authority — nvarchar(20)
- Region — nvarchar(20)
- EditAuthority — nvarchar(10)
- LoginFailCount — int
- LoginFailDate — datetime
- Department — nvarchar(20)
- Email — nvarchar(100)
- LoginDatetime — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
AccountInfo_Dormant
- AccountID — nvarchar(100) — 기본 키 — NOT NULL
- LastLoginDate — datetime
- DormantNotiDate — datetime
- DeleteDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Activity_DrinkWater
- UID — nvarchar(50) — 기본 키 — NOT NULL
- Date — date — 기본 키 — NOT NULL
- DrinkCount — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Activity_Exercise
- ExerciseID — int — 기본 키 — NOT NULL
- UID — nvarchar(50) — NOT NULL
- Date — date — NOT NULL
- ExerciseCode — nvarchar(20) — NOT NULL
- ExerciseTime — nvarchar(20) — NOT NULL
- ExerciseImage — nvarchar(4000)
- RegDate — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Activity_ExerciseCode
- ExerciseCode — nvarchar(20) — 기본 키 — NOT NULL
- ExerciseName — nvarchar(50) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Activity_Food
- UID — nvarchar(50) — 기본 키 — NOT NULL
- Date — date — 기본 키 — NOT NULL
- MealTime — nvarchar(2) — 기본 키 — NOT NULL
- FoodImage — nvarchar(200)
- FoodThumbnail — nvarchar(200)
- Emoticon — nvarchar(20)
- TimeText — nvarchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Activity_Protein
- UID — nvarchar(50) — 기본 키 — NOT NULL
- Date — date — 기본 키 — NOT NULL
- MealTime — nvarchar(2) — 기본 키 — NOT NULL
- Emoticon — nvarchar(2) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Activity_Step
- UID — nvarchar(50) — 기본 키 — NOT NULL
- Date — date — 기본 키 — NOT NULL
- Hour — nvarchar(2) — 기본 키 — NOT NULL
- Step — int — NOT NULL
- RegDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Activity_TodayTip
- UID — nvarchar(50) — 기본 키 — NOT NULL
- Date — nchar(10) — 기본 키 — NOT NULL
- TipID — int — 기본 키 — NOT NULL
- IsAchived — bit — NOT NULL
- CreateDate — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
AmwayEquipSerial
- EquipSerial — nvarchar(20) — 기본 키 — NOT NULL
- CenterName — nvarchar(50) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Announcement
- ID — int — 기본 키 — NOT NULL
- Category — nvarchar(50)
- Title — nvarchar(200) — NOT NULL
- Contents — nvarchar(4000)
- IsTopFix — bit
- RegDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
AppVersion
- OS_Type — nvarchar(20) — 기본 키 — NOT NULL
- LastVer — nvarchar(20)
- AppID — nvarchar(50)
- IsForceUpdate — bit
- IsUseAppleID — bit
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BCA_TBL
- UID_DATETIMES — nvarchar(200) — 기본 키 — NOT NULL
- DATETIMES — nvarchar(50) — NOT NULL
- UID — nvarchar(50) — 외래 키 — NOT NULL
- USER_ID — nvarchar(50)
- WT — real
- ICW — real
- ICW_MIN — real
- ICW_MAX — real
- IICW — real
- ECW — real
- ECW_MIN — real
- ECW_MAX — real
- IECW — real
- TBW — real
- TBW_MIN — real
- TBW_MAX — real
- ITBW — real
- PROTEIN — real
- PROTEIN_MIN — real
- PROTEIN_MAX — real
- IPROTEIN — real
- MINERAL — real
- MINERAL_MIN — real
- MINERAL_MAX — real
- IMINERAL — real
- BFM — real
- BFM_MIN — real
- BFM_MAX — real
- IBFM — real
- SLM — real
- SLM_MIN — real
- SLM_MAX — real
- FFM — real
- FFM_MIN — real
- FFM_MAX — real
- EQUIP — nvarchar(50)
- UNIT — real
- IBSynk — bit
- ReadGraph — bit
- EQUIP_SERIAL — nvarchar(50)
- RAW_Data — nvarchar(max)
- CID — nvarchar(50)
- DIGITAL_VERSION — nvarchar(50)
- ICWRA — real
- ICWLA — real
- ICWTR — real
- ICWRL — real
- ICWLL — real
- ECWRA — real
- ECWLA — real
- ECWTR — real
- ECWRL — real
- ECWLL — real
- IICWRA — real
- IICWTR — real
- IICWRL — real
- IECWRA — real
- IECWTR — real
- IECWRL — real
- PLEAN — real
- … +56
BannerInfo
- RewardImageURL — nvarchar(500)
- RewardBannerView — bit — NOT NULL
- RewardBannerLink — nvarchar(1000)
- EventImageURL — nvarchar(500)
- EventBannerView — bit — NOT NULL
- EventBannerLink — nvarchar(1000)
- EventBannerStartDate — date
- EventBannerEndDate — date
- LiveGXImageURL — nvarchar(500)
- LiveGXBannerView — bit
- LiveGXBannerLink — nvarchar(1000)
BasalMedical_CardiacData
- UID — nvarchar(100) — 기본 키 — NOT NULL
- Date — date — 기본 키 — NOT NULL
- Hour — int — 기본 키 — NOT NULL
- HRM — int
- EquipSerial — nvarchar(20)
- ServerSyncDatetime — datetime — NOT NULL
- HRMData — nvarchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BasalMedical_CardiacStandardRange
- Gender — nvarchar(1) — 기본 키 — NOT NULL
- AGE_MIN — int — 기본 키 — NOT NULL
- AGE_MAX — int — 기본 키 — NOT NULL
- AvgRange — nvarchar(20) — NOT NULL
- TotalRange — nvarchar(20) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BasalMedical_StressData
- UID — nvarchar(100) — 기본 키 — NOT NULL
- Date — date — 기본 키 — NOT NULL
- Hour — int — 기본 키 — NOT NULL
- VFL — real
- HF — real
- LF — real
- SDNN — real
- RMSSD — real
- MEANBPM — real
- EquipSerial — nvarchar(20)
- ServerSyncDatetime — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Board
- BoardID — int — 기본 키 — NOT NULL
- Type — nvarchar(20) — NOT NULL
- Category — nvarchar(20) — NOT NULL
- Requestor — nvarchar(20) — NOT NULL
- Title — nvarchar(200) — NOT NULL
- Contents — nvarchar(max)
- Status — nvarchar(20)
- RegDate — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BoardComment
- CommentID — int — 기본 키 — NOT NULL
- BoardID — int — NOT NULL
- Comment — nvarchar(4000) — NOT NULL — varchar(4000) NOT NUL
- AccountID — nvarchar(50) — NOT NULL
- FileURL — nvarchar(500)
- RegDate — datetime — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
BodyType
- BodyTypeID — int — 기본 키 — NOT NULL
- BodyTypeName — nvarchar(20) — NOT NULL
- BodyTypeCode — nvarchar(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CouponInfo
- Coupon — nvarchar(20) — 기본 키 — NOT NULL
- ProgramID — int
- CouponType — nvarchar(20) — NOT NULL
- CreateDate — datetime — NOT NULL
- ExpireDate — date — NOT NULL
- UseDate — datetime
- Status — nvarchar(20) — NOT NULL
- UID — nvarchar(50)
- Code — nvarchar(20) — NOT NULL
- IsReissue — bit
- ReissueUser — nvarchar(50)
- ReissueAccount — nvarchar(50)
- ReissueDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
ED_TBL
- UID_DATETIMES — nvarchar(200) — 외래 키 → BCA_TBL.UID_DATETIMES — NOT NULL
- DATETIMES — nvarchar(50) — NOT NULL
- FED — real
- WED — real
- FEDRA — real
- FEDLA — real
- FEDT — real
- FEDRL — real
- FEDLL — real
- WEDRA — real
- WEDLA — real
- WEDT — real
- WEDLL — real
- WEDRL — real
- NECK — real
- CHEST — real
- ABD — real
- HIP — real
- ACR — real
- ACL — real
- THIGHR — real
- THIGHL — real
- AMC — real
- COFRA — real
- CORCOFLA — real
- CORCALF — real
- COLCALF — real
- CCHEST — real
- CABD — real
- CACR — real
- CACL — real
- CTHIGHR — real
- CTHIGHL — real
- FCHEST — real
- FABD — real
- FACR — real
- FACL — real
- FTHIGHR — real
- FTHIGHL — real
- ICCHEST — real
- ICABD — real
- ICACR — real
- ICACL — real
- ICTHIGHR — real
- ICTHIGHL — real
- IFCHEST — real
- IFABD — real
- IFACR — real
- IFACL — real
- IFTHIGHR — real
- IFTHIGHL — real
- INECK — real
- ICHEST — real
- IABD — real
- IHIP — real
- IACR — real
- IACL — real
- ITHIGHR — real
- ITHIGHL — real
- DCCHEST — real
- … +30
ExercisePlan
- ExercisePlan — nvarchar(20) — 기본 키 — NOT NULL
- ExercisePlanName — nvarchar(50) — NOT NULL
- ExercisePlanDescription — nvarchar(2000) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
ExerciseVideo
- VideoID — int — 기본 키 — NOT NULL
- ProgramKind — nvarchar(20) — NOT NULL
- Gender — nvarchar(20) — NOT NULL
- BodyTypeID — int — NOT NULL
- Day — int — NOT NULL
- ThumbnailURL — nvarchar(500)
- VideoURL — nvarchar(500)
- Title — nvarchar(50)
- Contents — nvarchar(1000)
- Preparation — nvarchar(50)
- PlayingTime — nvarchar(20)
- PlayingSecond — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
ExerciseVideo_BodyKeyM
- VideoID — int — 기본 키 — NOT NULL
- ExercisePlan — nvarchar(20) — NOT NULL
- ExercisePart — nvarchar(20)
- Week — int — NOT NULL
- DW — int — NOT NULL
- ThumbnailURL — nvarchar(500) — NOT NULL
- VideoURL — nvarchar(500) — NOT NULL
- Title — nvarchar(50) — NOT NULL
- Preparation — nvarchar(50)
- PlayingTime — nvarchar(20)
- PlayingSecond — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Exercise_ActivityData
- UID — nvarchar(100) — 기본 키 — NOT NULL
- Year — nvarchar(5) — 기본 키 — NOT NULL
- Month — nvarchar(5) — 기본 키 — NOT NULL
- Day — nvarchar(5) — 기본 키 — NOT NULL
- Time — nvarchar(10) — 기본 키 — NOT NULL
- Minute — nvarchar(10) — 기본 키 — NOT NULL
- Week — nvarchar(5)
- DayofWeek — nvarchar(5)
- Walk — real
- Run — real
- WalkTime — real
- RunTime — real
- WalkKcal — real
- RunKcal — real
- WalkDistance — real
- RunDistance — real
- ModifyDate — datetime
- SyncDatetime — datetime
- ServerSyncDatetime — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
FAQ
- ID — int — 기본 키 — NOT NULL
- FAQ_Type — nvarchar(20) — NOT NULL
- Title — nvarchar(50) — NOT NULL
- Contents — nvarchar(max) — NOT NULL
- RegDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
IMP_TBL
- UID_DATETIMES — nvarchar(200) — 외래 키 → BCA_TBL.UID_DATETIMES — NOT NULL
- DATETIMES — nvarchar(50) — NOT NULL
- IRA1 — real
- ILA1 — real
- IT1 — real
- IRL1 — real
- ILL1 — real
- IRA5 — real
- ILA5 — real
- IT5 — real
- IRL5 — real
- ILL5 — real
- IRA50 — real
- ILA50 — real
- IT50 — real
- IRL50 — real
- ILL50 — real
- IRA250 — real
- ILA250 — real
- IT250 — real
- IRL250 — real
- ILL250 — real
- IRA500 — real
- ILA500 — real
- IT500 — real
- IRL500 — real
- ILL500 — real
- IRA1M — real
- ILA1M — real
- IT1M — real
- IRL1M — real
- ILL1M — real
- xra5 — real
- xla5 — real
- xtr5 — real
- xrl5 — real
- xll5 — real
- xra50 — real
- xla50 — real
- xtr50 — real
- xrl50 — real
- xll50 — real
- xra250 — real
- xla250 — real
- xtr250 — real
- xrl250 — real
- xll250 — real
- IRA20 — real
- ILA20 — real
- IT20 — real
- IRL20 — real
- ILL20 — real
- IRA100 — real
- ILA100 — real
- IT100 — real
- IRL100 — real
- ILL100 — real
- RERA5 — real
- RELA5 — real
- RET5 — real
- … +78
InBodyBAND_FirmwareInfo
- ProgramName — nvarchar(50) — 기본 키 — NOT NULL
- Language — nvarchar(20) — 기본 키 — NOT NULL
- IsEssentialUpdate — bit
- CurrentVersion — nvarchar(20)
- FileURL_Firmware — nvarchar(200)
- FileURL_Image — nvarchar(200)
- FileURL_Language — nvarchar(200)
- FileURL_Font — nvarchar(200)
- FileURL_Touch — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
InBodyData_Goal
- UID — nvarchar(50) — 기본 키 — NOT NULL
- ProgramID — int — 기본 키 — NOT NULL
- GoalCode — nvarchar(10)
- Datetimes — nvarchar(20)
- Gender — nvarchar(2)
- Age — real
- Height — real
- WT — real
- FFM — real
- SMM — real
- BFM — real
- BMI — real
- PBF — real
- WED — real
- PWT — real
- PSMM — real
- PFATNEW — real
- BMR — real
- WT_Goal — real
- SMM_Goal — real
- BFM_Goal — real
- BMI_Goal — real
- PBF_Goal — real
- PWT_Goal — real
- PSMM_Goal — real
- PFATNEW_Goal — real
- FFM_Goal — real
- DiffWT — real
- DiffSMM — real
- DiffBFM — real
- DiffPBF — real
- DiffFFM — real
- CreateDatetimeUTC — datetime
- UpdateDatetimeUTC — datetime
- ChallengeDay — int
- BodyTypeID — int
- IsTutorialPopup — bit
- ResetAccountID — nvarchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
InBodyData_ManualInput
- UID_DATETIMES — nvarchar(50) — 기본 키 — NOT NULL
- UID — nvarchar(50) — NOT NULL
- Datetimes — nvarchar(20) — NOT NULL
- WT — real
- PBF — real
- BFM — real
- SMM — real
- CreateDate — datetime — NOT NULL
- IsDeleted — bit
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
LB_TBL
- UID_DATETIMES — nvarchar(200) — 외래 키 → BCA_TBL.UID_DATETIMES — NOT NULL
- DATETIMES — nvarchar(50) — NOT NULL
- LRA — real
- PLRA — real
- PILRA — real
- LLA — real
- PLLA — real
- PILLA — real
- LT — real
- PLT — real
- PILT — real
- LRL — real
- PLRL — real
- PILRL — real
- LLL — real
- PLLL — real
- PILLL — real
- PWLA — real
- PWLL — real
- DIFFARM — real
- DIFFLEG — real
- DIFFHI — real
- VFALEG — real
- FRA — real
- FLA — real
- FT — real
- FRL — real
- FLL — real
- PFRA — real
- PFLA — real
- PFT — real
- PFRL — real
- PFLL — real
- PBFRA — real
- PBFLA — real
- PBFT — real
- PBFRL — real
- PBFLL — real
- PBFIRA — real
- PBFILA — real
- PBFIT — real
- PBFIRL — real
- PBFILL — real
- WWRA — real
- WWLA — real
- WWT — real
- WWRL — real
- WWLL — real
- IWRA — real
- IWTR — real
- IWRL — real
- ILRA — real
- ILT — real
- ILRL — real
- PINWRA — real
- PINWLA — real
- PINWT — real
- PINWRL — real
- PINWLL — real
- AlgleRA5 — real
- … +100
MFA_TBL
- UID_DATETIMES — nvarchar(200) — 외래 키 → BCA_TBL.UID_DATETIMES — NOT NULL
- DATETIMES — nvarchar(50) — NOT NULL
- PWT — real — NOT NULL
- WT_MIN — real
- WT_MAX — real
- IWT — real
- SMM — real
- PSMM — real
- SMM_MIN — real
- SMM_MAX — real
- ISMM — real
- PBFM — real
- PBFM_MIN — real
- PBFM_MAX — real
- BMI — real
- BMI_MIN — real
- BMI_MAX — real
- IBMI — real
- PBF — real
- PBF_MIN — real
- PBF_MAX — real
- IPBF — real
- WHR — real
- WHR_MIN — real
- WHR_MAX — real
- IWHR — real
- PFAT — real
- PFATNEW — real
- PMINERAL — real
- PPROTEIN — real
- PTBW — real
- PFFM — real
- ISLM — real
- IFFM — real
- PICW — real
- PECW — real
- BMI_MAX2 — real
- IBMI2 — real
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MissionInfo
- MissionID — int — 기본 키 — NOT NULL
- ProgramKind — nvarchar(50)
- MissionName — nvarchar(50)
- MissionType — nvarchar(20)
- WeekType — nvarchar(20)
- StartTime — time(7)
- EndTime — time(7)
- DW — nvarchar(20)
- Link — nvarchar(500)
- GainKey — int
- Times — int
- GainKeyText — nvarchar(200)
- MissionTitle — nvarchar(500)
- MissionSubTitle — nvarchar(500)
- MissionSubTitle2 — nvarchar(500)
- GX_Time — nvarchar(50)
- GX_Exercise — nvarchar(50)
- IsSpecialMission — bit
- IsGeneralMission — bit
- MissionGoal — int
- Sort — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MissionInfoText
- MissionID — int — 기본 키 — NOT NULL
- IsAchieved — bit — 기본 키 — NOT NULL
- IsGainKey — bit — 기본 키 — NOT NULL
- MissionTitle — nvarchar(200)
- MissionTitle_M — nvarchar(200)
- MissionSubTitle — nvarchar(200)
- MissionSubTitle2 — nvarchar(200)
- Gx_Time — nvarchar(50)
- GX_Exercise — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MotivationInfo
- MotivationID — int — 기본 키 — NOT NULL
- MotivationType — nvarchar(20) — NOT NULL
- GainKey — int — NOT NULL
- TextTypeRandSeed — varbinary(max)
- TextTypeMAX — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
NotiMessage
- Mode — nvarchar(20) — NOT NULL
- DayWeek — nvarchar(20) — NOT NULL
- NotiTime — nvarchar(20) — NOT NULL
- Minute — int
- NotiMessage — nvarchar(500) — NOT NULL
- RegDate — datetime
- IsSpecialMission — bit
NotiMessagePush
- Type — nvarchar(50) — 기본 키 — NOT NULL
- DW — int — 기본 키 — NOT NULL
- Message — nvarchar(500) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Notice
- NoticeID — int — 기본 키 — NOT NULL
- NoticeType — nvarchar(20)
- UID — nvarchar(50) — NOT NULL
- SenderUID — nvarchar(50) — NOT NULL
- Title — nvarchar(200)
- Message — nvarchar(1000) — NOT NULL
- IsDeleted — bit — NOT NULL
- NoticeDate — datetime — NOT NULL
- IsRead — bit — NOT NULL
- LandingCode — nvarchar(50)
- Link — nvarchar(500)
- IsPush — bit
- IsTop — bit
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
ProgramInfo
- ProgramID — int — 기본 키 — NOT NULL
- ProgramKind — nvarchar(20)
- ProgramTitle — nvarchar(200) — NOT NULL
- RegStartDate — nvarchar(10)
- RegEndDate — nvarchar(10)
- FirstInBodyStartDate — nvarchar(10)
- FirstInBodyEndDate — nvarchar(10)
- ProgramStartDate — nvarchar(10)
- ProgramEndDate — nvarchar(10)
- LastInBodyStartDate — nvarchar(10)
- LastInBodyEndDate — nvarchar(10)
- RegDate — datetime — NOT NULL
- ProgramStatus — nvarchar(20) — NOT NULL
- RewardURL — nvarchar(500)
- IsVoucherPopup — bit
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
ReservationBanner
- BannerType — nvarchar(50) — 기본 키 — NOT NULL
- BannerName — nvarchar(50) — NOT NULL
- StartDate — datetime
- EndDate — datetime
- Link — nvarchar(500)
- BannerImageURL — nvarchar(500)
- RegDate — datetime
- Sort — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
RewardInfo
- RewardType — nvarchar(20) — 기본 키 — NOT NULL
- Voucher — int
- Link — nvarchar(200)
- RewardText — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SchedulePushMessage
- PushID — int — 기본 키 — NOT NULL
- Title — nvarchar(50)
- Message — nvarchar(200)
- Ticker — nvarchar(10)
- GroupUID — nvarchar(4000)
- GroupName — nvarchar(100)
- ScheduleTime — datetime — NOT NULL
- AccountID — nvarchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Sleep_SleepData
- SN — int — 기본 키 — NOT NULL
- UID — nvarchar(100) — NOT NULL
- Year — nvarchar(5) — NOT NULL
- Month — nvarchar(3) — NOT NULL
- Day — nvarchar(3) — NOT NULL
- Week — nvarchar(5) — NOT NULL
- DayofWeek — nvarchar(2) — NOT NULL
- EventTime — nvarchar(10) — NOT NULL
- EventDuration — int — NOT NULL
- EventType — nvarchar(10) — NOT NULL
- ModifyDate — datetime
- SyncDatetime — datetime
- ServerSyncDatetime — datetime
- IDX — nvarchar(20)
- Diff — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Terms
- ID — int — 기본 키 — NOT NULL
- TermsKind — nvarchar(50) — NOT NULL
- Version — nvarchar(20) — NOT NULL
- Contents — nvarchar(max)
- RegDate — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TermsInfo
- TermsKind — nvarchar(50) — 기본 키 — NOT NULL
- Sort — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TimeBanner
- BannerID — int — 기본 키 — NOT NULL
- BannerType — nvarchar(20) — NOT NULL
- BannerText — nvarchar(500) — NOT NULL
- IsProgramMode — bit
- TimeText — nvarchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
TodayTip
- TipID — int — 기본 키 — NOT NULL
- TipName — nvarchar(50) — NOT NULL
- GoalKey — int — NOT NULL
- Link — nvarchar(500)
- TipType — nvarchar(20)
- Day — int
- ProgramKind — nvarchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
WC_TBL
- UID_DATETIMES — nvarchar(200) — 기본 키 — NOT NULL
- DATETIMES — nvarchar(50) — NOT NULL
- TW — real
- WC — real
- FC — real
- MC — real
- FS — real
- VFA — real
- HT — real
- AGE — real
- SEX — nvarchar(10)
- IHT — real
- OBESITY — real
- BMC — real
- BMR — real
- BCM — real
- IBCM — real
- IBMC — real
- BSD — real
- BD — real
- OD_MIN — real
- OD_MAX — real
- BCM_MIN — real
- BCM_MAX — real
- BMR_MIN — real
- BMR_MAX — real
- BMC_MIN — real
- BMC_MAX — real
- RBMR — real
- BcaMent — ntext
- BalMent — ntext
- HWMent — ntext
- ODK — real
- TOT_SCORE — real
- DM — real
- ETYPE1 — nvarchar(50)
- ETYPE2 — nvarchar(50)
- ETYPE3 — nvarchar(50)
- FSRank — real
- VFALevel — real
- MScore — real — NOT NULL
- HScore — real — NOT NULL
- SScore — real — NOT NULL
- flag — real — NOT NULL
- MScorePrev — real — NOT NULL
- HScorePrev — real — NOT NULL
- SScorePrev — real — NOT NULL
- HScoreNew — real — NOT NULL
- DW — real
- ResultChild — bit — NOT NULL
- RENERGY — real
- SMI_TS — real
- SMI_ZS — real
- SMIB — real
- SMIB_TS — real
- SMIB_ZS — real
- SMIW — real
- SMIW_TS — real
- SMIW_ZS — real
- ECW_TS — real
- … +80