| id |
int(10)
|
|
|
|
| name_aegis |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| name_english |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| type |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| subtype |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| price_buy |
mediumint(8)
|
|
|
|
| price_sell |
mediumint(8)
|
|
|
|
| weight |
smallint(5)
|
|
|
|
| attack |
smallint(5)
|
|
|
|
| magic_attack |
smallint(5)
|
|
|
|
| defense |
smallint(5)
|
|
|
|
| range |
tinyint(2)
|
|
|
|
| slots |
tinyint(2)
|
|
|
|
| job_all |
tinyint(1)
|
|
|
|
| job_acolyte |
tinyint(1)
|
|
|
|
| job_alchemist |
tinyint(1)
|
|
|
|
| job_archer |
tinyint(1)
|
|
|
|
| job_assassin |
tinyint(1)
|
|
|
|
| job_barddancer |
tinyint(1)
|
|
|
|
| job_blacksmith |
tinyint(1)
|
|
|
|
| job_crusader |
tinyint(1)
|
|
|
|
| job_gunslinger |
tinyint(1)
|
|
|
|
| job_hunter |
tinyint(1)
|
|
|
|
| job_kagerouoboro |
tinyint(1)
|
|
|
|
| job_knight |
tinyint(1)
|
|
|
|
| job_mage |
tinyint(1)
|
|
|
|
| job_merchant |
tinyint(1)
|
|
|
|
| job_monk |
tinyint(1)
|
|
|
|
| job_ninja |
tinyint(1)
|
|
|
|
| job_novice |
tinyint(1)
|
|
|
|
| job_priest |
tinyint(1)
|
|
|
|
| job_rebellion |
tinyint(1)
|
|
|
|
| job_rogue |
tinyint(1)
|
|
|
|
| job_sage |
tinyint(1)
|
|
|
|
| job_soullinker |
tinyint(1)
|
|
|
|
| job_spirit_handler |
tinyint(1)
|
|
|
|
| job_stargladiator |
tinyint(1)
|
|
|
|
| job_summoner |
tinyint(1)
|
|
|
|
| job_supernovice |
tinyint(1)
|
|
|
|
| job_swordman |
tinyint(1)
|
|
|
|
| job_taekwon |
tinyint(1)
|
|
|
|
| job_thief |
tinyint(1)
|
|
|
|
| job_wizard |
tinyint(1)
|
|
|
|
| class_all |
tinyint(1)
|
|
|
|
| class_normal |
tinyint(1)
|
|
|
|
| class_upper |
tinyint(1)
|
|
|
|
| class_baby |
tinyint(1)
|
|
|
|
| class_third |
tinyint(1)
|
|
|
|
| class_third_upper |
tinyint(1)
|
|
|
|
| class_third_baby |
tinyint(1)
|
|
|
|
| class_fourth |
tinyint(1)
|
|
|
|
| gender |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| location_head_top |
tinyint(1)
|
|
|
|
| location_head_mid |
tinyint(1)
|
|
|
|
| location_head_low |
tinyint(1)
|
|
|
|
| location_armor |
tinyint(1)
|
|
|
|
| location_right_hand |
tinyint(1)
|
|
|
|
| location_left_hand |
tinyint(1)
|
|
|
|
| location_garment |
tinyint(1)
|
|
|
|
| location_shoes |
tinyint(1)
|
|
|
|
| location_right_accessory |
tinyint(1)
|
|
|
|
| location_left_accessory |
tinyint(1)
|
|
|
|
| location_costume_head_top |
tinyint(1)
|
|
|
|
| location_costume_head_mid |
tinyint(1)
|
|
|
|
| location_costume_head_low |
tinyint(1)
|
|
|
|
| location_costume_garment |
tinyint(1)
|
|
|
|
| location_ammo |
tinyint(1)
|
|
|
|
| location_shadow_armor |
tinyint(1)
|
|
|
|
| location_shadow_weapon |
tinyint(1)
|
|
|
|
| location_shadow_shield |
tinyint(1)
|
|
|
|
| location_shadow_shoes |
tinyint(1)
|
|
|
|
| location_shadow_right_accessory |
tinyint(1)
|
|
|
|
| location_shadow_left_accessory |
tinyint(1)
|
|
|
|
| weapon_level |
tinyint(1)
|
|
|
|
| armor_level |
tinyint(1)
|
|
|
|
| equip_level_min |
smallint(5)
|
|
|
|
| equip_level_max |
smallint(5)
|
|
|
|
| refineable |
tinyint(1)
|
|
|
|
| gradable |
tinyint(1)
|
|
|
|
| view |
smallint(5)
|
|
|
|
| alias_name |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| flag_buyingstore |
tinyint(1)
|
|
|
|
| flag_deadbranch |
tinyint(1)
|
|
|
|
| flag_container |
tinyint(1)
|
|
|
|
| flag_uniqueid |
tinyint(1)
|
|
|
|
| flag_bindonequip |
tinyint(1)
|
|
|
|
| flag_dropannounce |
tinyint(1)
|
|
|
|
| flag_noconsume |
tinyint(1)
|
|
|
|
| flag_dropeffect |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| delay_duration |
bigint(20)
|
|
|
|
| delay_status |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| stack_amount |
smallint(5)
|
|
|
|
| stack_inventory |
tinyint(1)
|
|
|
|
| stack_cart |
tinyint(1)
|
|
|
|
| stack_storage |
tinyint(1)
|
|
|
|
| stack_guildstorage |
tinyint(1)
|
|
|
|
| nouse_override |
smallint(5)
|
|
|
|
| nouse_sitting |
tinyint(1)
|
|
|
|
| trade_override |
smallint(5)
|
|
|
|
| trade_nodrop |
tinyint(1)
|
|
|
|
| trade_notrade |
tinyint(1)
|
|
|
|
| trade_tradepartner |
tinyint(1)
|
|
|
|
| trade_nosell |
tinyint(1)
|
|
|
|
| trade_nocart |
tinyint(1)
|
|
|
|
| trade_nostorage |
tinyint(1)
|
|
|
|
| trade_noguildstorage |
tinyint(1)
|
|
|
|
| trade_nomail |
tinyint(1)
|
|
|
|
| trade_noauction |
tinyint(1)
|
|
|
|
| script |
text
|
utf8mb4_general_ci
|
|
|
| equip_script |
text
|
utf8mb4_general_ci
|
|
|
| unequip_script |
text
|
utf8mb4_general_ci
|
|
|
