COMPICK

Tables (14)

ADDRESS

  • address_id — NUMBER(19) — Primary key — NOT NULL
  • member_id — NUMBER(19) — Foreign key → MEMBER.member_id — NOT NULL
  • address_name — VARCHAR2(50) — NOT NULL
  • recipient_name — VARCHAR2(50) — NOT NULL
  • recipient_phone — VARCHAR2(20) — NOT NULL
  • zip_code — VARCHAR2(10) — NOT NULL
  • basic_address — VARCHAR2(255) — NOT NULL
  • detail_address — VARCHAR2(255)
  • is_default — CHAR(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

AI_RECOMMENDATION

  • ai_recommendation_id — NUMBER(19) — Primary key — NOT NULL
  • quote_id — NUMBER(19) — Foreign key → QUOTE.quote_id — NOT NULL
  • user_requirements — CLOB — NOT NULL
  • ai_answer_json — CLOB — NOT NULL

CART

  • cart_id — NUMBER(19) — Primary key — NOT NULL
  • member_id — NUMBER(19) — Foreign key → MEMBER.member_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

CART_PRODUCT_ITEM

  • cart_product_item_id — NUMBER(19) — Primary key — NOT NULL
  • cart_id — NUMBER(19) — Foreign key → CART.cart_id — NOT NULL
  • product_id — NUMBER(19) — Foreign key → PRODUCT.product_id — NOT NULL
  • quantity — NUMBER(10) — NOT NULL
  • is_selected — CHAR(1) — NOT NULL

CART_QUOTE_ITEM

  • cart_quote_item_id — NUMBER(19) — Primary key — NOT NULL
  • cart_id — NUMBER(19) — Foreign key → CART.cart_id — NOT NULL
  • quote_id — NUMBER(19) — Foreign key → QUOTE.quote_id — NOT NULL
  • quantity — NUMBER(10) — NOT NULL
  • is_selected — CHAR(1) — NOT NULL

CATEGORY

  • category_id — NUMBER(19) — Primary key — NOT NULL
  • category_name — VARCHAR2(30) — NOT NULL

MEMBER

  • member_id — NUMBER(19) — Primary key — NOT NULL
  • login_id — VARCHAR2(50) — NOT NULL
  • password_hash — VARCHAR2(255) — NOT NULL
  • member_name — VARCHAR2(50) — NOT NULL
  • email — VARCHAR2(100) — NOT NULL
  • phone — VARCHAR2(20) — NOT NULL
  • member_role — VARCHAR2(20) — NOT NULL
  • member_status — VARCHAR2(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

ORDERS

  • order_id — NUMBER(19) — Primary key — NOT NULL
  • member_id — NUMBER(19) — Foreign key → MEMBER.member_id — NOT NULL
  • order_number — VARCHAR2(50) — NOT NULL
  • order_status — VARCHAR2(30) — NOT NULL
  • product_amount — NUMBER(12) — NOT NULL
  • shipping_fee — NUMBER(12) — NOT NULL
  • final_amount — NUMBER(12) — NOT NULL
  • recipient_name — VARCHAR2(50) — NOT NULL
  • recipient_phone — VARCHAR2(20) — NOT NULL
  • zip_code — VARCHAR2(10) — NOT NULL
  • basic_address — VARCHAR2(255) — NOT NULL
  • detail_address — VARCHAR2(255)
  • delivery_request — VARCHAR2(500)
  • ordered_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

ORDER_GROUP

  • order_group_id — NUMBER(19) — Primary key — NOT NULL
  • order_id — NUMBER(19) — Foreign key → ORDERS.order_id — NOT NULL
  • source_quote_id — NUMBER(19) — Foreign key → QUOTE.quote_id
  • group_type — VARCHAR2(20) — NOT NULL
  • group_name — VARCHAR2(150) — NOT NULL
  • group_quantity — NUMBER(10) — NOT NULL
  • assembly_type — VARCHAR2(20) — NOT NULL

ORDER_ITEM

  • order_item_id — NUMBER(19) — Primary key — NOT NULL
  • order_id — NUMBER(19) — Foreign key → ORDERS.order_id — NOT NULL
  • order_group_id — NUMBER(19) — Foreign key → ORDER_GROUP.order_group_id — NOT NULL
  • product_id — NUMBER(19) — Foreign key → PRODUCT.product_id — NOT NULL
  • product_name — VARCHAR2(255) — NOT NULL
  • order_price — NUMBER(12) — NOT NULL
  • quantity — NUMBER(10) — NOT NULL
  • line_amount — NUMBER(12) — NOT NULL

PAYMENT

  • payment_id — NUMBER(19) — Primary key — NOT NULL
  • order_id — NUMBER(19) — Foreign key → ORDERS.order_id — NOT NULL
  • payment_method — VARCHAR2(30) — NOT NULL
  • payment_amount — NUMBER(12) — NOT NULL
  • payment_status — VARCHAR2(20) — NOT NULL
  • external_transaction_id — VARCHAR2(100)
  • approval_number — VARCHAR2(100)
  • requested_at — TIMESTAMP — NOT NULL
  • approved_at — TIMESTAMP
  • cancelled_at — TIMESTAMP

PRODUCT

  • product_id — NUMBER(19) — Primary key — NOT NULL
  • category_id — NUMBER(19) — Foreign key → CATEGORY.category_id — NOT NULL
  • product_name — VARCHAR2(255) — NOT NULL
  • brand — VARCHAR2(100) — NOT NULL
  • model_name — VARCHAR2(150) — NOT NULL
  • price — NUMBER(12) — NOT NULL
  • stock_quantity — NUMBER(10) — NOT NULL
  • product_description — CLOB
  • image_url — VARCHAR2(1000)
  • sales_status — VARCHAR2(20) — NOT NULL
  • socket_type — VARCHAR2(50)
  • memory_type — VARCHAR2(50)
  • form_factor — VARCHAR2(50)
  • power_consumption — NUMBER(8)
  • recommended_power — NUMBER(8)
  • gpu_length_mm — NUMBER(8)
  • max_gpu_length_mm — NUMBER(8)
  • power_capacity_watt — NUMBER(8)
  • spec_json — CLOB
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

QUOTE

  • quote_id — NUMBER(19) — Primary key — NOT NULL
  • member_id — NUMBER(19) — Foreign key → MEMBER.member_id — NOT NULL
  • quote_name — VARCHAR2(150) — NOT NULL
  • quote_type — VARCHAR2(20) — NOT NULL
  • assembly_type — VARCHAR2(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

QUOTE_ITEM

  • quote_item_id — NUMBER(19) — Primary key — NOT NULL
  • quote_id — NUMBER(19) — Foreign key → QUOTE.quote_id — NOT NULL
  • product_id — NUMBER(19) — Foreign key → PRODUCT.product_id — NOT NULL
  • quantity — NUMBER(10) — NOT NULL