BuyBid

Tables (9)

bid_details

  • bid_id — bigint — Primary key — NOT NULL
  • amount — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • product_id — bigint — Foreign key → products.product_id — NOT NULL
  • winner_id — bigint — Foreign key → users.user_idx — NOT NULL

bid_proxy

  • proxy_id — bigint — Primary key — NOT NULL
  • max_amount — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • product_id — bigint — Foreign key → products.product_id — NOT NULL
  • user_id — bigint — Foreign key → users.user_idx — NOT NULL

categories

  • cate_id — int — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL

chat_message

  • message_id — bigint — Primary key — NOT NULL
  • room_id — bigint — Foreign key → chatroom.room_id — NOT NULL
  • sender_id — bigint — Foreign key → users.user_idx — NOT NULL
  • message — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL

chatroom

  • room_id — bigint — Primary key — NOT NULL
  • product_id — bigint — Foreign key → products.product_id — NOT NULL
  • buyer_id — bigint — Foreign key → users.user_idx — NOT NULL
  • seller_id — bigint — Foreign key → users.user_idx — NOT NULL
  • created_at — datetime — NOT NULL

product_image

  • image_id — bigint — Primary key — NOT NULL
  • img_url — varchar(255) — NOT NULL
  • product_id — bigint — Foreign key → products.product_id — NOT NULL

products

  • product_id — bigint — Primary key — NOT NULL
  • title — varchar(255)
  • content — varchar(255)
  • start_at — datetime — NOT NULL
  • end_at — datetime — NOT NULL
  • start_price — bigint — NOT NULL
  • min_increment — int — NOT NULL
  • buy_now — int
  • current_price — bigint
  • seller_id — bigint — Foreign key → users.user_idx — NOT NULL
  • cate_id — int — Foreign key → categories.cate_id — NOT NULL

refresh_tokens

  • token_id — bigint — Primary key — NOT NULL
  • refresh_token — varchar(255) — NOT NULL
  • user_id — bigint — NOT NULL
  • created_at — datetime — NOT NULL

users

  • user_idx — bigint — Primary key — NOT NULL
  • email — varchar(255)
  • password — varchar(255)
  • name — varchar(255)
  • created_at — datetime — NOT NULL
  • role — varchar(255)