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