hongkong liveCommerce

Tables (28)

AuthLog

  • log_id — SERIAL
  • user_id — INTEGER — NOT NULL
  • ip_address — VARCHAR(45) — NOT NULL
  • login_time — TIMESTAMP

BlacklistedToken

  • blacklist_id — SERIAL
  • access_token — TEXT — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP

BroadcastProduct

  • broadcast_product_id — SERIAL
  • broadcast_id — INTEGER — NOT NULL
  • sku_id — INTEGER — NOT NULL
  • discount_price — DECIMAL(10,2)
  • expected_sales_quantity — INTEGER — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Cart

  • cart_id — SERIAL
  • consumer_id — INTEGER — NOT NULL
  • seller_id — INTEGER — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

CartItem

  • cart_item_id — SERIAL
  • cart_id — INTEGER — NOT NULL
  • sku_id — INTEGER — NOT NULL
  • quantity — INTEGER — NOT NULL
  • price_at_broadcast — DECIMAL(10,2)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Consumer

  • consumer_id — SERIAL
  • user_id — INTEGER
  • zipcode — VARCHAR(10) — NOT NULL
  • address — TEXT — NOT NULL
  • detail_address — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Coupon

  • coupon_id — SERIAL
  • code — VARCHAR(50) — NOT NULL
  • discount_type — ENUM('fixed', 'percentage') — NOT NULL
  • discount_value — DECIMAL(10,2) — NOT NULL
  • min_order_amount — DECIMAL(10,2)
  • valid_from — TIMESTAMP — NOT NULL
  • valid_until — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

CouponUsage

  • usage_id — SERIAL
  • coupon_id — INTEGER — NOT NULL
  • consumer_id — INTEGER — NOT NULL
  • order_id — INTEGER — NOT NULL
  • used_at — TIMESTAMP

CustomerInquiry

  • inquiry_id — SERIAL
  • consumer_id — INTEGER — NOT NULL
  • inquiry_type — ENUM('product', 'shipping', 'refund', 'other') — NOT NULL
  • subject — VARCHAR(255) — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

InquiryReply

  • reply_id — SERIAL
  • inquiry_id — INTEGER — NOT NULL
  • admin_id — INTEGER
  • seller_id — INTEGER
  • reply_text — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

JWTToken

  • token_id — SERIAL
  • user_id — INTEGER — NOT NULL
  • access_token — TEXT — NOT NULL
  • refresh_token — TEXT — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • refresh_expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP

LiveBroadcast

  • broadcast_id — SERIAL
  • seller_id — INTEGER — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • scheduled_time — TIMESTAMP — NOT NULL
  • duration — INTEGER — NOT NULL
  • viewer_count — INTEGER
  • stream_type — ENUM('RTMP', 'WebRTC', 'HLS') — NOT NULL
  • status — ENUM('scheduled', 'live', 'ended')
  • stream_url — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Order

  • order_id — SERIAL
  • consumer_id — INTEGER — NOT NULL
  • seller_id — INTEGER — NOT NULL
  • total_price — DECIMAL(10,2) — NOT NULL
  • status — ENUM('pending', 'completed', 'cancelled')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

OrderItem

  • order_item_id — SERIAL
  • order_id — INTEGER — NOT NULL
  • sku_id — INTEGER — NOT NULL
  • quantity — INTEGER — NOT NULL
  • price_at_broadcast — DECIMAL(10,2)
  • price_final — DECIMAL(10,2) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Payment

  • payment_id — SERIAL
  • order_id — INTEGER — NOT NULL
  • payment_method — ENUM('kakaopay', 'naverpay', 'bank_transfer') — NOT NULL
  • amount — DECIMAL(10,2) — NOT NULL
  • status — ENUM('pending', 'paid', 'failed')
  • paid_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Product

  • product_id — SERIAL
  • supplier_id — INTEGER — NOT NULL
  • category_id — INTEGER — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • supply_price — DECIMAL(10,2) — NOT NULL
  • base_price — DECIMAL(10,2) — NOT NULL
  • combine_shipping — BOOLEAN
  • consignment — BOOLEAN
  • thumbnail_url_1 — TEXT
  • thumbnail_url_2 — TEXT
  • thumbnail_url_3 — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ProductAttribute

  • attribute_id — SERIAL
  • sku_id — INTEGER — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • value — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ProductCategory

  • category_id — SERIAL
  • parent_id — INTEGER
  • name — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ProductReview

  • review_id — SERIAL
  • consumer_id — INTEGER — NOT NULL
  • product_id — INTEGER — NOT NULL
  • rating — INTEGER — NOT NULL
  • review_text — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ProductSKU

  • sku_id — SERIAL
  • product_id — INTEGER — NOT NULL
  • sku_code — VARCHAR(50) — NOT NULL
  • supply_price — DECIMAL(10,2) — NOT NULL
  • base_price — DECIMAL(10,2) — NOT NULL
  • stock — INTEGER — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ReviewReply

  • reply_id — SERIAL
  • review_id — INTEGER — NOT NULL
  • admin_id — INTEGER
  • seller_id — INTEGER
  • reply_text — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Seller

  • seller_id — SERIAL
  • user_id — INTEGER
  • business_type — ENUM('individual', 'corporation') — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • bank_code — VARCHAR(10) — NOT NULL
  • account_number — VARCHAR(50) — NOT NULL
  • commission_rate — DECIMAL(5,2) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • address — TEXT — NOT NULL
  • status — ENUM('pending', 'approved', 'rejected')
  • applied_at — TIMESTAMP
  • approved_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

SellerCommission

  • commission_id — SERIAL
  • seller_id — INTEGER — NOT NULL
  • commission_rate — DECIMAL(5,2) — NOT NULL
  • effective_date — DATE — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Settlement

  • settlement_id — SERIAL
  • seller_id — INTEGER — NOT NULL
  • total_sales — DECIMAL(12,2) — NOT NULL
  • commission_rate — DECIMAL(5,2) — NOT NULL
  • net_amount — DECIMAL(12,2) — NOT NULL
  • status — ENUM('pending', 'completed')
  • settled_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Shipping

  • shipping_id — SERIAL
  • order_id — INTEGER — NOT NULL
  • tracking_number — VARCHAR(50)
  • status — ENUM('preparing', 'shipped', 'delivered')
  • shipping_address — TEXT — NOT NULL
  • zipcode — VARCHAR(10) — NOT NULL
  • shipping_type — ENUM('single', 'combined') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Supplier

  • supplier_id — SERIAL
  • user_id — INTEGER
  • company_name — VARCHAR(255) — NOT NULL
  • business_number — VARCHAR(20) — NOT NULL
  • representative_name — VARCHAR(100) — NOT NULL
  • tax_email — VARCHAR(255) — NOT NULL
  • bank_code — VARCHAR(10) — NOT NULL
  • account_number — VARCHAR(50) — NOT NULL
  • company_address — TEXT — NOT NULL
  • company_phone — VARCHAR(20) — NOT NULL
  • manager_phone — VARCHAR(20) — NOT NULL
  • manager_email — VARCHAR(255) — NOT NULL
  • status — ENUM('pending', 'approved', 'rejected')
  • applied_at — TIMESTAMP
  • approved_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

User

  • user_id — SERIAL
  • email — VARCHAR(255)
  • password_hash — TEXT
  • kakao_id — VARCHAR(255)
  • role — ENUM('admin', 'supplier', 'seller', 'consumer') — NOT NULL
  • photo_url — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Wishlist

  • wishlist_id — SERIAL
  • consumer_id — INTEGER — NOT NULL
  • product_id — INTEGER — NOT NULL
  • created_at — TIMESTAMP