universal-device-rental

테이블 (9)

결제 (payments)

  • 결제ID (payment_id) — bigint — 기본 키 — NOT NULL — identity
  • 대여ID (rental_id) — bigint — 외래 키 → 대여.대여ID — NOT NULL — FK(partial unique index)
  • 결제방식 (payment_method) — enum — NOT NULL — CARD,BANK_TRANSFER
  • 결제상태 (status) — enum — NOT NULL — PENDING, PAID, FAILED, CANCELED, REFUNDED
  • 결제금액 (amount_before_discound) — integer — NOT NULL
  • 실제결제금액 (amount) — integer — NOT NULL
  • 포인트사용유무 (point_usage) — boolean — NOT NULL
  • 포인트사용금액 (point_used_amount) — integer
  • 쿠폰사용유무 (coupon_usage) — boolean — NOT NULL
  • 쿠폰사용금액 (coupon_discount_amount) — integer
  • pg사 (pg_company) — varchar(50)
  • pg_tid — varchar(100)
  • 결제일 (paid_at) — timestamp without time zone
  • 취소일 (canceled_at) — timestamp without time zone
  • 환불일 (refunded_at) — timestamp without time zone
  • 생성일 (created_at) — timestamp without time zone — NOT NULL
  • 수정일 (updated_at) — timestamp without time zone — NOT NULL

대여 (rentals)

  • 대여ID (rental_id) — bigint — 기본 키 — NOT NULL — identity
  • 회원ID (user_id) — bigint — 외래 키 → 회원.회원ID — NOT NULL — FK
  • 게시글ID (post_id) — bigint — 외래 키 → 상품게시.게시글ID — NOT NULL — FK
  • 시작일 (start_date) — date — NOT NULL
  • 종료일 (end_date) — date — NOT NULL
  • 실제반납일 (actual_returned_at) — timestamp without time zone
  • 수령방법 (receive_method) — enum — NOT NULL — PARCEL, MEETUP
  • 상태 (status) — enum — NOT NULL — REQUESTED,CONFIRMED,IN_USE,RETURNED,ENDED, CANCELED
  • 전체대여금액 (total_price) — integer — NOT NULL
  • 생성일 (created_at) — timestamp without time zone — NOT NULL
  • 수정일 (updated_at) — timestamp without time zone — NOT NULL

상품게시 (posts)

  • 게시글ID (post_id) — bigint — 기본 키 — NOT NULL — identity
  • 회원ID (user_id) — bigint — 외래 키 → 회원.회원ID — NOT NULL — FK
  • 카테고리ID (category_id) — bigint — 외래 키 → 카테고리.카테고리ID — NOT NULL — FK
  • 제목 (title) — varchar(50) — NOT NULL
  • 내용 (description) — text
  • 가격 (price_per_day) — integer — NOT NULL
  • 택배수령가능여부 (is_parcel_available) — boolean — NOT NULL — +CHECK
  • 대면수령가능여부 (is_meetup_available) — boolean — NOT NULL — +CHECK
  • 상태 (status) — enum — NOT NULL — AVAILABLE, HIDDEN, RESERVED, ENDED
  • 썸네일 (thumbnail_url) — varchar(255)
  • 생성일 (created_at) — timestamp without time zone — NOT NULL
  • 수정일 (updated_at) — timestamp without time zone — NOT NULL

상품이미지 (post_images)

  • 이미지ID (image_id) — bigint — 기본 키 — NOT NULL — identity
  • 게시글ID (post_id) — bigint — 외래 키 → 상품게시.게시글ID — NOT NULL — FK
  • 이미지URL (image_url) — varchar(255)
  • 정렬순서 (sort_order) — smallint
  • 생성일 (created_at) — timestamp without time zone — NOT NULL

카테고리 (categories)

  • 카테고리ID (category_id) — bigint — 기본 키 — NOT NULL — identity
  • 부모ID (parent_id) — bigint
  • 카테고리명 (name) — varchar(50) — NOT NULL
  • 상세정보 (description) — varchar(255)
  • 생성일 (created_at) — timestamp without time zone — NOT NULL
  • 수정일 (updated_at) — timestamp without time zone — NOT NULL

