TransferStay

Tables (8)

Assignment_post (양도글)

  • post_id (양도글 id) — bigint — Primary key — NOT NULL
  • user_id (작성자 id) — bigint — Foreign key → User.user_id — NOT NULL
  • title (제목) — varchar — NOT NULL
  • description (설명) — text — NOT NULL
  • price (가격) — bigint — NOT NULL
  • is_auction (경매여부) — boolean — NOT NULL
  • created_at (생성일시) — datetime — NOT NULL
  • updated_at (수정일시) — datetime
  • location_depth1 (숙소위치1(시/도)) — varchar — NOT NULL
  • location_depth2 (숙소위치2(구/군)) — varchar — NOT NULL
  • personnel (예약인원) — int — NOT NULL
  • check_in_date (체크인 날짜) — date — NOT NULL
  • check_out_date (체크아웃 날짜) — date — NOT NULL
  • reservation_platform (예약 플랫폼) — varchar — NOT NULL
  • reservation_code (예약확정코드) — varchar — NOT NULL
  • reservation_name (예약자 명) — varchar — NOT NULL
  • reservation_phone (예약자 번호) — varchar — NOT NULL
  • status (판매중/완료/삭제) — varchar — NOT NULL

Auction (경매정보)

  • auction_id (경매 id) — bigint — Primary key — NOT NULL
  • post_id (양도글 id) — bigint — Foreign key → Assignment_post.post_id — NOT NULL
  • user_id (판매인) — bigint — Foreign key → Assignment_post.user_id — NOT NULL
  • start_time (경매 시작 시간) — datetime — NOT NULL
  • deadline (경매 마감 시간) — datetime — NOT NULL
  • start_price (경매 시작가) — bigint — NOT NULL
  • winning_bidder_id (낙찰자) — bigint
  • winning_bid (낙찰가) — bigint
  • status (대기/시작/낙찰/유찰) — varchar — NOT NULL

Auction_transaction (입찰 내역)

  • id (입찰 내역 id) — Primary key — NOT NULL
  • auction_id (경매 id) — Foreign key → Auction.auction_id — NOT NULL
  • bidder_id (입찰자) — NOT NULL
  • suggest_price (제시가) — NOT NULL
  • max_price (최대 입찰가)
  • type (입찰 유형(수동/자동)) — NOT NULL
  • created_at (거래 생성시간) — NOT NULL
  • status (상태 (진행중/유효한 응찰))

Escrow (에스크로)

  • id (에스크로 id) — bigint — Primary key — NOT NULL
  • post_id (양도글 id) — bigint — Foreign key → Assignment_post.post_id — NOT NULL
  • buyer_id (구매자(송금인)) — bigint — NOT NULL
  • seller_id (판매자(수취인)) — bigint — NOT NULL
  • amount (금액) — bigint — NOT NULL
  • status (거래중/거래완료/경매진행중/환불) — varchar — NOT NULL
  • created_at (에스크로 생성일시) — datetime — NOT NULL
  • updated_at (에스크로 갱신일시) — datetime

Like_accommodation (Untitled7)

  • like_id (좋아요 id) — bigint — Primary key — NOT NULL
  • user_id (사용자 id) — bigint — Foreign key → User.user_id — NOT NULL
  • post_id (양도글 id) — bigint — NOT NULL

Media (양도글 관련 파일)

  • id (미디어 id) — bigint — Primary key — NOT NULL
  • post_id (양도글 id) — bigint — Foreign key → Assignment_post.post_id — NOT NULL
  • url (미디어 url) — varchar(2083) — NOT NULL
  • data_format (데이터포멧(jpg, pdf..)) — varchar — NOT NULL
  • type (타입(양도글 이미지, 예약확정서)) — varchar — NOT NULL

Transaction (거래내역)

  • id (거래 id) — bigint — Primary key — NOT NULL
  • user_id (사용자 id) — bigint — Foreign key → User.user_id — NOT NULL
  • amount (금액) — bigint — NOT NULL
  • type (송금/입금/충전) — boolean — NOT NULL
  • descirption (거래명) — varchar — NOT NULL
  • balance (잔액) — bigint — NOT NULL
  • created_at (거래 생성일시) — datetime — NOT NULL

User (사용자)

  • user_id (사용자 id) — bigint — Primary key — NOT NULL
  • email (이메일) — varchar
  • password (비밀번호) — varchar
  • name (이름) — varchar
  • phone (전화번호) — varchar
  • nickname (닉네임) — varchar
  • oauth_id (소셜인증 id) — varchar(36)
  • oauth_provider (인증 제공자) — varchar(50)
  • created_at (생성일시) — datetime
  • updated_at (수정일시) — datetime
  • agreemented_at (가입약관동의 일시) — datetime
  • deleted_at (탈퇴일시) — datetime
  • role (권한) — varchar
  • amount (예치금 잔액) — bigint