whatever
Tables (8)
Bid (입찰)
- bid_id (입찰_id) — NotNull — Primary key — NOT NULL
- bid_price (입찰가) — NotNull
- user_id (유저_id) — NotNull — Foreign key → User.user_id — NOT NULL
- success (낙찰 여부) — NotNull
- createdAt (생성 날짜) — NotNull
- updatedAt (수정날짜) — Null
- auction_id (경매_id) — NotNull — Foreign key → auction.auction_id — NOT NULL
Payment (결제)
- payment_id (결제ID) — NotNull — Primary key — NOT NULL
- payment_price (결제금액) — NotNull
- payment_type (결제방법) — NotNull
- createdAt (결제시간) — NotNull
- payment_request_id (결제요청ID) — NotNull — Foreign key → Payment_Request.payment_request_id — NOT NULL
- user_id (유저_id) — NotNull — Foreign key → User.user_id — NOT NULL
Payment_Request (결제요청)
- payment_request_id (결제요청ID) — NotNull — Primary key — NOT NULL
- request_payment (결제요청가격) — NotNull
- auction_id (경매_id) — NotNull — Foreign key → auction.auction_id — NOT NULL
- user_id (유저_id) — NotNull — Foreign key → User.user_id — NOT NULL
Stuff (물품)
- stuff_id (물품_id) — NotNull — Primary key — NOT NULL
- intro (물품소개) — NotNull
- price (가격) — NotNull
- user_id (유저_id) — NotNull — Foreign key → User.user_id — NOT NULL
- name (물품이름) — NotNull
- auction_id (경매_id) — NotNull — Foreign key → auction.auction_id — NOT NULL
- createdAt (생성날짜) — NotNull
- updatedAt (수정날짜) — Null
User (사용자)
- user_id (유저_id) — NotNull — Primary key — NOT NULL
- email (이메일) — NotNull
- password (비밀번호) — NotNull
- kakaoId (카카오Id) — Null
- intro (자기소개) — Null
- like (좋아하는 것) — Null
- address (주소) — Null
- createdAt (생성 날짜) — NotNull
- updatedAt (수정날짜) — null
- role (역할) — not null
- nickname (닉네임) — NotNull
adjustment (정산)
- adjustment (정산ID) — NotNull — Primary key — NOT NULL
- adjustment_price (정산금액) — NotNull
- createdAt (정산날짜) — NotNull
- account_number (계좌번호) — NotNull
- payment_id (결제ID) — NotNull — Foreign key → Payment.payment_id — NOT NULL
- user_id (유저_id) — NotNull — Foreign key → User.user_id — NOT NULL
auction (경매)
- auction_id (경매_id) — NotNull — Primary key — NOT NULL
- startTime (경매시작시간) — NotNull
- endTime (경매종료시간) — NotNull
- minPrice (최소가격) — NotNull
- participationPeople (참여가능인원) — NotNull
- status (상태) — NotNull
- createdAt (생성날짜) — NotNull
- updatedAt (수정날짜) — Null
- title (경매이름) — NotNull
like (좋아요)
- like_id (좋아요_id) — NotNull — Primary key — NOT NULL
- user_id (유저_id) — NotNull — Foreign key → User.user_id — NOT NULL
- auction_id (경매_id) — NotNull — Foreign key → auction.auction_id — NOT NULL