• Welcome to Mabinogi Duel Forum!
  • New themes...yay!
  • Specifics and feedback here
Hello There, Guest! Login Register FB

Dismiss this notice
We are aware that site registration wasn't possible the last few days due to a software bug.
Please excuse any inconvenience and try again. It should be fixed now.


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.
Looking for rare/SE/AA/collab cards? -> my sales thread
Want to sell some gems? -> my WTB gems thread
If you want to support my work, send me some gems and/or leave some feedback Smile

 
Reply
  


Possibly Related Threads...
Thread Author Replies Views Last Post
Bug New Trading Widget - Suggestion, feedback & discussion thread (Phase: Brainstorming) sicut 34 3,838 02-01-2017, 06:35 PM
Last Post: sicut
  Arena Viewer (Top 10 decks) feedback thread sicut 3 429 01-28-2017, 10:34 AM
Last Post: Haides
Lightbulb Chat/Shoutbox - Suggestion, feedback & discussion thread InfiniteEvil 16 1,547 01-06-2017, 05:41 PM
Last Post: Khang
  Pricing Widget - Suggestion, feedback & discussion thread (Phase: Brainstorming) sicut 0 245 11-29-2016, 11:27 AM
Last Post: sicut
  [Suggestion] Card Color Camp Exclusivity Kasmot 5 771 08-08-2016, 05:30 AM
Last Post: sicut

Forum Jump:


Browsing: 1 Guest(s)