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)