Advertisement
Guest User

Untitled

a guest
Jul 21st, 2019
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.10 KB | None | 0 0
  1. MKS Data Structure:
  2.  
  3. Users
  4. UserId - Auto-generated number representing the user
  5. UserName - The user's unique name
  6. CreatedOn - The date the record was created
  7. CreatedBy - Who/what the record was created by
  8. ModifiedOn - The date the record was last updated
  9. ModifiedBy - Who/What the record was last updated by
  10. ObsoletedOn - The date the record was deleted, or null if the record is active
  11. ObsoletedBy - Who/What the record was deleted by, or null if the record is active.
  12.  
  13. Auth
  14. AuthId - Auto-generated number representing this auth entry
  15. UserId - The ID of the user that the login belongs to
  16. Type - The type of login (email, Google, Facebook, Discord, ect)
  17. Identifier - The Identifier for the login (the user's email address)
  18. Token - The unique token used differently by the platforms. Could also be used for a reset token when type is email.
  19. Hash - The hash of sensitive data (Password)
  20. Salt - One of the salts used to hash the sensitive data
  21. Status - The status of the users availability to login (whether it needs to be reset, locked out, or suspended)
  22. CreatedOn - The date the record was created
  23. CreatedBy - Who/what the record was created by
  24. ModifiedOn - The date the record was last updated
  25. ModifiedBy - Who/What the record was last updated by
  26. ObsoletedOn - The date the record was deleted, or null if the record is active
  27. ObsoletedBy - Who/What the record was deleted by, or null if the record is active.
  28.  
  29. Logins
  30. LoginId - Auto-generated number representing this login attempt
  31. AuthId - What authentication media was attempt
  32. Status - A number representing the type of attempt result (successful, invalid email, invalid password, invalid captcha, ect)
  33. IpAddress - The IP Address of the user attempting the connection
  34. Attempt - A string representing the attempted value (Email Address)
  35. CreatedOn - The date the record was created
  36. CreatedBy - Who/what the record was created by
  37. ModifiedOn - The date the record was last updated
  38. ModifiedBy - Who/What the record was last updated by
  39.  
  40. Organization
  41. OrgId
  42. OwnerId
  43. Name
  44. Description
  45. DefaultPermissions
  46. CreatedOn - The date the record was created
  47. CreatedBy - Who/what the record was created by
  48. ModifiedOn - The date the record was last updated
  49. ModifiedBy - Who/What the record was last updated by
  50. ObsoletedOn - The date the record was deleted, or null if the record is active
  51. ObsoletedBy - Who/What the record was deleted by, or null if the record is active.
  52.  
  53. Servers
  54. ServerId - The auto-generated number representing this server
  55. OrgId - The organization the server falls under or null if it's not attached to an organization
  56. Guid - The GUID used for this server across the system
  57. Name - The name of this server
  58. Type - The type of game used for this server
  59. CreatedOn - The date the record was created
  60. CreatedBy - Who/what the record was created by
  61. ModifiedOn - The date the record was last updated
  62. ModifiedBy - Who/What the record was last updated by
  63. ObsoletedOn - The date the record was deleted, or null if the record is active
  64. ObsoletedBy - Who/What the record was deleted by, or null if the record is active.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement