Keybudy

Tables (14)

Category (카테고리)

  • name (이름) — text

Chat (채팅)

  • unique_id (고유번호) — text — Primary key — NOT NULL
  • message (메세지) — text
  • chat_type (채팅유형) — CHAT_TYPE
  • promise (약속) — Promise
  • review (리뷰) — text
  • user (유저) — User — Foreign key → User.email — NOT NULL

ChatRoom (채팅방)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • last_message (마지막 메세지) — text
  • last_message_at (마지막 메세지 일자) — date
  • exchange_request (교환 요청) — ExchangeRequest — Foreign key → ExchangeRequest.unique_id — NOT NULL
  • Seller (판매자) — User — Foreign key → User.email — NOT NULL
  • Consumer (소비자) — User — Foreign key → User.email — NOT NULL

ExchangeRequest (교환 요청)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • request_state (의뢰 상태) — REQUEST_STATE
  • request_at (의뢰 요청 일자) — date
  • promist_at (약속 일자) — date
  • user (유저) — User — Foreign key → User.email — NOT NULL

IndexMedia (시작영상)

  • vedio_file (동영상 파일) — file

Inquiry (문의)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • title (제목) — text
  • contents (내용) — text
  • inquiry_image (문의 이미지) — List<image>
  • inquiry_at (문의 일자) — DateTime
  • answer_user (답변자) — User
  • answer_at (답변 일자) — DateTime
  • inquiry_category (카테고리) — INQUIRY_CATEGORY
  • user (유저) — User — Foreign key → User.email — NOT NULL

Product (상품)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • image (상품 이미지) — List<image>
  • product_name (상품명) — text
  • product_price (상품 가격) — number
  • product_state (상품 상태) — PRODUCT_STATE
  • address (주소) — text
  • address_detail (주소 상세) — text
  • product_description (상품 설명) — text
  • category (카테고리) — CATEGORY
  • brand (브랜드) — BRAND
  • user (유저) — User — Foreign key → User.email — NOT NULL

ProductDetail (상품 상세)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • product (상품) — Product — Foreign key → Product.unique_id — NOT NULL
  • product_description (상품 설명) — text
  • sell_state (판매 상태) — SELL_STATE
  • address (주소) — text
  • address_detail (주소 상세) — text
  • ad_product (광고 상품) — List<Product>
  • customer_review_of_the_seller (소비자의 판매자 리뷰) — text
  • products_from_other_sellers (다른 판매자의 상품) — List<Product>
  • user (유저) — User — Foreign key → User.email — NOT NULL

Report (신고)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • title (제목) — text
  • contents (내용) — text
  • report_image (신고 이미지) — List<image>
  • report_at (문의일자) — DateTime
  • answer_user (답변자) — User
  • answer_at (답변 일자) — DateTime
  • report_category (신고 카테고리) — REPORT_CATEGORY
  • user (유저) — User — Foreign key → User.email — NOT NULL

Term (약관)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • term_type (약관 유형) — TERM_TYPE
  • last_update_at (마지막 업데이트 일자) — date
  • contents (내용) — text

Today_Product (오늘의 상품)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • image (이미지) — image
  • product_name (상품명) — text
  • product (상품) — Product — Foreign key → Product.unique_id — NOT NULL

User (유저)

  • email (이메일) — text — Primary key — NOT NULL
  • phone (전화번호) — number
  • register_at (가입일자) — DateTime
  • point (보유포인트) — number
  • login_type (로그인 타입) — enum
  • user_state (유저상태) — enum
  • user_type (유저타입) — enum
  • nickname (닉네임) — text
  • recently_viewed_Listings (최근 본 상품) — List<Product>

UserLike (관심상품)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • user (유저) — User — Foreign key → User.email — NOT NULL
  • product (상품) — Product — Foreign key → Product.unique_id — NOT NULL

UserNoti (공지)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • title (제목) — text
  • contents (내용) — text
  • created_at (등록날짜) — DateTime
  • user (유저) — User — Foreign key → User.email — NOT NULL