RooTale
Tables (10)
AuthenticationProvider (Untitled)
- providerKey (Key) — varchar — Primary key — NOT NULL
- userID (id) — Foreign key → user.id — NOT NULL
- providerType (Field2) — enum
character (Untitled5)
- id (Key) — Primary key — NOT NULL
- universeID (Key2) — Foreign key → universe.id — NOT NULL
- name (Field)
- description (Field2)
- personality (Field3)
- avatarURL (Field4)
fcmToken (Untitled6)
- Key — Primary key — NOT NULL
- userID (id) — Foreign key → user.id — NOT NULL
- deviceToken (Field)
- isActive (Field2)
- notificationEnabled (Field4)
- tokenCheckTime (Field3)
feedback (Untitled8)
- id (Key) — Primary key — NOT NULL
- userID (id) — Foreign key → user.id — NOT NULL
- category (Field) — enum
- title (Field2)
- content (Field3)
follows (Untitled3)
- followerId, followingId (id) — Foreign key → user.id — NOT NULL
topic (Untitled9)
- Key — Primary key — NOT NULL
- userID (id) — Foreign key → user.id — NOT NULL
- name (Field)
universe (Untitled4)
- id (Key) — Primary key — NOT NULL
- name (Field3)
- representativeImageURL (Field)
- description (Field5)
- estimatedPlayTime (Field2)
- startMessage (Field4)
user (사용자)
- id — Primary key — NOT NULL
- email (Field) — varchar
- name (Field2) — varchar
- nickname (Field5) — varchar
- avartarURL (Field3) — varchar
- subscriptionTier (Field6) — varchar
- userType (Field4) — enum
- isActive (Field7) — boolean
userSettings (Untitled2)
- userId (id) — Foreign key → user.id — NOT NULL
- theme (Field) — varchar
- language (Field2) — varchar
- notifyEmail (Field3) — boolean
- notifyPush (Field4) — boolean
- notifyStoryUpdates (Field5) — boolean
- profileVisibility (Field6) — boolean
- storySharing (Field7) — boolean
- autoSave (Field9) — boolean
- imageQuality (Field10)
userUniverse(Mapping) (Untitled7)
- id (Key) — Primary key — NOT NULL
- userID (id) — Foreign key → user.id — NOT NULL
- universeID (Key2) — Foreign key → universe.id — NOT NULL
- lastRead (Field)