Auction
Tables (5)
auction
- 경매id (id) — bigint — Primary key — NOT NULL
- 위탁자id (cosigner_id) — bigint — Foreign key → user.유저id — NOT NULL
- 아이템id (item_id) — bigint — Foreign key → item.아이템id — NOT NULL
- 시작가 (starting_price) — varchar(255)
- 상태 (status) — enum
- 호가단위 (bid_increment) — varchar(255)
- 생성일자 (created_at) — datetime
- 수정일자 (updated_at) — datetime
bidding
- 응찰id (id) — bigint — Primary key — NOT NULL
- 옥션id (auction_id) — bigint — Foreign key → auction.경매id — NOT NULL
- 응찰자id (bidder_id) — bigint — Foreign key → user.유저id — NOT NULL
- 응찰가 (bid_price) — varchar(255)
- 생성일자 (created_at) — datetime
- 수정일자 (updated_at) — datetime
item
- 아이템id (id) — bigint — Primary key — NOT NULL
- 소유주id (owner_id) — bigint — Foreign key → user.유저id — NOT NULL
- 이름 (name) — varchar(255)
- 설명 (detail) — varchar(255)
- 생성일자 (created_at) — datetime
- 수정일자 (updated_at) — datetime
successful_bidding
- 낙찰id (id) — bigint — Primary key — NOT NULL
- 응찰id (bidding_id) — bigint — Foreign key → bidding.응찰id — NOT NULL
- 경매id (auction_id) — bigint — Foreign key → auction.경매id — NOT NULL
- 생성일자 (created_at) — datetime
- 수정일자 (updated_at) — datetime
user
- 유저id (id) — bigint — Primary key — NOT NULL
- 닉네임 (nickname) — varchar(255)
- 이메일 (email) — varchar(255)
- 생성일자 (created_at) — datetime
- 수정일자 (updated_at) — datetime