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>