캡스톤 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)