바디키_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