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)