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)