Online Auction ERD-희원
테이블 (7)
Auction
- auction_id — BIGINT — 기본 키 — NOT NULL
- product_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- starting_price (사전예약 시간) — DECIMAL(10,2) — NOT NULL — 사전ㅇ{ㅖ약 시간
- current_price (경매 종료 시간) — DECIMAL(10,2) — 경매 종료 시간
- status — VARCHAR(50) — NOT NULL
- start_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- created_at — TIMESTAMP
Bid
- bid_id — BIGINT — 기본 키 — NOT NULL
- auction_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- bid_amount — DECIMAL(10,2) — NOT NULL
- bid_time — TIMESTAMP
Chat
- chat_id — BIGINT — 기본 키 — NOT NULL
- auction_id (어느 경매와 관련 채팅?) — BIGINT — NOT NULL
- sender_id (메세지 보낸사람) — BIGINT — NOT NULL
- receiver_id (메세지 받는 사람) — BIGINT — NOT NULL
- message (채팅 내용) — TEXT — NOT NULL
- sent_at — TIMESTAMP
Notification
- notification_id — BIGINT — 기본 키 — NOT NULL
- user_id (알림받을 사용자) — BIGINT — NOT NULL
- auction_id (관련된 경매) — BIGINT — NOT NULL
- message (알림내용) — TEXT — NOT NULL
- is_read (읽음 여부) — BOOLEAN
- created_at — TIMESTAMP
Product
- product_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- category — VARCHAR(255)
- image_url — VARCHAR(512)
- condition (새상품/중고상품 구분) — VARCHAR(50) — NOT NULL — 새상품/ 중고상품 구분 (ex. NEW, USED)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- user_id (user_id2) — BIGINT — 외래 키 → User.user_id — NOT NULL
Transaction
- transaction_id — BIGINT — 기본 키 — NOT NULL
- auction_id — BIGINT — NOT NULL
- buyer_id — BIGINT — NOT NULL
- seller_id — BIGINT — NOT NULL
- transaction_amount — DECIMAL(10,2) — NOT NULL
- transaction_date — TIMESTAMP
User
- user_id — BIGINT — 기본 키 — NOT NULL
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP