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