Keybudy
Tables (14)
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