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