carrot-market

Tables (3)

Chat (채팅방)

  • Unique_id (고유 아이디) — text — Primary key — NOT NULL
  • user (채팅참여유저) — List<User>
  • product (상품) — Product
  • Unique_id (고유 아이디2) — text — Foreign key → User.Unique_id — NOT NULL
  • Unique_id (고유 아이디3) — text — Foreign key → Product.Unique_id — NOT NULL

Product (상품)

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

User (유저)

  • Unique_id (고유 아이디) — text — Primary key — NOT NULL
  • email (이메일) — text
  • nickname (닉네임) — text
  • neighborhood (동네) — NEIGHBORHOOD_TYPE
  • profile_image (프로필이미지) — image
  • badge (뱃지) — List<BADGE>
  • Field