asd

Tables (30)

CS_A

  • CS_Q_id — VARCHAR(50) — Foreign key → CS_Q.CS_Q_id — NOT NULL
  • A_message — TEXT — NOT NULL
  • A_at — DATETIME
  • employer_id — VARCHAR(50) — Foreign key → employer.employer_id — NOT NULL

CS_Q

  • CS_Q_id — VARCHAR(50) — Primary key — NOT NULL
  • Q_message — TEXT — NOT NULL
  • Q_at — DATETIME
  • customer_id — VARCHAR(50) — Foreign key → customer.customer_id — NOT NULL
  • status — VARCHAR(50) — 답변 기다림, 답변 완료

address

  • address_id — VARCHAR(50) — Primary key — NOT NULL
  • customer_id — VARCHAR(50) — Foreign key → customer.customer_id — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • postal_code — VARCHAR(20) — NOT NULL

coupon

  • coupon_id — VARCHAR(50) — Primary key — NOT NULL
  • discount_rate — INT — NOT NULL

customer

  • customer_id — VARCHAR(50) — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
  • number_of_purchases — INT
  • total_purchase_amount — INT
  • membership_grade — VARCHAR(50)
  • point — INT

employer

  • employer_id — VARCHAR(50) — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
  • consultation_availability — TINYINT(1)

issued_coupon

  • customer_id — VARCHAR(50) — Foreign key → customer.customer_id — NOT NULL
  • coupon_id — VARCHAR(50) — Foreign key → coupon.coupon_id — NOT NULL
  • amount — INT

item

  • product_variant_id — VARCHAR(50) — Foreign key → product_variant.product_variant_id — NOT NULL — sku
  • warehouse_id — VARCHAR(50) — Foreign key → warehouse.warehouse_id — NOT NULL
  • count — INT — NOT NULL

notification

  • notification_id — VARCHAR(50) — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • message — TEXT

notification_log

  • notification_log_id — VARCHAR(50) — Primary key — NOT NULL
  • notification_id — VARCHAR(50) — Foreign key → notification.notification_id — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
  • registered_at — DATETIME
  • sent_at — DATETIME
  • is_notified — TINYINT(1)

option_value

  • option_value_id — VARCHAR(50) — Primary key — NOT NULL
  • value_name — VARCHAR(100) — NOT NULL
  • value_order — INT
  • option_id — VARCHAR(50) — Foreign key → product_option.option_id — NOT NULL

order_detail

  • order_detail_id — VARCHAR(50) — Primary key — NOT NULL
  • order_id — VARCHAR(50) — Foreign key → orders.order_id — NOT NULL
  • product_id — VARCHAR(50) — Foreign key → product.product_id — NOT NULL
  • product_variant_id — VARCHAR(50) — Foreign key → product_variant.product_variant_id — NOT NULL — sku
  • count — INT — NOT NULL
  • product_total_amount — INT — NOT NULL

orders

  • order_id — VARCHAR(50) — Primary key — NOT NULL
  • customer_id — VARCHAR(50) — Foreign key → customer.customer_id — NOT NULL
  • order_date — DATETIME
  • order_status — VARCHAR(50) — 결제완료, 구매확정, 환불, 취소
  • address_id — VARCHAR(50) — Foreign key → address.address_id — NOT NULL

payment_log

  • order_id — VARCHAR(50) — Foreign key → orders.order_id — NOT NULL
  • order_amount — INT — NOT NULL
  • coupon_id — VARCHAR(50) — Foreign key → coupon.coupon_id
  • used_point_id — VARCHAR(50)
  • payment_amount — INT — NOT NULL
  • payment_datetime — DATETIME

point_log

  • point_log_id — VARCHAR(50) — Primary key — NOT NULL
  • customer_id — VARCHAR(50) — Foreign key → customer.customer_id — NOT NULL
  • use_type — VARCHAR(50) — NOT NULL — EARN/USE
  • amount — INT — NOT NULL
  • total_amount — INT — NOT NULL

