view buy me

Tables (14)

auction_results

  • result_id — INT
  • auction_id — INT — NOT NULL
  • winner_member_id — INT
  • winning_bid_amount — DECIMAL(10,2)
  • total_bids — INT
  • status — ENUM('IN_PROGRESS', 'COMPLETED', 'NO_WINNER', 'CANCELLED')
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP

auctions

  • auction_id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — NOT NULL
  • starting_price — DECIMAL(10, 2) — NOT NULL
  • start_time — TIMESTAMP — NOT NULL
  • end_time — TIMESTAMP — NOT NULL
  • period — ENUM('3', '5', '7', '10')
  • status — ENUM('OPEN', 'AWARD', 'CLOSE' ,'CANCELLED')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

bids

  • bid_id — BIGINT — Primary key — NOT NULL
  • auction_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • bid_price — DECIMAL(10, 2) — NOT NULL
  • bid_time — TIMESTAMP
  • status — ENUM('ACTIVE', 'CANCELED', 'AWARD')
  • created_at (careated_at) — TIMESTAMP
  • updated_at — TIMESTAMP

favorite_products

  • favorite_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — NOT NULL
  • deleted — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

files

  • id — BIGINT
  • filename — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • content_type — VARCHAR(100) — NOT NULL
  • status — VARCHAR(50)
  • created_at — TIMESTAMP
  • uploaded_at — TIMESTAMP

members

  • member_id (memver_id) — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — Primary key — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(15)
  • address — VARCHAR(255)
  • role — ENUM('USER', 'ADMIN')
  • status — ENUM('ACTIVE', 'INACTIVE', 'BANNED', 'DELETED')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

payments

  • payment_id — BIGINT
  • settlement_id — BIGINT — NOT NULL
  • payment_method — ENUM('CARD', 'TRANSFER') — NOT NULL
  • payment_amount — DECIMAL(10, 2) — NOT NULL
  • payment_status — ENUM('PENDING', 'COMPLETED', 'FAILED', 'CANCELLED', 'REFUNDED')
  • transaction_id — VARCHAR(200)
  • payment_gateway — VARCHAR(100)
  • paid_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

product_categories

  • category_id (Key) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL

product_images

  • image_id (Key) — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT
  • file_id — BIGINT

products

  • product_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • thumbnail_url — VARCHAR(255) — NOT NULL
  • category — VARCHAR(100) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • available — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

push_notifications

  • notification_id (Key) — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

seller_reviews

  • id — BIGINT
  • reviewer_id — BIGINT — NOT NULL
  • seller_id — BIGINT — NOT NULL
  • product_id — BIGINT
  • rating — INT
  • comment — TEXT — EX
  • created_at — DATETIME

settlements

  • settlement_id — BIGINT
  • auction_id — BIGINT — NOT NULL
  • buyer_id — BIGINT — NOT NULL
  • status — ENUM('AWARD', 'PENDING', 'REJECTED', 'FAILED') — NOT NULL
  • payment_deadline — DATETIME — NOT NULL
  • rejected_reason — TEXT
  • price — INT
  • paid_at — DATETIME
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

shipping

  • shipping_id — INT
  • order_id — INT — NOT NULL
  • tracking_number — VARCHAR(100)
  • shipping_company — VARCHAR(100)
  • recipient_name — VARCHAR(100) — NOT NULL
  • recipient_phone — VARCHAR(20) — NOT NULL
  • shipping_address — VARCHAR(500) — NOT NULL
  • shipping_status — ENUM('PREPARING', 'SHIPPED', 'IN_TRANSIT', 'OUT_FOR_DELIVERY', 'DELIVERED', 'FAILED', 'RETURNED')
  • shipping_method — ENUM('STANDARD', 'EXPRESS', 'OVERNIGHT')
  • shipping_cost — DECIMAL(10,2)
  • estimated_delivery_date — DATE
  • actual_delivery_date — DATETIME
  • special_instructions — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP