Skip to content

faction_values

Relationships

erDiagram
    faction_values {
        int char_id
        int faction_id
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    faction_list {
        int id
    }
    faction_values ||--o{ character_data : "One-to-One"
    faction_values ||--o{ faction_list : "One-to-One"
Relationship Type Local Key Relates to Table Foreign Key
One-to-One char_id character_data id
One-to-One faction_id faction_list id

Schema

Column Data Type Description
char_id int Character Identifier
faction_id int Faction Identifier
current_value smallint Current Value
temp tinyint Temporary: 0 = False, 1 = True