nb3

Tables (532)

Bd_AccessTerms

  • TermsIdx — int — Primary key — NOT NULL
  • Title — nvarchar(100) — NOT NULL
  • Contents — nvarchar(max) — NOT NULL
  • EnforcementDate — datetime — NOT NULL
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_AdminNotice

  • ANoIdx — int — Primary key — NOT NULL
  • Title — nvarchar(200) — NOT NULL
  • Contents — nvarchar(max) — NOT NULL
  • PopSDate — datetime
  • PopEDate — datetime
  • FileIdx1 — int
  • FileIdx2 — int
  • FileIdx3 — int
  • ImportantYn — char(1) — NOT NULL
  • DispYn — char(1)
  • UseYn — char(1)
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_AdminNoticePopUnread

  • ANoIdx — int — Primary key — NOT NULL
  • AdminIdx — int — Primary key — NOT NULL
  • UseYn — varchar(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_Answer

  • AnsIdx — int — Primary key — NOT NULL
  • QIdx — int — NOT NULL
  • AnswerName — nvarchar(100) — NOT NULL
  • AnswerContents — nvarchar(max)
  • AnswerCode — int
  • Type — nchar(10)
  • Chanel — nchar(10)
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_AreaCode

  • AreaCode — char(2) — NOT NULL
  • AreaName — varchar(20) — NOT NULL
  • DispSeq — int — NOT NULL
  • DispAreaName — varchar(30)
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL

Bd_BenefitCard

  • BenefitIdx — int — Primary key — NOT NULL
  • MonthType — char(2) — NOT NULL
  • BenefitType — nvarchar(50)
  • CardName — nvarchar(50)
  • BaseInfo — nvarchar(200)
  • AddInfo — nvarchar(200)
  • FileIdx — int
  • UseYn — char(1)
  • InsNo — int
  • InsDate — datetime
  • UptNo — int
  • UptDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_BenefitCardPopImg

  • PopImgIdx — int — Primary key — NOT NULL
  • MonthType — char(2)
  • PcFileIdx — int
  • MoFileIdx — int
  • InsNo — int
  • InsDate — datetime
  • UptNo — int
  • UptDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_CodeDtl

  • Code — int — Primary key — NOT NULL
  • CodeNm — nvarchar(50) — NOT NULL
  • UpCode — int — NOT NULL
  • GrpCode — int — NOT NULL
  • Depth — char(1) — NOT NULL
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — date — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — date — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_CollectionComment

  • CmIdx — int — Primary key — NOT NULL
  • CollectionIdx — int — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • WebID — nvarchar(50) — NOT NULL
  • CustName — nvarchar(200) — NOT NULL
  • Content — nvarchar(max) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int
  • InsDate — datetime
  • UptNo — int
  • UptDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_Event

  • EvIdx — int — Primary key — NOT NULL
  • EvTitle — nvarchar(200) — NOT NULL
  • PCContents — nvarchar(max)
  • MobileContents — nvarchar(max)
  • EvFileIdx — int
  • SDate — datetime — NOT NULL
  • EDate — datetime — NOT NULL
  • ReplyYn — char(1) — NOT NULL
  • WinnerYn — char(1) — NOT NULL
  • EvDispYn — char(1) — NOT NULL
  • SNSImgFileIdx — int
  • SNSTitle — nvarchar(100)
  • SNSDesc — nvarchar(100)
  • ViewCnt — int — NOT NULL
  • UseYn — char(1)
  • InsNo — int
  • InsDate — datetime
  • UptNo — int
  • UptDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_EventReply

  • EvRIdx — int — Primary key — NOT NULL
  • EvIdx — int — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • WebID — nvarchar(50) — NOT NULL
  • CustName — nvarchar(200) — NOT NULL
  • ReplyContent — nvarchar(max) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int
  • InsDate — datetime
  • UptNo — int
  • UptDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_EventWinner

  • EvWinIdx — int — Primary key — NOT NULL
  • EvIdx — int
  • WinTitle — nvarchar(200) — NOT NULL
  • WinPcContents — nvarchar(max) — NOT NULL
  • WinMobileContents — nvarchar(max) — NOT NULL
  • WinDispDate — datetime
  • WinFileIdx — int
  • WinViewCnt — int
  • WinDispYn — char(1) — NOT NULL
  • InsNo — int
  • InsDate — datetime
  • UptNo — int
  • UptDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_EventWinnerList

  • WinIdx — int — Primary key — NOT NULL
  • EvWinIdx — int
  • EvIdx — int — NOT NULL
  • CustNo — nchar(16)
  • WebID — nvarchar(50)
  • CustName — nvarchar(200) — NOT NULL
  • ParticipantType — nvarchar(10) — NOT NULL
  • UseYn — char(1)
  • InsNo — int
  • InsDate — datetime
  • UptNo — int
  • UptDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_FAQ

  • FaqIdx — int — Primary key — NOT NULL
  • Title — nvarchar(200) — NOT NULL
  • TypeIdx — int — NOT NULL
  • Contents — nvarchar(max) — NOT NULL
  • DispYn — char(1) — NOT NULL
  • FileIdx01 — int
  • FileIdx02 — int
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_FAQType

  • TypeIdx — int — Primary key — NOT NULL
  • TypeName — nvarchar(200) — NOT NULL
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_LookShop

  • LookShopIdx — int — Primary key — NOT NULL
  • Title — nvarchar(200) — NOT NULL
  • Contents — nvarchar(max)
  • ContentImgType — char(1)
  • viewCnt — int
  • dispSeq — int
  • mainYn — char(1)
  • LSContentFileIdx — int
  • LSThumFileIdx — int
  • MainBGColor — nvarchar(10)
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1)
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • ContentsForMobile — nvarchar(max)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_LunchingCalendar

  • LunchingCalendarIdx — int — Primary key — NOT NULL
  • LunchType — char(1) — NOT NULL
  • BrandCode — char(2) — NOT NULL
  • StyleCode — nvarchar(18)
  • colCode — nvarchar(3)
  • CollectionIdx — int
  • RaffleIdx — int
  • CategoryType — int
  • ProdDesc — nvarchar(200)
  • Contents — nvarchar(max)
  • MovieFileIdx — int
  • ThumbnailFileIdx — int
  • DetailPcImgIdx — int
  • DetailMoImgIdx — int
  • NowPcImgIdx — int
  • NowMoImgIdx — int
  • SlideImg1Idx — int
  • SlideImg2Idx — int
  • SlideImg3Idx — int
  • SlideImg4Idx — int
  • SlideImg5Idx — int
  • SlideImg6Idx — int
  • LunchDate — datetime — NOT NULL
  • DispDate — datetime — NOT NULL
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • MyNBYn — char(1) — NOT NULL
  • ApplicationCnt — int — NOT NULL
  • OgMetaImgIdx — int
  • OgMetaTitle — nvarchar(50)
  • OgMetaDesc — nvarchar(100)
  • InsNo — int
  • InsDate — datetime
  • UptNo — int
  • UptDate — datetime
  • StoreType — int
  • OfflineStoreList — nvarchar(max) — NOT NULL
  • MileageCouponDesc — nvarchar(200)
  • BuyLimitDesc — nvarchar(200)
  • OfflineAllStoreYn — char(1) — NOT NULL
  • OnlineAllStoreYn — char(1) — NOT NULL
  • AddContents — nvarchar(max)
  • NoticeContents — nvarchar(max)
  • MovieLink — nvarchar(200)
  • ReleaseStoreList — nvarchar(max)
  • NewContents — nvarchar(max)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_LunchingCalendarProdInfo

  • LCProdInfoIdx — int — Primary key — NOT NULL
  • LunchingCalendarIdx — int — NOT NULL
  • ProdName — nvarchar(200)
  • ProdPrice — int
  • DispSeq — int — NOT NULL
  • InsDate — datetime
  • UptDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_LunchingCalendarReportCust

  • LCReportCustIdx — int — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • UseYn — char(1)
  • InsNo — int
  • InsDate — datetime
  • UptNo — int
  • UptDate — datetime

