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