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