carrot market

Tables (7)

AeraPlace (동네생활)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • user (유저) — User — Foreign key → User.Unique_id — NOT NULL
  • catgory_detail (주제) — CATEGORY_DETAIL
  • creat_at (생성일) — date
  • title (제목) — text
  • edit (내용) — text

Area (위치)

  • creat_at (셍성일) — Date
  • chat_massege (채팅메시지) — ChatMassge — Foreign key → ChatMassege.Unique_id — NOT NULL
  • dates (날짜) — Date
  • time (시간) — Date
  • place (장소) — text

CATGORY_DETAIL (동네생활대분류)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • catgory_detail (주제) — CATEGORY_DETAIL

Chat (채팅)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • user (채팅유저) — List<User> — Foreign key → User.Unique_id — NOT NULL
  • product (고유아이디2) — Product — Foreign key → Product.Unique_id — NOT NULL
  • is_read (확인여부) — boolean
  • creat_at (셍성일) — Date
  • Field

ChatMassege (메시지)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • is_read (확인여부) — boolean
  • creat_at (셍성일) — Date
  • chat (채팅방) — Chat — Foreign key → Chat.Unique_id — NOT NULL
  • image (이미지) — Image
  • Field

Product (상품)

  • Unique_id (고유아이디) — text — Primary key — NOT NULL
  • profile_image (프로필이미지) — List<image>
  • title (제목) — text
  • category (카테고리) — CATEGORY_TYPE
  • price (가격) — number
  • userlike (좋아요) — List<User> — Foreign key → User.Unique_id — NOT NULL
  • product_state (상품상태) — PRODUCT_STATE
  • seller (판매자) — User — Foreign key → User.Unique_id — NOT NULL
  • buyer (구매자) — User — Foreign key → User.Unique_id — NOT NULL
  • creat_at (상품등록날짜) — Date
  • area_type (동네) — AREA_TYPE

User (사용자)

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