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