thirty_days_lab_demo

Tables (6)

ClientDevices

  • id (clientDeviceID) — Int — Primary key — NOT NULL
  • userID — Int — Foreign key → Users.id — NOT NULL
  • operatingSystem — Int — NOT NULL — 0: iOS, 1: Android
  • fcmToken — String
  • isPushOn — Boolean
  • isSignedIn — Boolean
  • language — String
  • notificationStatus — String — NOT NULL — granted, denied, unknown, provisional

NotificationGroupTypes

  • id (notificationGroupTypeID) — Int — Primary key — NOT NULL
  • name (notificationGroupTypeName) — String — NOT NULL
  • description (notificationGroupTypeDescription) — String — NOT NULL
  • status — Int — NOT NULL

NotificationGroups (NotificationChannels)

  • id (groupID) — Int — Primary key — NOT NULL
  • userID — Int — Foreign key → Users.id — NOT NULL
  • notificationChannelTypeID (notificationGroupTypeID) — Int — Foreign key → NotificationGroupTypes.id — NOT NULL
  • isOn — Boolean

Notifications

  • id (notificationID) — Int — Primary key — NOT NULL
  • groupID — Int — Foreign key → NotificationGroups.id — NOT NULL
  • title — String
  • body — String
  • eventType — String
  • eventValue — String

UserNotifications

  • id (userID) — Int — Foreign key → Users.id — NOT NULL
  • id (notificationID) — Int — Foreign key → Notifications.id — NOT NULL

Users

  • id (userID) — Int — Primary key — NOT NULL
  • username — String — NOT NULL
  • password — String
  • mobile — String
  • clientSecretKey — String
  • profileImageURL — String