Skip to content

Latest commit

 

History

History
64 lines (58 loc) · 1.31 KB

Entities.md

File metadata and controls

64 lines (58 loc) · 1.31 KB

Entities List XML SQL

Entities

  1. Address
  • Unit #
  • Street Address
  • City
  • Province / State / Region
  • Country
  • Postal Code
  1. User
  • Password(Hashed)
  • Hash Salt
  • Email
    • Verification key (for validating)
    • Was it verified?
    • Allows marketing?
  • Phone Number
  • Display Name
  • Gender
  • Full Name
  • Date of Birth
  • Friends
  • Stripe Email
  • Stripe ID
  1. Credit Card
  • Number
  • CVV
  • Expiration
  1. Game
  • Name
  • Category
  • Platform
  • Release Date
  • Price
  1. Order
  • Games
  • Order Date
  • Ship Date
  1. Review
  • Rating
  • Subject Text
  • Context Text
  1. Platform
  • Name
  1. Category
  • Name
  1. Friendship
  • isFamilyMember
  • isAccepted

Relationships

A relational database using these entities might look something like this

Entities

This diagram was created with http://ondras.zarovi.cz/sql/demo/

You can load the XML into that web editor by clicking the "save / load" button at the top right, pasting the XML into the textarea and clicking "Load XML".

You can load the version stored on their servers by instead clicking the "load" button in the server section and paste/type "SeaSharpe" into the dialogue box. This is probably easier and faster but it might not be the same version stored in this repository.