beauty9
Tables (32)
AdminMember
- AdminId — varchar(50) — Primary key — NOT NULL
- Idx — int — NOT NULL
- AdminPw — varchar(50)
- AdminName — varchar(50)
- AdminGroup — int
- ManageSiteName — varchar(50)
- ManageSiteUrl — varchar(100)
- MobileNo — varchar(50)
- Email — varchar(50)
- WorkTimeStart — varchar(50)
- WorkTimeEnd — varchar(50)
- AdminStatue — varchar(50)
- Regdate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Article
- ArticleNo — int — Primary key — NOT NULL
- ArticleType — varchar(50)
- CategorySub — int
- UserEmail — varchar(50)
- Title — nvarchar(1000)
- Contents — nvarchar(max)
- MoviePath — varchar(200)
- ImagePath — varchar(100)
- ImagePath2 — varchar(100)
- ImagePath3 — varchar(100)
- ImagePath4 — varchar(100)
- ImagePath5 — varchar(100)
- RelProductCode1 — varchar(50)
- RelProductCode2 — varchar(50)
- RelProductCode3 — varchar(50)
- RelProductCode4 — varchar(50)
- RelProductCode5 — varchar(50)
- Rating1 — varchar(50)
- Rating2 — varchar(50)
- Rating3 — varchar(50)
- Rating4 — varchar(50)
- Rating5 — varchar(50)
- RegDate — varchar(50)
- IpAddress — varchar(50)
- ArticleState — varchar(50)
- ArticleViewCnt — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- UserEmail (UserEmail2) — varchar(50) — Foreign key → Members.UserEmail — NOT NULL
- ProductNo — int — Foreign key → Product.ProductNo — NOT NULL
Bnr_Banner
- Idx — int — Primary key — NOT NULL
- UseOnOff — varchar(10)
- SiteCode — varchar(50)
- SiteName — varchar(50)
- SiteURL — varchar(200)
- ObjName — varchar(100)
- ObjWidth — int
- ObjHeight — int
- wname — varchar(50)
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Bnr_Banner_Obj
- IdxBnr — int — Primary key — NOT NULL
- Idx — int
- BannerName — varchar(50)
- BannerFileName — varchar(50)
- TargetURL — varchar(200)
- ExpWeight — int
- ExpSeq — int
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Brand
- BrandNo — int — Primary key — NOT NULL
- BrandName — varchar(500)
- CompanyNo — int
- SalesCompanyNo — int
- BrandLogo — varchar(100)
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- ProductNo — int — Foreign key → Product.ProductNo — NOT NULL
Cart
- Idx — int — Primary key — NOT NULL
- UserEmail — varchar(100)
- ProductNo — int
- ProductCount — int
- SelectedYN — varchar(2)
- RegDate — varchar(50)
- ArticleNoPayback — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- UserEmail (UserEmail2) — varchar(50) — Foreign key → Members.UserEmail — NOT NULL
CategoryRank
- Idx — int — Primary key — NOT NULL
- CategoryNo1 — int
- CategoryName1 — varchar(50)
- CategoryNo2 — int
- CategoryName2 — varchar(50)
- CategoryNo3 — int
- CategoryName3 — varchar(50)
- CategoryNo4 — int
- CategoryName4 — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CategoryShop
- Idx — int — Primary key — NOT NULL
- CategoryNo1 — int
- CategoryName1 — varchar(50)
- CategoryNo2 — int
- CategoryName2 — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Comment
- CommentNo — int — Primary key — NOT NULL
- CommentNoParents — int
- ArticleNo — int
- UserEmail — varchar(50)
- CommContents — nvarchar(max)
- CommState — varchar(50)
- CommRegDate — varchar(50)
- Depth — int
- Seq — int
- CommLikeCnt — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
CommentReport
- Idx — int — Primary key — NOT NULL
- CommentNo — int
- InformerEmail — varchar(50)
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Company
- CompanyNo — int — Primary key — NOT NULL
- CompanyName — varchar(500)
- CompanyPhoneNo — varchar(50)
- CompanyAddrZip — varchar(50)
- CompanyAddr — varchar(500)
- CompanyAddrDetail — varchar(100)
- CompanyHomePageUrl — varchar(100)
- CompanyRegNo — varchar(50)
- CompanyState — varchar(50)
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- BrandNo — int — Foreign key → Brand.BrandNo — NOT NULL
Event
- EventNo — int — Primary key — NOT NULL
- EventType — varchar(50)
- EventCate — varchar(50)
- Title — varchar(500)
- Contents — varchar(1000)
- ThumbPath — varchar(100)
- HeaderPath — varchar(100)
- BodyPath — varchar(100)
- SubscriptionCount — int
- SupplyBenefit — varchar(50)
- StartDate — varchar(50)
- EndDate — varchar(50)
- LotteryDate — varchar(50)
- SendDate — varchar(50)
- CutoffDate — varchar(50)
- Notice — varchar(1000)
- ProductNo — int
- BrandNo — int
- EventStatue — varchar(50)
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
EventResult
- Idx — int — Primary key — NOT NULL
- EventNo — int
- UserEmail — varchar(50)
- UserEmailReg — varchar(50)
- UserName — varchar(50)
- MobileNo — varchar(50)
- ProductNo — int
- PostCode — varchar(50)
- RoadAddress — varchar(50)
- RoadAddressDetail — varchar(100)
- InvoiceNo — varchar(50)
- FeedBackPoint — int
- WinnerYN — varchar(2)
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- EventNo (EventNo2) — int — Foreign key → Event.EventNo — NOT NULL
EwgList
- Idx — int — Primary key — NOT NULL
- CheName — varchar(1000)
- TitleName1 — varchar(1000)
- TitleName2 — varchar(1000)
- TitleName3 — varchar(1000)
- TitleName4 — varchar(1000)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
FileUpload
- Idx — int — Primary key — NOT NULL
- FileName — varchar(500)
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Ingredient
- IngredientCode — int — Primary key — NOT NULL
- StdName — varchar(500)
- StdNameEng — varchar(500)
- StdNameOld — varchar(500)
- StdNameEngOld — varchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- ProductNo — int — Foreign key → ProductIngredient.ProductNo — NOT NULL
- Seq — int — Foreign key → ProductIngredient.Seq — NOT NULL
IngredientItem
- IngredientCode — int
- ItemName — varchar(8000)
- ItemValue — varchar(8000)
IngredientProd
- Idx — int — Primary key — NOT NULL
- CheName — varchar(1000)
- TitleName1 — varchar(1000)
- TitleName2 — varchar(1000)
- TitleName3 — varchar(1000)
- TitleName4 — varchar(1000)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
IngredientTypeInfo
- IngredientCode — int — Primary key — NOT NULL
- Idx — int — Primary key — NOT NULL
- IngredientTypeTitle — varchar(100)
- IngredientTypeContents — varchar(1000)
- IngredientType — varchar(50)
- IngredientTypeDisp — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- IngredientCode (IngredientCode2) — int — Foreign key → Ingredient.IngredientCode — NOT NULL
MemberActivity
- TableType — varchar(50) — Primary key — NOT NULL
- ArticleNo — int — Primary key — NOT NULL
- UserEmail — varchar(50) — Primary key — NOT NULL
- LikeYN — varchar(2)
- LikeRegDate — varchar(50)
- BookYN — varchar(2)
- BookRegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MemberActivityComm
- Idx — int — Primary key — NOT NULL
- CommentNo — int
- UserEmail — varchar(50)
- ActivityName — varchar(50)
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MemberActivityEtc
- Idx — int — Primary key — NOT NULL
- UserEmail — varchar(50)
- ActivityName — varchar(50)
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Members
- UserEmail — varchar(50) — Primary key — NOT NULL
- UserPassword — varchar(50) — NOT NULL
- NickName — varchar(100)
- deviceId — varchar(50)
- Sex — varchar(10)
- AgeYear — int
- ChildYN — varchar(2)
- SkinType — varchar(50)
- SkinTrouble — varchar(100)
- ProfilePhoto — varchar(50)
- ActionLevel — int
- MemberStatue — varchar(50)
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MyPay
- Idx — int — Primary key — NOT NULL
- PayNo — int — NOT NULL
- PayType — varchar(10)
- BankItem — varchar(50)
- UserEmail — varchar(100)
- ProductNo — int
- ProductCount — int
- PayPrice — int
- OrderProcessStatue — varchar(50)
- OrderFinishStatue — varchar(50)
- PostCode — varchar(50)
- ReceiveAddr — varchar(50)
- ReceiveAddrDetail — varchar(50)
- ReceiveMemo — varchar(500)
- ReceiveName — varchar(50)
- ReceiveMobileNo — varchar(50)
- InvoiceNo — varchar(50)
- RegDate — varchar(50)
- ArticleNoPayback — int
- DeliveryPrice — int
- TotalPrice — int
- MileagePrice — int
- MileagePriceUsed — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- Idx (Idx2) — int — Foreign key → Cart.Idx — NOT NULL
MyQna
- Idx — int — Primary key — NOT NULL
- QnaType — varchar(50)
- Contents — varchar(1000)
- UserEmail — varchar(100)
- ReturnEmail — varchar(100)
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MyRequest
- Idx — int — Primary key — NOT NULL
- Contents — varchar(1000)
- UserEmail — varchar(100)
- ReturnEmail — varchar(100)
- ImagePath — varchar(200)
- ImagePath2 — varchar(200)
- ImagePath3 — varchar(200)
- ImagePath4 — varchar(200)
- ImagePath5 — varchar(200)
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
Payback
- PaybackNo — int — Primary key — NOT NULL
- PayIdx — int
- ProductNo — int
- PaybackAmount — int
- PaybackStatue — varchar(50)
- PaybackRate — int
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- Idx (Idx2) — int — Foreign key → MyPay.Idx — NOT NULL
Planning
- PlanningNo — int — Primary key — NOT NULL
- PlanningName — varchar(500)
- PlanningContents — varchar(1000)
- PlanningImgPath — varchar(100)
- PlanningImgPath2 — varchar(100)
- PlanningStatue — varchar(50)
- RegDate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
PlanningProduct
- PlanningNo — int — NOT NULL
- Seq — int
- ProductNo — int
Product
- ProductNo — int — Primary key — NOT NULL
- ProductName — varchar(100)
- ProductDesc — varchar(500)
- ProductImgPath — varchar(500)
- ProductVolume — varchar(50)
- RankYN — varchar(2)
- ShopYN — varchar(2)
- CategoryRankNo — varchar(1000)
- CategoryShopNo — varchar(1000)
- Price — int
- PriceSale — int
- BrandNo — int
- CountryName — varchar(50)
- ProductInfoImage — varchar(100)
- Score — int
- SellerId — varchar(50)
- AdminId — varchar(50)
- AdminIdFirst — varchar(50)
- RegDate — varchar(50)
- ProductState — varchar(50)
- ProductStock — int
- PayBackRatePhoto — int
- PayBackRateMovie — int
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- SellerId (SellerId2) — varchar(50) — Foreign key → Sellers.SellerId — NOT NULL
- Idx — int — Foreign key → CategoryRank.Idx — NOT NULL
- Idx (Idx2) — int — Foreign key → CategoryShop.Idx — NOT NULL
ProductIngredient
- ProductNo — int — Primary key — NOT NULL
- Seq — int — Primary key — NOT NULL
- IngredientCode — int
- StdNameUnconfirmed — varchar(500)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- ProductNo (ProductNo2) — int — Foreign key → Product.ProductNo — NOT NULL
Sellers
- SellerId — varchar(50) — Primary key — NOT NULL
- SellerPw — varchar(50)
- SellerName — varchar(50)
- SellerGroup — int
- MobileNo — varchar(50)
- Email — varchar(50)
- SellerStatue — varchar(50)
- DeliveryPrice — int
- Regdate — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =