Winky

Tables (6)

Auth (회원)

  • User Id (uid) — String — Primary key — NOT NULL
  • Phone (identifier) — String — NOT NULL
  • Created Time (createdAt) — DateTime — NOT NULL
  • Latest Loged Time (logedAt) — DateTime

Comments (댓글)

  • Comment Id (commentId) — String — Primary key — NOT NULL
  • Post Id (postId) — String — Foreign key → Posts.Post Id — NOT NULL
  • Room Id (roomId) — String — Foreign key → Posts.Room Id — NOT NULL
  • Author Id (uid) — String — Foreign key → Posts.Author Id — NOT NULL
  • Content (text) — Text — NOT NULL
  • Created At (createdAt) — DateTime — NOT NULL
  • Updated At (updatedAt) — DateTime — NOT NULL
  • Is Deleted Or Not (isDeleted) — Bool — NOT NULL

Invites (초대)

  • Invite Code (inviteCode) — String — Primary key — NOT NULL
  • User Id (uid) — String — Foreign key → Users.User Id — NOT NULL
  • Inviter UID (inviterUid) — String — NOT NULL
  • Expires At (expireDate) — DateTime — NOT NULL

Posts (게시글)

  • Post Id (postId) — String — Primary key — NOT NULL
  • Room Id (roomId) — String — Foreign key → Rooms.Room Id — NOT NULL
  • Author Id (uid) — String — Foreign key → Rooms.User Id — NOT NULL
  • Created At (createdAt) — DateTime — NOT NULL
  • Updated At (updatedAt) — DateTime — NOT NULL
  • Front Image URL (frontImageURL) — URL — NOT NULL
  • Back Image URL (backImageURL) — URL — NOT NULL
  • Caption (caption) — Text
  • Sticker's Original Post Id (stickerPostId) — String
  • Sticker Emotion (stickerType) — String
  • Is Deleted Or Not (isDeleted) — Bool — NOT NULL

Rooms (부모-자녀 방)

  • Room Id (roomId) — String — Primary key — NOT NULL
  • User Id (uid2) — String — Foreign key → Users.User Id — NOT NULL
  • Participants (participants) — Array
  • Created At (createdAt) — DateTime — NOT NULL

Users (사용자)

  • User Id (uid) — String — Foreign key → Auth.User Id — NOT NULL
  • User Name (name) — String — NOT NULL
  • Role (role) — String
  • Room Id (roomId) — String — NOT NULL
  • Created At (createdAt) — DateTime — NOT NULL
  • Updated At (updatedAt) — DateTime — NOT NULL