dgmTypeAttributes (CCP DB)

From EVEDev
Jump to: navigation, search
CCP DB Table Categories

Contents

Structure

dgmTypeAttributes

All attributes for items. Only one value of attribute exists per table row. Correct way to obtain value is isNULL(valueInt,valueFloat) in MS SQL or IFNULL(valueInt,valueFloat) in mySQL.
Column Links to Used Note
typeID invTypes.typeID * Item ID.
attributeID dgmAttributeTypes.attributeID * Attribute ID.
valueInt * Integer value of attribute.
valueFloat * Float value of attribute.

Note

always use coalesce(valueFloat,valueInt) to access the value.
there are cases where a obviously-integer (attribute or type id) value is stored in valueFloat.
there are cases that have both valueFloat and valueInt.
there are cases that have different valueFloat and valueInt.
the safe way is to ALWAYS use coalesce(valueFloat, valueInt).
really.

Examples

Personal tools