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)