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