• Welcome to Mabinogi Duel Forum!
  • Check out our Wiki for even more game infos!
  • Check here for the status of our current projects
Hello There, Guest! Facebook Login Login Register


Card database - Suggestion, feedback & discussion thread (Phase: Brainstorming)
#1
This is planned to be the heart for nearly all automated feature in the forum:
Trading widget, daily mutant widget, card price widget and so on

Here the SQL structure for the cards database:
Code:
CARDS DB
Cards table
    - name (name plus set -> DragToHell_WNB) -> unique?-> ID?
    - set
    - card discussion forum link (via ingame name, since the set is irrelevant
    - mutant - yes/no -> redundant with the next?/card name
    - rotation mutant - yes/no -> redundant with table Rotation_mutants
    - Epoli's attributes:
        - Color
        - mutant "gene" -> redundant as well? -> Nah, we need that to filter out the mutants for the bad words DB for example
        - description (blob)
    - price link (current/last/median?)
    
Alternative_names table (abbreviations) - I try to make the card filter and other things work with this to make typing easier
    - ID
    - alt name
    - foreign key -> Cards_name [unique]


Rotation_mutants table
    - ID
    - foreign key -> Cards_name [unique]
    - when
    - drop chance

Ratings table
    - ID
    - foreign key -> Cards_name [unique]
    - rating
    - date
    - user
    - notes/reasons (optional, blob)
    
Nerfs/boosts table
    - ID
    - foreign key -> Cards_name [unique]
    - what changed (old -> new)
    - date
    - user
    - notes/reasons (optional, blob)

Price widget(selling!!!!) table
    - ID
    - foreign key -> Cards_name [unique]
    - price
    - date entered (sold?)
    - user
    
TRADING widget table
    - ID
    - foreign key -> Cards_name [unique]
    - set (auto from Cards_name) -> NOPE, per SELECT in the tool
    - condition
    - price
    - sell/buy
    - user
    - date entered

These are the tables I came up with so far.
If anyone knows what this is and has some more input on this, feel free to comment.
If you want to know more about specifics or what this is, just ask...I just didnt want to post a text wall if nobody reads it anyway.
 
Reply
  


Possibly Related Threads...
Thread Author Replies Views Last Post
Lightbulb Chat/Shoutbox - Suggestion, feedback & discussion thread InfiniteEvil 16 762 01-06-2017, 05:41 PM
Last Post: Khang Beo
Bug New Trading Widget - Suggestion, feedback & discussion thread (Phase: Brainstorming) sicut 31 2,449 11-29-2016, 01:11 PM
Last Post: sicut
  Pricing Widget - Suggestion, feedback & discussion thread (Phase: Brainstorming) sicut 0 111 11-29-2016, 11:27 AM
Last Post: sicut
  [Suggestion] Card Color Camp Exclusivity Kasmot 5 556 08-08-2016, 05:30 AM
Last Post: sicut
Question Forum update 2016/07/28 discussion thread - What's better / what's worse? sicut 28 1,771 08-08-2016, 05:13 AM
Last Post: sicut

Forum Jump:


Browsing: 1 Guest(s)



Website Security Test