Bd_LunchingCalendarWarehousing

  • WhLunchingCalendarIdx — int — NOT NULL
  • LunchingCalendarIdx — int — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • ReportionDate — datetime — NOT NULL
  • CellNo — nchar(11)
  • CustName — nvarchar(50)
  • CustInfoDelDate — datetime
  • SendYn — char(1) — NOT NULL
  • SendDate — datetime
  • UseYn — char(1)
  • InsNo — int
  • InsDate — datetime
  • UptNo — int
  • UptDate — datetime
  • ApplicationSendDate — datetime
  • SendType — char(1) — NOT NULL

Bd_NBGuideDtl

  • NbGuideIdx — int — Primary key — NOT NULL
  • NbGuideDtlIdx — int — Primary key — NOT NULL
  • Title — nvarchar(200) — NOT NULL
  • Contents — nvarchar(max) — NOT NULL
  • NbGuideFileIdx — int — NOT NULL
  • DispSeq — int — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int
  • InsDate — datetime
  • UptNo — int
  • UptDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_NBGuideListForFront

  • NbGuideIdx — int — Primary key — NOT NULL
  • StyleCode — nvarchar(18) — Primary key — NOT NULL
  • ColCode — nvarchar(10) — Primary key — NOT NULL
  • DisplayName — nvarchar(100) — NOT NULL
  • NorPrice — numeric(12, 2) — NOT NULL
  • Price — numeric(12, 2) — NOT NULL
  • ImgUrl — nvarchar(500) — NOT NULL
  • CIdx — int
  • Category1 — int
  • SaleIconName — nvarchar(100)
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_NBGuideMst

  • NbGuideIdx — int — Primary key — NOT NULL
  • StyleCode — nvarchar(18) — NOT NULL
  • ColCode — nvarchar(10) — NOT NULL
  • Title — nvarchar(200) — NOT NULL
  • StaffInfo — nvarchar(100)
  • ShopName — nvarchar(100)
  • DispSeq — int
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_NBPeople

  • PeopleIdx — int — Primary key — NOT NULL
  • HashTag — nvarchar(200)
  • FileIdx — int
  • DispSeq — int
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1)
  • mainYn — char(1)
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_NBTag

  • TagIdx — int — Primary key — NOT NULL
  • TagName — nvarchar(100) — NOT NULL
  • TagContent — nvarchar(100) — NOT NULL
  • SDate — datetime — NOT NULL
  • EDate — datetime — NOT NULL
  • MainYn — char(1)
  • DispSeq — int
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1)
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_NBTagStyleListForFront

  • TagIdx — int — Primary key — NOT NULL
  • StyleCode — nvarchar(18) — Primary key — NOT NULL
  • ColCode — nvarchar(3) — Primary key — NOT NULL
  • TagName — nvarchar(100) — NOT NULL
  • TagContent — nvarchar(100) — NOT NULL
  • DisplayName — nvarchar(100) — NOT NULL
  • NorPrice — numeric(12, 2) — NOT NULL
  • Price — numeric(12, 2) — NOT NULL
  • ImgUrl — nvarchar(500) — NOT NULL
  • TagDispSeq — int — NOT NULL
  • StyleDispSeq — int — NOT NULL
  • StyleRowNum — int — NOT NULL
  • MainYn — char(1) — NOT NULL
  • StyleCount — int — NOT NULL
  • SaleIconName — nvarchar(100)
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_Notice

  • NoIdx — int — Primary key — NOT NULL
  • Title — nvarchar(200) — NOT NULL
  • Contents — nvarchar(max) — NOT NULL
  • ReservDate — datetime — NOT NULL
  • ViewCnt — int — NOT NULL
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_OrderTerms

  • Contents — nvarchar(max) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL

