a

Tables (5)

auction_results

  • id — bigint — Primary key
  • buyer_id — bigint — Foreign key → users.id
  • product_id — bigint — Foreign key → products.id
  • final_price — integer — NOT NULL
  • auction_status — enum
  • created_at — timestamp(6)
  • updated_at — timestamp(6)

bids

  • id — bigint — Primary key
  • product_id — bigint — Foreign key → products.id
  • user_id — bigint — Foreign key → users.id
  • bidding_price — integer — NOT NULL
  • auction_status — enum
  • created_at — timestamp(6)
  • updated_at — timestamp(6)

payments

  • id — bigint — Primary key
  • user_id — bigint — Foreign key → users.id
  • auction_id — bigint — Foreign key → auction_results.id
  • created_at — timestamp(6)
  • updated_at — timestamp(6)

products

  • id — bigint — Primary key
  • writer_id — bigint — Foreign key → users.id
  • title — varchar(255)
  • description — varchar(255)
  • category — enum
  • status — enum
  • images — varchar(255)
  • start_price — integer — NOT NULL
  • current_price — integer — NOT NULL
  • start_date — timestamp(6)
  • end_date — timestamp(6)
  • created_at — timestamp(6)
  • updated_at — timestamp(6)

users

  • id — bigint — Primary key
  • nickname — varchar(255)
  • image — varchar(255)
  • created_at — timestamp(6)
  • updated_at — timestamp(6)