Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 20th, 2012  |  syntax: None  |  size: 0.53 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. How would I design this MySQL schema?
  2. User table
  3. ------------
  4. UserId
  5. Name
  6.  
  7. UserAttribute table
  8. ---------------------
  9. UserId
  10. AttributeId
  11. Value
  12.  
  13. Attribute table
  14. ------------------
  15. AttributeId
  16. AttributeName
  17.        
  18. Users Table
  19. -----------
  20.  UserId
  21.  RelationshipId
  22.  StatusId
  23.  WorkId
  24.  HometownId
  25.  SchoolId
  26.  
  27. Relationships Table
  28. -----------
  29.  RelationshipId
  30.  RelationshipText
  31.        
  32. User
  33.     UserId
  34.     Name
  35.     OtherRelativelyStraighforwardUserInformation
  36.  
  37. Attribute
  38.     AttributeId
  39.     AttributeText
  40.  
  41. UserAttributes
  42.     UserId
  43.     AttributeId
  44.     Value
create a new version of this paste RAW Paste Data