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