xdcd
Tables (12)
address
- address_no — number
- address_receiver — varchar(255)
- address_roadAddress — varchar(255)
- address_detail — varchar(255)
- address_jibunAddress — varchar(255)
- address_extraAddress — varchar(255)
- address_isDefault — boolean
- address_deliveryRequest — varchar(255)
- address_phone — varchar(255)
- address_createdDate — varchar(255)
- address_modifiedDate — varchar(255)
- address_deletedDate — varchar(255)
- users_users_id — varchar(255) — Foreign key → users.users_id
agreement
- agreement_no — number
- agreement_info — boolean
- agreement_sns — boolean
- agreement_required — boolean
- users_users_id — varchar(255) — Foreign key → users.users_id
cart
- cart_no — number
- cart_qty — number
- cart_createdDate — date
- cart_ckLimit — date
- cart_ckId — varchar(255)
- cart_optionContent — varchar(255)
- users_users_id — varchar(255) — Foreign key → users.users_id
- product_product_no — number — Foreign key → prouct.product_no
- productOption_productOption_no — number — Foreign key → productOption.productOption_type
coupon
- coupon_no — number
- coupon_type — varchar(255)
- coupon_value — number
- coupon_condition — number
- coupon_createdDate — varchar(255)
- coupon_expiredDate — varchar(255)
- coupon_used — boolean
- users_users_id — varchar(255) — Foreign key → users.users_id
image
- image_no — number
- image_name — varchar(255)
- image_file — blob
- image_fileName — varchar(255)
- product_product_no — number — Foreign key → prouct.product_no
- review_review_no — number — Foreign key → review.review_no
orderProduct
- orderProduct_no — number
- orderProduct_qty — number
- orderProduct_isOrdered — boolean
- orderProduct_reviewed — boolean
- users_users_id — varchar(255) — Foreign key → users.users_id
- productOption_productOption_no — number — Foreign key → productOption.productOption_no
- pOrder_order_no — number — Foreign key → pOrder.order_no
pInquriy
- pInquriy_no — number
- pInquriy_title — varchar(255)
- pInquriy_content — varchar(255)
- pInquriy_type — number
- pInquriy_createdDate — varchar(255)
- pInquriy_modifiedDate — varchar(255)
- pInquriy_deletedDate — varchar(255)
- users_users_id — varchar(255) — Foreign key → users.users_id
- product_product_no — number — Foreign key → prouct.product_no
pOrder
- order_no — number
- order_cashReceipt — boolean
- order_createdDate — varchar(255)
- order_modifiedDate — varchar(255)
- order_deletedDate — varchar(255)
- order_del_fee — number
- order_requset — varchar(255)
- order_oPoint — number
- order_total_price — number
- users_users_id — varchar(255) — Foreign key → users.users_id
- coupon_coupon_no — number — Foreign key → coupon.coupon_no
- address_address_no — number — Foreign key → address.address_no
productOption
- productOption_no — number
- productOption_type — varchar(255)
- product_product_no — number — Foreign key → prouct.product_no
prouct
- product_no — number
- product_name — varchar(255)
- product_price — number
- product_createdDate — varchar(255)
- product_imgFile — blob
- product_img — clob
review
- review_no — number
- review_name — varchar(255)
- review_rating — number
- review_title — varchar(255)
- review_contents — clob
- review_createdDate — varchar(255)
- review_modifiedDate — varchar(255)
- review_deletedDate — varchar(255)
- product_product_no — number — Foreign key → prouct.product_no
users
- users_id — varchar(255)
- users_email — varchar(255)
- users_password — varchar(255)
- users_name — varchar(255)
- users_phone — varchar(255)
- users_opoint — number
- users_createdDate — varchar(255)
- users_modifiedDate — varchar(255)
- users_deletedDate — varchar(255)
- users_loginDate — varchar(255)
- users_type — varchar(255)
- users_bdate — varchar(255)
- users_imgFile — blob
- users_mattach — blob