쿠폰 (coupons)

  • 쿠폰ID (coupon_id) — bigint — 기본 키 — NOT NULL — identity
  • 쿠폰명 (coupon_name) — varchar(100) — NOT NULL
  • 상세정보 (description) — varchar(255)
  • 할인유형 (discount_type) — enum — NOT NULL — FIEXD, PERCENT
  • 할인값 (discount_value) — integer — NOT NULL
  • 최대할인금액 (max_discount_amount) — integer
  • 최소결제금액 (min_order_amount) — integer
  • 총발급수량 (total_quantity) — smallint — NOT NULL
  • 현재발급수량 (issued_quantity) — smallint — NOT NULL
  • 유저당제한수량 (per_user_limit) — smallint — NOT NULL
  • 유효시작일 (valid_from) — timestamp without time zone — NOT NULL
  • 유효종료일 (valid_until) — timestamp without time zone — NOT NULL
  • 상태 (status) — enum — NOT NULL — ACTIVE, INACTIVE, ENDED
  • 생성일 (created_at) — timestamp without time zone — NOT NULL
  • 수정일 (updated_at) — timestamp without time zone — NOT NULL

포인트이력 (user_point_history)

  • 이력번호 (history_id) — bigint — 기본 키 — NOT NULL — identity
  • 회원ID (user_id) — bigint — 외래 키 → 회원.회원ID — NOT NULL — FK
  • 유형 (type) — enum — NOT NULL — EARN, SPEND, REFUND, ADJUST
  • 변화량 (amount) — integer — NOT NULL
  • 최종포인트 (final_balance) — integer — NOT NULL
  • 대여ID (rental_id) — bigint — 외래 키 → 대여.대여ID — identity
  • 결제ID (payment_id) — bigint — 외래 키 → 결제.결제ID — identity
  • 생성일 (created_at) — timestamp without time zone — NOT NULL — LOCALTIMESTAMP

회원 (users)

  • 회원ID (user_id) — bigint — 기본 키 — NOT NULL — identity
  • 이름 (name) — varchar(10) — NOT NULL
  • 이메일 (email) — varchar(100) — NOT NULL — unique
  • 비밀번호 (pasasword) — varchar(255) — NOT NULL
  • 닉네임 (nickname) — varchar(15) — NOT NULL — unique
  • 주소 (address) — varchar(255)
  • 은행 (bank) — varchar(20)
  • 계좌번호 (account) — varchar(20)
  • 포인트 (point) — integer — NOT NULL
  • 포인트_ver (point_version) — smallint — NOT NULL
  • 권한 (role) — enum(admin, user) — NOT NULL
  • 휴대폰번호 (phone) — varchar(11) — NOT NULL
  • 생성일 (created_at) — timestamp without time zone — NOT NULL
  • 수정일 (updated_at) — timestamp without time zone — NOT NULL

회원_쿠폰 (user_coupons)

  • 회원_쿠폰ID (user_coupon_id) — bigint — 기본 키 — NOT NULL — identity
  • 회원ID (user_id) — bigint — 외래 키 → 회원.회원ID — NOT NULL — FK
  • 쿠폰ID (coupon_id) — bigint — 외래 키 → 쿠폰.쿠폰ID — NOT NULL — FK
  • 발행일 (issued_at) — timestamp without time zone — NOT NULL
  • 사용일 (used_at) — timestamp without time zone
  • 상태 (status) — enum — NOT NULL — ISSUED, USED, CANCELED
  • 대여ID (rental_id) — bigint — 외래 키 → 대여.대여ID — NOT NULL — identity
  • 결제ID (payment_id) — bigint — 외래 키 → 결제.결제ID — NOT NULL — identity
  • 생성일 (created_at) — timestamp without time zone — NOT NULL
  • 수정일 (updated_at) — timestamp without time zone — NOT NULL