TwoNine
Tables (10)
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
InterestCategories
- id (interestCategoryID) — Int — Primary key — NOT NULL
- name (categoryName) — String
- Field
Interests
- id (interestID) — Int — Primary key — NOT NULL
- Field
MatchUsers
- id — Int — Primary key — NOT NULL
- user1ID — Int — Foreign key → Users.id — NOT NULL
- user2ID — Int — Foreign key → Users.id — NOT NULL
Matches
- id (matchID) — Int — Primary key — NOT NULL
- matchUsersID — Int — Foreign key → MatchUsers.id — NOT NULL
- channelName — String
- accessToken — Int
- goCount — Int
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
- gender — Int — NOT NULL — 0: female, 1: male
- mobile — String
- clientSecretKey — String
- profileImageURL — String
- profileImageReference — String