Welcome to TCG Creation, where you can ask questions and receive answers from other members of the community.

What information do we need to persist?

1 like 0 dislike
Which data do we need to persist between games, most likely with a RDMS? (most likely PostgreSQL)
asked Aug 26, 2014 by SimonAndréForsberg (2,670 points)

2 Answers

1 like 0 dislike

User logins

User Id
Display Name
Password (in plain text of course! `</sarcasm>`)
E-mail
Signup date
Last seen date
 

answered Aug 27, 2014 by SimonAndréForsberg (2,670 points)
1 like 0 dislike

User Decks

Deck Id
Deck Name
Deck Type (if applicable)
Game Mod Id
Owner Id (Foreign Key to user_logins.userid)


User Deck Cards (many to many relationship between decks and card)

Deck Id
Card Id / Card Name
Amount


I don't think there should be a table for the cards themselves as they are provided from scripts

answered Aug 27, 2014 by SimonAndréForsberg (2,670 points)
...