E-Commerce

Tables (12)

ACTIVITY_LOGS

  • log_id — bigint
  • user_id — bigint — Foreign key → USERS.user_id
  • action_type — varchar(255)
  • description — text
  • created_at — timestamp
  • ip_address — varchar(255)

CART_ITEMS

  • cart_item_id — bigint
  • user_id — bigint — Foreign key → USERS.user_id
  • product_id — bigint — Foreign key → PRODUCTS.product_id
  • quantity — int
  • added_at — timestamp

COUPONS (쿠폰 테이블)

  • coupon_id — bigint
  • code — varchar(255)
  • type — varchar(255)
  • value — decimal
  • total_quantity — int
  • used_quantity — int
  • valid_from — timestamp
  • valid_until — timestamp
  • is_active — boolean

FCFS_COUPONS (선착순 쿠폰 테이블)

  • fcfs_coupon_id (고유 아이디) — bigint
  • code — varchar(255)
  • type — varchar(255)
  • value — decimal
  • total_quantity — int
  • used_quantity — int
  • valid_from — timestamp
  • valid_until — timestamp
  • is_active — boolean

ORDERS

  • order_id — bigint
  • user_id — bigint — Foreign key → USERS.user_id
  • total_amount — decimal
  • status — varchar(255)
  • order_date — timestamp
  • coupon_id — bigint
  • shipping_address — text

ORDER_ITEMS

  • order_item_id — bigint
  • order_id — bigint — Foreign key → ORDERS.order_id
  • product_id — bigint — Foreign key → PRODUCTS.product_id
  • quantity — int
  • unit_price — decimal
  • subtotal — decimal

PAYMENTS

  • payment_id — bigint
  • order_id — bigint — Foreign key → ORDERS.order_id
  • amount — decimal
  • payment_method — varchar(255)
  • status — varchar(255)
  • payment_date — timestamp

PRODUCTS

  • product_id — bigint
  • name — varchar(255)
  • description — text
  • price — decimal
  • category — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • is_active — boolean

PRODUCT_ANALYTICS

  • analytics_id — bigint
  • product_id — bigint — Foreign key → PRODUCTS.product_id
  • view_count — int
  • purchase_count — int
  • conversion_rate — decimal
  • recorded_at — timestamp

PRODUCT_INVENTORY

  • inventory_id — bigint
  • product_id — bigint — Foreign key → PRODUCTS.product_id
  • quantity — int
  • last_updated — timestamp

USERS

  • user_id — bigint
  • email — varchar(255)
  • password — varchar(255)
  • name — varchar(255)
  • phone — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • is_active — boolean

USER_COUPONS (유저 쿠폰 테이블)

  • user_coupon_id — bigint
  • user_id — bigint — Foreign key → USERS.user_id
  • coupon_id — bigint — Foreign key → COUPONS.coupon_id
  • is_used — boolean
  • used_at — timestamp
  • issued_at — timestamp