ㅁㅁㅁ

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>