Skip to content

Database.md

Latest commit

 

History

History
159 lines (122 loc) · 4.77 KB

Database.md

File metadata and controls

159 lines (122 loc) · 4.77 KB
Raw

Database of Dimag Se Khelo

The database of Dimag Se Khelo is present at Firebase-DimageSeKhelo

JSON Header Name : ContestMaster

This table holds the Contest Master for every contest. They will be against a particular match. One particular match may have more >than one contests.

Column Names :

  1. _ContestId: The unique identifier of a contest
  2. _ContestType: The type of the contest
  3. _EntryFeePoints: The entry fee points
  4. _MatchId: The match id for which this contest has been created
  5. _PrizePool: The total prize pool
  6. _TotalStrength: The total strength
  7. _TotalWinners: The total winners

JSON Header Name : UpcomingMatches

This contains all the upcoming matches

Column Names :

  1. _Caption: The Caption of the match describing the match
  2. _Id: The unique identifier
  3. _IsActive: Flag to determine if the match is active
  4. _MatchTime: The timestamp of the match
  5. _MatchType: The type of the match
  6. _TeamName1: The name of the first team
  7. _TeamName2: The name of the second team

JSON Header Name : UserProfile

This contains all the upcoming matches

Column Names :

  1. _EmailId: The email id of the user
  2. _HashedPassword: The hashed password of the user
  3. _MobileNumber: The otp verified mobile number of the user
  4. _Salt: The salt of the hashed passwords

JSON Header Name : PlayerMasterContest

This contains the players playing in a particular match (with an unique Match Id)

Column Names :

  1. _MatchId: The match id of the match
  2. _PlayerCredit: The credit of the player
  3. _PlayerId: The unique player identifier
  4. _PlayerName: The name of the player
  5. _PlayerPictureUrl: The url of the player picture
  6. _PlayerType: The type of the player

JSON Header Name : TeamContest

The mapping between User Phone Number Unique Identifier and Team Id Unique >Identifier for Team

Column Names :

  1. _CaptainPlayerId: The player id of the captain
  2. _IsDelete: If the team has been deleted
  3. _TeamId: The team id of the team
  4. _TeamName: The name of the team
  5. _UserPhoneNumber: The unique identifier of the player
  6. _ViceCaptainPlayerId: The player id of the vice captain
  7. players: List of player ids of the team other than the captain and vice captain

JSON Header Name : ContestUser

The mapping between User Phone Number Unique Identifier and Team Id Unique >Identifier for Team and Contest Id for Contest, it also carries the Points and Rank of the user in the particular contest

Column Names :

  1. _ContestId: Unique Identifier
  2. _ContestJoinTimeStamp: Contest Joining timestamp
  3. _Points: The points earned in the contest
  4. _Rank: The rank of the player in the contest
  5. _TeamId: The team id using which he has joined
  6. _UserPhoneNumber: User phone number of the user who has joined the contest

JSON Header Name : MatchStatus

The status of a particular match

Column Names :

  1. _MatchId: The unique identifier of the match
  2. _MatchStatus: The current status of the match

JSON Header Name : RedeemPoints

To redeem points, send a request to the system

Column Names :

  1. _AccountHolderName: The name of the account holder
  2. _BankAccountNumber: The bank account number
  3. _ContestId: The Contest Id of the particular contest
  4. _IfscCode: The IFSC code of the bank
  5. _MatchId: The match id of the match
  6. _Rank: The Rank of the user
  7. _Score: The Score of the user
  8. _UserPhoneNumber: The phone number of the user

JSON Header Name : CurrentMatches

Running current match score board

Column Names :

  1. _BattingStatus: Batting status of the player
  2. _BoundariesHit: Boundaries hit by the playee
  3. _BowledOvers: Over bowled by the player
  4. _BowlingStatus: Bowling status of the player
  5. _ContestId: Contest Id of the match
  6. _MaidenOvers: Maiden overs of the player
  7. _MatchId: Match Id of the match
  8. _OverBoundariesHit: Over-boundaries hit by the player
  9. _OversFaced: Over faced by the player
  10. _PlayerId: The player id
  11. _PlayerName: The name of the player
  12. _PlayerType: The type of the player
  13. _RunsGiven: The runs given by the player
  14. _RunsScored: The runs scored by the player
  15. _WicketsB: Bowled wickets
  16. _WicketsC: Caught wickets
  17. _WicketsCB: Caught & Bowled wickets
  18. _WicketsR: Run out wickets