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