Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MKS Data Structure:
- Users
- UserId - Auto-generated number representing the user
- UserName - The user's unique name
- CreatedOn - The date the record was created
- CreatedBy - Who/what the record was created by
- ModifiedOn - The date the record was last updated
- ModifiedBy - Who/What the record was last updated by
- ObsoletedOn - The date the record was deleted, or null if the record is active
- ObsoletedBy - Who/What the record was deleted by, or null if the record is active.
- Auth
- AuthId - Auto-generated number representing this auth entry
- UserId - The ID of the user that the login belongs to
- Type - The type of login (email, Google, Facebook, Discord, ect)
- Identifier - The Identifier for the login (the user's email address)
- Token - The unique token used differently by the platforms. Could also be used for a reset token when type is email.
- Hash - The hash of sensitive data (Password)
- Salt - One of the salts used to hash the sensitive data
- Status - The status of the users availability to login (whether it needs to be reset, locked out, or suspended)
- CreatedOn - The date the record was created
- CreatedBy - Who/what the record was created by
- ModifiedOn - The date the record was last updated
- ModifiedBy - Who/What the record was last updated by
- ObsoletedOn - The date the record was deleted, or null if the record is active
- ObsoletedBy - Who/What the record was deleted by, or null if the record is active.
- Logins
- LoginId - Auto-generated number representing this login attempt
- AuthId - What authentication media was attempt
- Status - A number representing the type of attempt result (successful, invalid email, invalid password, invalid captcha, ect)
- IpAddress - The IP Address of the user attempting the connection
- Attempt - A string representing the attempted value (Email Address)
- CreatedOn - The date the record was created
- CreatedBy - Who/what the record was created by
- ModifiedOn - The date the record was last updated
- ModifiedBy - Who/What the record was last updated by
- Organization
- OrgId
- OwnerId
- Name
- Description
- DefaultPermissions
- CreatedOn - The date the record was created
- CreatedBy - Who/what the record was created by
- ModifiedOn - The date the record was last updated
- ModifiedBy - Who/What the record was last updated by
- ObsoletedOn - The date the record was deleted, or null if the record is active
- ObsoletedBy - Who/What the record was deleted by, or null if the record is active.
- Servers
- ServerId - The auto-generated number representing this server
- OrgId - The organization the server falls under or null if it's not attached to an organization
- Guid - The GUID used for this server across the system
- Name - The name of this server
- Type - The type of game used for this server
- CreatedOn - The date the record was created
- CreatedBy - Who/what the record was created by
- ModifiedOn - The date the record was last updated
- ModifiedBy - Who/What the record was last updated by
- ObsoletedOn - The date the record was deleted, or null if the record is active
- 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