캡스톤 12월 erd
테이블 (6)
BoardPhotos
- id — int — 기본 키 — NOT NULL
- idBoard — int — 외래 키 → board.idBoard — NOT NULL
- photo_url — varchar(255) — NOT NULL
auction
- idRequest — int — 기본 키 — NOT NULL
- idBoard — int — 외래 키 → board.idBoard — NOT NULL
- idsuggest — int — 외래 키 → suggest.idSuggest
- leader — int — NOT NULL
- participant — int
- bid — decimal(10,2)
- created_at — timestamp
- expires_at — timestamp — NOT NULL
- status — varchar(50)
bids
- idBids — int — 기본 키 — NOT NULL
- idBoard — int — 외래 키 → board.idBoard — NOT NULL
- idUser — int — 외래 키 → user.idUser — NOT NULL
- bid_price — decimal(10,0) — NOT NULL
- bid_status — enum('latest','previous','canceled')
board
- idBoard — int — 기본 키 — NOT NULL
- idUser — int — 외래 키 → user.idUser — NOT NULL
- title — varchar(255)
- status — enum('on_board','in_process','completed','ex_auction')
- price — decimal(10,0) — NOT NULL
- max_price — decimal(10,0) — NOT NULL
- discount_price — decimal(10,0)
- min_inc — decimal(10,0) — NOT NULL
- ex_auction_time — timestamp
- location — varchar(255)
- duration — int
- start_date — date
- expired_at — timestamp
- end_date — date
- details — varchar(100)
- categories — enum('products','accommodation','tutoring') — NOT NULL
- subject — varchar(255)
- role — enum('consumer','provider','admin') — NOT NULL
- created_at — timestamp
suggest
- idSuggest — int — 기본 키 — NOT NULL
- idUser — int — 외래 키 → user.idUser — NOT NULL
- location — varchar(255)
- start_date — date
- end_date — date
- details — varchar(100)
- categories — enum('products','accommodation','tutoring') — NOT NULL
- title — varchar(255)
- price — decimal(10,2)
- subject — varchar(255)
- role — enum('consumer','provider','admin') — NOT NULL
- created_at — timestamp
- idBoard — int — 외래 키 → board.idBoard — NOT NULL
user
- idUser — int — 기본 키 — NOT NULL
- pw — varchar(255) — NOT NULL
- role — enum('consumer','provider','admin') — NOT NULL
- created_at — timestamp
- name — varchar(100) — NOT NULL
- age — int
- email — varchar(100) — NOT NULL
- nickname — varchar(45) — NOT NULL
- phonenumber — varchar(11) — NOT NULL
- profile_photo — varchar(255)