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