BadHabitClub

Tables (17)

Inventory (Inventories)

  • inventoryId — char — Primary key — NOT NULL
  • prdtOptionId — char — Foreign key → Untitled.prdtOptionId — NOT NULL
  • buyingQty — int
  • salesQty — int

Laundry (Laundries)

  • prdtId — char — Foreign key → Prdt.prdtId — NOT NULL
  • cd — char — Foreign key → Untitled.cd — NOT NULL

Like (Likes)

  • likeId — char — Primary key — NOT NULL — auto increment로 해 ?
  • userId — char — Foreign key → User.userId — NOT NULL
  • prdtId — char — Foreign key → Prdt.prdtId — NOT NULL

Material (Materials)

  • prdtId — char — Foreign key → Prdt.prdtId — NOT NULL
  • cd — char — Foreign key → Untitled.cd — NOT NULL

Option (Options)

  • optionId — char — Primary key — NOT NULL
  • optionCd — char
  • optionName — char

Prdt (Prdts)

  • prdtId — char — Primary key — NOT NULL
  • prdtName — char
  • originPrice — int
  • brandId — char
  • priceUnit — char
  • prdtCondition — char
  • description — char
  • seller — char — default 임시

Review (Reviews)

  • reviewId — char — Primary key — NOT NULL
  • userId — char — Foreign key → User.userId — NOT NULL
  • prdtId — char — Foreign key → Prdt.prdtId — NOT NULL
  • regDt — time
  • chgDt — time
  • star — int
  • content — char

Untitled (Menu)

  • menuId — char — Primary key — NOT NULL
  • menuName — char
  • seq — int
  • menuUrl — char

Untitled (CommonCodes)

  • cd — char — Primary key — NOT NULL
  • upperCd — char
  • label — char
  • use — boolean

Untitled (PrdtOptions)

  • prdtOptionId — char — Primary key — NOT NULL
  • optionId — char — Foreign key → Option.optionId — NOT NULL
  • prdtId — char — Foreign key → Prdt.prdtId — NOT NULL

Untitled (OrderPrdts)

  • prdtId — char — Foreign key → Prdt.prdtId — NOT NULL
  • orderId — char — Foreign key → Untitled.orderId — NOT NULL
  • dscntRate — int — 소수점
  • qty — int

Untitled (Orders)

  • orderId — char — Primary key — NOT NULL
  • userId — char — Foreign key → User.userId — NOT NULL
  • orderNo — char
  • status — char
  • clubMoneyUsed — int
  • couponId — char
  • orderDt — time
  • payMtd — char
  • trackingNo — char
  • deliveryCoId — char
  • deliveryFee — int
  • deliveryRequest — char
  • countryCd — char
  • zipCd — char
  • subAddr — char
  • receiver — char
  • telCountryCd — char
  • telNo — char

Untitled (Visitors)

  • visitorId — char — Primary key — NOT NULL
  • ip — char
  • visitDt — time
  • cnt — int
  • isUser — boolean

Untitled (PrdtImages)

  • prdtId — char — Foreign key → Prdt.prdtId — NOT NULL
  • imgId — char — Foreign key → Untitled.imgId — NOT NULL

Untitled (Images)

  • imgId — char — Primary key — NOT NULL
  • path — char

Untitled (UserImages)

  • imgId — char — Foreign key → Untitled.imgId — NOT NULL
  • userId — char — Foreign key → User.userId — NOT NULL

User (Users)

  • userId — char — Primary key — NOT NULL
  • userName — char
  • givenName — char
  • familyName — char
  • password — char
  • rcvMarketing — boolean
  • level — char
  • email — char
  • status — char
  • clubMoney — int
  • joinDt — time
  • countryCd — char — NOT NULL
  • zipCd — char — NOT NULL
  • addr — char — NOT NULL
  • subAddr — char — NOT NULL
  • receiver — char
  • cityCd — char — NOT NULL
  • telCountryCd — char
  • telNo — char — NOT NULL
  • useAddr — boolean