prod_A

  • prod_Q_id — VARCHAR(50) — Foreign key → prod_Q.prod_Q_id — NOT NULL
  • A_message — TEXT — NOT NULL
  • A_at — DATETIME
  • seller_id — VARCHAR(50) — Foreign key → seller.seller_id — NOT NULL

prod_Q

  • prod_Q_id — VARCHAR(50) — Primary key — NOT NULL
  • Q_message — TEXT — NOT NULL
  • Q_at — DATETIME
  • product_id — VARCHAR(50) — Foreign key → product.product_id — NOT NULL
  • customer_id — VARCHAR(50) — Foreign key → customer.customer_id — NOT NULL
  • status — VARCHAR(50) — 답변 기다림, 답변 완료

product

  • product_id — VARCHAR(50) — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • price — INT — NOT NULL
  • review_count — INT
  • discount_rate — INT
  • is_sold_out — TINYINT(1)
  • product_description — TEXT
  • category_id — VARCHAR(50) — Foreign key → product_category.category_id — NOT NULL
  • sub_category_id — VARCHAR(50) — Foreign key → product_sub_category.sub_category_id — NOT NULL

product_category

  • category_id — VARCHAR(50) — Primary key — NOT NULL
  • category_name — VARCHAR(100) — NOT NULL

product_option

  • option_id — VARCHAR(50) — Primary key — NOT NULL
  • product_id — VARCHAR(50) — Foreign key → product.product_id — NOT NULL
  • option_name — VARCHAR(100) — NOT NULL
  • option_order — INT

product_register

  • product_id — VARCHAR(50) — Foreign key → product.product_id — NOT NULL
  • register_date — DATETIME
  • seller_id — VARCHAR(50) — Foreign key → seller.seller_id — NOT NULL

product_sub_category

  • sub_category_id — VARCHAR(50) — Primary key — NOT NULL
  • category_id — VARCHAR(50) — Foreign key → product_category.category_id — NOT NULL
  • sub_category_name — VARCHAR(100) — NOT NULL

product_variant

  • product_variant_id — VARCHAR(50) — Primary key — NOT NULL — sku
  • product_id — VARCHAR(50) — Foreign key → product.product_id — NOT NULL
  • variant_description — VARCHAR(255)
  • product_variant_name — VARCHAR(100)

refund_log

  • order_id — VARCHAR(50) — Foreign key → orders.order_id — NOT NULL
  • refund_amount — INT — NOT NULL
  • refund_reason — TEXT
  • refund_datetime — DATETIME

seller

  • seller_id — VARCHAR(50) — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
  • store_name — VARCHAR(100)
  • store_contact — VARCHAR(50)

shopping_cart

  • shopping_cart_id — VARCHAR(50) — Primary key — NOT NULL
  • customer_id — VARCHAR(50) — Foreign key → customer.customer_id — NOT NULL

shopping_cart_item

  • shopping_cart_item_id — VARCHAR(50) — Primary key — NOT NULL
  • shopping_cart_id — VARCHAR(50) — Foreign key → shopping_cart.shopping_cart_id — NOT NULL
  • product_id — VARCHAR(50) — Foreign key → product.product_id — NOT NULL
  • product_variant_id — VARCHAR(50) — Foreign key → product_variant.product_variant_id — NOT NULL
  • amount — INT

user

  • user_id — VARCHAR(50) — Primary key — NOT NULL
  • join_date — DATETIME
  • user_name — VARCHAR(100) — NOT NULL
  • user_password — VARCHAR(255) — NOT NULL
  • user_contact — VARCHAR(50)

variant_option_mapping

  • option_value_id — VARCHAR(50) — Foreign key → option_value.option_value_id — NOT NULL
  • product_variant_id — VARCHAR(50) — Foreign key → product_variant.product_variant_id — NOT NULL

warehouse

  • warehouse_id — VARCHAR(50) — Primary key — NOT NULL
  • warehouse_name — VARCHAR(100)
  • address — VARCHAR(255)