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 — =