-- Table structure for table `student_check_permission`
--

CREATE TABLE `student_check_permission` (
  `class_now` tinyint(4) NOT NULL,
  `room_now` tinyint(4) NOT NULL,
  `person_id` varchar(13) NOT NULL,
  `student_check_year` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_check_permission`
--

INSERT INTO `student_check_permission` VALUES (3,1,'1340700398100',2558),(3,0,'1340700204747',2561),(5,1,'3350800274948',2558),(7,1,'3349800035119',2558),(8,1,'3349800150660',2558),(2,1,'1340700204747',2565),(4,1,'3331000130845',2558),(8,1,'3349800150660',2564),(4,0,'3331000130845',2561),(5,0,'3350800274948',2561),(6,0,'3349900275031',2561),(7,0,'3349800035119',2561),(8,0,'3349800150660',2561),(9,0,'1340700065119',2561),(4,1,'3331000130845',2561),(5,1,'3350800274948',2561),(7,1,'3349800035119',2561),(8,1,'3349800150660',2561),(9,1,'1340700398100',2561),(9,1,'3350300547007',2564),(4,1,'1340700555388',2565),(5,1,'3331000130845',2562),(8,1,'3349800150660',2562),(2,1,'1340700204747',2563),(7,1,'3349800035119',2562),(1,1,'1340700204747',2563),(5,1,'3350800274948',2564),(8,1,'3349800150660',2563),(5,1,'3349800035119',2563),(9,1,'3350300547007',2563),(4,1,'1340700555388',2564),(8,1,'3349800150660',2566),(2,1,'1340700204747',2564),(5,1,'3350800274948',2565),(8,1,'3349800150660',2565),(9,1,'3350300547007',2565),(6,1,'1490200096456',2566),(9,1,'3350300547007',2566),(5,1,'3350800274948',2566),(4,1,'1340700555388',2566),(2,1,'1340700204747',2566),(7,1,'3340701131201',2566),(2,1,'1340700204747',2567),(3,1,'1341900113681',2567),(4,1,'1340700555388',2567),(5,1,'3350800274948',2567),(6,1,'1490200096456',2567),(7,1,'3340701131201',2567),(8,1,'3349800150660',2567),(9,1,'3350300547007',2567);

--
-- Table structure for table `student_check_year`
--

CREATE TABLE `student_check_year` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_check_year` int(11) NOT NULL,
  `year_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `student_check_year` (`student_check_year`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_check_year`
--

INSERT INTO `student_check_year` VALUES (9,2568,1),(8,2567,0);

--
-- Table structure for table `student_main`
--

CREATE TABLE `student_main` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` varchar(7) NOT NULL,
  `student_number` int(11) DEFAULT NULL,
  `prename` varchar(20) NOT NULL,
  `name` varchar(50) NOT NULL,
  `surname` varchar(50) NOT NULL,
  `person_id` varchar(20) DEFAULT NULL,
  `sex` tinyint(4) NOT NULL DEFAULT 0,
  `pic` varchar(150) DEFAULT NULL,
  `class_now` tinyint(4) DEFAULT NULL,
  `room` tinyint(4) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `out_edyear` int(11) DEFAULT NULL,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `student_number` (`student_id`),
  KEY `class_now` (`class_now`),
  KEY `room` (`room`)
) ENGINE=MyISAM AUTO_INCREMENT=234 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_main`
--

INSERT INTO `student_main` VALUES (212,'1432',10,'เด็กหญิง','มนัสนันท์','ผิวอ่อนดี','1102004986414',2,'',4,1,0,NULL,'3340701131201','2023-05-18'),(211,'1431',9,'เด็กชาย','ศุภกิตติ์','บุญเจริญ','1341501636087',1,'',4,1,0,NULL,'3340701131201','2023-05-18'),(167,'1390',5,'เด็กชาย','ธีระพงศ์   ',' ประสานวงษ์','1341501594929',1,'',6,1,0,NULL,'3340701131201','2021-06-28'),(203,'1423',2,'เด็กชาย','ชนากานต์','อ่อนไทย','1348900474702',1,'',4,1,0,NULL,'3340701131201','2023-05-18'),(210,'1430',8,'เด็กชาย','ภัทรพล','เมืองสองชั้น','1348900487294',1,'',4,1,0,NULL,'3340701131201','2023-05-18'),(209,'1429',7,'เด็กชาย','พีรวิชญ์','ศรีหาญ','1139600913461',1,'',4,1,0,NULL,'3340701131201','2023-05-18'),(207,'1427',6,'เด็กชาย','ธนากร','ชวดทอง','1399900663409',1,'',4,1,0,NULL,'3340701131201','2023-05-18'),(15,'1287',1,'เด็กชาย','กันยา','ดารุนิกร','1348900225508',1,NULL,9,1,1,2564,'3340701131201','0000-00-00'),(16,'1288',2,'เด็กชาย','ชัยณรงค์','วงธะนู','1348900227772',1,NULL,9,1,1,2564,'3340701131201','0000-00-00'),(17,'1290',3,'เด็กชาย','ธนดล','สุคุณา','1341501516987',1,NULL,9,1,1,2564,'3340701131201','0000-00-00'),(18,'1291',4,'เด็กชาย','ธีรพงษ์','ธานี','1348900220824',1,NULL,9,1,1,2564,'3340701131201','0000-00-00'),(19,'1292',5,'เด็กชาย','วีรภัทร','ศรีสะอาด','1349901682920',1,NULL,9,1,1,2564,'3340701131201','0000-00-00'),(20,'1294',6,'เด็กหญิง','กมลรัตน์','สีสำอาง','1348900222894',2,NULL,9,1,1,2564,'3340701131201','0000-00-00'),(22,'1296',7,'เด็กหญิง','รสริน','เหลืองทอง','1348900227675',2,NULL,9,1,1,2564,'3340701131201','0000-00-00'),(23,'1297',8,'เด็กหญิง','วิภาภรณ์','ตันสุ','1348900223106',2,NULL,9,1,1,2564,'3340701131201','0000-00-00'),(24,'1298',9,'เด็กหญิง','สุพัตรา','ธานี','1348900224544',2,NULL,9,1,1,2564,'3340701131201','0000-00-00'),(168,'1391',6,'เด็กชาย','พายุภัค   ','แสงงาม','1341501600082',1,'',6,1,0,NULL,'3340701131201','2021-06-28'),(26,'1268',1,'เด็กชาย','กริช','อักษร','1348900194319',1,NULL,9,1,1,2563,'3340701131201','0000-00-00'),(27,'1269',2,'เด็กชาย','ขจรศักดิ์','ธานี','1349901577271',1,NULL,9,1,1,2563,'3340701131201','0000-00-00'),(28,'1270',3,'เด็กชาย','เจษฎาพร','ธานี','1349700388919',1,NULL,9,1,1,2563,'3340701131201','0000-00-00'),(29,'1271',4,'เด็กชาย','ชัชพล','แจ่มสกุล','1348900203016',1,NULL,9,1,1,2563,'3340701131201','0000-00-00'),(31,'1273',6,'เด็กชาย','นครินทร์','จำเริญ','1348900205493',1,NULL,9,1,1,2563,'3340701131201','0000-00-00'),(32,'1276',7,'เด็กชาย','เดชศักดิ์ดา','สุคุณา','1348900202109',1,NULL,9,1,1,2563,'3340701131201','0000-00-00'),(33,'1277',8,'เด็กชาย','อายุทัย','พูลสุข','1348900212635',1,NULL,9,1,1,2563,'3340701131201','0000-00-00'),(34,'1278',9,'เด็กหญิง','กฤตยา','กั้ววิจารย์','1348900198861',2,NULL,9,1,1,2563,'3340701131201','0000-00-00'),(35,'1279',10,'เด็กหญิง','ฝันสิริ','เงินงาม','1409903734560',2,NULL,9,1,1,2563,'3340701131201','0000-00-00'),(36,'1280',11,'เด็กหญิง','รัตนภรณ์','กออำไพ','1348900201358',2,NULL,9,1,1,2563,'3340701131201','0000-00-00'),(37,'1281',12,'เด็กหญิง','วิลาวรรณ','ธานี','1348900195773',2,NULL,9,1,1,2563,'3340701131201','0000-00-00'),(165,'1388',4,'เด็กชาย','ธนพัฒน์   ',' เต่าทอง','1104301668613',1,'',6,1,0,NULL,'3340701131201','2021-06-28'),(152,'1376',1,'เด็กชาย','จีระศักดิ์   ','ธานี','1341501580723',1,'',7,1,0,NULL,'3340701131201','2020-07-14'),(226,'1446',1,'เด็กชาย','กชฐณณ(กด-ถะ-นน)','จำศรี','1349902367203',1,'',2,1,0,NULL,'3340701131201','2025-05-16'),(45,'1260',0,'เด็กหญิง','พรทิพย์','ทองแจ่ม','1348900184551',2,NULL,5,1,3,2558,'','0000-00-00'),(157,'1381',5,'เด็กชาย','รณกร   ','ศาลา','1342900056522',1,'',7,1,0,NULL,'3340701131201','2020-07-14'),(154,'1378',2,'เด็กชาย','ปรีชา','ดารุนิกร','1341501581908',1,'',7,1,0,NULL,'3340701131201','2020-07-14'),(155,'1379',3,'เด็กชาย','ประกาศิต','อำพันธ์','1341501587345',1,'',7,1,0,NULL,'3340701131201','2020-07-14'),(143,'1367',7,'เด็กชาย','วุฒิชัย','สมอารีย์','1342900056492',1,'',8,1,0,NULL,'3340701131201','2019-05-23'),(163,'1386',2,'เด็กชาย','ธนเดช   ','พรมสวัสดิ์','1348900405611',1,'',6,1,0,NULL,'3340701131201','2021-06-28'),(141,'1365',5,'เด็กชาย','ปฏิพัทธ์','เจริญเชาว์','1341501572933',1,'',8,1,0,NULL,'3340701131201','2019-05-23'),(140,'1364',4,'เด็กชาย','ไชยพัฒน์','เกษมทาง','1341501569479',1,'',8,1,0,NULL,'3340701131201','2019-05-23'),(139,'1363',3,'เด็กชาย','ธีรภัทร','ไชยวงค์','1341501574251',1,'',8,1,0,NULL,'3340701131201','2019-05-23'),(126,'1350',13,'เด็กชาย','อภิชาติ','แสวงวงค์','1349901536397',1,'',9,1,1,2563,'3340701131201','2018-08-27'),(160,'1384',8,'เด็กหญิง','จิรายุ   ','ชวดทอง','1341501588112',2,'',7,1,0,NULL,'3340701131201','2020-07-14'),(59,'1313',0,'เด็กชาย','อัมรินทร์','ธานี','1219901028643',1,NULL,9,1,1,2560,'','0000-00-00'),(60,'1230',0,'เด็กชาย','กชกร','แคหอม','1348900129118',1,NULL,9,1,1,2560,'','0000-00-00'),(61,'1231',0,'เด็กชาย','ธรีเดช','ลำดับ','1749700122958',1,NULL,9,1,1,2560,'','0000-00-00'),(62,'1232',0,'เด็กชาย','บดินทร์ชัย','มุทะระพัฒน์','1341501480851',1,NULL,9,1,1,2560,'','0000-00-00'),(63,'1234',0,'เด็กชาย','พงศกร','จันแก้ว','1348900128545',1,NULL,9,1,1,2560,'','0000-00-00'),(64,'1286',0,'เด็กชาย','ปฐวี','นุชประสาท','1101801432870',1,NULL,9,1,1,2560,'','0000-00-00'),(65,'1235',0,'เด็กหญิง','นันทวดี','สีสาสีมา','1348900130892',2,NULL,9,1,1,2560,'','0000-00-00'),(66,'1236',0,'เด็กหญิง','นิตยา','ชวดทอง','1341501468435',2,NULL,9,1,1,2560,'','0000-00-00'),(67,'1237',0,'เด็กหญิง','วรรณวิษา','สวัสดี','1129901952384',2,NULL,9,1,1,2560,'','0000-00-00'),(68,'1238',0,'เด็กหญิง','อัจฉริยาภรณ์','สมสุข','1341501478694',2,NULL,9,1,1,2560,'','0000-00-00'),(69,'1210',0,'เด็กชาย','จีรภัทร','เหลืองทอง','1348900092788',1,NULL,9,1,1,2559,'','0000-00-00'),(70,'1211',0,'เด็กชาย','ชัยพร','ทองโท','1348900085871',1,NULL,9,1,1,2559,'','0000-00-00'),(71,'1212',0,'เด็กชาย','ชาญชัย','กาสา','1347700017048',1,NULL,9,1,1,2559,'','0000-00-00'),(72,'1215',0,'เด็กชาย','ศรนรินทร์','ประสานวงษ์','1348900088535',1,NULL,9,1,1,2559,'','0000-00-00'),(73,'1216',0,'เด็กชาย','ศุภกร','ตันสุ','1348900097470',1,NULL,9,1,1,2559,'','0000-00-00'),(74,'1217',0,'เด็กชาย','สิทธิพร','อินทะนาม','1348900090998',1,NULL,9,1,1,2559,'','0000-00-00'),(75,'1218',0,'เด็กชาย','อัครพล','พูลสุข','1348900102104',1,NULL,9,1,1,2559,'','0000-00-00'),(76,'1266',0,'เด็กชาย','ทินกร','สิงห์โห','1104000107558',1,NULL,9,1,1,2559,'','0000-00-00'),(77,'1219',0,'เด็กหญิง','กาญจนา','บุญเจริญ','1348900089655',2,NULL,9,1,1,2559,'','0000-00-00'),(78,'1220',0,'เด็กหญิง','จุฑามาศ','แสงงาม','1348900102244',2,NULL,9,1,1,2559,'','0000-00-00'),(79,'1221',0,'เด็กหญิง','ภัทรมน','ชินโชติ','1349901321463',2,NULL,9,1,1,2559,'','0000-00-00'),(80,'1222',0,'เด็กหญิง','อรชา','พิมมะศรี','1348900092591',2,NULL,9,1,1,2559,'','0000-00-00'),(81,'1223',0,'เด็กหญิง','อาภาพร','ธานี','1348900089493',2,NULL,9,1,1,2559,'','0000-00-00'),(82,'1198',0,'เด็กชาย','กฤตยชญ์','คำอุด','1348900040869',1,NULL,9,1,1,2561,'','0000-00-00'),(83,'1199',0,'เด็กชาย','ธีรภัทร','ประเสริฐบุญ','1348900059136',1,NULL,9,1,1,2561,'','0000-00-00'),(84,'1200',0,'เด็กชาย','ธีรศักดิ์','วงธะนู','1348900068712',1,NULL,9,1,1,2561,'','0000-00-00'),(85,'1239',0,'เด็กชาย','ธวัชชัย','เพพัง','1348900061351',1,NULL,9,1,1,2561,'','0000-00-00'),(86,'1201',0,'เด็กหญิง','จิดาภา','โนนจันทร์','1348900067490',2,NULL,9,1,1,2561,'','0000-00-00'),(87,'1202',0,'เด็กหญิง','ศุภนิดา','บุญอาจ','1348900080348',2,NULL,9,1,1,2561,'','0000-00-00'),(88,'1203',0,'เด็กหญิง','สุชาดา','เกตุสิน','1348900083053',2,NULL,9,1,1,2561,'','0000-00-00'),(89,'1204',0,'เด็กหญิง','สุภัท','เพชรนุช','1749800356233',2,NULL,9,1,1,2561,'','0000-00-00'),(90,'1267',0,'เด็กหญิง','รัตนภรณ์','วระโงน','1104000083357',2,NULL,9,1,1,2561,'','0000-00-00'),(91,'1316',0,'เด็กหญิง','สุนิดา','ช่างทอง','1103703555405',2,'',9,1,1,2559,'3341100274253','2015-11-03'),(92,'1315',0,'เด็กชาย','ธนากร','สายลาด','1418600045627',1,'',9,1,1,2558,'3341100274253','2015-11-03'),(171,'1394',9,'เด็กหญิง','เกวลิน   ','งามม้าว','1341501606927',2,'',6,1,0,NULL,'3340701131201','2021-06-28'),(170,'1393',8,'เด็กชาย','สารัชต์    ',' แก้วกรมไกร','1341501599904',1,'',6,1,0,NULL,'3340701131201','2021-06-28'),(169,'1392',7,'เด็กชาย','รัชชานนท์    ','ทังโส','1341501609462',1,'',6,1,0,NULL,'3340701131201','2021-06-28'),(233,'1453',15,'เด็กหญิง','ปภาวรินทร์','บุญเจริญ','1399200046717',2,'',6,1,0,NULL,'3340701131201','2025-11-03'),(101,'1340',1,'เด็กชาย','กมลเทพ','อ่างศิลป','1341501555931',1,'',9,1,0,NULL,'3340701131201','2018-08-27'),(102,'1342',2,'เด็กชาย','นันทพัทธ์','โหมดงาม','1348900316422',1,'',9,1,0,NULL,'3340701131201','2018-08-27'),(103,'1343',3,'เด็กชาย','ภาณุพงศ์','อำพันธ์','1341501559562',1,'',9,1,0,NULL,'3340701131201','2018-08-27'),(104,'1344',4,'เด็กชาย','ธนกฤต','ไทยสมัคร','1341501567221',1,'',9,1,0,NULL,'3340701131201','2018-08-27'),(105,'1345',5,'เด็กหญิง','กัญญาพัชร','อ่อนไทย','1341501566399',2,'',9,1,0,NULL,'3340701131201','2018-08-27'),(106,'1346',6,'เด็กหญิง','ขนิษฐากานต์','สีตั้ง','1341501555702',2,'',9,1,0,NULL,'3340701131201','2018-08-27'),(107,'1347',7,'เด็กหญิง','ปัฐมาวรรณ','ชินะโชติ','1341501559864',2,'',9,1,0,NULL,'3340701131201','2018-08-27'),(108,'1348',8,'เด็กหญิง','ปนัดดา','วงศ์ประเทศ','1341501556148',2,'',9,1,0,NULL,'3340701131201','2018-08-27'),(109,'1349',9,'เด็กหญิง','วรัญญา','พูลสุข','1341501558400',2,'',9,1,0,NULL,'3340701131201','2018-08-27'),(225,'1445',9,'เด็กหญิง','อุดมลักษณ์','บุญเจริญ','1348900511985',2,'',3,1,0,NULL,'3340701131201','2024-05-20'),(227,'1447',2,'เด็กชาย','กันตภณ  ','สายคำ','1346400001501',1,'',2,1,0,NULL,'3340701131201','2025-05-16'),(228,'1448',3,'เด็กชาย','ธนวันต์   ','ทำบุญ','1349902366592',1,'',2,1,0,NULL,'3340701131201','2025-05-16'),(223,'1443',7,'เด็กหญิง','โชติกา','อำพันธ์','1341501650829',2,'',3,1,0,NULL,'3340701131201','2024-05-20'),(222,'1442',6,'เด็กชาย','อภิวัฒน์','แสงงาม','1349902311330',1,'',3,1,0,NULL,'3340701131201','2024-05-20'),(221,'1441',5,'เด็กชาย','ณัฐสิทธิ์','คำสุข','1341501652139',1,'',3,1,0,NULL,'3340701131201','2024-05-20'),(220,'1440',4,'เด็กชาย','ณัฐวุฒิ','อ่างแก้ว','1348900507848',1,'',3,1,0,NULL,'3340701131201','2024-05-20'),(218,'1438',2,'เด็กชาย','ภารวี','สีสำอาง','1341501647976',1,'',3,1,0,NULL,'3340701131201','2024-05-20'),(185,'1407',1,'เด็กชาย','จิรัฐพันธ์','พิมมะศรี','1341501610789',1,'',5,1,0,NULL,'3340701131201','2022-05-24'),(137,'1361',2,'เด็กชาย','ธนกร','ตันสุ','1341501576904',1,'',8,1,0,NULL,'1340700555388','2019-05-23'),(127,'1354',10,'เด็กหญิง','นิภาพร','สุภาจันทร์','1348900216991',2,'',9,1,1,2564,'3340701131201','2018-08-27'),(217,'1437',1,'เด็กชาย','ภัคพล','ธานี','1341501644365',1,'',3,1,0,NULL,'3340701131201','2024-05-20'),(206,'1426',5,'เด็กชาย','ธนวัฒน์','แสนดวง','1348900480427',1,'',4,1,0,NULL,'3340701131201','2023-05-18'),(173,'1396',10,'เด็กหญิง','ณัฐธิดา   ','ทองคำ','1341501606480',2,'',6,1,0,NULL,'3340701131201','2021-06-28'),(142,'1366',6,'เด็กชาย','ภัทรดนัย','เมืองสองชั้น','1118700282119',1,'',8,1,0,NULL,'3340701131201','2019-05-23'),(133,'1355',14,'เด็กชาย','กิตติพงศ์','สุภาจันทร์','1860401293981',1,'',9,1,1,2563,'3340701131201','2018-11-02'),(162,'1385',1,'เด็กชาย','ชญตว์   ',' จันแก้ว','1101100321648',1,'',6,1,0,NULL,'3340701131201','2021-06-28'),(159,'1383',7,'เด็กหญิง','รัตติยากร  ','สายคำ','1348900388105',2,'',7,1,0,NULL,'3340701131201','2020-07-14'),(232,'1452',7,'เด็กชาย','กฤติเดช','บุญเจริญ','1219700159082',1,'',2,1,0,NULL,'3340701131201','2025-11-03'),(204,'1424',3,'เด็กชาย','ฐิติภัทร','ประดู่','1348900465797',1,'',4,1,0,NULL,'3340701131201','2023-05-18'),(158,'1382',6,'เด็กชาย','สุรเดช   ','สิงห์โห','1348900379556',1,'',7,1,0,NULL,'3340701131201','2020-07-14'),(136,'1360',1,'เด็กชาย','ดำรงศักดิ์','ธานี','1341501574731',1,'',8,1,0,NULL,'3340300018845','2019-05-23'),(150,'1374',11,'เด็กหญิง','ธนิสรา  ','แจ่มสกุล','1102200415599',2,'',8,1,0,NULL,'3340701131201','2020-07-14'),(156,'1380',4,'เด็กชาย','พุฒิพงษ์  ','ธานี','1349902089971',1,'',7,1,0,NULL,'3340701131201','2020-07-14'),(216,'1436',13,'เด็กชาย','เมธัสชัย','วัฒนสิงห์','1459200111356',1,'',5,1,0,NULL,'3340701131201','2024-05-20'),(231,'1451',6,'เด็กหญิง','พิชญาภา  ','ทำบุญ','1103101507992',2,'',2,1,0,NULL,'3340701131201','2025-05-16'),(146,'1370',8,'เด็กหญิง','ณัฐกมล','บุญธิเสน','1342900056450',2,'',8,1,0,NULL,'3340701131201','2019-05-23'),(147,'1371',9,'เด็กหญิง','นุศรา','สีสาสีมา','1348900349568',2,'',8,1,0,NULL,'3340701131201','2019-05-23'),(148,'1372',10,'เด็กหญิง','นันทิชา','เยื่อใย','1348900353930',2,'',8,1,0,NULL,'3340701131201','2019-05-23'),(164,'1387',3,'เด็กชาย','ธนาธิป   ',' ชวดทอง','1489900843716',1,'',6,1,0,NULL,'3340701131201','2021-06-28'),(175,'1398',11,'เด็กหญิง','ประกายแก้ว   ','ประจญ','1341501595097',2,'',6,1,0,NULL,'3340701131201','2021-06-28'),(176,'1399',12,'เด็กหญิง','ปรานต์ฟ้า   ','ยอดวงค์ษา','1348900427267',2,'',6,1,0,NULL,'3340701131201','2021-06-28'),(177,'1400',13,'เด็กหญิง','พัชราภา  ','ไชยรัตน์','1342900056662',2,'',6,1,0,NULL,'3340701131201','2021-06-28'),(178,'1401',14,'เด็กหญิง','สิรินดา   ','พงษ์บัว','1348900413304',2,'',6,1,0,NULL,'3340701131201','2021-06-28'),(205,'1425',4,'เด็กชาย','ณัฐวรรธน์','ทำบุญ','1349902268311',1,'',4,1,0,NULL,'3340701131201','2023-05-18'),(202,'1422',1,'เด็กชาย','กันตภณ','ชวดทอง','1129701746756',1,'',4,1,0,NULL,'3340701131201','2023-05-18'),(186,'1408',2,'เด็กชาย','ชัยมนัส','ศรีสอาด','1341501614849',1,'',5,1,0,NULL,'3340701131201','2022-05-24'),(187,'1409',3,'เด็กชาย','ภาคิน','อินธิไชย','1348900441073',1,'',5,1,0,NULL,'3340701131201','2022-05-24'),(188,'1410',4,'เด็กชาย','ภักดีบดินทร์','ไชยวงศ์','1341501620113',1,'',5,1,0,NULL,'3340701131201','2022-05-24'),(189,'1411',5,'เด็กชาย','วัชรากร','อินทร์สม','1341501619719',1,'',5,1,0,NULL,'3340701131201','2022-05-24'),(190,'1412',6,'เด็กชาย','สิทธิชัย','จันทร์เขียว','1739902877534',1,'',5,1,0,NULL,'3340701131201','2022-05-24'),(191,'1413',7,'เด็กชาย','อาชวิน','โทนไทย','1129902578109',1,'',5,1,0,NULL,'3340701131201','2022-05-24'),(214,'1434',11,'เด็กชาย','ต้นกล้า','ที','0103700002776',1,'',4,1,0,NULL,'3340701131201','2023-05-24'),(193,'1415',8,'เด็กหญิง','ชรินดา','มาคะวงค์','1341501616019',2,'',5,1,0,NULL,'3340701131201','2022-05-24'),(194,'1416',9,'เด็กหญิง','ชุติมา','คำภาทู','1341501610274',2,'',5,1,0,NULL,'3340701131201','2022-05-24'),(195,'1417',10,'เด็กหญิง','ดาวิกา','ศรีแจ่ม','1347600137891',2,'',5,1,0,NULL,'3340701131201','2022-05-24'),(196,'1418',11,'เด็กหญิง','ภัทรธิดา','สุทธิเลิศ','1349700546948',2,'',5,1,0,NULL,'3340701131201','2022-05-24'),(197,'1419',12,'เด็กหญิง','โชติกา','พุ่มจันทร์','1348900437912',2,'',5,1,0,NULL,'3340701131201','2022-05-24'),(230,'1450',5,'เด็กหญิง','เบญญาพร  ','ประสานวงษ์','1346400003156',2,'',2,1,0,NULL,'3340701131201','2025-05-16'),(229,'1449',4,'เด็กหญิง','กิตติยาพร   ','อักษร','1342900056905',2,'',2,1,0,NULL,'3340701131201','2025-05-16');

--
-- Table structure for table `student_main_class`
--

CREATE TABLE `student_main_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class_code` tinyint(4) NOT NULL,
  `class_name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `class_code` (`class_code`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_main_class`
--

INSERT INTO `student_main_class` VALUES (1,2,'อนุบาล2'),(2,3,'อนุบาล3'),(3,4,'ประถมศึกษาปีที่1'),(4,5,'ประถมศึกษาปีที่2'),(5,6,'ประถมศึกษาปีที่3'),(6,7,'ประถมศึกษาปีที่4'),(7,8,'ประถมศึกษาปีที่5'),(8,9,'ประถมศึกษาปีที่6');

--
-- Table structure for table `student_main_classlog`
--

CREATE TABLE `student_main_classlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ed_year` int(11) NOT NULL,
  `student_id` varchar(7) NOT NULL,
  `student_number` int(11) DEFAULT NULL,
  `class_code` tinyint(4) NOT NULL,
  `room` tinyint(4) DEFAULT 0,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=779 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_main_classlog`
--

INSERT INTO `student_main_classlog` VALUES (1,2558,'1260',0,5,1,'3341100274253','2015-11-03'),(2,2561,'1299',0,2,1,'3340701131201','2018-08-25'),(3,2561,'1300',0,2,1,'3340701131201','2018-08-25'),(4,2561,'1301',0,2,1,'3340701131201','2018-08-25'),(5,2561,'1302',0,2,1,'3340701131201','2018-08-25'),(6,2561,'1303',0,2,1,'3340701131201','2018-08-25'),(7,2561,'1304',0,2,1,'3340701131201','2018-08-25'),(8,2561,'1305',0,2,1,'3340701131201','2018-08-25'),(9,2561,'1306',0,2,1,'3340701131201','2018-08-25'),(10,2561,'1307',0,2,1,'3340701131201','2018-08-25'),(11,2561,'1308',0,2,1,'3340701131201','2018-08-25'),(12,2561,'1309',0,2,1,'3340701131201','2018-08-25'),(13,2561,'1310',0,2,1,'3340701131201','2018-08-25'),(14,2561,'1311',0,2,1,'3340701131201','2018-08-25'),(15,2561,'1312',0,2,1,'3340701131201','2018-08-25'),(16,2561,'1287',0,3,1,'3340701131201','2018-08-25'),(17,2561,'1288',0,3,1,'3340701131201','2018-08-25'),(18,2561,'1290',0,3,1,'3340701131201','2018-08-25'),(19,2561,'1291',0,3,1,'3340701131201','2018-08-25'),(20,2561,'1292',0,3,1,'3340701131201','2018-08-25'),(21,2561,'1294',0,3,1,'3340701131201','2018-08-25'),(22,2561,'1295',0,3,1,'3340701131201','2018-08-25'),(23,2561,'1296',0,3,1,'3340701131201','2018-08-25'),(24,2561,'1297',0,3,1,'3340701131201','2018-08-25'),(25,2561,'1298',0,3,1,'3340701131201','2018-08-25'),(26,2561,'1268',0,4,1,'3340701131201','2018-08-25'),(27,2561,'1269',0,4,1,'3340701131201','2018-08-25'),(28,2561,'1270',0,4,1,'3340701131201','2018-08-25'),(29,2561,'1271',0,4,1,'3340701131201','2018-08-25'),(30,2561,'1272',0,4,1,'3340701131201','2018-08-25'),(31,2561,'1273',0,4,1,'3340701131201','2018-08-25'),(32,2561,'1276',0,4,1,'3340701131201','2018-08-25'),(33,2561,'1277',0,4,1,'3340701131201','2018-08-25'),(34,2561,'1278',0,4,1,'3340701131201','2018-08-25'),(35,2561,'1279',0,4,1,'3340701131201','2018-08-25'),(36,2561,'1280',0,4,1,'3340701131201','2018-08-25'),(37,2561,'1281',0,4,1,'3340701131201','2018-08-25'),(38,2561,'1314',0,4,1,'3340701131201','2018-08-25'),(39,2561,'1254',0,5,1,'3340701131201','2018-08-25'),(40,2561,'1255',0,5,1,'3340701131201','2018-08-25'),(41,2561,'1256',0,5,1,'3340701131201','2018-08-25'),(42,2561,'1257',0,5,1,'3340701131201','2018-08-25'),(43,2561,'1258',0,5,1,'3340701131201','2018-08-25'),(44,2561,'1259',0,5,1,'3340701131201','2018-08-25'),(45,2561,'1261',0,5,1,'3340701131201','2018-08-25'),(46,2561,'1262',0,5,1,'3340701131201','2018-08-25'),(47,2561,'1263',0,5,1,'3340701131201','2018-08-25'),(48,2561,'1264',0,5,1,'3340701131201','2018-08-25'),(49,2561,'1265',0,5,1,'3340701131201','2018-08-25'),(50,2561,'1283',0,5,1,'3340701131201','2018-08-25'),(51,2561,'1241',0,6,1,'3340701131201','2018-08-25'),(52,2561,'1243',0,6,1,'3340701131201','2018-08-25'),(53,2561,'1245',0,6,1,'3340701131201','2018-08-25'),(54,2561,'1246',0,6,1,'3340701131201','2018-08-25'),(55,2561,'1249',0,6,1,'3340701131201','2018-08-25'),(56,2561,'1250',0,6,1,'3340701131201','2018-08-25'),(57,2561,'1251',0,6,1,'3340701131201','2018-08-25'),(58,2561,'1252',0,6,1,'3340701131201','2018-08-25'),(59,2561,'1230',0,7,1,'3340701131201','2018-08-25'),(60,2561,'1231',0,7,1,'3340701131201','2018-08-25'),(61,2561,'1232',0,7,1,'3340701131201','2018-08-25'),(62,2561,'1234',0,7,1,'3340701131201','2018-08-25'),(63,2561,'1235',0,7,1,'3340701131201','2018-08-25'),(64,2561,'1236',0,7,1,'3340701131201','2018-08-25'),(65,2561,'1237',0,7,1,'3340701131201','2018-08-25'),(66,2561,'1238',0,7,1,'3340701131201','2018-08-25'),(67,2561,'1286',0,7,1,'3340701131201','2018-08-25'),(68,2561,'1313',0,7,1,'3340701131201','2018-08-25'),(69,2561,'1210',0,8,1,'3340701131201','2018-08-25'),(70,2561,'1211',0,8,1,'3340701131201','2018-08-25'),(71,2561,'1212',0,8,1,'3340701131201','2018-08-25'),(72,2561,'1215',0,8,1,'3340701131201','2018-08-25'),(73,2561,'1216',0,8,1,'3340701131201','2018-08-25'),(74,2561,'1217',0,8,1,'3340701131201','2018-08-25'),(75,2561,'1218',0,8,1,'3340701131201','2018-08-25'),(76,2561,'1219',0,8,1,'3340701131201','2018-08-25'),(77,2561,'1220',0,8,1,'3340701131201','2018-08-25'),(78,2561,'1221',0,8,1,'3340701131201','2018-08-25'),(79,2561,'1222',0,8,1,'3340701131201','2018-08-25'),(80,2561,'1223',0,8,1,'3340701131201','2018-08-25'),(81,2561,'1266',0,8,1,'3340701131201','2018-08-25'),(82,2561,'1316',0,8,1,'3340701131201','2018-08-25'),(83,2561,'1198',0,9,1,'3340701131201','2018-08-25'),(84,2561,'1199',0,9,1,'3340701131201','2018-08-25'),(85,2561,'1200',0,9,1,'3340701131201','2018-08-25'),(86,2561,'1201',0,9,1,'3340701131201','2018-08-25'),(87,2561,'1202',0,9,1,'3340701131201','2018-08-25'),(88,2561,'1203',0,9,1,'3340701131201','2018-08-25'),(89,2561,'1204',0,9,1,'3340701131201','2018-08-25'),(90,2561,'1239',0,9,1,'3340701131201','2018-08-25'),(91,2561,'1267',0,9,1,'3340701131201','2018-08-25'),(92,2561,'1315',0,9,1,'3340701131201','2018-08-25'),(93,2558,'1315',0,9,1,'3340701131201','2018-08-25'),(94,2558,'1263',0,5,1,'3340701131201','2018-08-25'),(95,2558,'1264',0,5,1,'3340701131201','2018-08-25'),(96,2558,'1265',0,5,1,'3340701131201','2018-08-25'),(97,2558,'1283',0,5,1,'3340701131201','2018-08-25'),(98,2558,'1241',0,6,1,'3340701131201','2018-08-25'),(99,2558,'1243',0,6,1,'3340701131201','2018-08-25'),(100,2558,'1245',0,6,1,'3340701131201','2018-08-25'),(101,2558,'1246',0,6,1,'3340701131201','2018-08-25'),(102,2558,'1249',0,6,1,'3340701131201','2018-08-25'),(103,2558,'1250',0,6,1,'3340701131201','2018-08-25'),(104,2558,'1251',0,6,1,'3340701131201','2018-08-25'),(105,2558,'1252',0,6,1,'3340701131201','2018-08-25'),(106,2558,'1230',0,7,1,'3340701131201','2018-08-25'),(107,2558,'1231',0,7,1,'3340701131201','2018-08-25'),(108,2558,'1232',0,7,1,'3340701131201','2018-08-25'),(109,2558,'1234',0,7,1,'3340701131201','2018-08-25'),(110,2558,'1235',0,7,1,'3340701131201','2018-08-25'),(111,2558,'1236',0,7,1,'3340701131201','2018-08-25'),(112,2558,'1237',0,7,1,'3340701131201','2018-08-25'),(113,2558,'1238',0,7,1,'3340701131201','2018-08-25'),(114,2558,'1286',0,7,1,'3340701131201','2018-08-25'),(115,2558,'1313',0,7,1,'3340701131201','2018-08-25'),(116,2558,'1210',0,8,1,'3340701131201','2018-08-25'),(117,2558,'1211',0,8,1,'3340701131201','2018-08-25'),(118,2558,'1212',0,8,1,'3340701131201','2018-08-25'),(119,2558,'1215',0,8,1,'3340701131201','2018-08-25'),(120,2558,'1216',0,8,1,'3340701131201','2018-08-25'),(121,2558,'1217',0,8,1,'3340701131201','2018-08-25'),(122,2558,'1218',0,8,1,'3340701131201','2018-08-25'),(123,2558,'1219',0,8,1,'3340701131201','2018-08-25'),(124,2558,'1220',0,8,1,'3340701131201','2018-08-25'),(125,2558,'1221',0,8,1,'3340701131201','2018-08-25'),(126,2558,'1222',0,8,1,'3340701131201','2018-08-25'),(127,2558,'1223',0,8,1,'3340701131201','2018-08-25'),(128,2558,'1266',0,8,1,'3340701131201','2018-08-25'),(129,2558,'1316',0,8,1,'3340701131201','2018-08-25'),(130,2559,'1210',0,9,1,'3340701131201','2018-08-25'),(131,2559,'1211',0,9,1,'3340701131201','2018-08-25'),(132,2559,'1212',0,9,1,'3340701131201','2018-08-25'),(133,2559,'1215',0,9,1,'3340701131201','2018-08-25'),(134,2559,'1216',0,9,1,'3340701131201','2018-08-25'),(135,2559,'1217',0,9,1,'3340701131201','2018-08-25'),(136,2559,'1218',0,9,1,'3340701131201','2018-08-25'),(137,2559,'1219',0,9,1,'3340701131201','2018-08-25'),(138,2559,'1220',0,9,1,'3340701131201','2018-08-25'),(139,2559,'1221',0,9,1,'3340701131201','2018-08-25'),(140,2559,'1222',0,9,1,'3340701131201','2018-08-25'),(141,2559,'1223',0,9,1,'3340701131201','2018-08-25'),(142,2559,'1266',0,9,1,'3340701131201','2018-08-25'),(143,2559,'1316',0,9,1,'3340701131201','2018-08-25'),(144,2559,'1263',0,6,1,'3340701131201','2018-08-25'),(145,2559,'1264',0,6,1,'3340701131201','2018-08-25'),(146,2559,'1265',0,6,1,'3340701131201','2018-08-25'),(147,2559,'1283',0,6,1,'3340701131201','2018-08-25'),(148,2559,'1241',0,7,1,'3340701131201','2018-08-25'),(149,2559,'1243',0,7,1,'3340701131201','2018-08-25'),(150,2559,'1245',0,7,1,'3340701131201','2018-08-25'),(151,2559,'1246',0,7,1,'3340701131201','2018-08-25'),(152,2559,'1249',0,7,1,'3340701131201','2018-08-25'),(153,2559,'1250',0,7,1,'3340701131201','2018-08-25'),(154,2559,'1251',0,7,1,'3340701131201','2018-08-25'),(155,2559,'1252',0,7,1,'3340701131201','2018-08-25'),(156,2559,'1230',0,8,1,'3340701131201','2018-08-25'),(157,2559,'1231',0,8,1,'3340701131201','2018-08-25'),(158,2559,'1232',0,8,1,'3340701131201','2018-08-25'),(159,2559,'1234',0,8,1,'3340701131201','2018-08-25'),(160,2559,'1235',0,8,1,'3340701131201','2018-08-25'),(161,2559,'1236',0,8,1,'3340701131201','2018-08-25'),(162,2559,'1237',0,8,1,'3340701131201','2018-08-25'),(163,2559,'1238',0,8,1,'3340701131201','2018-08-25'),(164,2559,'1286',0,8,1,'3340701131201','2018-08-25'),(165,2559,'1313',0,8,1,'3340701131201','2018-08-25'),(166,2560,'1230',0,9,1,'3340701131201','2018-08-25'),(167,2560,'1231',0,9,1,'3340701131201','2018-08-25'),(168,2560,'1234',0,9,1,'3340701131201','2018-08-25'),(169,2560,'1235',0,9,1,'3340701131201','2018-08-25'),(170,2560,'1236',0,9,1,'3340701131201','2018-08-25'),(171,2560,'1237',0,9,1,'3340701131201','2018-08-25'),(172,2560,'1238',0,9,1,'3340701131201','2018-08-25'),(173,2560,'1286',0,9,1,'3340701131201','2018-08-25'),(174,2560,'1313',0,9,1,'3340701131201','2018-08-25'),(175,2560,'1299',0,2,1,'3340701131201','2018-08-25'),(176,2560,'1300',0,2,1,'3340701131201','2018-08-25'),(177,2560,'1301',0,2,1,'3340701131201','2018-08-25'),(178,2560,'1302',0,2,1,'3340701131201','2018-08-25'),(179,2560,'1303',0,2,1,'3340701131201','2018-08-25'),(180,2560,'1304',0,2,1,'3340701131201','2018-08-25'),(181,2560,'1305',0,2,1,'3340701131201','2018-08-25'),(182,2560,'1306',0,2,1,'3340701131201','2018-08-25'),(183,2560,'1307',0,2,1,'3340701131201','2018-08-25'),(184,2560,'1308',0,2,1,'3340701131201','2018-08-25'),(185,2560,'1309',0,2,1,'3340701131201','2018-08-25'),(186,2560,'1310',0,2,1,'3340701131201','2018-08-25'),(187,2560,'1311',0,2,1,'3340701131201','2018-08-25'),(188,2560,'1312',0,2,1,'3340701131201','2018-08-25'),(189,2560,'1287',0,3,1,'3340701131201','2018-08-25'),(190,2560,'1288',0,3,1,'3340701131201','2018-08-25'),(191,2560,'1290',0,3,1,'3340701131201','2018-08-25'),(192,2560,'1291',0,3,1,'3340701131201','2018-08-25'),(193,2560,'1292',0,3,1,'3340701131201','2018-08-25'),(194,2560,'1294',0,3,1,'3340701131201','2018-08-25'),(195,2560,'1295',0,3,1,'3340701131201','2018-08-25'),(196,2560,'1296',0,3,1,'3340701131201','2018-08-25'),(197,2560,'1297',0,3,1,'3340701131201','2018-08-25'),(198,2560,'1298',0,3,1,'3340701131201','2018-08-25'),(199,2560,'1268',0,4,1,'3340701131201','2018-08-25'),(200,2560,'1269',0,4,1,'3340701131201','2018-08-25'),(201,2560,'1270',0,4,1,'3340701131201','2018-08-25'),(202,2560,'1271',0,4,1,'3340701131201','2018-08-25'),(203,2560,'1272',0,4,1,'3340701131201','2018-08-25'),(204,2560,'1273',0,4,1,'3340701131201','2018-08-25'),(205,2560,'1276',0,4,1,'3340701131201','2018-08-25'),(206,2560,'1277',0,4,1,'3340701131201','2018-08-25'),(207,2560,'1278',0,4,1,'3340701131201','2018-08-25'),(208,2560,'1279',0,4,1,'3340701131201','2018-08-25'),(209,2560,'1280',0,4,1,'3340701131201','2018-08-25'),(210,2560,'1281',0,4,1,'3340701131201','2018-08-25'),(211,2560,'1314',0,4,1,'3340701131201','2018-08-25'),(212,2560,'1254',0,5,1,'3340701131201','2018-08-25'),(213,2560,'1255',0,5,1,'3340701131201','2018-08-25'),(214,2560,'1256',0,5,1,'3340701131201','2018-08-25'),(215,2560,'1257',0,5,1,'3340701131201','2018-08-25'),(216,2560,'1258',0,5,1,'3340701131201','2018-08-25'),(217,2560,'1259',0,5,1,'3340701131201','2018-08-25'),(218,2560,'1261',0,5,1,'3340701131201','2018-08-25'),(219,2560,'1262',0,5,1,'3340701131201','2018-08-25'),(220,2560,'1232',0,9,1,'3340701131201','2018-08-27'),(221,2560,'1251',8,9,1,'3340701131201','2019-05-03'),(222,2560,'1252',9,9,1,'3340701131201','2019-05-03'),(223,2561,'1340',1,1,1,'3340701131201','2019-05-03'),(224,2561,'1342',2,1,1,'3340701131201','2019-05-03'),(225,2561,'1343',3,1,1,'3340701131201','2019-05-03'),(226,2561,'1344',4,1,1,'3340701131201','2019-05-03'),(227,2561,'1345',5,1,1,'3340701131201','2019-05-03'),(228,2561,'1346',6,1,1,'3340701131201','2019-05-03'),(229,2561,'1347',7,1,1,'3340701131201','2019-05-03'),(230,2561,'1348',8,1,1,'3340701131201','2019-05-03'),(231,2561,'1349',9,1,1,'3340701131201','2019-05-03'),(232,2561,'1358',14,5,1,'3340701131201','2019-05-03'),(233,2561,'1350',13,7,1,'3340701131201','2019-05-03'),(234,2561,'1355',14,7,1,'3340701131201','2019-05-03'),(235,2561,'1318',1,4,1,'3340701131201','2019-05-03'),(236,2561,'1319',2,4,1,'3340701131201','2019-05-03'),(237,2561,'1320',3,4,1,'3340701131201','2019-05-03'),(238,2561,'1321',4,4,1,'3340701131201','2019-05-03'),(239,2561,'1323',5,4,1,'3340701131201','2019-05-03'),(240,2561,'1325',6,4,1,'3340701131201','2019-05-03'),(241,2561,'1326',7,4,1,'3340701131201','2019-05-03'),(242,2561,'1327',8,4,1,'3340701131201','2019-05-03'),(243,2561,'1328',9,4,1,'3340701131201','2019-05-03'),(244,2561,'1329',10,4,1,'3340701131201','2019-05-03'),(245,2561,'1330',11,4,1,'3340701131201','2019-05-03'),(246,2561,'1341',12,4,1,'3340701131201','2019-05-03'),(247,2561,'1356',13,4,1,'3340701131201','2019-05-03'),(248,2561,'1289',3,6,1,'3340701131201','2019-05-03'),(249,2561,'1332',1,2,1,'3340701131201','2019-05-03'),(250,2561,'1333',2,2,1,'3340701131201','2019-05-03'),(251,2561,'1335',4,2,1,'3340701131201','2019-05-03'),(252,2561,'1336',5,2,1,'3340701131201','2019-05-03'),(253,2561,'1337',6,2,1,'3340701131201','2019-05-03'),(254,2561,'1339',7,2,1,'3340701131201','2019-05-03'),(255,2561,'1317',12,8,1,'3340701131201','2019-05-03'),(256,2561,'1351',13,8,1,'3340701131201','2019-05-03'),(257,2562,'1319',2,5,1,'3340701131201','2019-12-11'),(258,2562,'1360',1,1,1,'3340701131201','2020-07-14'),(259,2562,'1361',2,1,1,'3340701131201','2020-07-14'),(260,2562,'1362',3,1,1,'3340701131201','2020-07-14'),(261,2562,'1363',4,1,1,'3340701131201','2020-07-14'),(262,2562,'1364',5,1,1,'3340701131201','2020-07-14'),(263,2562,'1365',6,1,1,'3340701131201','2020-07-14'),(264,2562,'1366',7,1,1,'3340701131201','2020-07-14'),(265,2562,'1367',8,1,1,'3340701131201','2020-07-14'),(266,2562,'1368',9,1,1,'3340701131201','2020-07-14'),(267,2562,'1369',10,1,1,'3340701131201','2020-07-14'),(268,2562,'1370',11,1,1,'3340701131201','2020-07-14'),(269,2562,'1371',12,1,1,'3340701131201','2020-07-14'),(270,2562,'1372',13,1,1,'3340701131201','2020-07-14'),(271,2562,'1373',14,1,1,'3340701131201','2020-07-14'),(272,2562,'1340',1,2,1,'3340701131201','2020-07-14'),(273,2562,'1342',2,2,1,'3340701131201','2020-07-14'),(274,2562,'1343',3,2,1,'3340701131201','2020-07-14'),(275,2562,'1344',4,2,1,'3340701131201','2020-07-14'),(276,2562,'1345',5,2,1,'3340701131201','2020-07-14'),(277,2562,'1346',6,2,1,'3340701131201','2020-07-14'),(278,2562,'1347',7,2,1,'3340701131201','2020-07-14'),(279,2562,'1348',8,2,1,'3340701131201','2020-07-14'),(280,2562,'1349',9,2,1,'3340701131201','2020-07-14'),(281,2562,'1332',1,4,1,'3340701131201','2020-07-14'),(282,2562,'1333',2,4,1,'3340701131201','2020-07-14'),(283,2562,'1334',3,4,1,'3340701131201','2020-07-14'),(284,2562,'1335',4,4,1,'3340701131201','2020-07-14'),(285,2562,'1336',5,4,1,'3340701131201','2020-07-14'),(286,2562,'1337',6,4,1,'3340701131201','2020-07-14'),(287,2562,'1339',7,4,1,'3340701131201','2020-07-14'),(288,2562,'1359',8,4,1,'3340701131201','2020-07-14'),(289,2562,'1318',1,5,1,'3340701131201','2020-07-14'),(290,2562,'1320',3,5,1,'3340701131201','2020-07-14'),(291,2562,'1321',4,5,1,'3340701131201','2020-07-14'),(292,2562,'1323',5,5,1,'3340701131201','2020-07-14'),(293,2562,'1325',6,5,1,'3340701131201','2020-07-14'),(294,2562,'1326',7,5,1,'3340701131201','2020-07-14'),(295,2562,'1327',8,5,1,'3340701131201','2020-07-14'),(296,2562,'1328',9,5,1,'3340701131201','2020-07-14'),(297,2562,'1329',10,5,1,'3340701131201','2020-07-14'),(298,2562,'1341',12,5,1,'3340701131201','2020-07-14'),(299,2562,'1356',13,5,1,'3340701131201','2020-07-14'),(334,2562,'1310',11,7,1,'3340701131201','2020-07-14'),(301,2562,'1300',2,6,1,'3340701131201','2020-07-14'),(302,2562,'1301',3,7,1,'3340701131201','2020-07-14'),(303,2562,'1303',5,6,1,'3340701131201','2020-07-14'),(304,2562,'1304',6,6,1,'3340701131201','2020-07-14'),(305,2562,'1305',7,6,1,'3340701131201','2020-07-14'),(306,2562,'1306',8,6,1,'3340701131201','2020-07-14'),(307,2562,'1311',12,6,1,'3340701131201','2020-07-14'),(308,2562,'1287',1,7,1,'3340701131201','2020-07-14'),(309,2562,'1288',2,7,1,'3340701131201','2020-07-14'),(310,2562,'1290',4,7,1,'3340701131201','2020-07-14'),(311,2562,'1292',6,7,1,'3340701131201','2020-07-14'),(312,2562,'1294',7,7,1,'3340701131201','2020-07-14'),(313,2562,'1296',8,7,1,'3340701131201','2020-07-14'),(314,2562,'1297',9,7,1,'3340701131201','2020-07-14'),(315,2562,'1298',10,7,1,'3340701131201','2020-07-14'),(316,2562,'1331',11,7,1,'3340701131201','2020-07-14'),(317,2562,'1354',12,7,1,'3340701131201','2020-07-14'),(318,2562,'1268',1,8,1,'3340701131201','2020-07-14'),(319,2562,'1269',2,8,1,'3340701131201','2020-07-14'),(320,2562,'1270',3,8,1,'3340701131201','2020-07-14'),(321,2562,'1271',4,8,1,'3340701131201','2020-07-14'),(322,2562,'1272',5,8,1,'3340701131201','2020-07-14'),(323,2562,'1273',6,8,1,'3340701131201','2020-07-14'),(324,2562,'1276',7,8,1,'3340701131201','2020-07-14'),(325,2562,'1277',8,8,1,'3340701131201','2020-07-14'),(326,2562,'1278',9,8,1,'3340701131201','2020-07-14'),(327,2562,'1279',10,8,1,'3340701131201','2020-07-14'),(328,2562,'1280',11,8,1,'3340701131201','2020-07-14'),(329,2562,'1281',12,8,1,'3340701131201','2020-07-14'),(330,2562,'1350',13,8,1,'3340701131201','2020-07-14'),(331,2562,'1355',14,8,1,'3340701131201','2020-07-14'),(333,2562,'1308',9,7,1,'3340701131201','2020-07-14'),(335,2562,'1309',10,7,1,'3340701131201','2020-07-14'),(336,2562,'1302',4,7,1,'3340701131201','2020-07-14'),(337,2563,'1291',4,8,1,'3340701131201','2021-01-20'),(338,2563,'1374',15,3,1,'3340300018845','2021-01-21'),(339,2563,'1375',16,3,1,'3340300018845','2021-01-21'),(340,2563,'1376',1,2,1,'3340701131201','2021-01-21'),(341,2563,'1377',2,2,1,'3340701131201','2021-01-21'),(342,2563,'1378',3,2,1,'3340701131201','2021-01-21'),(343,2563,'1379',4,2,1,'3340300018845','2021-01-21'),(344,2563,'1380',5,2,1,'3340701131201','2021-01-21'),(345,2563,'1381',6,2,1,'3340701131201','2021-01-21'),(346,2563,'1382',7,2,1,'3340300018845','2021-01-21'),(347,2563,'1383',8,2,1,'3340300018845','2021-01-21'),(348,2563,'1384',9,2,1,'3340701131201','2021-01-21'),(349,2563,'1300',1,7,1,'3340701131201','2021-01-20'),(350,2563,'1301',2,7,1,'3340701131201','2021-01-20'),(371,2563,'1334',2,5,1,'3340701131201','2021-01-20'),(352,2563,'1303',3,7,1,'3340701131201','2021-01-20'),(353,2563,'1304',4,7,1,'3340701131201','2021-01-20'),(354,2563,'1305',5,7,1,'3340701131201','2021-01-20'),(355,2563,'1306',6,7,1,'3340701131201','2021-01-20'),(356,2563,'1308',7,7,1,'3340701131201','2021-01-20'),(357,2563,'1309',8,7,1,'3340701131201','2021-01-20'),(358,2563,'1310',9,7,1,'3340701131201','2021-01-20'),(359,2563,'1311',10,7,1,'3340701131201','2021-01-20'),(360,2563,'1341',11,6,1,'3340701131201','2021-01-20'),(361,2563,'1356',12,6,1,'3340701131201','2021-01-20'),(362,2563,'1290',3,8,1,'3340701131201','2021-01-20'),(363,2563,'1292',5,8,1,'3340701131201','2021-01-20'),(364,2563,'1294',6,8,1,'3340701131201','2021-01-20'),(365,2563,'1296',7,8,1,'3340701131201','2021-01-20'),(366,2563,'1297',8,8,1,'3340701131201','2021-01-20'),(367,2563,'1298',9,8,1,'3340701131201','2021-01-20'),(375,2563,'1360',1,3,1,'3340300018845','2021-01-21'),(369,2563,'1354',11,8,1,'3340701131201','2021-01-20'),(370,2563,'1299',11,7,1,'3340701131201','2021-01-20'),(372,2563,'1359',3,5,1,'3340701131201','2021-01-20'),(373,2563,'1337',4,5,1,'3340701131201','2021-01-20'),(374,2563,'1339',5,5,1,'3340701131201','2021-01-20'),(376,2563,'1361',2,3,1,'3340300018845','2021-01-21'),(377,2563,'1362',3,3,1,'3340300018845','2021-01-21'),(378,2563,'1363',4,3,1,'3340300018845','2021-01-21'),(379,2563,'1364',5,3,1,'3340300018845','2021-01-21'),(380,2563,'1365',6,3,1,'3340300018845','2021-01-21'),(381,2563,'1366',7,3,1,'3340300018845','2021-01-21'),(382,2563,'1367',8,3,1,'3340300018845','2021-01-21'),(383,2563,'1368',9,3,1,'3340300018845','2021-01-21'),(384,2563,'1369',10,3,1,'3340300018845','2021-01-21'),(385,2563,'1370',11,3,1,'3340300018845','2021-01-21'),(386,2563,'1371',12,3,1,'3340300018845','2021-01-21'),(387,2563,'1372',13,3,1,'3340300018845','2021-01-21'),(388,2563,'1373',14,3,1,'3340300018845','2021-01-21'),(389,2563,'1340',1,4,1,'3340701131201','2021-01-20'),(390,2563,'1342',2,4,1,'3340701131201','2021-01-20'),(391,2563,'1343',3,4,1,'3340701131201','2021-01-20'),(392,2563,'1344',4,4,1,'3340701131201','2021-01-20'),(393,2563,'1345',5,4,1,'3340701131201','2021-01-20'),(394,2563,'1346',6,4,1,'3340701131201','2021-01-20'),(395,2563,'1347',7,4,1,'3340701131201','2021-01-20'),(396,2563,'1348',8,4,1,'3340701131201','2021-01-20'),(397,2563,'1349',9,4,1,'3340701131201','2021-01-20'),(398,2563,'1332',1,5,1,'3340701131201','2021-01-20'),(399,2563,'1318',1,6,1,'3340701131201','2021-01-20'),(400,2563,'1319',2,6,1,'3340701131201','2021-01-20'),(401,2563,'1320',3,6,1,'3340701131201','2021-01-20'),(402,2563,'1321',4,6,1,'3340701131201','2021-01-20'),(403,2563,'1323',5,6,1,'3340701131201','2021-01-20'),(404,2563,'1325',6,6,1,'3340701131201','2021-01-20'),(405,2563,'1326',7,6,1,'3340701131201','2021-01-20'),(406,2563,'1327',8,6,1,'3340701131201','2021-01-20'),(407,2563,'1328',9,6,1,'3340701131201','2021-01-20'),(408,2563,'1329',10,6,1,'3340701131201','2021-01-20'),(409,2563,'1287',1,8,1,'3340701131201','2021-01-20'),(410,2563,'1288',2,8,1,'3340701131201','2021-01-20'),(411,2563,'1268',1,9,1,'3340701131201','2021-01-20'),(412,2563,'1269',2,9,1,'3340701131201','2021-01-20'),(413,2563,'1270',3,9,1,'3340701131201','2021-01-20'),(414,2563,'1271',4,9,1,'3340701131201','2021-01-20'),(415,2563,'1272',5,9,1,'3340701131201','2021-01-20'),(416,2563,'1273',6,9,1,'3340701131201','2021-01-20'),(417,2563,'1276',7,9,1,'3340701131201','2021-01-20'),(418,2563,'1277',8,9,1,'3340701131201','2021-01-20'),(419,2563,'1278',9,9,1,'3340701131201','2021-01-20'),(420,2563,'1279',10,9,1,'3340701131201','2021-01-20'),(421,2563,'1280',11,9,1,'3340701131201','2021-01-20'),(422,2563,'1281',12,9,1,'3340701131201','2021-01-20'),(423,2563,'1350',13,9,1,'3340701131201','2021-01-20'),(424,2563,'1355',14,9,1,'3340701131201','2021-01-20'),(461,2564,'1402',10,3,1,'3340701131201','2021-11-04'),(426,2564,'1308',5,8,1,'3340701131201','2021-11-08'),(427,2564,'1309',6,8,1,'3340701131201','2021-11-08'),(428,2564,'1310',7,8,1,'3340701131201','2021-11-08'),(429,2564,'1311',8,8,1,'3340701131201','2021-11-08'),(430,2564,'1354',10,9,1,'3340701131201','2021-06-28'),(431,2564,'1363',3,4,1,'3340701131201','2021-06-28'),(432,2564,'1364',4,4,1,'3340701131201','2021-06-28'),(433,2564,'1365',5,4,1,'3340701131201','2021-06-28'),(434,2564,'1366',6,4,1,'3340701131201','2021-06-28'),(435,2564,'1367',7,4,1,'3340701131201','2021-07-13'),(436,2564,'1368',8,4,1,'3340701131201','2021-06-28'),(437,2564,'1369',9,4,1,'3340701131201','2021-06-28'),(438,2564,'1370',10,4,1,'3340701131201','2021-06-28'),(439,2564,'1371',11,4,1,'3340701131201','2021-06-28'),(440,2564,'1372',12,4,1,'3340701131201','2021-06-28'),(441,2564,'1374',13,4,1,'3340701131201','2021-06-28'),(462,2564,'1403',10,5,1,'3340701131201','2021-11-08'),(443,2564,'1385',1,2,1,'3340701131201','2021-06-28'),(444,2564,'1386',2,2,1,'3340701131201','2021-06-28'),(445,2564,'1387',3,2,1,'3340701131201','2021-06-28'),(446,2564,'1388',4,2,1,'3340701131201','2021-06-28'),(447,2564,'1389',5,2,1,'3340701131201','2021-06-28'),(448,2564,'1390',6,2,1,'3340701131201','2021-06-28'),(449,2564,'1391',7,2,1,'3340701131201','2021-06-28'),(450,2564,'1392',8,2,1,'3340701131201','2021-06-28'),(451,2564,'1393',9,2,1,'3340701131201','2021-06-28'),(452,2564,'1394',10,2,1,'3340701131201','2021-06-28'),(453,2564,'1395',11,2,1,'3340701131201','2021-06-28'),(454,2564,'1396',12,2,1,'3340701131201','2021-06-28'),(455,2564,'1397',13,2,1,'3340701131201','2021-06-28'),(456,2564,'1398',14,2,1,'3340701131201','2021-06-28'),(457,2564,'1399',15,2,1,'3340701131201','2021-06-28'),(458,2564,'1400',16,2,1,'3340701131201','2021-06-28'),(459,2564,'1401',17,2,1,'3340701131201','2021-06-28'),(460,2564,'1344',4,5,1,'3340701131201','2021-10-06'),(463,2564,'1405',9,8,1,'3340701131201','2021-11-08'),(464,2564,'1404',14,4,1,'3340701131201','2021-11-08'),(465,2564,'1361',2,4,1,'1340700555388','2022-01-09'),(466,2564,'1287',1,9,1,'3340300018845','2022-05-09'),(467,2564,'1288',2,9,1,'3340300018845','2022-05-09'),(468,2564,'1290',3,9,1,'3340300018845','2022-05-09'),(469,2564,'1291',4,9,1,'3340300018845','2022-05-09'),(470,2564,'1292',5,9,1,'3340300018845','2022-05-09'),(471,2564,'1294',6,9,1,'3340300018845','2022-05-09'),(472,2564,'1296',7,9,1,'3340300018845','2022-05-09'),(473,2564,'1297',8,9,1,'3340300018845','2022-05-09'),(474,2564,'1298',9,9,1,'3340300018845','2022-05-09'),(475,2564,'1300',1,8,1,'3340300018845','2022-05-09'),(476,2564,'1301',2,8,1,'3340300018845','2022-05-09'),(477,2564,'1303',3,8,1,'3340300018845','2022-05-09'),(478,2564,'1304',4,8,1,'3340300018845','2022-05-09'),(479,2564,'1318',1,7,1,'3340300018845','2022-05-09'),(480,2564,'1319',2,7,1,'3340300018845','2022-05-09'),(481,2564,'1320',3,7,1,'3340300018845','2022-05-09'),(482,2564,'1321',4,7,1,'3340300018845','2022-05-09'),(483,2564,'1323',5,7,1,'3340300018845','2022-05-09'),(484,2564,'1325',6,7,1,'3340300018845','2022-05-09'),(485,2564,'1326',7,7,1,'3340300018845','2022-05-09'),(486,2564,'1327',8,7,1,'3340300018845','2022-05-09'),(487,2564,'1328',9,7,1,'3340300018845','2022-05-09'),(488,2564,'1329',10,7,1,'3340300018845','2022-05-09'),(489,2564,'1332',1,6,1,'3340300018845','2022-05-09'),(490,2564,'1334',2,6,1,'3340300018845','2022-05-09'),(491,2564,'1359',3,6,1,'3340300018845','2022-05-09'),(492,2564,'1337',4,6,1,'3340300018845','2022-05-09'),(493,2564,'1339',5,6,1,'3340300018845','2022-05-09'),(494,2564,'1340',1,5,1,'3340300018845','2022-05-09'),(495,2564,'1342',2,5,1,'3340300018845','2022-05-09'),(496,2564,'1343',3,5,1,'3340300018845','2022-05-09'),(497,2564,'1349',9,5,1,'3340300018845','2022-05-09'),(498,2564,'1345',5,5,1,'3340300018845','2022-05-09'),(499,2564,'1346',6,5,1,'3340300018845','2022-05-09'),(500,2564,'1347',7,5,1,'3340300018845','2022-05-09'),(501,2564,'1348',8,5,1,'3340300018845','2022-05-09'),(502,2564,'1360',1,4,1,'3340300018845','2022-05-09'),(503,2564,'1376',1,3,1,'3340300018845','2022-05-09'),(504,2564,'1377',2,3,1,'3340300018845','2022-05-09'),(505,2564,'1378',3,3,1,'3340300018845','2022-05-09'),(506,2564,'1379',4,3,1,'3340300018845','2022-05-09'),(507,2564,'1380',5,3,1,'3340300018845','2022-05-09'),(508,2564,'1381',6,3,1,'3340300018845','2022-05-09'),(509,2564,'1382',7,3,1,'3340300018845','2022-05-09'),(510,2564,'1383',8,3,1,'3340300018845','2022-05-09'),(511,2564,'1384',9,3,1,'3340300018845','2022-05-09'),(512,2565,'1390',5,3,1,'3340701131201','2022-05-19'),(513,2565,'1391',6,3,1,'3340701131201','2022-05-19'),(514,2565,'1392',7,3,1,'3340701131201','2022-05-19'),(515,2565,'1393',8,3,1,'3340701131201','2022-05-19'),(516,2565,'1394',9,3,1,'3340701131201','2022-05-19'),(517,2565,'1395',10,3,1,'3340701131201','2022-05-19'),(518,2565,'1396',11,3,1,'3340701131201','2022-05-19'),(519,2565,'1397',12,3,1,'3340701131201','2022-05-19'),(520,2565,'1398',13,3,1,'3340701131201','2022-05-19'),(521,2565,'1399',14,3,1,'3340701131201','2022-05-19'),(522,2565,'1400',15,3,1,'3340701131201','2022-05-19'),(523,2565,'1401',16,3,1,'3340701131201','2022-05-19'),(524,2565,'1306',6,9,1,'3340701131201','2022-08-09'),(525,2565,'1308',7,9,1,'3340701131201','2022-08-09'),(526,2565,'1405',11,9,1,'3340701131201','2022-08-09'),(527,2565,'1311',10,9,1,'3340701131201','2022-08-09'),(528,2565,'1310',9,9,1,'3340701131201','2022-08-09'),(529,2565,'1309',8,9,1,'3340701131201','2022-08-09'),(530,2565,'1406',6,7,1,'3340300018845','2022-06-16'),(531,2565,'1407',1,2,1,'3340701131201','2022-05-24'),(532,2565,'1408',2,2,1,'3340701131201','2022-05-24'),(533,2565,'1409',3,2,1,'3340701131201','2022-05-24'),(534,2565,'1410',4,2,1,'3340701131201','2022-05-24'),(535,2565,'1411',5,2,1,'3340701131201','2022-05-24'),(536,2565,'1412',6,2,1,'3340701131201','2022-05-24'),(537,2565,'1413',7,2,1,'3340701131201','2022-05-24'),(554,2565,'1369',9,5,1,'3340701131201','2023-05-16'),(539,2565,'1415',8,2,1,'3340701131201','2022-11-01'),(540,2565,'1416',9,2,1,'3340701131201','2022-11-01'),(541,2565,'1417',10,2,1,'3340701131201','2022-11-01'),(542,2565,'1418',11,2,1,'3340701131201','2022-11-01'),(543,2565,'1419',12,2,1,'3340701131201','2022-11-01'),(553,2565,'1368',8,5,1,'3340701131201','2023-05-16'),(545,2565,'1333',2,7,1,'3340300018845','2022-06-16'),(546,2565,'1334',3,7,1,'3340300018845','2022-06-16'),(547,2565,'1303',4,9,1,'3340701131201','2022-08-09'),(548,2565,'1304',5,9,1,'3340701131201','2022-08-09'),(549,2565,'1302',3,9,1,'3340701131201','2022-08-09'),(550,2565,'1301',2,9,1,'3350300547007','2022-09-13'),(551,2565,'1366',6,5,1,'3340701131201','2022-09-16'),(552,2565,'1421',7,7,1,'3340701131201','2022-10-04'),(555,2565,'1370',10,5,1,'3340701131201','2023-05-16'),(556,2565,'1371',11,5,1,'3340701131201','2023-05-16'),(557,2565,'1372',12,5,1,'3340701131201','2023-05-16'),(558,2565,'1374',13,5,1,'3340701131201','2023-05-16'),(559,2565,'1404',14,5,1,'3340701131201','2023-05-16'),(560,2565,'1340',1,6,1,'3340701131201','2023-05-16'),(561,2565,'1342',2,6,1,'3340701131201','2023-05-16'),(562,2565,'1343',3,6,1,'3340701131201','2023-05-16'),(563,2565,'1344',4,6,1,'3340701131201','2023-05-16'),(564,2565,'1345',5,6,1,'3340701131201','2023-05-16'),(565,2565,'1346',6,6,1,'3340701131201','2023-05-16'),(566,2565,'1347',7,6,1,'3340701131201','2023-05-16'),(567,2565,'1348',8,6,1,'3340701131201','2023-05-16'),(568,2565,'1349',9,6,1,'3340701131201','2023-05-16'),(569,2565,'1332',1,7,1,'3340701131201','2023-05-16'),(570,2565,'1337',4,7,1,'3340701131201','2023-05-16'),(571,2565,'1339',5,7,1,'3340701131201','2023-05-16'),(572,2565,'1318',1,8,1,'3340701131201','2023-05-16'),(573,2565,'1319',2,8,1,'3340701131201','2023-05-16'),(574,2565,'1320',3,8,1,'3340701131201','2023-05-16'),(575,2565,'1321',4,8,1,'3340701131201','2023-05-16'),(576,2565,'1323',5,8,1,'3340701131201','2023-05-16'),(577,2565,'1325',6,8,1,'3340701131201','2023-05-16'),(578,2565,'1326',7,8,1,'3340701131201','2023-05-16'),(579,2565,'1327',8,8,1,'3340701131201','2023-05-16'),(580,2565,'1328',9,8,1,'3340701131201','2023-05-16'),(581,2565,'1329',10,8,1,'3340701131201','2023-05-16'),(582,2565,'1385',1,3,1,'3340701131201','2023-05-16'),(583,2565,'1386',2,3,1,'3340701131201','2023-05-16'),(584,2565,'1387',3,3,1,'3340701131201','2023-05-16'),(585,2565,'1388',4,3,1,'3340701131201','2023-05-16'),(586,2565,'1376',1,4,1,'3340701131201','2023-05-16'),(587,2565,'1377',2,4,1,'3340701131201','2023-05-16'),(588,2565,'1378',3,4,1,'3340701131201','2023-05-16'),(589,2565,'1379',4,4,1,'3340701131201','2023-05-16'),(590,2565,'1380',5,4,1,'3340701131201','2023-05-16'),(591,2565,'1381',6,4,1,'3340701131201','2023-05-16'),(592,2565,'1382',7,4,1,'3340701131201','2023-05-16'),(593,2565,'1383',8,4,1,'3340701131201','2023-05-16'),(594,2565,'1384',9,4,1,'3340701131201','2023-05-16'),(595,2565,'1402',10,4,1,'3340701131201','2023-05-16'),(596,2565,'1360',1,5,1,'3340701131201','2023-05-16'),(597,2565,'1361',2,5,1,'3340701131201','2023-05-16'),(598,2565,'1363',3,5,1,'3340701131201','2023-05-16'),(599,2565,'1364',4,5,1,'3340701131201','2023-05-16'),(600,2565,'1365',5,5,1,'3340701131201','2023-05-16'),(601,2565,'1367',7,5,1,'3340701131201','2023-05-16'),(602,2566,'1422',1,2,1,'3340701131201','2023-06-06'),(603,2566,'1423',2,2,1,'3340701131201','2023-05-18'),(604,2566,'1424',3,2,1,'3340701131201','2023-05-18'),(605,2566,'1425',4,2,1,'3340701131201','2023-05-18'),(606,2566,'1426',5,2,1,'3340701131201','2023-05-18'),(607,2566,'1427',6,2,1,'3340701131201','2023-06-06'),(608,2566,'1428',7,2,1,'3340701131201','2023-06-06'),(609,2566,'1429',8,2,1,'3340701131201','2023-05-18'),(610,2566,'1430',9,2,1,'3340701131201','2023-05-18'),(611,2566,'1431',10,2,1,'3340701131201','2023-05-18'),(612,2566,'1432',11,2,1,'3340701131201','2023-05-18'),(617,2566,'1340',1,7,1,'3340701131201','2023-11-08'),(614,2566,'1434',12,2,1,'3340701131201','2023-05-24'),(615,2566,'1392',7,4,1,'3340701131201','2023-05-30'),(616,2566,'1419',12,3,1,'3340701131201','2023-05-30'),(618,2566,'1381',6,5,1,'3340701131201','2024-05-16'),(619,2566,'1382',7,5,1,'3340701131201','2024-05-16'),(620,2566,'1383',8,5,1,'3340701131201','2024-05-16'),(621,2566,'1384',9,5,1,'3340701131201','2024-05-16'),(622,2566,'1360',1,6,1,'3340701131201','2024-05-16'),(623,2566,'1361',2,6,1,'3340701131201','2024-05-16'),(624,2566,'1363',3,6,1,'3340701131201','2024-05-16'),(625,2566,'1364',4,6,1,'3340701131201','2024-05-16'),(626,2566,'1365',5,6,1,'3340701131201','2024-05-16'),(627,2566,'1366',6,6,1,'3340701131201','2024-05-16'),(628,2566,'1367',7,6,1,'3340701131201','2024-05-16'),(629,2566,'1368',8,6,1,'3340701131201','2024-05-16'),(630,2566,'1369',9,6,1,'3340701131201','2024-05-16'),(631,2566,'1370',10,6,1,'3340701131201','2024-05-16'),(632,2566,'1371',11,6,1,'3340701131201','2024-05-16'),(633,2566,'1372',12,6,1,'3340701131201','2024-05-16'),(634,2566,'1374',13,6,1,'3340701131201','2024-05-16'),(635,2566,'1342',2,7,1,'3340701131201','2024-05-16'),(636,2566,'1343',3,7,1,'3340701131201','2024-05-16'),(637,2566,'1344',4,7,1,'3340701131201','2024-05-16'),(638,2566,'1345',5,7,1,'3340701131201','2024-05-16'),(639,2566,'1346',6,7,1,'3340701131201','2024-05-16'),(640,2566,'1347',7,7,1,'3340701131201','2024-05-16'),(641,2566,'1348',8,7,1,'3340701131201','2024-05-16'),(642,2566,'1349',9,7,1,'3340701131201','2024-05-16'),(643,2566,'1332',1,8,1,'3340701131201','2024-05-16'),(644,2566,'1333',2,8,1,'3340701131201','2024-05-16'),(645,2566,'1334',3,8,1,'3340701131201','2024-05-16'),(646,2566,'1337',4,8,1,'3340701131201','2024-05-16'),(647,2566,'1339',5,8,1,'3340701131201','2024-05-16'),(648,2566,'1406',6,8,1,'3340701131201','2024-05-16'),(649,2566,'1421',7,8,1,'3340701131201','2024-05-16'),(650,2566,'1407',1,3,1,'3340701131201','2024-05-16'),(651,2566,'1408',2,3,1,'3340701131201','2024-05-16'),(652,2566,'1409',3,3,1,'3340701131201','2024-05-16'),(653,2566,'1410',4,3,1,'3340701131201','2024-05-16'),(654,2566,'1411',5,3,1,'3340701131201','2024-05-16'),(655,2566,'1412',6,3,1,'3340701131201','2024-05-16'),(656,2566,'1413',7,3,1,'3340701131201','2024-05-16'),(657,2566,'1415',8,3,1,'3340701131201','2024-05-16'),(658,2566,'1416',9,3,1,'3340701131201','2024-05-16'),(659,2566,'1417',10,3,1,'3340701131201','2024-05-16'),(660,2566,'1418',11,3,1,'3340701131201','2024-05-16'),(661,2566,'1385',1,4,1,'3340701131201','2024-05-16'),(662,2566,'1386',2,4,1,'3340701131201','2024-05-16'),(663,2566,'1387',3,4,1,'3340701131201','2024-05-16'),(664,2566,'1388',4,4,1,'3340701131201','2024-05-16'),(665,2566,'1390',5,4,1,'3340701131201','2024-05-16'),(666,2566,'1391',6,4,1,'3340701131201','2024-05-16'),(667,2566,'1393',8,4,1,'3340701131201','2024-05-16'),(668,2566,'1394',9,4,1,'3340701131201','2024-05-16'),(669,2566,'1395',10,4,1,'3340701131201','2024-05-16'),(670,2566,'1396',11,4,1,'3340701131201','2024-05-16'),(671,2566,'1397',12,4,1,'3340701131201','2024-05-16'),(672,2566,'1398',13,4,1,'3340701131201','2024-05-16'),(673,2566,'1399',14,4,1,'3340701131201','2024-05-16'),(674,2566,'1400',15,4,1,'3340701131201','2024-05-16'),(675,2566,'1401',16,4,1,'3340701131201','2024-05-16'),(676,2566,'1376',1,5,1,'3340701131201','2024-05-16'),(677,2566,'1377',2,5,1,'3340701131201','2024-05-16'),(678,2566,'1378',3,5,1,'3340701131201','2024-05-16'),(679,2566,'1379',4,5,1,'3340701131201','2024-05-16'),(680,2566,'1380',5,5,1,'3340701131201','2024-05-16'),(681,2567,'1435',8,9,1,'3340701131201','2024-05-20'),(682,2567,'1436',13,4,1,'3340701131201','2024-05-20'),(683,2567,'1370',8,7,1,'3340701131201','2024-05-20'),(684,2567,'1371',9,7,1,'3340701131201','2024-05-20'),(685,2567,'1372',10,7,1,'3340701131201','2024-05-20'),(686,2567,'1374',11,7,1,'3340701131201','2024-05-20'),(687,2567,'1437',1,2,1,'3340701131201','2024-05-20'),(688,2567,'1438',2,2,1,'3340701131201','2024-05-20'),(706,2567,'1422',1,3,1,'3340701131201','2025-05-16'),(690,2567,'1440',4,2,1,'3340701131201','2024-05-20'),(691,2567,'1441',5,2,1,'3340701131201','2024-05-20'),(692,2567,'1442',6,2,1,'3340701131201','2024-05-20'),(693,2567,'1443',7,2,1,'3340701131201','2024-05-20'),(694,2567,'1444',8,2,1,'3340701131201','2024-06-06'),(695,2567,'1445',9,2,1,'3340701131201','2024-05-20'),(696,2567,'1429',7,3,1,'3340701131201','2024-05-20'),(697,2567,'1430',8,3,1,'3340701131201','2024-05-20'),(698,2567,'1431',9,3,1,'3340701131201','2024-05-20'),(699,2567,'1432',10,3,1,'3340701131201','2024-05-20'),(700,2567,'1434',11,3,1,'3340701131201','2024-05-20'),(701,2567,'1398',12,5,1,'3340701131201','2024-05-20'),(702,2567,'1399',13,5,1,'3340701131201','2024-05-20'),(703,2567,'1400',14,5,1,'3340701131201','2024-05-20'),(704,2567,'1401',15,5,1,'3340701131201','2024-05-20'),(705,2567,'1417',10,4,1,'3340701131201','2024-10-31'),(707,2567,'1423',2,3,1,'3340701131201','2025-05-16'),(708,2567,'1424',3,3,1,'3340701131201','2025-05-16'),(709,2567,'1425',4,3,1,'3340701131201','2025-05-16'),(710,2567,'1426',5,3,1,'3340701131201','2025-05-16'),(711,2567,'1427',6,3,1,'3340701131201','2025-05-16'),(712,2567,'1407',1,4,1,'3340701131201','2025-05-16'),(713,2567,'1408',2,4,1,'3340701131201','2025-05-16'),(714,2567,'1409',3,4,1,'3340701131201','2025-05-16'),(715,2567,'1410',4,4,1,'3340701131201','2025-05-16'),(716,2567,'1411',5,4,1,'3340701131201','2025-05-16'),(717,2567,'1412',6,4,1,'3340701131201','2025-05-16'),(718,2567,'1413',7,4,1,'3340701131201','2025-05-16'),(719,2567,'1415',8,4,1,'3340701131201','2025-05-16'),(720,2567,'1416',9,4,1,'3340701131201','2025-05-16'),(721,2567,'1418',11,4,1,'3340701131201','2025-05-16'),(722,2567,'1419',12,4,1,'3340701131201','2025-05-16'),(723,2567,'1385',1,5,1,'3340701131201','2025-05-16'),(724,2567,'1386',2,5,1,'3340701131201','2025-05-16'),(725,2567,'1387',3,5,1,'3340701131201','2025-05-16'),(726,2567,'1388',4,5,1,'3340701131201','2025-05-16'),(727,2567,'1390',5,5,1,'3340701131201','2025-05-16'),(728,2567,'1391',6,5,1,'3340701131201','2025-05-16'),(729,2567,'1392',7,5,1,'3340701131201','2025-05-16'),(730,2567,'1393',8,5,1,'3340701131201','2025-05-16'),(731,2567,'1394',9,5,1,'3340701131201','2025-05-16'),(732,2567,'1395',10,5,1,'3340701131201','2025-05-16'),(733,2567,'1396',11,5,1,'3340701131201','2025-05-16'),(734,2567,'1382',7,6,1,'3340701131201','2025-05-16'),(735,2567,'1383',8,6,1,'3340701131201','2025-05-16'),(736,2567,'1384',9,6,1,'3340701131201','2025-05-16'),(737,2567,'1360',1,7,1,'3340701131201','2025-05-16'),(738,2567,'1361',2,7,1,'3340701131201','2025-05-16'),(739,2567,'1363',3,7,1,'3340701131201','2025-05-16'),(740,2567,'1364',4,7,1,'3340701131201','2025-05-16'),(741,2567,'1365',5,7,1,'3340701131201','2025-05-16'),(742,2567,'1366',6,7,1,'3340701131201','2025-05-16'),(743,2567,'1367',7,7,1,'3340701131201','2025-05-16'),(744,2567,'1340',1,8,1,'3340701131201','2025-05-16'),(745,2567,'1342',2,8,1,'3340701131201','2025-05-16'),(746,2567,'1343',3,8,1,'3340701131201','2025-05-16'),(747,2567,'1344',4,8,1,'3340701131201','2025-05-16'),(748,2567,'1345',5,8,1,'3340701131201','2025-05-16'),(749,2567,'1346',6,8,1,'3340701131201','2025-05-16'),(750,2567,'1347',7,8,1,'3340701131201','2025-05-16'),(751,2567,'1348',8,8,1,'3340701131201','2025-05-16'),(752,2567,'1349',9,8,1,'3340701131201','2025-05-16'),(753,2568,'1392',7,6,1,'3340701131201','2025-05-16'),(754,2568,'1394',9,6,1,'3340701131201','2025-05-16'),(755,2568,'1400',13,6,1,'3340701131201','2025-05-16'),(756,2568,'1393',8,6,1,'3340701131201','2025-05-16'),(757,2568,'1398',11,6,1,'3340701131201','2025-05-16'),(758,2568,'1399',12,6,1,'3340701131201','2025-05-16'),(759,2568,'1396',10,6,1,'3340701131201','2025-05-16'),(760,2568,'1401',14,6,1,'3340701131201','2025-05-16'),(761,2568,'1381',5,7,1,'3340701131201','2025-05-16'),(762,2568,'1376',1,7,1,'3340701131201','2025-05-16'),(763,2568,'1380',4,7,1,'3340701131201','2025-05-16'),(764,2568,'1378',2,7,1,'3340701131201','2025-05-16'),(765,2568,'1379',3,7,1,'3340701131201','2025-05-16'),(766,2568,'1382',6,7,1,'3340701131201','2025-05-16'),(767,2568,'1383',7,7,1,'3340701131201','2025-05-16'),(768,2568,'1384',8,7,1,'3340701131201','2025-05-16'),(769,2568,'1429',7,4,1,'3340701131201','2025-05-16'),(770,2568,'1446',1,2,1,'3340701131201','2025-05-16'),(771,2568,'1447',2,2,1,'3340701131201','2025-05-16'),(772,2568,'1448',3,2,1,'3340701131201','2025-05-16'),(773,2568,'1449',4,2,1,'3340701131201','2025-05-16'),(774,2568,'1450',5,2,1,'3340701131201','2025-05-16'),(775,2568,'1451',6,2,1,'3340701131201','2025-05-16'),(776,2568,'1424',3,4,1,'3340701131201','2025-08-20'),(777,2568,'1452',7,2,1,'3340701131201','2025-11-03'),(778,2568,'1453',15,6,1,'3340701131201','2025-11-03');

--
-- Table structure for table `student_main_edyear`
--

CREATE TABLE `student_main_edyear` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ed_year` int(11) NOT NULL,
  `year_active` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ed_year` (`ed_year`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_main_edyear`
--

INSERT INTO `student_main_edyear` VALUES (16,2568,1),(15,2567,0);

--
-- Table structure for table `student_main_expand1`
--

CREATE TABLE `student_main_expand1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` varchar(13) NOT NULL,
  `e_name` varchar(50) NOT NULL,
  `e_surname` varchar(50) NOT NULL,
  `birthday` date NOT NULL,
  `blood` varchar(2) NOT NULL,
  `race` varchar(30) NOT NULL,
  `nationlity` varchar(30) NOT NULL,
  `religion` varchar(30) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `person_id` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=176 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_main_expand1`
--

INSERT INTO `student_main_expand1` VALUES (1,'1341501574731','Dumrongsuk','Thanee','2014-11-19','','ไทย','ไทย','พุทธ','2025-05-16'),(2,'1341501576904','Tanakorn','Thunsuk','2015-01-20','','ไทย','ไทย','พุทธ','2025-05-16'),(3,'1348900345783','Tanathorn','Srikort','2014-07-05','','','','','2020-11-06'),(4,'1341501574251','Theenphat','Chaiwong','2014-11-08','','ไทย','ไทย','พุทธ','2025-05-16'),(5,'1341501569479','Chaiyaphat','kasemtang','2014-07-08','','ไทย','ไทย','พุทธ','2025-05-16'),(6,'1341501572933','Patiphat','Charoenchao','2014-10-09','','ไทย','ไทย','พุทธ','2025-05-16'),(7,'1118700282119','Phataradanai','Muengsongchan','2015-03-04','','ไทย','ไทย','พุทธ','2025-05-16'),(8,'1342900056492','Sarawuy','Som-a-ree','2015-05-02','','ไทย','ไทย','พุทธ','2025-05-16'),(9,'1348900354804','Adisrn','Sawaengwong','2014-10-17','','ไทย','ไทย','พุทธ','2021-06-28'),(10,'1341501577749','Nuttanicha','Suwankum','2015-02-06','','ไทย','ไทย','พุทธ','2021-06-28'),(11,'1342900056450','Nuttakamon','Bunthisaen','2014-08-13','','ไทย','ไทย','พุทธ','2025-05-16'),(12,'1348900349568','Nutsara','Sisasimra','2014-08-19','','ไทย','ไทย','พุทธ','2025-05-16'),(13,'1348900353930','Nuntikha','Yaeyai','2014-10-02','','ไทย','ไทย','พุทธ','2025-05-16'),(14,'1341501577439','Laputiada','Malasit','2015-02-04','','','','','2020-11-06'),(15,'1341501555931','Kamonthep','Angsin','2013-07-03','','ไทย','ไทย','พุทธ','2025-05-16'),(16,'1348900316422','Nantapat','Modngam','2013-07-01','','ไทย','ไทย','พุทธ','2025-05-16'),(17,'1341501567221','Thanakrit','Thaisamak','2014-05-11','','ไทย','ไทย','พุทธ','2025-05-16'),(18,'1341501559562','Panupong','Aumpan','2013-10-04','','ไทย','ไทย','พุทธ','2025-05-16'),(19,'1341501566399','Kanyapat','Onthai','2014-04-20','','ไทย','ไทย','พุทธ','2025-05-16'),(20,'1341501555702','Khanitthakarn','Sitang','2013-06-12','','ไทย','ไทย','พุทธ','2025-05-16'),(21,'1341501556148','Panadda','Wongprated','2013-07-06','','ไทย','ไทย','พุทธ','2025-05-16'),(22,'1341501559864','Pattamawan','Chinnachot','2013-10-10','','ไทย','ไทย','พุทธ','2025-05-16'),(23,'1341501558400','Waranya','Poonsuk','2013-09-08','','ไทย','ไทย','พุทธ','2025-05-16'),(24,'1341501550131','Kittipoom','Niramoon','2012-11-13','','ไทย','ไทย','พุทธ','2024-06-12'),(25,'1347600078274','Thanapat','Thungso','2013-01-26','','ไทย','ไทย','พุทธ','2024-06-12'),(26,'1341501550972','Panyakorn','Wongla','2012-12-13','','','','','2020-11-06'),(27,'1102004415824','Tachin','Malaingeun','2012-11-07','','ไทย','ไทย','พุทธ','2024-06-12'),(28,'1118600070217','Nontakorn','Srijam','2012-07-10','','','','','2020-11-06'),(29,'1341501549940','Chakka Phat','Phe Phang','2012-11-06','','ไทย','ไทย','พุทธ','2021-06-28'),(30,'1348900300755','Paweena','Kumud','2012-12-11','','ไทย','ไทย','พุทธ','2024-06-12'),(31,'1341501545456','Jirapinya','Promsawat','2012-06-19','','ไทย','ไทย','พุทธ','2024-06-12'),(32,'1341501536601','Watcharin','Phe Phang','2011-09-10','','ไทย','ไทย','พุทธ','2021-06-28'),(33,'1348900274835','Krit Kon','Prasoet Si','2012-02-06','','ไทย','ไทย','พุทธ','2021-06-28'),(34,'1348900278849','Rat Phon','Thong Si','2012-03-29','','ไทย','ไทย','พุทธ','2021-06-28'),(35,'1209301267841','tunwa','sirisombut','2011-12-25','','ไทย','ไทย','พุทธ','2021-06-28'),(36,'1349901838512','Chen Chi Ra','Sisa Sima','2012-05-12','','ไทย','ไทย','พุทธ','2021-06-28'),(37,'1119902627622','WaNi Da','Chuat Thong','2011-07-21','','ไทย','ไทย','พุทธ','2021-06-28'),(38,'1342900056344','Pani Ta','Si Han','2012-03-08','','ไทย','ไทย','พุทธ','2021-06-28'),(39,'1341501537704','Nit Ya','On Thai','2011-10-11','','ไทย','ไทย','พุทธ','2021-06-28'),(40,'1118700194856','Si Phatson','Cham Si','2011-07-09','','ไทย','ไทย','พุทธ','2021-06-28'),(41,'1409800565927','Suphattra','Thonthai','2011-10-04','','ไทย','ไทย','พุทธ','2021-06-28'),(42,'1103101224834','Thanatchaporn','Thumbon','2012-09-24','','','','','2020-11-06'),(43,'1348900245509','Chaianan','Khatklao','2011-03-09','-','ไทย','ไทย','พุทธ','2019-08-08'),(44,'1118700174120','Natthawutthi','Mok Thai Song','2010-09-06','','ไทย','ไทย','พุทธ','2021-06-28'),(45,'1102004178687','Phongsiri','Thani','2010-07-16','','ไทย','ไทย','พุทธ','2021-06-28'),(46,'1347600050094','Natthanan','Kham Pha Thu','2010-12-08','','ไทย','ไทย','พุทธ','2021-06-28'),(47,'1341501520721','Phongphiphat','Chaikhunphon','2010-06-12','','ไทย','ไทย','พุทธ','2021-06-28'),(48,'1909803648730','Yuyhakan','Thonthai','2011-03-27','','','','','2020-11-06'),(49,'1348900245801','Thiraphong','Phephang','2011-03-12','','ไทย','ไทย','พุทธ','2022-08-09'),(50,'1348900249750','Suraphon','Imchit','2011-04-29','','ไทย','ไทย','พุทธ','2021-06-28'),(51,'1349700431792','Chuthamat','Thani','2011-04-17','','ไทย','ไทย','พุทธ','2021-06-28'),(52,'1348900249121','Thidarat','Chuensaeng','2011-04-24','','ไทย','ไทย','พุทธ','2021-06-28'),(53,'1348900233900','Thiratsuda','Thani','2010-07-24','','ไทย','ไทย','พุทธ','2021-06-28'),(54,'1341501524114','Suphitcha','Somsuk','2010-09-23','','ไทย','ไทย','พุทธ','2021-06-28'),(55,'1348900225508','Kanya','Da Ru Nikon','2009-11-26','','ไทย','ไทย','พุทธ','2021-07-15'),(56,'1349901682920','Wira Phat','Si Sa-at','2010-02-19','','ไทย','ไทย','พุทธ','2021-07-15'),(57,'1348900227772','Chai Narong','Wong Tha Nu','2010-02-21','','ไทย','ไทย','พุธร','2021-07-15'),(58,'1348900220824','test1','Thani','2009-07-09','','ไทย','ไทย','พุทธ','2021-07-15'),(59,'1341501516987','Thon Don','Su Khu Na','2010-01-26','','ไทย','ไทย','พุทธ','2021-07-15'),(60,'1348900222894','Kamon Rat','Si Sam-ang','2009-09-09','','ไทย','ไทย','พุทธ','2021-07-15'),(61,'1348900223106','Wipha Phon','Tan Su','2009-09-15','','ไทย','ไทย','พุทธ','2021-07-15'),(62,'1348900224544','Su Phattra','Thani','2009-10-19','','ไทย','ไทย','พุทธ','2021-07-15'),(63,'1348900227675','Rot Rin','Lueang Thong','2010-02-17','','ไทย','ไทย','พุทธ','2021-07-15'),(64,'1348900229821','yada','yingkla','2010-04-15','','','','','2020-11-06'),(65,'1348900216991','Nipaporn','Supajun','2009-04-10','','ไทย','ไทย','พุทธ','2021-07-15'),(66,'1349901536397','Apichard','Saweangwong','2008-01-14','','','','','2020-11-06'),(67,'1860401293981','Kittipong','Supajun','2008-01-14','B','','','','2020-11-06'),(68,'1348900194319','Krit','Akson','2008-06-12','','','','','2020-11-06'),(69,'1349700388919','Chetsada Phon','Thani','2008-08-05','','','','','2020-11-06'),(70,'1349901577271','Khachon Sak','Thani','2008-08-28','','','','','2020-11-06'),(71,'1348900205493','Nakharin','Cham roen','2008-10-25','','','','','2020-11-06'),(72,'1348900203016','Chatcha Phon','Chaem Sakun','2008-09-27','','','','','2020-11-06'),(73,'1348900214476','Thiraphat','Khaehom','2009-02-24','','','','','2020-11-06'),(74,'1348900212635','Ayu Thai','Phun Suk','2009-01-25','','','','','2020-11-06'),(75,'1348900202109','Det Sak','Su Khu Na','2008-09-19','','','','','2020-11-06'),(76,'1348900201358','Rattana Phon','Ko Amphai','2008-09-10','','','','','2020-11-06'),(77,'1348900198861','Krittaya','Kua Wi Chan','2008-08-11','','','','','2020-11-06'),(78,'1348900195773','Wi La Wan','Thani','2008-07-03','','','','','2020-11-06'),(79,'1409903734560','Fan Siri','Ngoen Ngam','2008-10-14','','','','','2020-11-06'),(80,'1347600020845','kittipet','Chuai Suk','2008-01-23','-','ไทย','ไทย','พุทธ','2019-08-08'),(81,'1349700382457','Itthiphon','Kaen Sing','2008-02-14','-','ไทย','ไทย','พุทธ','2019-08-08'),(82,'1348900186995','Thana','Thani','2008-03-01','-','ไทย','ไทย','พุทธ','2019-08-08'),(83,'1348900182612','Chawalit','Chaem Sakun','2008-01-05','-','ไทย','ไทย','พุทธ','2019-08-08'),(84,'1100704010523','An Da','Khun Mi','2008-03-13','-','ไทย','ไทย','พุทธ','2019-08-08'),(85,'1341501499829','Panatda','Si Han','2008-02-16','-','ไทย','ไทย','พุทธ','2019-08-08'),(86,'1341501501513','Waran Ya','Prasan Wong','2008-04-27','-','ไทย','ไทย','พุทธ','2019-08-08'),(87,'1341501500266','Suwimon','Mun Kaeo','2008-03-03','-','ไทย','ไทย','พุทธ','2019-08-08'),(88,'1103704294095','Ananta Ya','Thani','2008-03-03','-','ไทย','ไทย','พุทธ','2019-08-08'),(89,'1749700160345','In Thi Ra','Lamdap','2007-09-25','-','ไทย','ไทย','พุทธ','2019-08-08'),(90,'1101801538406','pasin','Waeng Bun','2007-11-09','-','ไทย','ไทย','พุทธ','2019-08-08'),(91,'1102170092371','TITIPHA','SENNAMTEANG','2007-07-20','-','ไทย','ไทย','พุทธ','2019-08-08'),(92,'1348900190569','Siriwan','Dechkamphoo','2008-04-18','-','ไทย','ไทย','พุทธ','2019-08-08'),(93,'134890026340','Narong Sak','Chuat Thong','2011-10-02','-','ไทย','ไทย','พุทธ','2019-09-18'),(95,'1341501580723','Cheerasak','Thanee','2015-05-26','','ไทย','ไทย','พุทธ','2025-05-16'),(94,'1348900263400','Narong Sak','Chuat Thong','2011-10-02','','ไทย','ไทย','พุทธ','2021-06-28'),(96,'1347600113509','Pannawit','Onat','2015-10-15','','ไทย','ไทย','พุทธ','2024-06-12'),(97,'1341501581908','Preegha','Darunikorn','2015-07-02','','ไทย','ไทย','พุทธ','2025-05-16'),(98,'1341501587345','Prakasit','Ampan','2015-11-04','','ไทย','ไทย','พุทธ','2025-05-16'),(99,'1349902089971','Phutthiphong','Thanee','2016-01-13','','ไทย','ไทย','พุทธ','2025-05-16'),(100,'1342900056522','Ronnakorn','Sala','2015-09-02','','ไทย','ไทย','พุทธ','2025-05-16'),(101,'1348900379556','Suradet','Singho','2015-09-02','','ไทย','ไทย','พุทธ','2025-05-16'),(102,'1348900388105','Rattiyakorn','Saikham','2015-12-19','','ไทย','ไทย','พุทธ','2025-05-16'),(103,'1341501588112','Jirayu','Chuadtong','2015-11-22','','ไทย','ไทย','พุทธ','2025-05-16'),(104,'1102200415599','Thanitsara','Chamsakun','2015-05-13','','ไทย','ไทย','พุทธ','2025-05-16'),(105,'1341501573841','Thanchanok','Tanuma','2014-10-29','','','','','2020-11-06'),(106,'1101100321648','Chayata   ','  Chankeaw  ','2017-04-17','','ไทย','ไทย','พุทธ','2021-06-28'),(107,'1348900405611','Thanadate   ','Promsawat','2016-08-09','','ไทย','ไทย','พุทธ','2021-06-28'),(108,'1489900843716','Thanathip   ','Chuatthong','2016-11-17','','ไทย','ไทย','พุทธ','2021-06-28'),(109,'1104301668613','Thanaphat   ',' Taothog','2017-03-19','','ไทย','ไทย','พุทธ','2021-06-28'),(110,'1349902161478','Thanawut    ','Phephang','2017-03-16','','ไทย','ไทย','พุทธ','2021-06-28'),(111,'1341501594929','Thiraphong    ','Prasanwong','2016-05-22','','ไทย','ไทย','พุทธ','2021-06-28'),(112,'1341501600082','Phayuphak     ','Sang-ngam','2016-09-22','','ไทย','ไทย','พุทธ','2021-06-28'),(113,'1341501609462','Ratchanon    ','Thungso','2017-04-26','','ไทย','ไทย','พุทธ','2021-06-28'),(114,'1341501599904','Sarat    ','Keawkromkri','2016-09-19','','ไทย','ไทย','พุทธ','2021-06-28'),(115,'1341501606927','Kewalin    ','Ngammao','2017-02-28','','ไทย','ไทย','พุทธ','2021-06-28'),(116,'1348900411646','Chutharat    ','Nerawong','2016-10-18','','ไทย','ไทย','พุทธ','2021-06-28'),(117,'1341501606480','Natthida     ','  Thongkham','2017-02-17','','ไทย','ไทย','พุทธ','2021-06-28'),(118,'1341501599581','Nalinda     ','Chinnachon','2016-09-13','','ไทย','ไทย','พุทธ','2021-06-28'),(119,'1341501595097','Prakaikeaw   ','Prachon','2016-05-29','','ไทย','ไทย','พุทธ','2021-06-28'),(120,'1348900427267','Pranfha    ',' Yotwongsa','2017-04-30','','ไทย','ไทย','พุทธ','2021-06-28'),(121,'1342900056662','Phatcharapha   ','Chirat','2016-10-24','','ไทย','ไทย','พุทธ','2021-06-28'),(122,'1348900413304','Silinda    ',' Phongbua','2016-11-08','','ไทย','ไทย','พุทธ','2021-06-28'),(123,'1669900674475','Patcharida','Thanee','2010-08-11','','ไทย','ไทย','พุทธ','2022-01-17'),(124,'1103400291606','Atichart','Khawpim','2013-11-08','','ไทย','ไทย','พุทธ','2022-01-17'),(125,'1349902054817','Khtha','Charoenchao','2015-07-10','','ไทย','ไทย','พุทธ','2022-01-17'),(126,'1102004599241','Aphichart','Thanee','2014-09-21','','ไทย','ไทย','พุทธ','2022-01-17'),(127,'1341501544816','Pacharaphorn','Pumjan','2012-05-27','','ไทย','ไทย','พุทธ','2022-05-24'),(128,'1341501610789','๋Jirattaphan','Pimmasri','2017-05-30','','ไทย','ไทย','พุทธ','2022-05-24'),(129,'1341501614849','Chaimanut','Srisaard','2017-08-29','','ไทย','ไทย','พุทธ','2022-05-24'),(130,'1348900441073','Phakin','Inthichai','2017-09-23','','ไทย','ไทย','พุทธ','2022-05-24'),(131,'1341501620113','Phakdeebodin','Chaiyawong','2017-12-23','','ไทย','ไทย','พุทธ','2022-05-24'),(132,'1341501619719','Watcharakon','Insom','2017-12-14','','ไทย','ไทย','พุทธ','2022-05-24'),(133,'1739902877534','Sitthichai','Jankeaw','2017-11-18','','ไทย','ไทย','พุทธ','2022-05-24'),(134,'1129902578109','Archawin','Thonthai','2017-10-19','','ไทย','ไทย','พุทธ','2022-05-24'),(135,'1319901837869','Jintana','Khueanthaisong','2017-11-27','','ไทย','ไทย','พุทธ','2022-05-24'),(136,'1341501616019','Charinda','Makawong','2017-09-19','','ไทย','ไทย','พุทธ','2022-05-24'),(137,'1341501610274','Chutima','Khamphathu','2017-05-19','','ไทย','ไทย','พุทธ','2022-05-24'),(138,'1347600137891','Davika','Srijam','2018-01-26','','ไทย','ไทย','พุทธ','2022-05-24'),(139,'1349700546948','Phattharathida','Suthilert','2017-11-09','','ไทย','ไทย','พุทธ','2022-05-24'),(140,'1348900437912','Chotika','Pumjan','2017-08-26','','ไทย','ไทย','พุทธ','2024-06-12'),(141,'1341501561834','Ekkachai','Kaewwongsa','2013-11-30','','ไทย','ไทย','พุทธ','2022-05-30'),(142,'1909803910574','์Natchaphong','Areelua','2013-05-29','','ไทย','ไทย','พุทธ','2022-11-01'),(143,'1399900663409','Thanakon','Chuadthong','2019-03-14','','ไทย','ไทย','พุทธ','2023-05-18'),(144,'1349902233991','Porawat','Jamsri','2018-07-01','','ไทย','ไทย','พุทธ','2023-05-18'),(145,'1129746756','Kantaphon','Chuadthong','2018-07-20','','ไทย','ไทย','พุทธ','2023-05-18'),(146,'1348900465797','Thitiphat','Pradu','2018-07-09','','ไทย','ไทย','ไทย','2025-08-20'),(147,'1348900474702','Chanakarn','Aonthai','2018-10-13','','ไทย','ไทย','พุทธ','2023-05-18'),(148,'1349902268311','Nadthawat','Thambun','2019-02-10','','ไทย','ไทย','พุทธ','2023-05-18'),(149,'1348900480427','Thanawat','Saenduang','2018-12-17','','ไทย','ไทย','พุทธ','2023-05-18'),(150,'1139600913461','Phirawit','Si Han','2018-11-15','','ไทย','ไทย','ไทย','2025-05-16'),(151,'1348900487294','Phattraphon','Mueangsongchan','2019-03-05','','ไทย','ไทย','พุทธ','2023-05-18'),(152,'1341501636087','Supakit','BoonJaren','2018-11-30','','ไทย','ไทย','พุทธ','2023-05-18'),(153,'1102004986414','Manatsanan','Piewondee','2019-04-25','','ไทย','ไทย','พุทธ','2023-05-18'),(154,'1129701746756','Kantaphon','Chuadthong','2018-07-20','','ไทย','ไทย','พุทธ','2023-05-19'),(155,'134890073400','Oanda','Torino','2015-07-01','','ไทย','ไทย','พุทธ','2023-05-22'),(156,'0103700002776','Tonka','Tee','2018-03-06','','กัมพูชา','กัมพูชา','กัมพูชา','2024-06-12'),(168,'1349902367203','Kotthanon  ',' Chamsri','2020-12-28','','ไทย','ไทย','พุทธ','2025-05-16'),(157,'1341501644365','Phakkaphon','Thani','2019-06-20','','ไทย','ไทย','พุทธ','2024-06-12'),(158,'1341501647976','Parawee','Seesamoang','2019-09-16','','ไทย','ไทย','พุทธ','2024-06-12'),(159,'1348900496838','Montre','Kamharn','2019-07-04','','ไทย','ไทย','พุทธ','2024-06-12'),(160,'1348900507848','Nattawut','Angkaew','2019-11-12','','ไทย','ไทย','พุทธ','2024-06-12'),(161,'1341501652139','Natthasit','Kamsook','2019-12-20','','ไทย','ไทย','พุทธ','2024-06-12'),(162,'1349902311330','Apiwat','Sangngam','2019-11-26','','ไทย','ไทย','พุทธ','2024-06-12'),(163,'1341501650829','Chotika','Ampan','2019-11-22','','ไทย','ไทย','พุทธ','2024-06-12'),(164,'1349902333490','Pawarias','Jamsri','2020-05-06','','ไทย','ไทย','พุทธ','2024-06-12'),(165,'1348900511985','Udomluck','Booncharoen','2020-01-09','','ไทย','ไทย','พุทธ','2024-06-12'),(166,'1459200111356','Mataschai','Watthanasingh','2018-03-29','','ไทย','ไทย','พุทธ','2024-06-12'),(167,'1209702742249','Kanokwan','Yingyuen','2012-07-11','','ไทย','ไทย','พุทธ','2024-06-12'),(169,'1346400001501','Kantaphon   ','Saikham','2020-07-08','','ไทย','ไทย','พุทธ','2025-05-16'),(170,'1349902366592','Thanawan   ','Thamboon','2020-12-24','','ไทย','ไทย','พุทธ','2025-05-16'),(171,'1342900056905','Kittiyaporm  ','Aksorn','2020-07-26','','ไทย','ไทย','พุทธ','2025-05-16'),(172,'1346400003156','Benyaphorm   ','Prasanwong','2020-08-13','','ไทย','ไทย','พุทธ','2025-05-16'),(173,'1103101507992','Pitchayapa   ',' Tamboon','2020-08-21','','ไทย','ไทย','พุทธ','2025-05-16'),(174,'1399200046717','Paphawarin','Booncharoen','2016-05-21','','ไทย','ไทย','พุทธ','2025-11-03'),(175,'1219700159082','Krittidech','Booncharoen','2020-09-17','','ไทย','ไทย','พุทธ','2025-11-03');

--
-- Table structure for table `student_main_permission`
--

CREATE TABLE `student_main_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` varchar(13) NOT NULL,
  `p1` tinyint(4) NOT NULL,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_main_permission`
--

INSERT INTO `student_main_permission` VALUES (5,'3341601220987',1,'3340701131201','2025-05-21'),(21,'3340700933125',1,'3340701131201','2025-11-10'),(17,'1340700555388',1,'3340300018845','2021-11-15'),(19,'1341900113681',1,'3340701131201','2025-07-21'),(9,'3340701131201',1,'3340701131201','2023-09-06'),(15,'1340700204747',1,'3340300018845','2020-07-21'),(22,'1490200096456',1,'3340701131201','2025-11-10'),(14,'3350300547007',1,'3340300018845','2020-07-21');

--
-- Table structure for table `system_ed_year`
--

CREATE TABLE `system_ed_year` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ed_year` int(11) NOT NULL,
  `active_ed_year` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ed_year` (`ed_year`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_ed_year`
--


--
-- Table structure for table `system_export_list`
--

CREATE TABLE `system_export_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data_name` varchar(50) NOT NULL,
  `thai_dataname` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `data_name` (`data_name`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_export_list`
--

INSERT INTO `system_export_list` VALUES (1,'person','ข้อมูลครูและบุคลากร'),(2,'student','ข้อมูลพื้นฐานนักเรียน'),(3,'onet','ผลสอบ O-NET'),(4,'plan','แผนปฏิบัติการประจำปี'),(5,'student_check','การมาเรียน'),(6,'health','สุขภาพผู้เรียน');

--
-- Table structure for table `system_export_log`
--

CREATE TABLE `system_export_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `computer_ip` varchar(25) NOT NULL,
  `requester` varchar(50) NOT NULL,
  `login_time` datetime NOT NULL,
  `data` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=78 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_export_log`
--

INSERT INTO `system_export_log` VALUES (1,'61.19.124.234','amssplus','2018-08-23 15:07:00','plan'),(2,'61.19.124.234','amssplus','2018-08-23 15:07:27','plan'),(3,'61.19.124.234','amssplus','2018-08-23 15:08:21','person'),(4,'61.19.124.234','amssplus','2018-08-23 15:44:38','student'),(5,'61.19.124.234','amssplus','2018-08-23 15:46:30','student'),(6,'61.19.124.234','amssplus','2018-08-23 15:53:35','person'),(7,'61.19.124.234','amssplus','2018-08-23 21:56:07','student'),(8,'61.19.124.234','amssplus','2018-08-24 10:05:56','person'),(9,'61.19.124.234','amssplus','2018-08-24 10:31:24','student'),(10,'61.19.124.234','amssplus','2018-08-24 14:05:45','plan'),(11,'61.19.124.234','amssplus','2018-08-30 16:28:27','student'),(12,'61.19.124.234','amssplus','2018-09-02 15:18:16','student'),(13,'61.19.124.234','amssplus','2018-09-14 12:26:29','person'),(14,'61.19.124.234','amssplus','2018-09-14 12:29:47','person'),(15,'61.19.124.234','amssplus','2018-09-14 13:09:33','person'),(16,'61.19.124.234','amssplus','2018-09-21 04:36:44','person'),(17,'61.19.124.234','amssplus','2018-09-28 16:30:14','person'),(18,'61.19.124.234','amssplus','2019-10-08 10:35:12','student_check'),(19,'122.155.223.9','amssplus','2020-03-30 15:02:15','student_check'),(20,'122.155.223.9','amssplus','2020-07-23 12:44:27','person'),(21,'122.155.223.9','amssplus','2020-08-05 10:18:44','student'),(22,'122.155.223.9','amssplus','2020-12-04 09:21:25','person'),(23,'10.1.1.3','amssplus','2021-04-07 07:14:48','health'),(24,'10.1.1.3','amssplus','2021-04-07 07:14:53','health'),(25,'10.1.1.3','amssplus','2021-04-16 07:31:01','health'),(26,'10.1.1.3','amssplus','2021-04-16 07:31:28','student_check'),(27,'10.1.1.3','amssplus','2021-10-06 10:27:28','student'),(28,'10.1.1.3','amssplus','2021-10-06 10:30:21','student'),(29,'10.1.1.3','amssplus','2021-11-11 10:20:23','student'),(30,'10.1.1.3','amssplus','2021-11-11 10:20:28','student'),(31,'10.1.1.3','amssplus','2021-11-11 10:20:58','student_check'),(32,'10.1.1.3','amssplus','2021-12-03 11:31:17','person'),(33,'10.1.1.3','amssplus','2021-12-03 11:39:55','person'),(34,'10.1.1.3','amssplus','2022-09-07 14:40:45','student'),(35,'10.1.1.3','amssplus','2023-01-22 00:23:23','student'),(36,'10.1.1.3','amssplus','2023-04-05 09:48:23','student_check'),(37,'10.1.1.3','amssplus','2023-04-05 22:38:14','student_check'),(38,'10.1.1.3','amssplus','2023-04-06 10:24:16','student_check'),(39,'10.1.1.3','amssplus','2023-04-06 10:25:07','student_check'),(40,'10.1.1.3','amssplus','2023-04-06 10:47:28','student_check'),(41,'10.1.1.3','amssplus','2023-04-06 13:13:42','student_check'),(42,'10.1.1.3','amssplus','2023-06-15 10:20:25','student_check'),(43,'10.1.1.3','amssplus','2023-06-15 10:56:10','student'),(44,'10.1.1.3','amssplus','2023-06-16 15:15:53','student'),(45,'10.1.1.3','amssplus','2023-07-04 11:24:36','student'),(46,'10.1.1.3','amssplus','2023-08-24 09:05:33','student_check'),(47,'10.1.1.3','amssplus','2023-08-31 09:02:51','student_check'),(48,'10.1.1.3','amssplus','2023-08-31 09:03:19','student_check'),(49,'10.1.1.3','amssplus','2023-08-31 09:03:39','student_check'),(50,'10.1.1.3','amssplus','2023-09-15 20:09:22','student'),(51,'','amssplus','2023-10-25 14:28:43','student_check'),(52,'','amssplus','2023-10-25 14:28:46','student_check'),(53,'','amssplus','2023-10-25 14:28:48','student_check'),(54,'10.255.199.107','amssplus','2023-11-29 08:55:48','student_check'),(55,'10.255.199.107','amssplus','2023-12-15 12:15:50','student_check'),(56,'10.255.199.107','amssplus','2024-01-25 03:50:22','student_check'),(57,'10.255.199.107','amssplus','2024-06-10 11:59:43','student'),(58,'10.255.199.107','amssplus','2024-06-10 12:33:43','student'),(59,'10.255.199.107','amssplus','2024-06-14 10:46:04','student'),(60,'10.255.199.107','amssplus','2024-06-14 10:52:06','student'),(61,'10.255.199.107','amssplus','2024-06-17 04:37:32','person'),(62,'10.255.199.107','amssplus','2024-06-17 04:39:47','person'),(63,'10.255.199.107','amssplus','2024-06-20 04:51:35','student_check'),(64,'10.255.199.107','amssplus','2025-03-11 07:57:44','student_check'),(65,'10.255.199.107','amssplus','2025-03-11 07:58:04','student_check'),(66,'10.255.199.107','amssplus','2025-03-28 01:48:40','student_check'),(67,'10.255.199.107','amssplus','2025-05-29 08:10:00','person'),(68,'10.255.199.107','amssplus','2025-05-29 08:12:47','person'),(69,'10.255.199.107','amssplus','2025-06-08 04:32:47','student'),(70,'10.255.199.107','amssplus','2025-07-30 08:33:28','student_check'),(71,'10.255.199.107','amssplus','2025-08-01 22:22:46','student_check'),(72,'10.255.199.107','amssplus','2025-08-01 22:22:50','student_check'),(73,'10.255.199.107','amssplus','2025-08-14 04:10:03','person'),(74,'10.255.199.107','amssplus','2025-08-18 02:44:19','student'),(75,'10.255.199.107','amssplus','2025-08-29 02:40:18','student_check'),(76,'10.255.199.107','amssplus','2025-09-13 05:43:36','student_check'),(77,'10.255.199.107','amssplus','2025-09-13 05:54:44','student_check');

--
-- Table structure for table `system_export_permission`
--

CREATE TABLE `system_export_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `requester` varchar(50) NOT NULL,
  `data_name` varchar(50) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_export_permission`
--

INSERT INTO `system_export_permission` VALUES (1,'amssplus','plan',1),(2,'amssplus','onet',1),(3,'amssplus','student',1),(4,'amssplus','person',1),(5,'amssplus','student_check',1),(6,'amssplus','health',1);

--
-- Table structure for table `system_module`
--

CREATE TABLE `system_module` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(50) NOT NULL,
  `module_desc` varchar(100) NOT NULL,
  `workgroup` tinyint(4) DEFAULT NULL,
  `module_active` tinyint(4) DEFAULT NULL,
  `module_order` int(11) NOT NULL,
  `web_link` tinyint(4) DEFAULT NULL,
  `url` varchar(150) DEFAULT NULL,
  `where_work` tinyint(4) NOT NULL DEFAULT 0,
  `menu_pic` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=114 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_module`
--

INSERT INTO `system_module` VALUES (1,'budget','การเงินและบัญชี',2,1,25,NULL,NULL,0,'fab fa-btc'),(32,'person','ข้อมูลพื้นฐานครูและบุคลากร',3,1,29,0,'',0,'fa fa-user-circle'),(36,'standard','มาตรฐานการศึกษา',1,1,21,NULL,NULL,0,''),(49,'health','ตรวจสุขภาพนักเรียน',1,1,5,NULL,NULL,1,''),(50,'student_check','การมาเรียน',1,1,1,NULL,NULL,0,'fa fa-child'),(70,'work','﻿การปฏิบัติราชการ',4,1,47,NULL,NULL,0,''),(48,'savings','ออมทรัพย์นักเรียน',1,1,3,NULL,NULL,1,'fab fa-btc'),(45,'student_main','ข้อมูลพื้นฐานนักเรียน',1,1,7,NULL,NULL,0,'fa fa-child'),(47,'plan','การวางแผน',2,1,23,NULL,NULL,0,''),(73,'la','﻿การลา',4,1,45,NULL,NULL,0,''),(80,'mail','ไปรษณีย์_โรงเรียน',4,1,36,0,'',0,'fa fa-envelope'),(75,'meeting','﻿จองห้องประชุม',4,1,49,NULL,NULL,0,''),(76,'permission','﻿ขออนุญาตไปราชการ',4,1,43,NULL,NULL,0,''),(81,'achievement','﻿ผลสัมฤทธิ์ทางการเรียน',1,1,19,NULL,NULL,0,'fa fa-graduation-cap'),(83,'cabinet','﻿ตู้เอกสาร',4,1,51,NULL,NULL,0,''),(99,'bookregister','﻿ทะเบียนหนังสือราชการ',4,1,33,0,'',0,'fa fa-book'),(100,'bets','ทดสอบการศึกษา_โรงเรียน',1,1,9,NULL,NULL,1,'fa fa-graduation-cap'),(101,'affair','﻿ภารกิจผู้อำนวยการ',4,1,41,0,'',0,''),(102,'amss_bets','﻿ทดสอบการศึกษา_สพท.',1,1,11,0,'',1,'fa fa-graduation-cap'),(103,'amss_budget','﻿การบริหารงบประมาณ_สพท.',2,1,27,0,'',0,'fab fa-btc'),(104,'amss_mail','﻿ไปรษณีย์_สพท.',4,1,37,0,'',0,'fa fa-envelope'),(105,'amss_opportunity','﻿สิทธิและโอกาสทางการศึกษา',1,1,15,0,'',0,'fa fa-child'),(106,'amss_spacial_student','﻿นักเรียนพิเศษ',1,1,17,0,'',0,'fa fa-child'),(107,'amss_supervision','﻿นิเทศ ติดตาม ประเมินผล',1,1,13,0,'',0,'fa fa-graduation-cap'),(108,'book','﻿รับส่งหนังสือราชการ',4,1,35,0,'',0,'fa fa-book'),(109,'delegate','รักษาการในตำแหน่ง',3,1,31,0,'',0,''),(110,'warroom','﻿วิเคราะห์สภาพการณ์',1,1,0,0,'',0,'fa fa-filter'),(111,'questionnaire','﻿แบบสอบถาม',4,1,0,0,'',0,''),(112,'idplan','﻿ข้อมูลครูและบุคลากร(ส่วนเพิ่ม)',3,1,0,0,'',0,''),(113,'amss_safety','สถานศึกษาปลอดภัย',1,1,0,0,'',0,'');

--
-- Table structure for table `system_module_admin`
--

CREATE TABLE `system_module_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` varchar(13) NOT NULL,
  `module` varchar(30) NOT NULL,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=161 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_module_admin`
--

INSERT INTO `system_module_admin` VALUES (1,'3340300018845','student_main','7777','2015-10-27'),(2,'3340300018845','achievement','7777','2015-10-28'),(3,'1340700398100','achievement','7777','2015-10-28'),(4,'3341100274253','achievement','7777','2015-10-28'),(5,'1340700065119','achievement','7777','2015-10-28'),(6,'3349900275031','achievement','7777','2015-10-28'),(7,'3350800274948','achievement','7777','2015-10-28'),(8,'3349800035119','achievement','7777','2015-10-28'),(9,'3340701131201','achievement','7777','2015-10-28'),(10,'1340700204747','achievement','7777','2015-10-28'),(11,'1340790002243','achievement','7777','2015-10-28'),(12,'3349800150660','achievement','7777','2015-10-28'),(13,'3349800150660','bets','7777','2015-10-28'),(14,'1340790002243','bets','7777','2015-10-28'),(15,'1340700204747','bets','7777','2015-10-28'),(16,'3340701131201','bets','7777','2015-10-28'),(17,'3349800035119','bets','7777','2015-10-28'),(18,'3340701131201','bets','7777','2015-10-28'),(19,'3350800274948','bets','7777','2015-10-28'),(20,'3349900275031','bets','7777','2015-10-28'),(21,'1340700065119','bets','7777','2015-10-28'),(22,'3341100274253','bets','7777','2015-10-28'),(23,'1340700398100','bets','7777','2015-10-28'),(24,'3340300018845','bets','7777','2015-10-28'),(25,'3340300018845','bookregister','7777','2015-10-28'),(26,'1340700398100','bookregister','7777','2015-10-28'),(27,'3341100274253','bookregister','7777','2015-10-28'),(28,'1340700065119','bookregister','7777','2015-10-28'),(30,'3349900275031','bookregister','7777','2015-10-28'),(31,'3350800274948','bookregister','7777','2015-10-28'),(32,'3349800035119','bookregister','7777','2015-10-28'),(34,'3340701131201','bookregister','7777','2015-10-28'),(35,'1340700204747','bookregister','7777','2015-10-28'),(36,'1340790002243','bookregister','7777','2015-10-28'),(37,'3349800150660','bookregister','7777','2015-10-28'),(38,'3340300018845','student_check','7777','2015-10-28'),(39,'1340700398100','student_check','7777','2015-10-28'),(40,'3341100274253','student_check','7777','2015-10-28'),(41,'1340700065119','student_check','7777','2015-10-28'),(42,'3349900275031','student_check','7777','2015-10-28'),(43,'3350800274948','student_check','7777','2015-10-28'),(44,'3349800035119','student_check','7777','2015-10-28'),(45,'3340701131201','student_check','7777','2015-10-28'),(46,'1340700204747','student_check','7777','2015-10-28'),(47,'1340790002243','student_check','7777','2015-10-28'),(48,'1340790002243','student_check','7777','2015-10-28'),(49,'3349800150660','student_check','7777','2015-10-28'),(50,'3340300018845','student_main','7777','2015-10-28'),(51,'1340700398100','student_main','7777','2015-10-28'),(52,'3341100274253','student_main','7777','2015-10-28'),(53,'1340700065119','student_main','7777','2015-10-28'),(54,'3340701131201','student_main','7777','2015-10-28'),(55,'1340790002243','student_main','7777','2015-10-28'),(56,'3349800150660','student_main','7777','2015-10-28'),(57,'3340701131201','work','7777','2015-10-28'),(58,'3349800150660','work','7777','2015-10-28'),(59,'3340300018845','work','7777','2015-10-28'),(60,'3341100274253','work','7777','2015-10-28'),(61,'1340700065119','work','7777','2015-10-28'),(62,'1340790002243','work','7777','2015-10-28'),(63,'3349800035119','work','7777','2015-10-28'),(64,'3349900275031','work','7777','2015-10-28'),(65,'1340700065119','work','7777','2015-10-28'),(66,'3340300018845','budget','7777','2015-10-28'),(67,'3340701131201','budget','7777','2015-10-28'),(68,'3341100274253','budget','7777','2015-10-28'),(69,'3349800035119','budget','7777','2015-10-28'),(70,'3340300018845','cabinet','7777','2015-10-28'),(71,'3340701131201','cabinet','7777','2015-10-28'),(72,'3341100274253','cabinet','7777','2015-10-28'),(73,'1340700065119','cabinet','7777','2015-10-28'),(74,'3349900275031','cabinet','7777','2015-10-28'),(75,'3350800274948','cabinet','7777','2015-10-28'),(76,'3349800035119','cabinet','7777','2015-10-28'),(77,'1340700204747','cabinet','7777','2015-10-28'),(78,'1340790002243','cabinet','7777','2015-10-28'),(79,'3349800150660','cabinet','7777','2015-10-28'),(80,'3340300018845','health','7777','2015-10-28'),(81,'1340700398100','health','7777','2015-10-28'),(82,'3341100274253','health','7777','2015-10-28'),(83,'1340700065119','health','7777','2015-10-28'),(84,'3349900275031','health','7777','2015-10-28'),(85,'3350800274948','health','7777','2015-10-28'),(86,'3349800035119','health','7777','2015-10-28'),(87,'3349800035119','health','7777','2015-10-28'),(88,'3340701131201','health','7777','2015-10-28'),(89,'1340700204747','health','7777','2015-10-28'),(90,'1340790002243','health','7777','2015-10-28'),(91,'3349800150660','health','7777','2015-10-28'),(92,'3340300018845','la','7777','2015-10-28'),(93,'3340701131201','la','7777','2015-10-28'),(94,'3340300018845','la','3340701131201','2015-10-28'),(95,'3340701131201','la','3340701131201','2015-10-28'),(96,'3340300018845','mail','3340701131201','2015-10-28'),(97,'3340300018845','person','3340701131201','2015-10-28'),(98,'3341100274253','person','3340701131201','2015-10-28'),(99,'3340701131201','person','3340701131201','2015-10-28'),(100,'3341100274253','person','3340701131201','2015-10-28'),(101,'3349800150660','person','3340701131201','2015-10-28'),(102,'3349800035119','person','3340701131201','2015-10-28'),(103,'3340300018845','plan','3340701131201','2015-10-28'),(104,'3349800035119','plan','3340701131201','2015-10-28'),(105,'3340701131201','plan','3340701131201','2015-10-28'),(106,'3341100274253','plan','3340701131201','2015-10-28'),(107,'1340700398100','savings','3340701131201','2015-10-28'),(108,'3341100274253','savings','3340701131201','2015-10-28'),(109,'1340700065119','savings','3340701131201','2015-10-28'),(110,'3349900275031','savings','3340701131201','2015-10-28'),(111,'3340300018845','savings','3340701131201','2015-10-28'),(112,'3350800274948','savings','3340701131201','2015-10-28'),(113,'3349800035119','savings','3340701131201','2015-10-28'),(114,'3340701131201','savings','3340701131201','2015-10-28'),(115,'3349800150660','savings','3340701131201','2015-10-28'),(116,'1340700204747','savings','3340701131201','2015-10-28'),(117,'3349800035119','savings','3340701131201','2015-10-28'),(118,'3340300018845','standard','3340701131201','2015-10-28'),(119,'1340700398100','standard','3340701131201','2015-10-28'),(120,'3341100274253','standard','3340701131201','2015-10-28'),(121,'3349900275031','standard','3340701131201','2015-10-28'),(122,'1340790002243','standard','3340701131201','2015-10-28'),(123,'3349800150660','standard','3340701131201','2015-10-28'),(124,'3350800274948','standard','3340701131201','2015-10-28'),(125,'1340700065119','standard','3340701131201','2015-10-28'),(126,'3340701131201','standard','3340701131201','2015-10-28'),(127,'3340300018845','permission','3340701131201','2015-10-28'),(128,'1340700398100','permission','3340701131201','2015-10-28'),(129,'3341100274253','permission','3340701131201','2015-10-28'),(130,'1340700065119','permission','3340701131201','2015-10-28'),(131,'3350800274948','permission','3340701131201','2015-10-28'),(132,'3349900275031','permission','3340701131201','2015-10-28'),(133,'3340701131201','permission','3340701131201','2015-10-28'),(134,'3349800035119','permission','3340701131201','2015-10-28'),(135,'1340700204747','permission','3340701131201','2015-10-28'),(136,'1340790002243','permission','3340701131201','2015-10-28'),(137,'3349800150660','permission','3340701131201','2015-10-28'),(138,'3340300018845','meeting','3340701131201','2015-10-28'),(139,'3349800150660','meeting','3340701131201','2015-10-28'),(140,'3349800035119','meeting','3340701131201','2015-10-28'),(141,'3340701131201','meeting','3340701131201','2015-10-28'),(142,'1340700398100','permission','7777','2015-10-28'),(143,'1340700065119','permission','7777','2015-10-28'),(144,'3349900275031','permission','7777','2015-10-28'),(145,'1340790002243','permission','7777','2015-10-28'),(146,'1340700065119','permission','7777','2015-10-28'),(147,'1340700204747','permission','7777','2015-10-28'),(148,'3350800274948','permission','7777','2015-10-28'),(149,'1340700398100','permission','7777','2015-10-28'),(150,'3349800150660','permission','7777','2015-10-28'),(151,'3340700993659','permission','7777','2015-10-28'),(152,'3349900275031','permission','7777','2015-10-28'),(153,'1340790002243','permission','7777','2015-10-28'),(154,'1340700398100','person','7777','2015-10-28'),(155,'1340700204747','person','7777','2015-10-28'),(156,'1340700065119','book','7777','2018-10-01'),(157,'3349900275031','book','3340300018845','2020-11-01'),(158,'3349900275031','budget','3340300018845','2020-11-01'),(159,'3349900275031','amss_bets','3340300018845','2020-11-01'),(160,'3340300018845','amss_spacial_student','3340300018845','2021-08-24');

--
-- Table structure for table `system_school_name`
--

CREATE TABLE `system_school_name` (
  `id` tinyint(4) NOT NULL,
  `school_name` varchar(200) NOT NULL,
  `school_type` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_school_name`
--

INSERT INTO `system_school_name` VALUES (1,'โรงเรียนบ้านนาประชุม',0);

--
-- Table structure for table `system_sync_code`
--

CREATE TABLE `system_sync_code` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `office_code` varchar(10) NOT NULL,
  `system_name` varchar(50) NOT NULL,
  `sync_code` varchar(50) NOT NULL,
  `amssplus_url` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `system_name` (`system_name`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_sync_code`
--

INSERT INTO `system_sync_code` VALUES (4,'34040122','amssplus','34040122','http://10.255.199.107/amssplus');

--
-- Table structure for table `system_version`
--

CREATE TABLE `system_version` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `smss_version` varchar(100) NOT NULL,
  `status1` int(11) DEFAULT NULL,
  `status2` int(11) DEFAULT NULL,
  `status3` int(11) DEFAULT NULL,
  `status4` int(11) DEFAULT NULL,
  `status5` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_version`
--

INSERT INTO `system_version` VALUES (1,'6.4',1,0,0,0,0);

--
-- Table structure for table `system_workgroup`
--

CREATE TABLE `system_workgroup` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `workgroup` tinyint(4) NOT NULL,
  `workgroup_desc` varchar(50) NOT NULL,
  `workgroup_order` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `workgroup` (`workgroup`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_workgroup`
--

INSERT INTO `system_workgroup` VALUES (1,1,'บริหารวิชาการ',1),(2,2,'บริหารงบประมาณ',2),(3,3,'บริหารงานบุคคล',6),(4,4,'บริหารทั่วไป',8);

--
-- Table structure for table `work_main`
--

CREATE TABLE `work_main` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `work_date` date NOT NULL,
  `person_id` varchar(13) NOT NULL,
  `work` tinyint(4) NOT NULL DEFAULT 0,
  `comment` varchar(150) DEFAULT NULL,
  `rec_date` datetime NOT NULL,
  `officer` varchar(13) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `work_date` (`work_date`),
  KEY `person_id` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `work_main`
--

INSERT INTO `work_main` VALUES (1,'2015-10-28','3340300018845',1,NULL,'2015-10-28 13:44:43','3340701131201'),(2,'2015-10-28','3349800150660',1,NULL,'2015-10-28 13:44:43','3340701131201'),(3,'2015-10-28','3350800274948',1,NULL,'2015-10-28 13:44:43','3340701131201'),(4,'2015-10-28','3349800035119',1,NULL,'2015-10-28 13:44:43','3340701131201'),(5,'2015-10-28','3341100274253',1,NULL,'2015-10-28 13:44:43','3340701131201'),(6,'2015-10-28','3349900275031',1,NULL,'2015-10-28 13:44:43','3340701131201'),(7,'2015-10-28','1340700398100',1,NULL,'2015-10-28 13:44:43','3340701131201'),(8,'2015-10-28','1340700204747',1,NULL,'2015-10-28 13:44:43','3340701131201'),(9,'2015-10-28','1340700065119',1,NULL,'2015-10-28 13:44:43','3340701131201'),(10,'2015-10-28','1340790002243',1,NULL,'2015-10-28 13:44:43','3340701131201'),(11,'2015-10-28','3340701131201',1,NULL,'2015-10-28 13:44:43','3340701131201'),(12,'2015-10-28','3340700993659',1,NULL,'2015-10-28 13:44:43','3340701131201');

--
-- Table structure for table `work_permission`
--

CREATE TABLE `work_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` varchar(13) NOT NULL,
  `p1` tinyint(4) NOT NULL,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `work_permission`
--

INSERT INTO `work_permission` VALUES (1,'3340300018845',1,'3340701131201','2015-10-28'),(2,'3340701131201',1,'3340701131201','2015-10-28');


