rosefinch

Tables (23)

answer (product_answer)

  • Key (id) — Primary key — NOT NULL
  • Key (product_question_id) — Foreign key → question.Key — NOT NULL
  • Field (title)
  • Field (content)
  • Field (create_date)
  • Field (update_date)
  • Field (adviser_id)

bascket

  • Key (id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → user.id — NOT NULL
  • Key (option_id) — Foreign key → option.Key — NOT NULL
  • Field (count)

category

  • Key (id) — Primary key — NOT NULL
  • parent_category_id — Foreign key → category.Key — NOT NULL
  • category_name (depth)

coupon

  • Key (id) — Primary key — NOT NULL
  • Field (coupon_name)
  • Field2 (description)
  • Field (discount_rate)
  • Field (start_date)
  • Field (expire_date)

img_file

  • Key (id) — Primary key — NOT NULL
  • Field (name)
  • Field (location)
  • Field (type)
  • Field (size)
  • Field (crate_date)
  • Field (update_date)

oauth_id

  • Key (id) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → user.id — NOT NULL
  • Field (token)
  • Field (provider)
  • Field (expire)

option (product_option)

  • Key (id) — Primary key — NOT NULL
  • id (product_id) — Foreign key → product.id — NOT NULL
  • Field (option_name)
  • Field (price)
  • Field (available_num)

product

  • id — Primary key — NOT NULL
  • Key (img_file_id) — Foreign key → img_file.Key — NOT NULL
  • Key (category_id) — Foreign key → category.Key — NOT NULL
  • Field3 (description_text)
  • Field2 (start_date)
  • Field2 (end_date)
  • Field2 (seller_id)
  • Field2 (coupon_id)
  • Field (create_date)
  • Field2 (update_date)
  • Field (selling_count)
  • Field (delivery_charge)
  • Field (event)
  • Field (view_count)

product_answer (answer)

  • Key (id) — Primary key — NOT NULL
  • Key (question_id) — Foreign key → product_question.Key — NOT NULL
  • Field (title)
  • Field (content)
  • Field (create_date)
  • Field (update_date)
  • Field (seller_id)

product_question (question)

  • Key (id) — Primary key — NOT NULL
  • user_id — Foreign key → user.id — NOT NULL
  • id (product_id) — Foreign key → product.id — NOT NULL
  • Field (title)
  • Field (content)
  • Field (create_date)
  • Field (update_date)
  • Field (secret)

puchased_product (purchased_product)

  • id — Primary key — NOT NULL
  • id (user_id) — Foreign key → user.id — NOT NULL
  • id (option_id) — Foreign key → option.Key — NOT NULL
  • Field (count)
  • Field (refund)
  • Field (exchange)
  • Field (product_id)

question (product_question)

  • Key (id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → user.id — NOT NULL
  • Field (title)
  • Field (content)
  • Field (product_id)
  • Field (create_date)
  • Field (update_date)
  • Field (secret)
  • Field (view_count)

seller

  • Key (id) — Primary key — NOT NULL
  • Field (name)
  • Field (phone)
  • Field (email)
  • Field (create_date)
  • Field (update_date)
  • Field (account)
  • Field (seller_id)
  • Field2 (seller_pw)
  • Field (credit_rate)
  • Field (description)

seller_product

  • seller_id — Foreign key → seller.Key — NOT NULL
  • product_id — Foreign key → product.id — NOT NULL

site_event (event)

  • Key (id) — Primary key — NOT NULL
  • img_file_id — Foreign key → img_file.Key — NOT NULL
  • title
  • content (description)

site_promotion (promotion)

  • id — Primary key — NOT NULL
  • img_file_id — Foreign key → img_file.Key — NOT NULL
  • title
  • product_id (description)
  • Field (product_id)

user

  • id — Primary key — NOT NULL
  • Field (name)
  • Field (phone)
  • Field (email)
  • Field (addr)
  • Field (user_id)
  • Field (user_pw)
  • Field (create_date)
  • Field (update_date)
  • Field (valid)
  • Field (rank)
  • Field (point)
  • Field (ip)

user_comment

  • Key (id) — Primary key — NOT NULL
  • Key (parent_comment_id) — Foreign key → user_comment.Key — NOT NULL
  • Key (user_id) — Foreign key → user.id — NOT NULL
  • Key (product_id) — Foreign key → product.id — NOT NULL
  • Field (comment)
  • Field (star_score)

user_comment_img

  • Key (user_comment_id) — Foreign key → user_comment.Key — NOT NULL
  • Key (file_id) — Foreign key → img_file.Key — NOT NULL

user_coupon

  • user_id — Foreign key → user.id — NOT NULL
  • Key (coupon_id) — Foreign key → coupon.Key — NOT NULL

user_delivery

  • Key (id) — Primary key — NOT NULL
  • id (product_id) — Foreign key → product.id — NOT NULL
  • id (user_id) — Foreign key → user.id — NOT NULL
  • Field (delivery_stage)
  • Field (delivery_charge)

user_interest_item (user_interest_product)

  • user_id — Foreign key → user.id — NOT NULL
  • id (product_id) — Foreign key → product.id — NOT NULL

user_login

  • Key (id) — Primary key — NOT NULL
  • Field (user_id) — Foreign key → user.id — NOT NULL
  • Field (expire)