villi-easy

Tables (11)

Chat (Untitled5)

  • 채팅ID (chat_id) — uuid — Primary key — NOT NULL
  • 대여요청ID (rental_request_id) — uuid — Foreign key → RentalRequest.대여요청ID — NOT NULL
  • 소유자ID (owner_id) — uuid — Foreign key → User.유저ID — NOT NULL
  • 대여자ID (requester_id) — uuid — Foreign key → User.유저ID — NOT NULL
  • 메시지 (message) — varchar
  • 읽음 여부 (is_read) — boolean
  • 메시지 시각 (sent_at) — timestamp

DeliveryProof (Untitled7)

  • 대여사진ID (proof_id) — Primary key — NOT NULL
  • 대여ID (rental_id) — uuid — Foreign key → Rental.대여ID — NOT NULL
  • 대여상태 (type) — varchar
  • 이미지URL (image_url) — varchar
  • 생성일자 (created_at) — timestamp
  • 수정일자 (updated_at) — timestamp
  • 삭제일자 (deleted_at) — timestamp

Item (Untitled2)

  • 물품ID (item_id) — uuid — Primary key — NOT NULL
  • 유저ID (user_id) — uuid — Foreign key → User.유저ID
  • 물품 이름 (name) — varchar — NOT NULL
  • 카테고리 (category) — varchar
  • 설명 (description) — text
  • 1일 대여 비용 (rental_fee_per_day) — int
  • 보증금 (deposit) — int
  • 대여 상태 (status) — varchar
  • 주소 (address1) — varchar
  • 상세주소 (address2) — varchar
  • 생성일자 (created_at) — timestamp
  • 수정일자 (updated_at) — timestamp
  • 삭제일자 (deleted_at) — timestamp

Notification (Untitled11)

  • 알림ID (notification_id) — uuid — Primary key — NOT NULL
  • 유저ID (user_id) — uuid — Foreign key → User.유저ID — NOT NULL
  • 타입 (type) — varchar
  • 제목 (title) — varchar
  • 내용 (body) — varchar
  • 확인 여부 (is_read) — boolean
  • 발송 시각 (sent_at) — timestamp

Payment (Untitled6)

  • 결제ID (payment_id) — uuid — Primary key — NOT NULL
  • 대여ID (rental_id) — uuid — Foreign key → Rental.대여ID — NOT NULL
  • 결제금액 (amount) — int
  • Field2
  • Field3
  • Field4
  • Field5

Rental (Untitled4)

  • 대여ID (rental_id) — uuid — Primary key — NOT NULL
  • 대여요청ID (rental_request_id) — uuid — Foreign key → RentalRequest.대여요청ID — NOT NULL
  • 대여자ID (requester_id) — uuid — Foreign key → User.유저ID — NOT NULL
  • 소유자ID (owner_id) — uuid — Foreign key → User.유저ID — NOT NULL
  • 물품ID (item_id) — uuid — Foreign key → Item.물품ID — NOT NULL
  • 총 금액 (total_fee) — int
  • 대여상태 (status) — varchar
  • 수령시간 (pickup_at) — timestamp
  • 반납시간 (returned_at) — timestamp
  • 생성일자 (created_at) — date
  • 수정일자 (updated_at) — date
  • 삭제일자 (deleted_at) — date

RentalRequest (Untitled3)

  • 대여요청ID (rental_request_id) — uuid — Primary key — NOT NULL
  • 대여자ID (user_id) — uuid — Foreign key → User.유저ID — NOT NULL
  • 물품ID (item_id) — uuid — Foreign key → Item.물품ID — NOT NULL
  • 대여시작일 (start_date) — date
  • 대여종료일 (end_date) — date
  • 거래시간 (meeting_time) — timestamp
  • 거래장소 (meeing_location) — varchar
  • 요청상태 (status) — varchar
  • 생성일자 (created_at) — timestamp
  • 수정일자 (updated_at) — timestamp
  • 삭제일자 (deleted_at) — timestamp

Review (Untitled9)

    User (Untitled)

    • 유저ID (user_id) — uuid — Primary key — NOT NULL
    • 이름 (nickname) — varchar
    • 이메일 (email) — varchar
    • 휴대폰번호 (phone) — varchar
    • 비밀번호 (password) — varchar
    • 프로필 사진 (profile_image) — varchar
    • 인증여부 (is_verified) — boolean
    • 인증일자 (identity_verified_at) — date
    • 생성일자 (created_at) — timestamp
    • 수정일자 (updated_at) — timestamp
    • 탈퇴일자 (deleted_at) — timestamp

    UserGrade (Untitled10)

      issue (Untitled8)

      • 신고ID (issue_id) — uuid — Primary key — NOT NULL
      • 대여ID (rental_id) — uuid — Foreign key → Rental.대여ID — NOT NULL
      • 신고자ID (repoter_id) — uuid
      • 제목 (title) — varchar
      • 내용 (context) — text
      • 처리상태 (status) — varchar
      • 생성일자 (created_at) — timestamp
      • 수정일자 (updated_at) — timestamp
      • 삭제일자 (deleted_at) — timestamp