table_name | column_name | data_type | is_nullable -------------------------+---------------------------+-----------------------------+------------- armor_items | id | integer | NO armor_items | flags | integer | YES armor_items | flags_description | ARRAY | YES armor_items | stack_size | integer | YES armor_items | type | integer | YES armor_items | type_description | text | YES armor_items | resource_id | integer | YES armor_items | valid_targets | integer | YES armor_items | valid_targets_description | ARRAY | YES armor_items | name | character varying | NO armor_items | description | text | YES armor_items | log_name_singular | character varying | YES armor_items | log_name_plural | character varying | YES armor_items | level | integer | YES armor_items | item_level | integer | YES armor_items | slots | integer | YES armor_items | slots_description | ARRAY | YES armor_items | races | integer | YES armor_items | races_description | ARRAY | YES armor_items | jobs | integer | YES armor_items | jobs_description | ARRAY | YES armor_items | superior_level | integer | YES armor_items | shield_size | integer | YES armor_items | max_charges | integer | YES armor_items | casting_time | integer | YES armor_items | use_delay | integer | YES armor_items | reuse_delay | integer | YES armor_items | unknown_2 | integer | YES armor_items | unknown_3 | integer | YES armor_items | icon_id | character varying | YES instinct_items | id | integer | NO instinct_items | flags | integer | YES instinct_items | flags_description | ARRAY | YES instinct_items | stack_size | integer | YES instinct_items | type | integer | YES instinct_items | type_description | text | YES instinct_items | resource_id | integer | YES instinct_items | valid_targets | integer | YES instinct_items | valid_targets_description | ARRAY | YES instinct_items | name | character varying | NO instinct_items | description | text | YES instinct_items | log_name_singular | character varying | YES instinct_items | log_name_plural | character varying | YES instinct_items | instinct_cost | integer | YES instinct_items | icon_id | character varying | YES inventory | id | integer | NO inventory | character_name | character varying | NO inventory | storage_type | character varying | NO inventory | item_name | character varying | NO inventory | quantity | integer | NO inventory | last_updated | timestamp without time zone | NO item_additional_effects | id | integer | NO item_additional_effects | item_id | integer | NO item_additional_effects | item_table | character varying | NO item_additional_effects | effect | text | NO item_elemental_effects | id | integer | NO item_elemental_effects | item_id | integer | NO item_elemental_effects | item_table | character varying | NO item_elemental_effects | element | character varying | NO item_elemental_effects | value | integer | NO item_enchantments | id | integer | NO item_enchantments | item_id | integer | NO item_enchantments | item_table | character varying | NO item_enchantments | spell | character varying | YES item_enchantments | location | character varying | YES item_enchantments | effect | text | YES item_icons | id | character varying | NO item_icons | format | character varying | YES item_icons | flag | integer | YES item_icons | category | character varying | YES item_icons | width | integer | YES item_icons | height | integer | YES item_icons | planes | integer | YES item_icons | bits | integer | YES item_icons | compression | integer | YES item_icons | size | integer | YES item_icons | horizontal_resolution | integer | YES item_icons | vertical_resolution | integer | YES item_icons | used_colors | integer | YES item_icons | important_colors | integer | YES item_icons | image_format | character varying | YES item_icons | image_encoding | character varying | YES item_icons | image_data | text | YES item_stats | id | integer | NO item_stats | item_id | integer | NO item_stats | item_table | character varying | NO item_stats | stat_name | character varying | NO item_stats | value | integer | NO key_items | id | integer | NO key_items | flags | integer | YES key_items | flags_description | ARRAY | YES key_items | stack_size | integer | YES key_items | type | integer | YES key_items | type_description | text | YES key_items | resource_id | integer | YES key_items | valid_targets | integer | YES key_items | valid_targets_description | ARRAY | YES key_items | name | character varying | NO key_items | description | text | YES key_items | log_name_singular | character varying | YES key_items | log_name_plural | character varying | YES key_items | icon_id | character varying | YES misc_items | id | integer | NO misc_items | flags | integer | YES misc_items | flags_description | ARRAY | YES misc_items | stack_size | integer | YES misc_items | type | integer | YES misc_items | type_description | text | YES misc_items | resource_id | integer | YES misc_items | valid_targets | integer | YES misc_items | valid_targets_description | ARRAY | YES misc_items | name | character varying | NO misc_items | description | text | YES misc_items | log_name_singular | character varying | YES misc_items | log_name_plural | character varying | YES misc_items | element | character varying | YES misc_items | storage_slots | integer | YES misc_items | unknown_3 | bigint | YES misc_items | icon_id | character varying | YES monipulator_items | id | integer | NO monipulator_items | flags | integer | YES monipulator_items | flags_description | ARRAY | YES monipulator_items | stack_size | integer | YES monipulator_items | type | integer | YES monipulator_items | type_description | text | YES monipulator_items | resource_id | integer | YES monipulator_items | valid_targets | integer | YES monipulator_items | valid_targets_description | ARRAY | YES monipulator_items | name | character varying | NO monipulator_items | unknown_1 | integer | YES monipulator_items | icon_id | character varying | YES puppet_items | id | integer | NO puppet_items | flags | integer | YES puppet_items | flags_description | ARRAY | YES puppet_items | stack_size | integer | YES puppet_items | type | integer | YES puppet_items | type_description | text | YES puppet_items | resource_id | integer | YES puppet_items | valid_targets | integer | YES puppet_items | valid_targets_description | ARRAY | YES puppet_items | name | character varying | NO puppet_items | description | text | YES puppet_items | log_name_singular | character varying | YES puppet_items | log_name_plural | character varying | YES puppet_items | puppet_slot | integer | YES puppet_items | element_charge | bigint | YES puppet_items | unknown_3 | integer | YES puppet_items | icon_id | character varying | YES usable_items | id | integer | NO usable_items | flags | integer | YES usable_items | flags_description | ARRAY | YES usable_items | stack_size | integer | YES usable_items | type | integer | YES usable_items | type_description | text | YES usable_items | resource_id | integer | YES usable_items | valid_targets | integer | YES usable_items | valid_targets_description | ARRAY | YES usable_items | name | character varying | NO usable_items | description | text | YES usable_items | log_name_singular | character varying | YES usable_items | log_name_plural | character varying | YES usable_items | activation_time | integer | YES usable_items | unknown_1 | integer | YES usable_items | unknown_3 | integer | YES usable_items | unknown_4 | integer | YES usable_items | icon_id | character varying | YES voucher_items | id | integer | NO voucher_items | flags | integer | YES voucher_items | flags_description | ARRAY | YES voucher_items | stack_size | integer | YES voucher_items | type | integer | YES voucher_items | type_description | text | YES voucher_items | resource_id | integer | YES voucher_items | valid_targets | integer | YES voucher_items | valid_targets_description | ARRAY | YES voucher_items | name | character varying | NO voucher_items | description | text | YES voucher_items | log_name_singular | character varying | YES voucher_items | log_name_plural | character varying | YES voucher_items | unknown_1 | integer | YES voucher_items | icon_id | character varying | YES weapon_items | id | integer | NO weapon_items | flags | integer | YES weapon_items | flags_description | ARRAY | YES weapon_items | stack_size | integer | YES weapon_items | type | integer | YES weapon_items | type_description | text | YES weapon_items | resource_id | integer | YES weapon_items | valid_targets | integer | YES weapon_items | valid_targets_description | ARRAY | YES weapon_items | name | character varying | NO weapon_items | description | text | YES weapon_items | log_name_singular | character varying | YES weapon_items | log_name_plural | character varying | YES weapon_items | level | integer | YES weapon_items | ilevel | integer | YES weapon_items | slots | integer | YES weapon_items | races | integer | YES weapon_items | jobs | integer | YES weapon_items | superior_level | integer | YES weapon_items | damage | integer | YES weapon_items | delay | integer | YES weapon_items | dps | integer | YES weapon_items | skill | integer | YES weapon_items | jug_size | integer | YES weapon_items | max_charges | integer | YES weapon_items | casting_time | integer | YES weapon_items | use_delay | integer | YES weapon_items | reuse_delay | integer | YES weapon_items | unknown_1 | integer | YES weapon_items | unknown_2 | integer | YES weapon_items | unknown_3 | integer | YES weapon_items | unknown_4 | integer | YES weapon_items | icon_id | character varying | YES (214 rows)