-- phpMyAdmin SQL Dump
-- version 2.11.11.3
-- http://www.phpmyadmin.net
--
-- ホスト: localhost
-- 生成時間: 2016 年 1 月 28 日 19:11
-- サーバのバージョン: 5.6.10
-- PHP のバージョン: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- データベース: `kyoikuc_20160128`
--

--
-- テーブルのデータをダンプしています `smsevent`
--

INSERT INTO `smsevent` (`id`, `deleted`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `name`, `shortname`, `description`, `parent_id`, `syllabus_id`, `smsdocument_id`, `category`, `status`, `school_id`, `vacation_type`, `vacation_count`, `subtype`, `event_credit`, `schedule_reminder`, `custom_var31`, `custom_var32`, `custom_var33`, `custom_var34`, `custom_var35`, `custom_var36`, `custom_var37`, `custom_var38`, `custom_var39`, `custom_var40`, `common_code`, `assigned_user_id`, `sakusei_jokyo`, `nen`, `ki`, `bumon_code`, `koza_kubun`, `name_furigana`, `customer_chui`, `kaisaishu_hyoji_web`, `kaisaijikan_hyoji_web`, `kaisaibi_hyoji_web`, `youbi`, `kaisaishu`, `show_web`, `uketsuke_web`, `name_web`, `name_sub_web`, `web_start_day`, `web_end_day`, `web_start_day_shinki`, `web_start_day_shinki_timepicker`, `web_end_day_shinki`, `web_end_day_shinki_timepicker`, `description_web`, `shashin_setsumei1`, `teiin`, `teiin_min`, `jukouryo`, `kaiin_tanka_zeikomi`, `hikaiin_tanka_zeikomi`, `houjin_tanka_zeikomi`, `kaiin_tanka_web`, `hikaiin_tanka_web`, `hojin_tanka_web`, `kyouzai`, `kyouzai_tanka_zeikomi`, `kyouzai_tanka_web`, `sonota_tanka_1`, `sonota_subcategory_1`, `sonota_tanka_zeikomi_1`, `sonota_tanka_web_1`, `sonota_tanka_2`, `sonota_subcategory_2`, `sonota_tanka_zeikomi_2`, `sonota_tanka_web_2`, `sonota_tanka_3`, `sonota_subcategory_3`, `sonota_tanka_zeikomi_3`, `sonota_tanka_web_3`, `touroku_no`, `yoyaku_no`, `taiken_no`, `kengaku_no`, `cancel_machi_no`, `picture_filename`, `event_short_name`, `branch`, `shisya`, `class_code`, `curriculum_id`, `ins_order_duplication`, `no_mail`) VALUES
('13517edd-590a-7bb1-da92-56a73c6caf58', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者5月生Fクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1222', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5F', 1, '07', '1216040002', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('1472b21e-d637-b39c-4109-56a73c8bfd1d', 0, '2016-01-26 18:28:13', '2016-01-26 18:28:13', 's1200001', 's1200001', '実務者5月生Fクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '0824', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5F', 1, '07', '1216040026', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('1bfde4da-9f11-13cb-b476-56a73c42f871', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者5月生Cクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1222', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5C', 1, '07', '1216040003', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('1eda5c96-5fd5-9150-e10d-56a73c6ffefc', 0, '2016-01-26 18:28:13', '2016-01-26 18:28:13', 's1200001', 's1200001', '実務者6月生Gクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '0824', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6G', 1, '07', '1216040027', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('240ce1f5-e6cf-9ad3-5ec2-56a73ce01e81', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者5月生Gクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1222', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5G', 1, '07', '1216040004', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('27b9f367-bc7b-c0fe-d86c-56a73c4f86d4', 0, '2016-01-26 18:28:13', '2016-01-26 18:28:13', 's1200001', 's1200001', '実務者6月生Dクラス(介Ⅲ)', NULL, NULL, NULL, NULL, NULL, 'course', 0, '0824', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6D', 1, '07', '1216040028', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('31388c74-8ea0-2ffb-f3f8-56a73c7886b8', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者5月生Aクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1222', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5A', 1, '07', '1216040005', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('3b25527b-c05c-cbe3-5d43-56a73c020c23', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者6月生Eクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1222', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6E', 1, '07', '1216040006', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('462e4522-5f95-1fae-aad5-56a73c85164b', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者6月生Kクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1222', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6K', 1, '07', '1216040007', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('50b4ef74-3a25-eade-cfc1-56a73cfe6f28', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者4月生Aクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1221', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4A', 1, '07', '1216040008', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('58ebd754-b5f1-b48e-7d97-56a73cca098d', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者4月生Fクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1221', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4F', 1, '07', '1216040009', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('641093cf-8c94-5503-87d4-56a73cda8978', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者4月生Gクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1221', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4G', 1, '07', '1216040010', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('6837a1e0-74a1-4efa-83e8-569611b78240', 1, '2016-01-13 17:56:17', '2016-01-14 10:21:46', '7803b4c1-3c24-b1ea-12b9-556c29fa3063', '7803b4c1-3c24-b1ea-12b9-556c29fa3063', '実務者研修　八王子教室　5月生　Dクラス', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1311', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1310006', NULL, 2016, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '実務者（介Ⅲ）5D', 1, '01', NULL, '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('6e6e2ef1-1bc2-a23e-1ac2-56a73c1a05bf', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者5月生Bクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1221', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5B', 1, '07', '1216040011', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('79b7ee16-9dd6-b1f3-93d8-56a73cbf0a3e', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者5月生Kクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1221', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5K', 1, '07', '1216040012', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('82821054-6d3d-526e-9f63-56a73cf81828', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者6月生Dクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1221', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6D', 1, '07', '1216040013', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('8fa3cf3c-a47b-20e1-467a-56a73c89b1ee', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者6月生Fクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1221', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6F', 1, '07', '1216040014', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('9df89fbc-4d3e-fc8e-3a75-56a73c4ad107', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者6月生Aクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1221', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6A', 1, '07', '1216040015', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('a1340d9d-f98f-6a10-ff8a-56a73c431981', 0, '2016-01-26 18:28:13', '2016-01-26 18:28:13', 's1200001', 's1200001', '実務者5月生Aクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '0824', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5A', 1, '07', '1216040025', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('a753bfe0-a00c-3088-8edf-56a73c695627', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者6月生Gクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1221', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6G', 1, '07', '1216040016', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('afeb71d8-b411-e51d-4084-56a73ce558dc', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者4月生Fクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1223', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4F', 1, '07', '1216040017', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('ba4a3de0-ca2d-15c8-4df2-56a73c162f0f', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者4月生Eクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1223', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4E', 1, '07', '1216040018', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('c2957504-5957-b82a-10f6-56a73c25da95', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者5月生Gクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1223', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5G', 1, '07', '1216040019', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('cd0bc753-8c33-c538-5d66-56a73c327913', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者5月生Aクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1223', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5A', 1, '07', '1216040020', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('d3d03a63-566a-e8c9-c61e-56a73c87e0b8', 0, '2016-01-26 18:28:11', '2016-01-26 18:28:11', 's1200001', 's1200001', '実務者4月生Dクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1222', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4D', 1, '07', '1216040001', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('d5750873-52ff-d8b1-ca67-56a73c672b7f', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者5月生Dクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1223', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '5D', 1, '07', '1216040021', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('ddd1ea82-2cbc-17a6-99be-56a73cef08a2', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者6月生Fクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1223', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6F', 1, '07', '1216040022', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('e961aafb-3596-94e6-7e68-56a73c184d03', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者6月生Cクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '1223', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '6C', 1, '07', '1216040023', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL),
('f1b3f279-1b1c-5b53-380a-56a73c0925f0', 0, '2016-01-26 18:28:12', '2016-01-26 18:28:12', 's1200001', 's1200001', '実務者4月生Gクラス（介Ⅲ）', NULL, NULL, NULL, NULL, NULL, 'course', 0, '0824', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 's1200001', NULL, 2016, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4G', 1, '07', '1216040024', '6388635d-64c4-42bf-fe3d-568f0b5715ba', 1, NULL);