ㅁㅁㅁ
Tables (5)
BADGE (뱃지)
- Unique_id (고유아이디) — text — Primary key — NOT NULL
- display (뱃지명) — text
- image (이미지) — image
- conditions (획득조건) — text
Chat (채팅방)
- Unique_idey (고유아이디) — text — Primary key — NOT NULL
- user (채팅참여유저) — List<User> — Foreign key → User.Unique_id — NOT NULL
- story (세계관) — Story — Foreign key → Story.Unique_id — NOT NULL
- is_read (채팅읽음여부) — boolean
- create_at (생성일) — Date
ChatMessage (채팅메세지)
- Unique_idey (고유아이디) — text — Primary key — NOT NULL
- message (채팅메세지) — text
- create_at (생성일) — Date
- chat (채팅방) — Chat — Foreign key → Chat.Unique_idey — NOT NULL
- image (채팅이미지) — image
Story (세계관)
- Unique_id (고유아이디) — text — Primary key — NOT NULL
- main_image (메인이미지) — image
- title (제목) — text
- contents (설명) — text
- category (카테고리) — CATEGORY_TYPE
- userlike (좋아요) — List<User> — Foreign key → User.Unique_id — NOT NULL
- writer (작성자) — User — Foreign key → User.Unique_id — NOT NULL
- viewer (시청자) — User — Foreign key → User.Unique_id — NOT NULL
- create_at (생성일) — Date
User (유저)
- Unique_id (고유아이디) — text — Primary key — NOT NULL
- email (이메일) — text
- nickname (닉네임) — text
- profile_image (프로필이미지) — image
- badge (뱃지) — List<BADGE>