Bd_PrivacyJoinMarketingPolicy

  • PolicyIdx — int — Primary key — NOT NULL
  • Title — nvarchar(100) — NOT NULL
  • Contents — nvarchar(max) — NOT NULL
  • EnforcementDate — datetime — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_PrivacyJoinPolicy

  • PolicyIdx — int — Primary key — NOT NULL
  • Title — nvarchar(100) — NOT NULL
  • Contents — nvarchar(max) — NOT NULL
  • EnforcementDate — datetime — NOT NULL
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_PrivacyPolicy

  • PolicyIdx — int — Primary key — NOT NULL
  • Title — nvarchar(100) — NOT NULL
  • Contents — nvarchar(max) — NOT NULL
  • EnforcementDate — datetime — NOT NULL
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_QNA

  • QIdx — int — Primary key — NOT NULL
  • CustNo — nchar(16)
  • WebID — nvarchar(200)
  • OrderNo — nvarchar(100)
  • StyleCode — nvarchar(18)
  • ColCode — nvarchar(3)
  • ProdCode — nvarchar(18)
  • BrandCode — char(2) — NOT NULL
  • TypeCodeLarge — nvarchar(50) — NOT NULL
  • TypeCodeMedium — nvarchar(50) — NOT NULL
  • TypeCodeSmall — nvarchar(50)
  • Title — nvarchar(200) — NOT NULL
  • Contents — nvarchar(max) — NOT NULL
  • FileIdx — int
  • QnaStatus — int
  • DispYn — char(1)
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • Channel — char(1) — NOT NULL
  • CustName — nvarchar(200)
  • CellNo — nvarchar(200)
  • TelNo — nvarchar(200)
  • ShopnName — nchar(10)
  • OutSite — nchar(10)
  • UseYn — char(1)
  • TempQnaNo — int
  • DestroyDate — datetime
  • FileIdx2 — int
  • FileIdx3 — int
  • FileIdx4 — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_QnaSyUser

  • UserIdx — int — Primary key — NOT NULL
  • UserNm — varchar(50) — NOT NULL
  • UserEmail — varchar(50) — NOT NULL
  • UseYn — varchar(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_QnaSyUserMenu

  • Code — int — NOT NULL
  • UserIdx — int — NOT NULL
  • UseYn — varchar(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL

Bd_Review

  • RIdx — int — Primary key — NOT NULL
  • StyleCode — nvarchar(18) — NOT NULL
  • ColCode — nvarchar(3) — NOT NULL
  • SizeCode — nvarchar(3) — NOT NULL
  • CustNo — nchar(16)
  • OrderNo — char(18)
  • PStyleCode — nvarchar(18) — NOT NULL
  • PColCode — nvarchar(3) — NOT NULL
  • WebID — nvarchar(50)
  • CustGradeCode — char(2)
  • ReviewTitle — nvarchar(200) — NOT NULL
  • ReviewContents — nvarchar(4000) — NOT NULL
  • ReviewStatusCode — nvarchar(50) — NOT NULL
  • ReviewTypeCode — nvarchar(50) — NOT NULL
  • RefusalReasonCode — nvarchar(50)
  • RefusalReasonContent — nvarchar(200)
  • Grade — float — NOT NULL
  • SizePoint — int — NOT NULL
  • WidthPoint — int — NOT NULL
  • ColorPoint — int — NOT NULL
  • DlvyPoint — int — NOT NULL
  • CustHeight — int
  • CustWeight — int
  • ProductBrandCode — char(2) — NOT NULL
  • ProductCategoryIdxs — nvarchar(100)
  • FileIdx1 — int
  • FileIdx2 — int
  • FileIdx3 — int
  • FileIdx4 — int
  • FileIdx5 — int
  • ThumbnailFileIdx1 — int
  • ThumbnailFileIdx2 — int
  • ThumbnailFileIdx3 — int
  • ThumbnailFileIdx4 — int
  • ThumbnailFileIdx5 — int
  • ApprovalDate — datetime
  • StaffName — nvarchar(100)
  • StaffReviewYn — char(1) — NOT NULL
  • StaffReviewTopFixedYn — char(1) — NOT NULL
  • RefusalPopupCloseDate — datetime
  • RefusalReasonDate — datetime
  • ShoesProductYn — char(1) — NOT NULL
  • UserAgent — nvarchar(200)
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_ReviewReapplyHistory

  • HIdx — int — Primary key — NOT NULL
  • RIdx — int — NOT NULL
  • StyleCode — nvarchar(18) — NOT NULL
  • ColCode — nvarchar(3) — NOT NULL
  • SizeCode — nvarchar(3) — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • OrderNo — char(18) — NOT NULL
  • PStyleCode — nvarchar(18) — NOT NULL
  • PColCode — nvarchar(3) — NOT NULL
  • WebID — nvarchar(50) — NOT NULL
  • CustGradeCode — char(2) — NOT NULL
  • ReviewTitle — nvarchar(200) — NOT NULL
  • ReviewContents — nvarchar(4000) — NOT NULL
  • ReviewStatusCode — nvarchar(50) — NOT NULL
  • ReviewTypeCode — nvarchar(50) — NOT NULL
  • RefusalReasonCode — nvarchar(50)
  • Grade — float — NOT NULL
  • SizePoint — int — NOT NULL
  • WidthPoint — int — NOT NULL
  • ColorPoint — int — NOT NULL
  • DlvyPoint — int — NOT NULL
  • CustHeight — int
  • CustWeight — int
  • ProductBrandCode — char(2) — NOT NULL
  • ProductCategoryIdxs — nvarchar(100)
  • FileIdx1 — int
  • FileIdx2 — int
  • FileIdx3 — int
  • FileIdx4 — int
  • FileIdx5 — int
  • ThumbnailFileIdx1 — int
  • ThumbnailFileIdx2 — int
  • ThumbnailFileIdx3 — int
  • ThumbnailFileIdx4 — int
  • ThumbnailFileIdx5 — int
  • ApprovalDate — datetime
  • RefusalReasonDate — datetime
  • RefusalPopupCloseDate — datetime
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_ReviewRecommendation

  • RIdx — int — Primary key — NOT NULL
  • CustNo — nchar(16) — Primary key — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_ReviewReport

  • Idx — int — Primary key — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • WebID — nvarchar(50) — NOT NULL
  • RIdx — int — NOT NULL
  • ReportMessage — nvarchar(200)
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int
  • UptDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_Review_Delete

  • RIdx — int — Primary key — NOT NULL
  • StyleCode — nvarchar(18) — NOT NULL
  • ColCode — nvarchar(3) — NOT NULL
  • SizeCode — nvarchar(3) — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • OrderNo — char(18) — NOT NULL
  • WebID — nvarchar(20) — NOT NULL
  • ReviewTitle — nvarchar(200) — NOT NULL
  • ReviewContents — nvarchar(4000) — NOT NULL
  • Grade — int — NOT NULL
  • SizePoint — int — NOT NULL
  • WidthPoint — int — NOT NULL
  • ColorPoint — int — NOT NULL
  • DlvyPoint — int — NOT NULL
  • FileIdx1 — int
  • FileIdx2 — int
  • CustHeight — int
  • CustWeight — int
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — date — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — date — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_ShopMng

  • ShopIdx — int — Primary key — NOT NULL
  • BrandCode — nvarchar(4)
  • ShopCode — char(4) — NOT NULL
  • ShopTypeCode — nvarchar(50) — NOT NULL
  • Area — nvarchar(50) — NOT NULL
  • ShopName — nvarchar(100) — NOT NULL
  • ShopAddress — nvarchar(200) — NOT NULL
  • ZipCode — nvarchar(6)
  • Latitude — float — NOT NULL
  • Hardness — float — NOT NULL
  • TelNo — nvarchar(20) — NOT NULL
  • OpenTime — nchar(4)
  • CloseTime — nchar(4)
  • AddInfo — varchar(1000)
  • MapUseYn — char(1) — NOT NULL
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • PickupYn — char(1) — NOT NULL
  • ShopTypeCodeUptNo — int
  • ShopTypeCodeUptDate — datetime
  • ShopNameUptNo — int
  • ShopNameUptDate — datetime
  • RaffleUseYn — char(1)
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_ShopMng_DailyBackUp

  • ShopIdx — int — NOT NULL
  • BrandCode — nvarchar(4)
  • ShopCode — char(4) — NOT NULL
  • ShopTypeCode — nvarchar(50) — NOT NULL
  • Area — nvarchar(50) — NOT NULL
  • ShopName — nvarchar(100) — NOT NULL
  • ShopAddress — nvarchar(200) — NOT NULL
  • ZipCode — nvarchar(6)
  • Latitude — float — NOT NULL
  • Hardness — float — NOT NULL
  • TelNo — nvarchar(20) — NOT NULL
  • AddInfo — varchar(1000)
  • MapUseYn — char(1) — NOT NULL
  • DispYn — char(1) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • ShopTypeCodeUptNo — int
  • ShopTypeCodeUptDate — datetime
  • ShopNameUptNo — int
  • ShopNameUptDate — datetime
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL

Bd_ShopMng_Prd$

  • BrandCode — nvarchar(255)
  • ShopCode — nvarchar(255)
  • ShopTypeCode — float
  • Area — float
  • ShopName — nvarchar(255)
  • ShopAddress — nvarchar(255)
  • ZipCode — float
  • Latitude — float
  • Hardness — float
  • TelNo — nvarchar(255)
  • AddInfo — nvarchar(255)
  • MapUseYn — nvarchar(255)
  • DispYn — nvarchar(255)
  • UseYn — nvarchar(255)
  • ShopTypeCodeUptNo — nvarchar(255)
  • ShopTypeCodeUptDate — nvarchar(255)
  • ShopNameUptNo — nvarchar(255)
  • ShopNameUptDate — nvarchar(255)
  • InsNo — float
  • InsDate — datetime
  • UptNo — float
  • UptDate — datetime

Bd_StyleLookShop

  • LookShopIdx — int — Primary key — NOT NULL
  • StyleCode — nvarchar(18) — Primary key — NOT NULL
  • ColCode — nvarchar(3) — Primary key — NOT NULL
  • UseYn — char(1) — NOT NULL
  • DispSeq — int — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_StyleNBPeople

  • PeopleIdx — int — Primary key — NOT NULL
  • StyleCode — nvarchar(18) — Primary key — NOT NULL
  • Location — nvarchar(20) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Bd_StyleNBTag

  • TagIdx — int — Primary key — NOT NULL
  • StyleCode — nvarchar(18) — Primary key — NOT NULL
  • ColCode — nvarchar(3) — Primary key — NOT NULL
  • dispSeq — int
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

CP_TempFirstBuyCoupon

  • Idx — int — NOT NULL
  • CustNo — nvarchar(18) — NOT NULL
  • IpinCiNo — nvarchar(100)
  • CpIdx — int — NOT NULL
  • CpSerialNo — nvarchar(16)
  • RegChk — char(1)
  • InsDate — datetime

Cm_LogonHis

  • LogonIdx — int — Primary key — NOT NULL
  • StaffNo — nchar(16) — NOT NULL
  • UserAgent — nvarchar(200) — NOT NULL
  • InsIp — nvarchar(50) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cm_Staff

  • StaffNo — int — Primary key — NOT NULL
  • WebID — nvarchar(50) — NOT NULL
  • WebPW — varchar(200)
  • UseYn — char(1) — NOT NULL
  • StaffName — nvarchar(200)
  • ShopCode — nvarchar(4)
  • ShopName — nvarchar(100)
  • CellNo — varchar(200)
  • LoginFailCnt — int — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • LastFailDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cm_StaffCart

  • StaffNo — int — Primary key — NOT NULL
  • ProdCode — nvarchar(18) — Primary key — NOT NULL
  • StyleCode — nvarchar(18) — NOT NULL
  • Qty — int — NOT NULL
  • SharePurchaseIdx — int — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cp_CouponList

  • CpSerialNo — nvarchar(16) — Primary key — NOT NULL
  • ShoplinkCouponNo — nvarchar(16)
  • CpIdx — int — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • OrderNo — char(18)
  • ShoplinkSaleNo — nvarchar(100)
  • ShoplinkSaleDate — datetime
  • UsedYn — char(1) — NOT NULL
  • UseableSDate — datetime — NOT NULL
  • UseableEDate — datetime — NOT NULL
  • UseableYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cp_CouponListRestoreLog

  • Idx — int — Primary key — NOT NULL
  • OrderNo — char(18)
  • CustNo — nchar(16)
  • CpIdx — int
  • ShoplinkSaleNo — nvarchar(100)
  • CpSerialNo — nvarchar(16)
  • ShoplinkCouponNo — nvarchar(16)
  • ResultCode — nvarchar(10)
  • ResultMsg — nvarchar(100)
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cp_CouponList_Insert_Api_LOG

  • LogIdx — int — Primary key — NOT NULL
  • CpDivCode — int
  • CpIdx — int
  • StyleCode — nvarchar(18)
  • CustNo — nchar(16)
  • AnnivYN — nchar(1)
  • MemberYN — nchar(1)
  • AnnivDate — nchar(10)
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cp_CouponMst

  • CpIdx — int — Primary key — NOT NULL
  • CpName — nvarchar(50) — NOT NULL
  • PubSDate — datetime
  • PubEDate — datetime
  • PubCnt — int
  • UsePeriodYear — int
  • UsePeriodMonth — int
  • UsePeriodDay — int
  • UseableSDate — datetime
  • UseableEDate — datetime
  • UseDivCode — nvarchar(50) — NOT NULL
  • DcDivCode — nvarchar(50) — NOT NULL
  • CpGrpCode — nvarchar(50)
  • CpDivCode — nvarchar(50) — NOT NULL
  • BrandCode — nchar(4)
  • DcPrice — int — NOT NULL
  • DcRate — int — NOT NULL
  • MaxLimitDcPrice — int
  • MinLimitOrderAmt — int
  • MaxLimitOrderAmt — int
  • ProductMatchYn — char(1) — NOT NULL
  • WebUseYn — char(1) — NOT NULL
  • MobileUseYn — char(1) — NOT NULL
  • AppUseYn — char(1) — NOT NULL
  • OtherProdIncludeYn — char(1) — NOT NULL
  • OfflineUseYn — char(1) — NOT NULL
  • ShoplinkEventNo — int
  • ShoplinkCouponIssueNo — int
  • AvailablePlace — nvarchar(300)
  • CpDetail — nvarchar(400)
  • UseYn — char(1) — NOT NULL
  • MyNBDispYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • DcProdYn — char(1) — NOT NULL
  • GiftYn — char(1) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cp_Coupon_JobChk

  • CpIdx — int — NOT NULL
  • CpType — char(2) — NOT NULL
  • CpIssueDate — char(10) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL

Cp_ProdMatch

  • PMIdx — int — Primary key — NOT NULL
  • CpIdx — int — NOT NULL
  • StyleCode — nvarchar(18) — NOT NULL
  • ColCode — nvarchar(3)
  • UseYn — char(1) — NOT NULL
  • ColCodeYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cp_SalesforceDummyInfo

  • SalesIdx — int — Primary key — NOT NULL
  • CouponNo — nvarchar(16) — NOT NULL
  • SerialNo — nvarchar(16) — NOT NULL
  • CouponName — nvarchar(50) — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • CouponSDate — nvarchar(8)
  • CouponEDate — nvarchar(8) — NOT NULL
  • CouponGiveDate — nvarchar(8) — NOT NULL
  • UseChk — char(1) — NOT NULL
  • SaleNo — nvarchar(15)
  • OrderNo — varchar(18)
  • CouponTypeNo — nvarchar(50) — NOT NULL
  • CouponTypeName — nvarchar(16) — NOT NULL
  • ModiDate — datetime — NOT NULL
  • DscAmt — int — NOT NULL
  • DscRate — int — NOT NULL
  • OnOffType — char(3) — NOT NULL
  • InsDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cp_TempAnnivDayCoupon

  • Idx — int — NOT NULL
  • CustNo — nvarchar(18) — NOT NULL
  • IpinCiNo — nvarchar(100)
  • CpIdx — int — NOT NULL
  • CpSerialNo — nvarchar(16)
  • RegChk — char(1)
  • InsDate — datetime

Cp_TempFirstBuyCouponByCustNo

  • Idx — int — NOT NULL
  • CustNo — nvarchar(18) — NOT NULL
  • InsDate — datetime

Cu_AdminMemo

  • MemoIdx — int — Primary key — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • MenuNo — int — NOT NULL
  • Memo — nvarchar(500) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • AdminID — varchar(50) — NOT NULL
  • AdminName — varchar(50) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_CartHistory

  • HisUpIdx — int — Primary key — NOT NULL
  • HisIdx — int — Primary key — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • WebID — nvarchar(50) — NOT NULL
  • ProdCode — nvarchar(18) — NOT NULL
  • StyleCode — nvarchar(18) — NOT NULL
  • Price — numeric(12, 2) — NOT NULL
  • BeforeQty — int — NOT NULL
  • AfterQty — int — NOT NULL
  • PurchaseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_Customer

  • CustNo — nchar(16) — Primary key — NOT NULL
  • WebID — nvarchar(50) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • EmpYn — char(1)
  • EmpSabun — nchar(64)
  • EmpCpLimitCode — nvarchar(50)
  • EmpName — nvarchar(40)
  • EmpUseAmt — int — NOT NULL
  • EmpOrgName — nvarchar(100)
  • EmpDiscountRate — int
  • OftenGoShop — nvarchar(4)
  • IpinCiNo — nvarchar(100)
  • MemberCpGetDate — datetime
  • AnnivCpGetDate — datetime
  • FirstBuyCpGetDate — datetime
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • EmpCpLimitCodeSecond — nvarchar(50)
  • EmpType — char(1)
  • EmailReceiveModifyDate — datetime
  • SmsReceiveModifyDate — datetime
  • EmpId — nvarchar(30)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_CustomerNoShow

  • NoShowIdx — int — Primary key — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • OrderNo — char(18) — NOT NULL
  • StyleCode — nvarchar(18) — NOT NULL
  • ProdCode — nvarchar(18) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_EmailSendHistory

  • Idx — int — Primary key — NOT NULL
  • Email — nvarchar(500) — NOT NULL
  • SendPath — char(1) — NOT NULL
  • InsDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_GA_CountCommonInfo

  • CustNo — nchar(16) — Primary key — NOT NULL
  • DaysSinceLastVisit — int
  • NumWishlist — int
  • DaysSinceLastPurchase — int
  • NumRaffle — int
  • NumPurchase — int
  • UptDate — datetime — NOT NULL
  • LastModifyDate — nvarchar(10) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_GA_Login

  • CustNo — nchar(16) — Primary key — NOT NULL
  • BeforeLoginDate — datetime
  • LastLoginDate — datetime — NOT NULL
  • LastLoginDt — nvarchar(8) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_GA_Purchase

  • CustNo — nchar(16) — Primary key — NOT NULL
  • BeforePurchaseDate — datetime
  • LastPurchaseDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_GiveHistory

  • HisIdx — int — Primary key — NOT NULL
  • GiveCustNo — nvarchar(16) — NOT NULL
  • GiveWebID — nvarchar(20) — NOT NULL
  • GiveCustName — nvarchar(20)
  • TakeCustNo — nvarchar(16) — NOT NULL
  • TakeCustName — nvarchar(20)
  • TakeWebID — nvarchar(20) — NOT NULL
  • CpIdx — int
  • CpSerialNo — nvarchar(16)
  • ShoplinkCouponIssueNo — int
  • ShoplinkCouponNo — nvarchar(16)
  • CpName — nvarchar(50) — NOT NULL
  • Mileage — int — NOT NULL
  • GiveType — char(1) — NOT NULL
  • GiftFromType — char(1)
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_IpinCiNoInfoBackup

  • CustNo — nchar(16) — Primary key — NOT NULL
  • WebID — nvarchar(20) — NOT NULL
  • IpinCiNo — nvarchar(100)
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_JoinPolicy

  • CustNo — nchar(16) — Primary key — NOT NULL
  • OptAgreement1 — char(1) — NOT NULL
  • OptAgreement2 — char(1) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_JoinShopCode

  • ShopCode — char(4) — Primary key — NOT NULL
  • ShopName — nvarchar(20) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsDate — datetime — NOT NULL
  • AdminAuthNo — varchar(6)
  • StoreYn — char(1)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_LogonHis

  • LogonIdx — int — Primary key — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • UserAgent — nvarchar(200) — NOT NULL
  • InsIp — nvarchar(50) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_LogonHis2

  • LogonIdx — int — Primary key — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • UserAgent — nvarchar(200) — NOT NULL
  • InsIp — nvarchar(50) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_LogonHis_2021

  • LogonIdx — int — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • UserAgent — nvarchar(200) — NOT NULL
  • InsIp — nvarchar(50) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL

Cu_MileageChangeCode

  • ShoplinkPointChangeCode — nchar(2) — Primary key — NOT NULL
  • ShoplinkPointChangeName — nvarchar(20) — NOT NULL
  • ShoplinkPointChangeDesc — nvarchar(100) — NOT NULL
  • ShoplinkPointChangeStat — nchar(2) — NOT NULL
  • UseYn — char(1) — NOT NULL
  • InsNo — nchar(10) — NOT NULL
  • InsDate — nchar(10) — NOT NULL
  • UptNo — nchar(10) — NOT NULL
  • UptDate — nchar(10) — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_MileageCremaHistory

  • Idx — int — Primary key — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • WebID — nvarchar(50)
  • AddPoint — int — NOT NULL
  • PointChangeCode — char(2) — NOT NULL
  • ReviewIdx — int
  • ProductCode — nvarchar(50)
  • OrderCode — nvarchar(50)
  • OrderSubCode — nvarchar(50)
  • MileageMessage — nvarchar(200)
  • ReviewCreateDate — datetime
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_MileageDtl

  • MileageIdx — int — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • WebID — nvarchar(50) — NOT NULL
  • MileagePoint — int
  • ResultCode — char(1) — NOT NULL

Cu_MileageDtlBulk

  • WebID — nvarchar(50) — NOT NULL
  • MileagePoint — int

Cu_MileageHis

  • MileageIdx — int — Primary key — NOT NULL
  • CustNo — nchar(16) — NOT NULL
  • ShoplinkPointChangeCode — nchar(2) — NOT NULL
  • ShoplinkPoint — int — NOT NULL
  • ApiMemo — nchar(100)
  • OrderNo — char(18)
  • OrderSeq — int
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL
  • UptNo — int — NOT NULL
  • UptDate — datetime — NOT NULL
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

Cu_MileageMst

  • MileageIdx — int — NOT NULL
  • MileageType — nchar(2)
  • MileageCode — nchar(2) — NOT NULL
  • MileageMemo — nchar(50)
  • SuccessCnt — int
  • InsNo — int — NOT NULL
  • InsDate — datetime — NOT NULL

Cu_OutflowUserInfo

  • CustName — nvarchar(100) — NOT NULL
  • CellNo — nvarchar(100) — NOT NULL
  • WebIDYn — char(1)
  • BirthDayYn — char(1)
  • SexYn — char(1)
  • MileageYn — char(1)
  • EmailYn — char(1)
  • OutflowDate — datetime
  • ConfirmDate — datetime

and 452 more tables