carrot market

Tables (11)

BADGE (뱃지)

  • Unique_id (고유번호) — text — Primary key — NOT NULL
  • display (뱃지명) — text
  • badge_image (뱃지이미지) — image
  • condition (획득조건) — text

Chat (채팅)

  • Unique_id (고유번호) — text — Primary key — NOT NULL
  • is_read (열람유무) — boolean
  • create_id (판매일) — Date
  • user (채팅참여유저) — List<User> — Foreign key → User.Unique_id — NOT NULL
  • product (상품) — Product — Foreign key → Product.Unique_id — NOT NULL

ChatMessage (채팅메세지)

  • Unique_id (고유번호) — text — Primary key — NOT NULL
  • create_id (생성일) — date
  • chat (채팅방) — Chat — Foreign key → Chat.Unique_id — NOT NULL
  • message (채팅메세지) — text
  • image (채팅이미지) — image

Comment (댓글)

  • Unique_id (고유번호) — text — Primary key — NOT NULL
  • user (사용자) — User — Foreign key → User.Unique_id — NOT NULL
  • create_dt (생성일) — Date
  • contents (내용) — text
  • neighborhood (동네생활) — Neighborhood — Foreign key → Neighborhood.Unique_id — NOT NULL

Neighborhood (동네생활)

  • Unique_id (고유번호) — text — Primary key — NOT NULL
  • subject_category_detail (게시글주제) — SUBJECT_CATEGORY_DETAIL
  • user (사용자) — User — Foreign key → User.Unique_id — NOT NULL
  • neighborhood_type (동네) — NEIGHBORHOOD_TYPE
  • create_dt (생성일) — Date
  • title (제목) — text
  • contents (내용) — text
  • view_count (조회수) — number
  • rank (조회수+댓글수) — number

Product (상품)

  • Unique_id (고유번호) — text — Primary key — NOT NULL
  • product_image (상품이미지) — List<image>
  • title (제목) — text
  • contexts (설명) — text
  • category (카테고리) — CATEGORY_TYPE
  • price (가격) — number
  • user_like (좋아요) — List<User> — Foreign key → User.Unique_id — NOT NULL
  • product_statue (상품상태) — STATUS_TYPE
  • seller (판매자) — User — Foreign key → User.Unique_id — NOT NULL
  • buyer (구매자) — User — Foreign key → User.Unique_id — NOT NULL
  • create_id (판매일) — Date
  • neighborhood_type (동네) — NEIGHBORHOOD_TYPE

Promise (약속)

  • Unique_id (고유번호) — text — Primary key — NOT NULL
  • create_id (생성일) — Date
  • image (채팅이미지) — image
  • chat_message (채팅메세지) — ChatMessage — Foreign key → ChatMessage.Unique_id — NOT NULL
  • date (날짜) — date
  • time (시간) — date
  • place (장소) — text

SUBJECT_CATEGOTY (동네생활 카테고리)

  • Unique_id (고유번호) — text — Primary key — NOT NULL
  • display (카테고리명) — text
  • icon (아이콘) — image

SUBJECT_CATEGOTY_DETAIL (동네생활 카테고리 상세)

  • Unique_id (고유번호) — text — Primary key — NOT NULL
  • display (카테고리명) — text
  • category (동네생활 카테고리) — SUBJECT_CATEGOTY — Foreign key → SUBJECT_CATEGOTY.Unique_id — NOT NULL

User (유저)

  • Unique_id (고유번호) — text — Primary key — NOT NULL
  • email (이메일) — text
  • nick_name (닉네임) — text
  • neighborhood (동네) — NEIGHBORHOOD_TYPE
  • profile_image (프로필사진) — image
  • badge (뱃지) — List<BADGE>

UserLike (유저 좋아요)

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