erDiagram
    armor ||--o{ armor_skills : has
    skill ||--o{ armor_skills : used_in
    skill ||--o{ weapon_skills : used_in
    weapon ||--o{ weapon_skills : has
    weapon ||--o{ weapon_needed_items : requires
    item ||--o{ weapon_needed_items : used_in
    skill ||--o{ decoration : main_skill
    skill ||--o{ decoration : sub_skill

    armor {
        int id PK
        string name
        string series_name
        string type
        string description
        int defense
        int fire_res
        int water_res
        int thunder_res
        int ice_res
        int dragon_res
        int slot1
        int slot2
        int slot3
        string icon_link_male
        string icon_link_female
    }
    
    armor_skills {
        int id PK
        int armor_id FK
        int skill_id FK
        int level
    }
    
    decoration {
        int id PK
        string name
        int main_skill_id FK
        int main_level
        int sub_skill_id FK
        int sub_level
        int slot
    }
    
    item {
        int id PK
        string name
        string description
    }
    
    skill {
        int id PK
        string name
        string url
    }
    
    weapon {
        int id PK
        string name
        string type
        string description
        int attack
        int affinity
        string element
        int element_attack
        int sharpness
        int max_sharpness
        int slot1
        int slot2
        int slot3
    }
    
    weapon_needed_items {
        int id PK
        int weapon_id FK
        int item_id FK
        int quantity
    }
    
    weapon_skills {
        int id PK
        int weapon_id FK
        int skill_id FK
        int level
    }