Skip to content

entity relationship diagrams

june 2022

may

drafting a db for the next iteration of random island adventures

adding monsters, quests, multiple islands

main idea is once you win on island 1 you can unlock more

eventually winning opening freeplay which is more survival and crafting



erDiagram
    ISLAND ||--o{ PLAYER : contains
    ISLAND ||--o{ MONSTERS : contains
    ISLAND {
        string name
        int position 
        int height 
        int width 
        int entrance 
        int exit 
    }

    ISLAND ||--o{ TREASURE : contains
    ISLAND ||--o{ DISASTER : contains
    TREASURE {
        string name
        int position 
    }

    ISLAND ||--o{ NPC : contains
    ISLAND ||--o{ ITEMS: contains
    ITEMS {
        string name
    }
    ITEMS ||..o{ ABILITIES : unlock
    DISASTER ||--o{ PLAYER : kills 

    DISASTER {
        string name
        int position 
    }

    PLAYER {
        string name
        int position 
        int hp 
    }
    PLAYER ||--o{ TREASURE : wins 
    PLAYER ||--o{ QUESTS : contains 
    ABILITIES {
        string name
    }

    QUESTS }|..|{ ABILITIES: contain 
    QUESTS {
        string name
        string abilities
        int position 
    }
    MONSTERS ||--|{ ITEMS : contains
    MONSTERS {
        string name
        int position 
        int hp 
    }
    PLAYER ||--o{ MONSTERS : fights 
    PLAYER }|..|{ NPC : meets
    PLAYER }|..|{ ITEMS: contains
    PLAYER }|..|{ ABILITIES: uses 

    NPC {
        string name
        int position 
        string reward
    }
    NPC ||--|{ QUESTS : contains
    NPC ||--|{ ITEMS : contains
    NPC ||--|{ ABILITIES : contains