• 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
    - 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
    - when
    - drop chance

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

Price widget(selling!!!!) table
    - ID
    - foreign key -> Cards_name
    - price
    - date entered (sold?)
    - user
    
TRADING widget table
    - ID
    - foreign key -> Cards_name
    - 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
Bug New Trading Widget - Suggestion, feedback & discussion thread (Phase: Brainstorming) sicut 34 2,943 02-01-2017, 06:35 PM
Last Post: sicut
  Arena Viewer (Top 10 decks) feedback thread sicut 3 306 01-28-2017, 10:34 AM
Last Post: Haides
Lightbulb Chat/Shoutbox - Suggestion, feedback & discussion thread InfiniteEvil 16 1,020 01-06-2017, 05:41 PM
Last Post: Khang
  Pricing Widget - Suggestion, feedback & discussion thread (Phase: Brainstorming) sicut 0 166 11-29-2016, 11:27 AM
Last Post: sicut
  [Suggestion] Card Color Camp Exclusivity Kasmot 5 614 08-08-2016, 05:30 AM
Last Post: sicut

Forum Jump:


Browsing: 1 Guest(s)



Website Security Test