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