DoYack

Tables (17)

cart

  • product_code — VARCHAR(4)
  • product_count — INT — NOT NULL
  • user_id — VARCHAR(4)

coupon

  • coupon_code — VARCHAR(4)
  • discount_rate — INT — NOT NULL
  • validity_period — INT — NOT NULL
  • expiration_date — DATE — NOT NULL
  • minimum_purchase_amount — INT — NOT NULL
  • applicable_product — VARCHAR(50)
  • excluded_product — VARCHAR(50)

delivery

  • delivery_number — VARCHAR(4)
  • user_id — VARCHAR(4) — NOT NULL
  • order_number — VARCHAR(4) — NOT NULL
  • tracking_number — VARCHAR(20)
  • delivery_status — VARCHAR(20) — NOT NULL

delivery_address

  • user_id — VARCHAR(4)
  • default_address_flag — VARCHAR(1) — NOT NULL
  • address — VARCHAR(100) — NOT NULL

ingredient

  • product_code — VARCHAR(4)
  • ingredient — VARCHAR(50) — NOT NULL

order

  • order_number — VARCHAR(4)
  • user_id — VARCHAR(4) — NOT NULL
  • payment_method — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • order_date — DATE — NOT NULL

order_product

  • order_number — VARCHAR(4)
  • product_code — VARCHAR(4)
  • product_count — INT — NOT NULL
  • applied_coupon_code — VARCHAR(4)
  • price — INT — NOT NULL
  • discounted_price — INT — NOT NULL

point_history

  • user_id — VARCHAR(4)
  • description — VARCHAR(50) — NOT NULL
  • point — INT — NOT NULL
  • date — DATE — NOT NULL

product

  • product_code — VARCHAR(4)
  • product_name — VARCHAR(50) — NOT NULL
  • product_price — VARCHAR(10) — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • product_notice — TEXT
  • registration_date — DATE — NOT NULL
  • product_description — TEXT

product_image

  • product_code — VARCHAR(4)
  • thumbnail_image — VARCHAR(100) — NOT NULL
  • main_image — VARCHAR(100) — NOT NULL
  • detail_page_image — VARCHAR(100)

product_tag

  • product_code — VARCHAR(4)
  • tag — VARCHAR(20) — NOT NULL

question

  • question_code — VARCHAR(4)
  • product_code — VARCHAR(4)
  • question_text — TEXT — NOT NULL

review

  • review_code — VARCHAR(4)
  • product_code — VARCHAR(4) — NOT NULL
  • user_id — VARCHAR(4) — NOT NULL
  • order_code — VARCHAR(4) — NOT NULL
  • like_count — INT — NOT NULL
  • star_rating — INT — NOT NULL
  • registration_date — DATE — NOT NULL
  • review_text — TEXT

review_image

  • review_code — VARCHAR(4)
  • review_image — VARCHAR(100) — NOT NULL

satisfaction

  • review_code — VARCHAR(4)
  • delivery_satisfaction — INT — NOT NULL
  • product_satisfaction — INT — NOT NULL
  • health_help_satisfaction — INT — NOT NULL
  • service_satisfaction — INT — NOT NULL

user

  • id — VARCHAR(4)
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • contact_number — VARCHAR(20) — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • birth_year — YEAR — NOT NULL
  • point — INT — NOT NULL

user_coupon

  • user_id — VARCHAR(4)
  • coupon_code — VARCHAR(4)
  • issuance_date — DATE — NOT NULL