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)