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