Catpstone_11_23

테이블 (5)

게시정보 (board)

  • idBoard — int — 기본 키 — NOT NULL
  • idUser — int — 외래 키 → 사용자.idUser — NOT NULL
  • location — varchar(255)
  • price_per_night — decimal(10,2)
  • start_date — date — NOT NULL
  • end_date — date — NOT NULL
  • details — text
  • categories — enum('products','accommodation','tutoring') — NOT NULL
  • title — varchar(255)
  • price — decimal(10,2)
  • status — varchar(100)
  • subject — varchar(255)
  • price_per_hour — decimal(10,2)
  • availability — text
  • role — enum('consumer','provider','admin') — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • response_id — int — 외래 키 → 게시정보.idBoard

사용자 (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)

사진 (BoardPhotos)

  • id — int — 기본 키 — NOT NULL
  • idBoard — int — 외래 키 → 게시정보.idBoard — NOT NULL
  • photo_url — varchar(255) — NOT NULL

응답 (answer)

  • idAnswer — int — 기본 키 — NOT NULL
  • idRequest — int — NOT NULL
  • idBids — int — 외래 키 → 입찰.idBids
  • idBoard — int — 외래 키 → 게시정보.idBoard — NOT NULL

입찰 (bids)

  • idBids — int — 기본 키 — NOT NULL
  • idRequest — int — NOT NULL
  • idUser — int — 외래 키 → 사용자.idUser — NOT NULL
  • bids_price — decimal(10,2) — NOT NULL
  • bid_amount — decimal(10,2) — NOT NULL
  • bid_time — datetime — NOT NULL
  • bid_status — enum('active','withdrawn','accepted')
  • is_winning — tinyint(1)
  • previous_bid_id — int — 외래 키 → 입찰.idBids