carrot-market

Tables (10)

BADGE(attribute) (활동뱃지)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • display (뱃지명) — text
  • conditon (획득조건) — text
  • image (이미지) — image

ChatMessage (채팅 메세지)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • message (채팅메세지) — text
  • chat (채팅방) — chat — Foreign key → chat.Unique_id — NOT NULL
  • image (이미지 첨부) — image
  • create_at (생성일)

Comment (댓글)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • contents (내용) — text
  • user (작성자) — user — Foreign key → User.Unique_id — NOT NULL
  • neighborhood lift (동네생활글) — Neighborhood life — Foreign key → Neighborhood life.Unique_id — NOT NULL
  • create_at (생성일) — date

Neighborhood life (동네생활)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • title (제목) — text
  • contents (설명) — text
  • subject_category_detail (게시글주제) — SUBJECT_CATEGORY_DETAIL
  • user (작성자) — User — Foreign key → User.Unique_id — NOT NULL
  • view_count (조회수) — number
  • create_at (생성일) — date
  • rank (조회수+댓글 수) — number

Product (상품)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • image (상품이미지) — List<image>
  • title (제목) — text
  • contents (상품설명) — text
  • price (가격) — number
  • Seller (판매자) — user — Foreign key → User.Unique_id — NOT NULL
  • category (카테고리) — CATEGORY_TYPE
  • product_state (상품상태) — PRODUCT_STATE
  • create_at (생성일) — date
  • Buyer (구매자) — user — Foreign key → User.Unique_id — NOT NULL
  • neighborhood_type (동네) — NEIGHBORHOOD_TYPE
  • userlike (유저 좋아요) — List<User>

Promise (약속)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • date (날짜) — date
  • create_at (생성일) — date
  • place (장소) — text
  • time (시간) — date
  • chatmessage (채팅메세지) — ChatMessage — Foreign key → ChatMessage.Unique_id — NOT NULL

SUBJECT_CATEGORY (동네생활 카테고리)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • icon (카테고리 이미지) — iamge
  • display (카테고리명) — text

SUBJECT_CATEGORY_DETAIL (카테고리 상세)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • display (카테고리 상세명) — text
  • subject_category (카테고리) — SUBJECT_CATEGORY — Foreign key → SUBJECT_CATEGORY.Unique_id — NOT NULL

User (유저)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • e-mail (이메일) — text
  • nickname (닉네임) — text
  • neighborhood (동네) — NEIGHBORHOOD_TYPE
  • badge (뱃지) — List<BADGE>

chat (채팅방)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • user (유저) — List<user> — Foreign key → User.Unique_id — NOT NULL
  • product (상품) — Product — Foreign key → Product.Unique_id — NOT NULL
  • create_at (생성일) — date
  • is_read (채팅 읽음 여부) — boolean