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