dgmTypeAttributes (CCP DB)

From EVEDev

CCP DB Table Categories
System Inventory Character Star Map Stations and Services NPC Corporations and Agents Certifications Planets Translation

1 Structure
- 1.1 dgmTypeAttributes
2 Note
3 Examples

[edit] Structure

dgmTypeAttributes

Column	Links to	Used	Note
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.
typeID	invTypes.typeID	*	Item ID.
attributeID	dgmAttributeTypes.attributeID	*	Attribute ID.
valueInt		*	Integer value of attribute.
valueFloat		*	Float value of attribute.

[edit] 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.