table column type null key default extra _session_ SID varchar(255) NO PRI 0 _session_ DATA text NO _session_ LIMIT_DATETIME datetime NO MUL _session_ UP_DATETIME datetime NO _transaction_ tid varchar(255) NO PRI 0 _transaction_ DATA mediumtext NO _transaction_ UP_DATETIME datetime NO _transaction_ LIMIT_DATETIME datetime NO MUL _transaction_ UP_USER varchar(255) NO admin_user pk int(11) NO PRI auto_increment admin_user ID varchar(20) YES admin_user PASS varchar(20) YES admin_user NAME varchar(255) YES admin_user SINGLE tinyint(4) YES admin_user IS_ADMIN tinyint(4) YES 0 admin_user LOGIN_TIME datetime NO 0000-00-00 00:00:00 admin_user SID varchar(255) YES m_busho pk int(11) NO PRI auto_increment m_busho m_company_pk int(11) NO MUL 0 m_busho RANK int(11) NO MUL 0 m_busho NAME varchar(255) NO m_busho TYPE tinyint(4) NO m_busho IRYO_SHOGU tinyint(4) NO 0 m_busho TT_KANRI int(11) NO 0 m_busho TT_YAKUSHOKU2 int(11) NO 0 m_busho TT_YAKUSHOKU3 int(11) NO 0 m_busho TT_YAKUSHOKU4 int(11) NO 0 m_busho NO_TT_KINBEN_1 tinyint(4) NO m_busho NO_TT_KINBEN_2 tinyint(4) NO m_busho NO_TT_KINBEN_3 tinyint(4) NO m_busho NO_TT_KINBEN_4 tinyint(4) NO m_busho TT_YAKIN int(11) NO m_busho UP_DATETIME datetime NO 0000-00-00 00:00:00 m_company pk int(11) NO PRI auto_increment m_company RANK int(11) NO MUL 0 m_company NAME varchar(255) NO m_company UP_DATETIME datetime NO 0000-00-00 00:00:00 m_hav_lcc pk int(11) NO PRI auto_increment m_hav_lcc RANK int(11) NO MUL 0 m_hav_lcc CATEGORY tinyint(4) NO 0 m_hav_lcc NAME varchar(255) NO m_hav_lcc UP_DATETIME datetime NO 0000-00-00 00:00:00 m_hav_lcc2 pk int(11) NO PRI auto_increment m_hav_lcc2 RANK int(11) NO MUL 0 m_hav_lcc2 CATEGORY tinyint(4) NO 0 m_hav_lcc2 NAME varchar(255) NO m_hav_lcc2 GET_DT_FLG tinyint(4) NO m_hav_lcc2 NEXT_DT_FLG tinyint(4) NO m_hav_lcc2 UP_DATETIME datetime NO 0000-00-00 00:00:00 m_koyokeitai pk int(11) NO PRI auto_increment m_koyokeitai NAME varchar(255) NO m_koyokeitai UP_DATETIME datetime NO 0000-00-00 00:00:00 m_kyuyo LV1 int(11) NO PRI 0 m_kyuyo LV2 int(11) NO PRI 0 m_kyuyo KINGAKU int(11) NO 0 m_kyuyo HABA int(11) NO 0 m_kyuyo UP_DATETIME datetime NO 0000-00-00 00:00:00 m_shogu pk int(11) NO PRI auto_increment m_shogu TYPE int(11) NO 0 m_shogu m_koyokeitai_pk int(11) NO 0 m_shogu PART_PLAN varchar(255) NO m_shogu SHOGU_TYPE tinyint(4) NO 0 m_shogu m_use_lcc_pk int(11) NO 0 m_shogu KINMUNENSU tinyint(4) NO 0 m_shogu G_YAKIN tinyint(4) NO 0 m_shogu SHOGU int(11) NO 0 m_shogu KIHON_NAIHO int(11) NO 0 m_shogu RSHOGU int(11) NO 0 m_shogu SHOUYO_SHOGU int(11) NO 0 m_shogu SHOUYO_RSHOGU int(11) NO 0 m_shogu UP_DATETIME datetime NO 0000-00-00 00:00:00 m_shouyo AT_MONTH date NO PRI 0000-00-00 m_shouyo m_busho_pk int(11) NO PRI 0 m_shouyo KIHON_BAI float YES m_shouyo TT_SHOGU_BAI float YES m_shouyo REG_DATETIME datetime NO 0000-00-00 00:00:00 m_shouyo REG_USER varchar(255) NO m_shouyo UP_DATETIME datetime NO 0000-00-00 00:00:00 m_shouyo UP_USER varchar(255) NO m_shukuchoku pk int(11) NO PRI auto_increment m_shukuchoku RANK int(11) NO MUL 0 m_shukuchoku NAME varchar(255) NO m_shukuchoku KINGAKU int(11) NO 0 m_teikijunkai pk int(11) NO PRI auto_increment m_teikijunkai AT_DATE date NO MUL 0000-00-00 m_teikijunkai AMOUNT int(11) NO 0 m_teikijunkai UP_DATETIME datetime NO 0000-00-00 00:00:00 m_tsukin pk int(11) NO PRI auto_increment m_tsukin RANK int(11) NO 0 m_tsukin KM_FROM float NO MUL 0 m_tsukin AMOUNT_FULL int(11) NO 0 m_tsukin AMOUNT_PART_DAY int(11) NO 0 m_tsukin UP_DATETIME datetime NO 0000-00-00 00:00:00 m_use_lcc pk int(11) NO PRI auto_increment m_use_lcc RANK int(11) NO MUL 0 m_use_lcc CATEGORY varchar(255) NO m_use_lcc NAME varchar(255) NO m_use_lcc SHOGU_TYPE tinyint(4) NO 0 m_use_lcc TEATE int(11) NO 0 m_use_lcc TEATE_OTHER int(11) NO 0 m_use_lcc 2_JIKYU_BASE int(11) NO 0 m_use_lcc 3_JIKYU_BASE int(11) NO 0 m_use_lcc UP_DATETIME datetime NO 0000-00-00 00:00:00 t_ikohyo AT_MONTH date NO PRI 0000-00-00 t_ikohyo A int(8) unsigned zerofill NO PRI 00000000 t_ikohyo B varchar(255) NO t_ikohyo C float NO 0 t_ikohyo D varchar(6) NO t_ikohyo E varchar(6) NO t_ikohyo F varchar(6) NO t_ikohyo G float NO 0 t_ikohyo H float NO 0 t_ikohyo I float NO 0 t_ikohyo J float NO 0 t_ikohyo K varchar(6) NO t_ikohyo L float NO 0 t_ikohyo M float NO 0 t_ikohyo N float NO 0 t_ikohyo O float NO 0 t_ikohyo P float NO 0 t_ikohyo Q float NO 0 t_ikohyo R float NO 0 t_ikohyo S float NO 0 t_ikohyo T varchar(6) NO t_ikohyo U float NO 0 t_ikohyo V varchar(6) NO t_ikohyo W float NO 0 t_ikohyo X float NO 0 t_ikohyo Y float NO 0 t_ikohyo Z float NO 0 t_ikohyo AA varchar(255) NO t_ikohyo AB varchar(6) NO t_ikohyo REG_DATETIME datetime NO 0000-00-00 00:00:00 t_ikohyo REG_USER varchar(255) NO t_ikohyo UP_DATETIME datetime NO 0000-00-00 00:00:00 t_ikohyo UP_USER varchar(255) NO t_meisai pk int(11) NO PRI auto_increment t_meisai AT_MONTH date NO MUL 0000-00-00 t_meisai t_staff_pk int(11) NO MUL 0 t_meisai STAFF_ID int(8) unsigned zerofill NO 00000000 t_meisai INFO text NO t_meisai REG_DATETIME datetime NO 0000-00-00 00:00:00 t_meisai REG_USER varchar(255) NO t_meisai UP_DATETIME datetime NO 0000-00-00 00:00:00 t_meisai UP_USER varchar(255) NO t_shouyo AT_MONTH date NO PRI 0000-00-00 t_shouyo t_staff_pk int(11) NO PRI 0 t_shouyo KK_DAYS int(11) NO 0 t_shouyo KK_MONTHS int(11) NO 0 t_shouyo KIHON int(11) YES t_shouyo KIHON_BAI float YES t_shouyo KOUJO int(11) YES t_shouyo HYOUKA float YES t_shouyo KENSHU_FLG tinyint(4) NO 0 t_shouyo KENSYU float YES t_shouyo SYOUKEI int(11) YES t_shouyo SHOGU_TANKA int(11) YES t_shouyo SHOGU_MONTH int(11) YES t_shouyo TT_SHOGU int(11) YES t_shouyo TT_SHOGU_BAI float YES t_shouyo TT_RSHOGU int(11) YES t_shouyo TT_CHOSEI int(11) YES t_shouyo TT_SONOTA int(11) YES t_shouyo GOUKEI int(11) YES t_shouyo COMMENT varchar(255) NO t_shouyo INFO text NO t_shouyo REG_DATETIME datetime NO 0000-00-00 00:00:00 t_shouyo REG_USER varchar(255) NO t_shouyo UP_DATETIME datetime NO 0000-00-00 00:00:00 t_shouyo UP_USER varchar(255) NO t_staff pk int(11) NO PRI auto_increment t_staff m_company_pk int(11) NO 0 t_staff m_busho_pk int(11) NO MUL 0 t_staff STAFF_ID int(8) unsigned zerofill NO MUL 00000000 t_staff TEST_MODE tinyint(4) NO 0 t_staff NAME varchar(255) NO t_staff RUBY varchar(255) NO t_staff GENDER varchar(255) NO t_staff m_koyokeitai_pk int(11) NO MUL 0 t_staff PART_PLAN varchar(255) NO t_staff KOYOKEITAI_RIREKI text NO t_staff KOYO_YUKI tinyint(4) NO 0 t_staff KOYO_YUKI_END_D date NO 0000-00-00 t_staff KOYO_MUKI_Y_D date NO 0000-00-00 t_staff YAKU varchar(255) NO t_staff YAKU_RIREKI text NO t_staff m_use_lcc_pk int(11) NO 0 t_staff LCC_DATE date NO 0000-00-00 t_staff PLUS_KAIGO tinyint(4) YES 0 t_staff USE_LCC_TEXT varchar(255) NO t_staff m_hav_lcc_1 int(11) NO 0 t_staff m_hav_lcc_2 int(11) NO 0 t_staff m_hav_lcc_3 int(11) NO 0 t_staff m_hav_lcc_4 int(11) NO 0 t_staff m_hav_lcc_99 varchar(255) NO t_staff HOYU_SHIKAKU1 varchar(255) NO t_staff HOYU_SHIKAKU2 varchar(255) NO t_staff HOYU_SHIKAKU3 varchar(255) NO t_staff HOYU_SHIKAKU4 varchar(255) NO t_staff HOYU_SHIKAKU5 varchar(255) NO t_staff HOYU_SHIKAKU6 varchar(255) NO t_staff NINTEIKENSHU varchar(255) NO t_staff ZIP varchar(8) NO t_staff ADDRESS varchar(255) NO t_staff TEL varchar(255) NO t_staff TEL2 varchar(255) NO t_staff BD date NO 0000-00-00 t_staff SCHOOL varchar(255) NO t_staff SCHOOL_NAME varchar(255) NO t_staff KEIKEN_NEN int(11) NO 0 t_staff KEIKEN_TSUKI tinyint(4) NO 0 t_staff SYOKUREKI text NO t_staff IN_DATE date NO 0000-00-00 t_staff ZAISEKI_NEN int(11) NO 0 t_staff GRADEUP_DATE date NO 0000-00-00 t_staff GRADEUP_NEN int(11) NO 0 t_staff OUT_DATE date NO 0000-00-00 t_staff OUT_STATUS tinyint(4) NO 0 t_staff OUT_TEXT varchar(255) NO t_staff HIDE_MEISAI tinyint(4) NO 0 t_staff SLEEP_MODE varchar(255) NO t_staff KYUSYOKU_INFO text NO t_staff COMEBACK_DATE date NO 0000-00-00 t_staff COMEBACK_TEXT varchar(255) NO t_staff SHAKAI_HOKEN date NO 0000-00-00 t_staff SHAKAI_HOKEN_FLG tinyint(4) NO 0 t_staff KOYO_HOKEN date NO 0000-00-00 t_staff KOYO_HOKEN_FLG tinyint(4) NO 0 t_staff TAISYOKUKIN_INDATE date NO 0000-00-00 t_staff TAISYOKUKIN_MEMO varchar(255) NO t_staff YACHIN int(11) NO 0 t_staff TSUKIN_KM float NO 0 t_staff TEIKIDAI int(11) NO 0 t_staff TEIKIDAI_UNIT tinyint(4) NO 0 t_staff GOJOKAI_FLG tinyint(4) NO 0 t_staff GOJOKAI_INDATE date NO 0000-00-00 t_staff IDO_RIREKI text NO t_staff MEMO text NO t_staff FIRST_LV1 int(11) NO 0 t_staff FIRST_LV2 int(11) NO 0 t_staff LV1 int(11) NO 0 t_staff LV2 int(11) NO 0 t_staff JIKYU_BASE int(11) NO 0 t_staff JIKYU_BASE_CUSTOM int(11) YES t_staff GEKKYU_BASE int(11) NO 0 t_staff GEKKYU_BASE_CUSTOM int(11) YES t_staff GEKKYU_SHOGU int(11) YES 0 t_staff JITAN tinyint(4) NO 0 t_staff TT_SHIKAKU int(11) NO 0 t_staff TT_SHIKAKU_CUSTOM int(11) YES t_staff TT_KANRI int(11) NO 0 t_staff TT_KANRI_CUSTOM int(11) YES t_staff TT_YAKUSHOKU int(11) NO 0 t_staff TT_YAKUSHOKU_CUSTOM int(11) YES t_staff TT_JIKANGAI int(11) NO 0 t_staff TT_JIKANGAI_BAI float NO 1.25 t_staff TT_SHINYA float NO 1.5 t_staff YUKYU_BASE int(11) YES 0 t_staff TT_CHOSEI int(11) NO 0 t_staff TT_KINBEN int(11) NO 8000 t_staff TT_SHOGU int(11) NO 0 t_staff TT_SHOGU_CUSTOM int(11) YES t_staff TT_TSHOGU int(11) NO 0 t_staff TT_RSHOGU int(11) NO 0 t_staff TT_RSHOGU_CUSTOM int(11) YES t_staff TT_ISHOGU_CUSTOM int(11) YES t_staff TT_ONCALL int(11) NO 0 t_staff TT_NENMATSU int(11) NO 3500 t_staff TT_YAKIN int(11) NO 0 t_staff TT_KYUJITSU int(11) NO 0 t_staff TT_SHUKUCHOKU int(11) YES 0 t_staff m_shukuchoku_pk int(11) NO 0 t_staff TT_CHIIKI_ENJU tinyint(4) YES 0 t_staff TT_TEIKIJUNKAI tinyint(4) YES 0 t_staff TT_JUTAKU int(11) NO 0 t_staff KT_KAZEI int(11) NO 0 t_staff KT_TANKA int(11) NO 0 t_staff GOJOKAI int(11) NO 0 t_staff KYUYO_MEMO text NO t_staff REG_DATETIME datetime NO 0000-00-00 00:00:00 t_staff REG_USER varchar(255) NO t_staff UP_DATETIME datetime NO 0000-00-00 00:00:00 t_staff UP_USER varchar(255) NO