--
-- Host: localhost    Database: catalogonline
-- ------------------------------------------------------


--
-- Table structure for table `access_log`
--

CREATE TABLE `access_log` (
  `access_log_id` int NOT NULL AUTO_INCREMENT,
  `access_log_pk` int NOT NULL,
  `access_log_ip` varchar(255) NOT NULL,
  `access_log_activity` varchar(255) NOT NULL,
  `access_log_loginas` varchar(255) DEFAULT NULL,
  `access_log_time` datetime NOT NULL,
  PRIMARY KEY (`access_log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=175 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `access_log`
--

INSERT INTO `access_log` VALUES (1,1,'49.229.126.185','Login','','2025-06-11 15:43:30'),(2,1,'49.229.126.185','Login','','2025-06-11 15:50:31'),(3,1,'49.229.126.185','Login','','2025-06-11 17:12:37'),(4,1,'49.229.127.211','Login','','2025-06-12 09:59:54'),(5,1,'49.229.127.211','Login','','2025-06-12 10:24:21'),(6,1,'49.229.127.211','Login','','2025-06-12 10:26:49'),(7,1,'49.229.127.211','Login','','2025-06-12 10:26:55'),(8,1,'49.229.127.211','LoginAsGo','73','2025-06-12 11:04:48'),(9,1,'49.229.127.211','Login','','2025-06-12 13:24:36'),(10,1,'49.229.127.211','Login','','2025-06-12 13:36:17'),(11,1,'49.229.126.5','Login','','2025-06-13 09:59:11'),(12,1,'49.229.126.0','Login','','2025-06-13 17:00:34'),(13,1,'49.229.127.235','Login','','2025-06-16 10:09:40'),(14,1,'49.229.127.235','Login','','2025-06-16 14:07:31'),(15,1,'49.229.126.57','Login','','2025-06-17 10:11:29'),(16,1,'49.229.126.57','Login','','2025-06-17 14:32:52'),(17,1,'49.229.125.12','Login','','2025-06-23 10:05:34'),(18,1,'49.229.124.182','Login','','2025-06-24 09:54:25'),(19,1,'49.229.124.182','Login','','2025-06-24 13:04:07'),(20,1,'49.229.125.234','Login','','2025-06-26 10:02:03'),(21,1,'49.229.125.234','Login','','2025-06-26 10:30:56'),(22,1,'49.229.125.122','Login','','2025-06-26 13:54:58'),(23,1,'192.168.42.124','Login','','2025-06-26 16:09:18'),(24,1,'49.229.124.139','Login','','2025-06-27 10:05:59'),(25,1,'192.168.42.27','Login','','2025-06-27 13:02:58'),(26,1,'49.229.127.193','Login','','2025-06-27 13:19:45'),(27,1,'49.229.125.231','Login','','2025-06-30 09:56:25'),(28,1,'49.229.125.239','Login','','2025-07-01 14:03:32'),(29,1,'49.229.126.88','Login','','2025-07-02 10:19:11'),(30,1,'49.229.126.88','Login','','2025-07-02 15:44:16'),(31,1,'49.229.127.20','Login','','2025-07-07 10:01:40'),(32,1,'192.168.42.226','Login','','2025-07-07 10:32:50'),(33,72,'192.168.42.226','Login','','2025-07-07 10:44:21'),(34,1,'192.168.42.226','Login','','2025-07-07 10:45:53'),(35,72,'192.168.42.226','Login','','2025-07-07 10:48:41'),(36,72,'192.168.42.226','Login','','2025-07-07 11:06:56'),(37,1,'203.131.209.86','Login','','2025-07-08 14:22:57'),(38,72,'203.131.209.86','Login','','2025-07-08 14:40:56'),(39,1,'203.131.209.86','Login','','2025-07-08 14:46:53'),(40,1,'192.168.3.131','Login','','2025-07-14 16:00:23'),(41,1,'49.229.126.37','Login','','2025-07-14 16:02:46'),(42,1,'192.168.3.57','Login','','2025-07-15 15:51:59'),(43,72,'192.168.3.57','Login','','2025-07-15 15:54:43'),(44,72,'203.131.209.86','Login','','2025-07-15 16:01:04'),(45,72,'192.168.3.57','Login','','2025-07-15 16:02:21'),(46,72,'203.131.209.86','Login','','2025-07-15 16:04:10'),(47,1,'203.131.209.86','Login','','2025-07-15 16:05:48'),(48,1,'203.131.209.86','Login','','2025-07-15 16:06:38'),(49,1,'49.229.124.184','Login','','2025-07-16 10:28:48'),(50,1,'49.229.124.184','Login','','2025-07-16 10:28:55'),(51,1,'49.229.124.184','Login','','2025-07-16 10:29:13'),(52,1,'49.229.126.40','Login','','2025-07-17 10:13:46'),(53,1,'192.168.41.45','Login','','2025-07-18 13:53:04'),(54,1,'49.229.126.102','Login','','2025-07-18 15:39:58'),(55,1,'49.229.126.102','Login','','2025-07-18 15:44:38'),(56,1,'49.229.126.102','Login','','2025-07-18 15:50:18'),(57,1,'192.168.41.45','Login','','2025-07-18 16:25:17'),(58,1,'192.168.41.45','LoginAsGo','79','2025-07-18 16:32:54'),(59,1,'49.229.126.102','LoginAsGo','79','2025-07-18 16:34:10'),(60,1,'49.229.126.102','Login','','2025-07-18 16:34:31'),(61,79,'192.168.41.45','LoginAsGo','78','2025-07-18 16:38:07'),(62,76,'192.168.41.45','Login','','2025-07-18 16:38:57'),(63,75,'192.168.41.45','Login','','2025-07-18 16:39:20'),(64,77,'192.168.41.45','Login','','2025-07-18 16:39:43'),(65,78,'192.168.41.45','Login','','2025-07-18 16:40:16'),(66,1,'49.229.126.102','LoginAsGo','79','2025-07-18 16:43:17'),(67,1,'49.229.126.102','LoginAsGo','79','2025-07-18 16:46:13'),(68,1,'49.229.126.102','LoginAsGo','79','2025-07-18 16:49:26'),(69,75,'192.168.41.45','Login','','2025-07-18 16:50:28'),(70,75,'192.168.41.45','Login','','2025-07-18 16:50:43'),(71,75,'49.229.126.102','Login','','2025-07-18 16:51:32'),(72,75,'192.168.2.246','Login','','2025-07-23 10:39:05'),(73,76,'192.168.2.246','Login','','2025-07-23 10:50:09'),(74,76,'192.168.2.246','Login','','2025-07-23 10:51:25'),(75,1,'49.229.124.62','Login','','2025-07-23 11:04:46'),(76,76,'49.229.124.62','Login','','2025-07-23 11:07:04'),(77,75,'192.168.2.246','Login','','2025-07-23 11:12:50'),(78,76,'192.168.2.246','Login','','2025-07-23 11:37:09'),(79,1,'49.229.124.62','Login','','2025-07-23 11:39:02'),(80,76,'192.168.2.246','Login','','2025-07-23 11:40:58'),(81,76,'192.168.2.246','Login','','2025-07-23 11:41:15'),(82,1,'192.168.2.246','Login','','2025-07-23 11:41:58'),(83,76,'192.168.2.246','Login','','2025-07-23 13:19:09'),(84,75,'192.168.2.246','Login','','2025-07-23 13:20:02'),(85,76,'192.168.2.246','Login','','2025-07-23 13:20:37'),(86,76,'49.229.124.62','Login','','2025-07-23 13:33:42'),(87,1,'49.229.124.62','Login','','2025-07-23 13:35:29'),(88,76,'192.168.2.246','Login','','2025-07-23 14:20:33'),(89,75,'192.168.2.246','Login','','2025-07-23 14:38:02'),(90,76,'192.168.2.246','Login','','2025-07-23 15:07:12'),(91,75,'192.168.2.246','Login','','2025-07-23 15:09:09'),(92,76,'192.168.2.246','Login','','2025-07-23 15:51:24'),(93,75,'192.168.2.246','Login','','2025-07-23 15:54:57'),(94,76,'192.168.2.246','Login','','2025-07-23 16:17:18'),(95,76,'192.168.2.174','Login','','2025-07-24 09:40:10'),(96,75,'192.168.2.174','Login','','2025-07-24 09:48:53'),(97,77,'192.168.2.174','Login','','2025-07-24 09:56:19'),(98,76,'192.168.2.174','Login','','2025-07-24 09:56:44'),(99,1,'49.229.125.252','Login','','2025-07-24 10:03:13'),(100,75,'192.168.2.174','Login','','2025-07-24 10:10:32'),(101,77,'192.168.2.174','Login','','2025-07-24 11:08:12'),(102,78,'192.168.2.174','Login','','2025-07-24 11:09:53'),(103,77,'49.229.125.252','Login','','2025-07-24 11:21:32'),(104,78,'49.229.125.252','Login','','2025-07-24 11:22:00'),(105,1,'49.229.125.252','Login','','2025-07-24 13:09:39'),(106,77,'192.168.2.174','Login','','2025-07-24 13:18:07'),(107,75,'192.168.2.174','Login','','2025-07-24 14:31:31'),(108,75,'192.168.2.174','Login','','2025-07-24 16:38:48'),(109,75,'192.168.3.111','Login','','2025-07-30 10:17:10'),(110,1,'192.168.3.111','Login','','2025-07-30 10:28:17'),(111,1,'203.131.209.86','Login','','2025-07-30 10:32:24'),(112,76,'192.168.3.111','Login','','2025-07-30 10:34:19'),(113,76,'192.168.3.111','Login','','2025-07-30 11:10:39'),(114,1,'192.168.3.111','Login','','2025-07-30 11:12:19'),(115,76,'192.168.3.111','Login','','2025-07-30 11:12:50'),(116,1,'192.168.3.111','Login','','2025-07-30 11:23:09'),(117,75,'192.168.3.111','Login','','2025-07-30 11:23:21'),(118,76,'192.168.3.111','Login','','2025-07-30 11:25:08'),(119,78,'192.168.3.111','Login','','2025-07-30 11:27:01'),(120,76,'192.168.3.111','Login','','2025-07-30 13:24:16'),(121,75,'192.168.3.111','Login','','2025-07-30 13:24:47'),(122,76,'192.168.3.111','Login','','2025-07-30 13:25:39'),(123,75,'192.168.3.111','Login','','2025-07-30 13:27:08'),(124,76,'192.168.3.111','Login','','2025-07-30 13:27:54'),(125,75,'192.168.3.111','Login','','2025-07-30 13:28:25'),(126,76,'192.168.3.111','Login','','2025-07-30 13:28:48'),(127,1,'203.131.209.86','Login','','2025-07-30 13:32:38'),(128,75,'192.168.3.111','Login','','2025-07-30 14:41:27'),(129,76,'192.168.3.111','Login','','2025-07-30 15:03:15'),(130,76,'192.168.3.111','Login','','2025-07-30 15:03:56'),(131,76,'192.168.3.111','Login','','2025-07-30 15:53:17'),(132,75,'192.168.3.111','Login','','2025-07-30 16:03:31'),(133,76,'192.168.3.111','Login','','2025-07-30 16:03:58'),(134,77,'192.168.3.111','Login','','2025-07-30 16:05:28'),(135,78,'192.168.3.111','Login','','2025-07-30 16:10:04'),(136,76,'192.168.3.111','Login','','2025-07-30 16:11:04'),(137,75,'192.168.3.111','Login','','2025-07-30 16:11:34'),(138,76,'192.168.3.111','Login','','2025-07-30 16:27:07'),(139,1,'203.131.209.86','Login','','2025-07-30 16:53:11'),(140,76,'192.168.3.111','Login','','2025-07-31 09:59:45'),(141,1,'49.229.124.147','Login','','2025-07-31 13:05:21'),(142,76,'192.168.3.111','Login','','2025-07-31 13:47:51'),(143,75,'192.168.3.111','Login','','2025-07-31 13:48:29'),(144,76,'192.168.3.111','Login','','2025-07-31 14:06:51'),(145,75,'192.168.3.111','Login','','2025-07-31 14:08:43'),(146,1,'49.229.124.231','Login','','2025-08-01 11:06:50'),(147,75,'49.229.125.14','Login','','2025-08-04 10:11:36'),(148,75,'49.229.125.14','Login','','2025-08-04 10:13:23'),(149,76,'49.229.125.14','Login','','2025-08-04 10:14:13'),(150,76,'49.229.125.14','Login','','2025-08-04 10:40:06'),(151,1,'172.16.1.238','Login','','2025-08-04 10:49:33'),(152,75,'49.229.125.14','Login','','2025-08-04 10:57:41'),(153,76,'49.229.125.14','Login','','2025-08-04 10:58:36'),(154,78,'49.229.125.14','Login','','2025-08-04 11:02:23'),(155,77,'49.229.125.14','Login','','2025-08-04 11:02:42'),(156,76,'49.229.125.14','Login','','2025-08-04 11:03:02'),(157,78,'49.229.125.14','Login','','2025-08-04 11:04:21'),(158,76,'49.229.125.14','Login','','2025-08-04 11:05:01'),(159,76,'49.229.125.14','Login','','2025-08-04 11:06:35'),(160,77,'49.229.125.14','Login','','2025-08-04 11:27:20'),(161,75,'49.229.125.14','Login','','2025-08-04 11:27:37'),(162,76,'49.229.125.14','Login','','2025-08-04 11:33:15'),(163,75,'49.229.125.14','Login','','2025-08-04 13:18:23'),(164,76,'49.229.125.14','Login','','2025-08-04 13:21:14'),(165,77,'49.229.125.14','Login','','2025-08-04 14:41:55'),(166,77,'49.229.125.14','Login','','2025-08-04 14:42:42'),(167,75,'49.229.125.14','Login','','2025-08-04 14:42:53'),(168,77,'49.229.125.14','Login','','2025-08-04 14:43:33'),(169,76,'49.229.125.14','Login','','2025-08-04 14:45:11'),(170,77,'49.229.125.14','Login','','2025-08-04 14:47:18'),(171,77,'49.229.125.14','Login','','2025-08-04 14:51:37'),(172,1,'172.16.1.238','Login','','2025-08-04 14:51:57'),(173,76,'49.229.125.14','Login','','2025-08-04 14:52:03'),(174,75,'49.229.125.14','Login','','2025-08-04 14:53:50');

--
-- Table structure for table `backup_log`
--

CREATE TABLE `backup_log` (
  `backup_log_id` int NOT NULL AUTO_INCREMENT,
  `backup_log_date_active` varchar(255) NOT NULL,
  `backup_log_date_inactive` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `backup_log_type` varchar(50) NOT NULL,
  `backup_log_folder` varchar(50) NOT NULL,
  `backup_log_status` varchar(50) NOT NULL,
  PRIMARY KEY (`backup_log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `backup_log`
--

INSERT INTO `backup_log` VALUES (10,'2025-07-18 14:17:05','2025-07-24 17:00:07','database','1','Inactive'),(11,'2025-07-18 17:00:05','2025-07-25 17:00:08','database','2','Inactive'),(12,'2025-07-19 17:00:06','2025-07-26 17:00:10','database','3','Inactive'),(13,'2025-07-20 17:00:09','2025-07-27 17:00:09','database','4','Inactive'),(14,'2025-07-21 17:00:06','2025-07-28 17:00:11','database','5','Inactive'),(15,'2025-07-22 17:00:07','2025-07-29 17:00:10','database','6','Inactive'),(16,'2025-07-23 17:00:06','2025-07-30 17:00:09','database','7','Inactive'),(17,'2025-07-24 17:00:07','2025-07-31 17:00:12','database','1','Inactive'),(18,'2025-07-25 17:00:08','2025-08-01 17:00:11','database','2','Inactive'),(19,'2025-07-26 17:00:10','2025-08-02 17:00:11','database','3','Inactive'),(20,'2025-07-27 17:00:09','2025-08-03 17:00:10','database','4','Inactive'),(21,'2025-07-28 17:00:11','','database','5','Active'),(22,'2025-07-29 17:00:10','','database','6','Active'),(23,'2025-07-30 17:00:09','','database','7','Active'),(24,'2025-07-31 17:00:12','','database','1','Active'),(25,'2025-08-01 17:00:11','','database','2','Active'),(26,'2025-08-02 17:00:11','','database','3','Active'),(27,'2025-08-03 17:00:10','','database','4','Active');

--
-- Table structure for table `cart_items`
--

CREATE TABLE `cart_items` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `product_id` int DEFAULT NULL,
  `qty` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `cart_items`
--

INSERT INTO `cart_items` VALUES (10,75,1,'1','2025-08-04 10:12:59','2025-08-04 10:12:59'),(25,75,9,'1','2025-08-04 10:57:58','2025-08-04 10:57:58'),(36,78,3,'1','2025-08-04 11:02:28','2025-08-04 11:02:28'),(37,78,4,'1','2025-08-04 11:02:29','2025-08-04 11:02:29'),(38,78,10,'1','2025-08-04 11:02:31','2025-08-04 11:02:31'),(68,76,11,'1','2025-08-04 13:16:50','2025-08-04 13:16:50'),(69,76,10,'1','2025-08-04 13:16:51','2025-08-04 13:16:51'),(71,76,8,'1','2025-08-04 13:16:58','2025-08-04 13:16:58'),(72,77,1,'1','2025-08-04 14:42:05','2025-08-04 14:42:05'),(73,77,5,'1','2025-08-04 14:42:08','2025-08-04 14:42:08'),(74,77,6,'1','2025-08-04 14:42:10','2025-08-04 14:42:10'),(75,1,9,'1','2025-08-04 14:59:56','2025-08-04 14:59:56');

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `categories_id` int NOT NULL AUTO_INCREMENT,
  `categories_name` varchar(255) DEFAULT NULL,
  `categories_description` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`categories_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `categories`
--


--
-- Table structure for table `log_activity`
--

CREATE TABLE `log_activity` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `USER_ID` int NOT NULL,
  `TYPE` varchar(100) NOT NULL,
  `KEY_ID` int NOT NULL,
  `MODULE` varchar(100) NOT NULL,
  `SOURCE` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `log_activity`
--

INSERT INTO `log_activity` VALUES (1,1,'INSERT',0,'User List','user_userid=>73///user_title=>///user_username=>Nongtest///user_fullname=>Nongtest Nongtest///user_firstname=>Nongtest///user_lastname=>Nongtest///user_position=>///user_email=>nalinee@siit.tu.ac.th///user_role=>///user_picture=>///','2025-06-12 11:04:27','2025-06-12 11:04:27'),(2,1,'INSERT',45,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>2///price=>359///product_id=>3///product_name=>Fan///quantity=>3///price=>500///','2025-07-02 16:28:12','2025-07-02 16:28:12'),(3,1,'INSERT',0,'User List','user_userid=>74///user_title=>///user_username=>Nongtest///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>nalinee.phumpra@gmail.com///user_phone=>0614989429///user_address=>Street///user_role=>///user_picture=>///','2025-07-07 10:43:50','2025-07-07 10:43:50'),(4,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_picture=>///','2025-07-08 15:12:47','2025-07-08 15:12:47'),(5,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_picture=>///','2025-07-18 16:09:32','2025-07-18 16:09:32'),(6,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>///user_picture=>///','2025-07-18 16:12:57','2025-07-18 16:12:57'),(7,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>///user_picture=>///','2025-07-18 16:13:16','2025-07-18 16:13:16'),(8,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>///user_picture=>///','2025-07-18 16:15:59','2025-07-18 16:15:59'),(9,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>///user_picture=>///','2025-07-18 16:17:24','2025-07-18 16:17:24'),(10,1,'UPDATE',1,'User List','user_title=>///user_username=>///user_fullname=>Consult Admin///user_firstname=>Consult///user_lastname=>Admin///user_position=>///user_email=>consulting@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:20:20','2025-07-18 16:20:20'),(11,1,'INSERT',0,'User List','user_userid=>75///user_title=>///user_username=>Nongtest///user_fullname=>นลินี พุ่มประจำ///user_firstname=>นลินี///user_lastname=>พุ่มประจำ///user_position=>///user_email=>nalinee@siit.tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:27:10','2025-07-18 16:27:10'),(12,1,'INSERT',0,'User List','user_userid=>76///user_title=>///user_username=>Requester///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>nalinee.phumpra@gmail.com///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:28:24','2025-07-18 16:28:24'),(13,1,'INSERT',0,'User List','user_userid=>77///user_title=>///user_username=>Supervisor///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>nalinee.phumprajam@gmail.com///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:29:57','2025-07-18 16:29:57'),(14,1,'INSERT',0,'User List','user_userid=>78///user_title=>///user_username=>Authorize///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>morefinn.nvm@gmail.com///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:30:55','2025-07-18 16:30:55'),(15,1,'INSERT',0,'User List','user_userid=>79///user_title=>///user_username=>Admin///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>nalineep@tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:32:41','2025-07-18 16:32:41'),(16,79,'UPDATE',79,'User List','user_title=>///user_username=>Admin///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>nalineep@tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>20///user_picture=>///','2025-07-18 16:34:40','2025-07-18 16:34:40'),(17,79,'UPDATE',79,'User List','user_title=>///user_username=>Admin///user_fullname=>ทดสอบ ทดสอบ///user_firstname=>ทดสอบ///user_lastname=>ทดสอบ///user_position=>///user_email=>nalineep@tu.ac.th///user_phone=>///user_address=>///user_role=>///user_division_id=>1///user_picture=>///','2025-07-18 16:34:59','2025-07-18 16:34:59'),(18,76,'INSERT',46,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///','2025-07-23 11:11:26','2025-07-23 11:11:26'),(19,75,'APPROVE',46,'Order','order_code=>2025/0005///status=>pending///approved_by=>Nongtest///','2025-07-23 11:14:17','2025-07-23 11:14:17'),(20,76,'INSERT',47,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 11:41:42','2025-07-23 11:41:42'),(21,1,'REJECT',47,'Order','order_code=>2025/0006///status=>rejected///rejected_by=>admin///','2025-07-23 13:18:45','2025-07-23 13:18:45'),(22,76,'INSERT',48,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///','2025-07-23 13:19:45','2025-07-23 13:19:45'),(23,75,'REJECT',48,'Order','order_code=>2025/0007///status=>rejected///rejected_by=>Nongtest///','2025-07-23 13:20:21','2025-07-23 13:20:21'),(24,76,'INSERT',49,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>6///product_name=>Fabric bag///quantity=>1///price=>199///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 13:35:10','2025-07-23 13:35:10'),(25,1,'REJECT',49,'Order','order_code=>2025/0008///status=>rejected///rejected_by=>admin///','2025-07-23 13:49:53','2025-07-23 13:49:53'),(26,1,'INSERT',50,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 13:50:09','2025-07-23 13:50:09'),(27,1,'INSERT',51,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 14:06:06','2025-07-23 14:06:06'),(28,1,'INSERT',52,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 14:15:53','2025-07-23 14:15:53'),(29,1,'APPROVE_ITEM',82,'OrderItem','order_item_id=>82///approved_by=>admin///','2025-07-23 14:22:12','2025-07-23 14:22:12'),(30,1,'INSERT',53,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 14:26:55','2025-07-23 14:26:55'),(31,1,'APPROVE_ITEM',84,'OrderItem','order_item_id=>84///approved_by=>admin///','2025-07-23 14:27:05','2025-07-23 14:27:05'),(32,1,'INSERT',54,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-23 14:32:31','2025-07-23 14:32:31'),(33,1,'APPROVE_ITEM',86,'OrderItem','order_item_id=>86///approved_by=>admin///','2025-07-23 14:32:40','2025-07-23 14:32:40'),(34,76,'INSERT',55,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///product_id=>3///product_name=>Fan///quantity=>1///price=>500///product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///','2025-07-23 14:37:16','2025-07-23 14:37:16'),(35,75,'APPROVE_ITEM',88,'OrderItem','order_item_id=>88///approved_by=>Nongtest///','2025-07-23 15:06:15','2025-07-23 15:06:15'),(36,75,'REJECT_ITEM',90,'OrderItem','order_item_id=>90///rejected_by=>Nongtest///','2025-07-23 15:06:26','2025-07-23 15:06:26'),(37,1,'APPROVE_ITEM',88,'OrderItem','order_item_id=>88///approved_by=>admin///','2025-07-24 10:10:19','2025-07-24 10:10:19'),(38,1,'INSERT',56,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///','2025-07-24 13:09:55','2025-07-24 13:09:55'),(39,1,'INSERT',57,'Order','product_id=>10///product_name=>Passport Case///quantity=>2///price=>269///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-30 10:29:35','2025-07-30 10:29:35'),(40,76,'INSERT',58,'Order','product_id=>10///product_name=>Passport Case///quantity=>2///price=>269///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-30 10:34:49','2025-07-30 10:34:49'),(41,1,'APPROVE_ITEM',97,'OrderItem','order_item_id=>97///approved_by=>admin///','2025-07-30 10:41:34','2025-07-30 10:41:34'),(42,1,'APPROVE_ITEM',100,'OrderItem','order_item_id=>100///approved_by=>admin///','2025-07-30 10:41:41','2025-07-30 10:41:41'),(43,1,'APPROVE_ITEM',93,'OrderItem','order_item_id=>93///approved_by=>admin///','2025-07-30 10:42:15','2025-07-30 10:42:15'),(44,1,'APPROVE_ITEM',96,'OrderItem','order_item_id=>96///approved_by=>admin///','2025-07-30 10:42:18','2025-07-30 10:42:18'),(45,76,'INSERT',59,'Order','product_id=>10///product_name=>Passport Case///quantity=>2///price=>269///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-30 11:10:13','2025-07-30 11:10:13'),(46,76,'INSERT',60,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>3///product_name=>Fan///quantity=>1///price=>500///product_id=>4///product_name=>Post-It///quantity=>1///price=>39///product_id=>1///product_name=>ขวดน้ำ///quantity=>2///price=>359///','2025-07-30 11:11:13','2025-07-30 11:11:13'),(47,78,'INSERT',61,'Order','product_id=>6///product_name=>Fabric bag///quantity=>1///price=>199///product_id=>5///product_name=>Pluck///quantity=>1///price=>299///product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///product_id=>10///product_name=>Passport Case///quantity=>2///price=>269///','2025-07-30 13:23:18','2025-07-30 13:23:18'),(48,75,'APPROVE_ITEM',111,'OrderItem','order_item_id=>111///approved_by=>Nongtest///','2025-07-30 13:25:28','2025-07-30 13:25:28'),(49,75,'APPROVE_ITEM',112,'OrderItem','order_item_id=>112///approved_by=>Nongtest///','2025-07-30 13:28:35','2025-07-30 13:28:35'),(50,1,'INSERT',62,'Order','product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///','2025-07-30 14:49:04','2025-07-30 14:49:04'),(51,1,'INSERT',63,'Order','product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///','2025-07-30 14:54:51','2025-07-30 14:54:51'),(52,1,'REJECT_ITEM',117,'OrderItem','order_item_id=>117///rejected_by=>admin///','2025-07-30 15:02:31','2025-07-30 15:02:31'),(53,1,'INSERT',64,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-30 15:45:49','2025-07-30 15:45:49'),(54,1,'INSERT',65,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///','2025-07-30 15:49:35','2025-07-30 15:49:35'),(55,76,'INSERT',66,'Order','product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///','2025-07-30 15:59:54','2025-07-30 15:59:54'),(56,76,'INSERT',67,'Order','product_id=>10///product_name=>Passport Case///quantity=>2///price=>269///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>3///product_name=>Fan///quantity=>1///price=>500///','2025-07-30 16:03:15','2025-07-30 16:03:15'),(57,75,'APPROVE_ITEM',122,'OrderItem','order_item_id=>122///approved_by=>Nongtest///','2025-07-30 16:03:45','2025-07-30 16:03:45'),(58,1,'APPROVE_ITEM',119,'OrderItem','order_item_id=>119///approved_by=>admin///','2025-07-30 16:18:29','2025-07-30 16:18:29'),(59,1,'INSERT',68,'Order','product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///','2025-07-31 13:33:32','2025-07-31 13:33:32'),(60,76,'INSERT',69,'Order','product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///','2025-08-04 10:59:16','2025-08-04 10:59:16'),(61,76,'INSERT',70,'Order','product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>6///product_name=>Fabric bag///quantity=>1///price=>199///','2025-08-04 11:01:55','2025-08-04 11:01:55'),(62,76,'INSERT',71,'Order','product_id=>6///product_name=>Fabric bag///quantity=>1///price=>199///product_id=>7///product_name=>Charging cable///quantity=>1///price=>149///product_id=>4///product_name=>Post-It///quantity=>1///price=>39///','2025-08-04 11:04:03','2025-08-04 11:04:03'),(63,76,'INSERT',72,'Order','product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///product_id=>5///product_name=>Pluck///quantity=>1///price=>299///','2025-08-04 11:05:21','2025-08-04 11:05:21'),(64,76,'INSERT',73,'Order','product_id=>11///product_name=>ทดสอบ///quantity=>1///price=>250///product_id=>10///product_name=>Passport Case///quantity=>1///price=>269///product_id=>8///product_name=>Business card box///quantity=>1///price=>99///','2025-08-04 13:17:05','2025-08-04 13:17:05'),(65,75,'APPROVE_ITEM',140,'OrderItem','order_item_id=>140///approved_by=>Nongtest///','2025-08-04 13:18:33','2025-08-04 13:18:33'),(66,75,'APPROVE_ITEM',139,'OrderItem','order_item_id=>139///approved_by=>Nongtest///','2025-08-04 13:18:39','2025-08-04 13:18:39'),(67,77,'INSERT',74,'Order','product_id=>1///product_name=>ขวดน้ำ///quantity=>1///price=>359///product_id=>5///product_name=>Pluck///quantity=>1///price=>299///product_id=>6///product_name=>Fabric bag///quantity=>1///price=>199///','2025-08-04 14:42:28','2025-08-04 14:42:28'),(68,75,'APPROVE_ITEM',142,'OrderItem','order_item_id=>142///approved_by=>Nongtest///','2025-08-04 14:43:17','2025-08-04 14:43:17'),(69,1,'INSERT',75,'Order','product_id=>9///product_name=>Craftsman key chain///quantity=>1///price=>129///','2025-08-04 14:59:59','2025-08-04 14:59:59');

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` int unsigned NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--

INSERT INTO `model_has_permissions` VALUES (7,'App\\User',1),(7,'App\\User',2);

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` int unsigned NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\User',1),(21,'App\\User',1),(1,'App\\User',73),(2,'App\\User',74),(21,'App\\User',75),(2,'App\\User',76),(3,'App\\User',77),(20,'App\\User',78),(1,'App\\User',79);

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `order_item_id` int NOT NULL AUTO_INCREMENT,
  `order_id` int DEFAULT NULL,
  `product_id` int DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `product_price` varchar(255) DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `item_status` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`order_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` VALUES (86,54,10,'Passport Case','269',1,NULL,'approved','2025-07-23 14:32:31','2025-07-23 14:32:40'),(87,54,1,'ขวดน้ำ','359',1,NULL,NULL,'2025-07-23 14:32:31','2025-07-23 14:32:31'),(88,55,1,'ขวดน้ำ','359',1,NULL,'approved','2025-07-23 14:37:16','2025-07-24 10:10:19'),(89,55,3,'Fan','500',1,NULL,NULL,'2025-07-23 14:37:16','2025-07-23 14:37:16'),(91,56,10,'Passport Case','269',1,NULL,NULL,'2025-07-24 13:09:55','2025-07-24 13:09:55'),(92,56,8,'Business card box','99',1,NULL,NULL,'2025-07-24 13:09:55','2025-07-24 13:09:55'),(97,58,10,'Passport Case','269',2,NULL,'approved','2025-07-30 10:34:49','2025-07-30 10:41:34'),(98,58,7,'Charging cable','149',1,NULL,NULL,'2025-07-30 10:34:49','2025-07-30 10:34:49'),(99,58,9,'Craftsman key chain','129',1,NULL,NULL,'2025-07-30 10:34:49','2025-07-30 10:34:49'),(100,58,1,'ขวดน้ำ','359',1,NULL,'approved','2025-07-30 10:34:49','2025-07-30 10:41:41'),(101,59,10,'Passport Case','269',2,NULL,NULL,'2025-07-30 11:10:13','2025-07-30 11:10:13'),(102,59,7,'Charging cable','149',1,NULL,NULL,'2025-07-30 11:10:13','2025-07-30 11:10:13'),(103,59,9,'Craftsman key chain','129',1,NULL,NULL,'2025-07-30 11:10:13','2025-07-30 11:10:13'),(104,59,1,'ขวดน้ำ','359',1,NULL,NULL,'2025-07-30 11:10:13','2025-07-30 11:10:13'),(105,60,10,'Passport Case','269',1,NULL,NULL,'2025-07-30 11:11:13','2025-07-30 11:11:13'),(106,60,3,'Fan','500',1,NULL,NULL,'2025-07-30 11:11:13','2025-07-30 11:11:13'),(107,60,4,'Post-It','39',1,NULL,NULL,'2025-07-30 11:11:13','2025-07-30 11:11:13'),(108,60,1,'ขวดน้ำ','359',2,NULL,NULL,'2025-07-30 11:11:13','2025-07-30 11:11:13'),(109,61,6,'Fabric bag','199',1,NULL,NULL,'2025-07-30 13:23:18','2025-07-30 13:23:18'),(110,61,5,'Pluck','299',1,NULL,NULL,'2025-07-30 13:23:18','2025-07-30 13:23:18'),(111,61,1,'ขวดน้ำ','359',1,NULL,'approved','2025-07-30 13:23:18','2025-07-30 13:25:27'),(112,61,10,'Passport Case','269',2,NULL,'approved','2025-07-30 13:23:18','2025-07-30 13:28:35'),(113,62,8,'Business card box','99',1,NULL,NULL,'2025-07-30 14:49:04','2025-07-30 14:49:04'),(114,62,9,'Craftsman key chain','129',1,NULL,NULL,'2025-07-30 14:49:04','2025-07-30 14:49:04'),(115,63,8,'Business card box','99',1,NULL,NULL,'2025-07-30 14:54:51','2025-07-30 14:54:51'),(116,63,9,'Craftsman key chain','129',1,NULL,NULL,'2025-07-30 14:54:51','2025-07-30 14:54:51'),(117,63,10,'Passport Case','269',1,NULL,'rejected','2025-07-30 14:54:51','2025-07-30 15:02:31'),(118,64,1,'ขวดน้ำ','359',1,NULL,NULL,'2025-07-30 15:45:49','2025-07-30 15:45:49'),(119,65,1,'ขวดน้ำ','359',1,NULL,'approved','2025-07-30 15:49:35','2025-07-30 16:18:29'),(120,66,9,'Craftsman key chain','129',1,NULL,NULL,'2025-07-30 15:59:54','2025-07-30 15:59:54'),(121,66,8,'Business card box','99',1,NULL,NULL,'2025-07-30 15:59:54','2025-07-30 15:59:54'),(122,67,10,'Passport Case','269',2,NULL,'approved','2025-07-30 16:03:15','2025-07-30 16:03:45'),(123,67,9,'Craftsman key chain','129',1,NULL,NULL,'2025-07-30 16:03:15','2025-07-30 16:03:15'),(124,67,8,'Business card box','99',1,NULL,NULL,'2025-07-30 16:03:15','2025-07-30 16:03:15'),(125,67,3,'Fan','500',1,NULL,NULL,'2025-07-30 16:03:15','2025-07-30 16:03:15'),(126,68,8,'Business card box','99',1,NULL,NULL,'2025-07-31 13:33:32','2025-07-31 13:33:32'),(127,68,9,'Craftsman key chain','129',1,NULL,NULL,'2025-07-31 13:33:32','2025-07-31 13:33:32'),(128,69,9,'Craftsman key chain','129',1,NULL,NULL,'2025-08-04 10:59:16','2025-08-04 10:59:16'),(129,70,9,'Craftsman key chain','129',1,NULL,NULL,'2025-08-04 11:01:55','2025-08-04 11:01:55'),(130,70,10,'Passport Case','269',1,NULL,NULL,'2025-08-04 11:01:55','2025-08-04 11:01:55'),(131,70,8,'Business card box','99',1,NULL,NULL,'2025-08-04 11:01:55','2025-08-04 11:01:55'),(132,70,6,'Fabric bag','199',1,NULL,NULL,'2025-08-04 11:01:55','2025-08-04 11:01:55'),(133,71,6,'Fabric bag','199',1,NULL,NULL,'2025-08-04 11:04:03','2025-08-04 11:04:03'),(134,71,7,'Charging cable','149',1,NULL,NULL,'2025-08-04 11:04:03','2025-08-04 11:04:03'),(135,71,4,'Post-It','39',1,NULL,NULL,'2025-08-04 11:04:03','2025-08-04 11:04:03'),(136,72,10,'Passport Case','269',1,NULL,NULL,'2025-08-04 11:05:21','2025-08-04 11:05:21'),(137,72,8,'Business card box','99',1,NULL,NULL,'2025-08-04 11:05:21','2025-08-04 11:05:21'),(138,72,5,'Pluck','299',1,NULL,NULL,'2025-08-04 11:05:21','2025-08-04 11:05:21'),(139,73,11,'ทดสอบ','250',1,NULL,'approved','2025-08-04 13:17:05','2025-08-04 13:18:39'),(140,73,10,'Passport Case','269',1,NULL,'approved','2025-08-04 13:17:05','2025-08-04 13:18:33'),(141,73,8,'Business card box','99',1,NULL,NULL,'2025-08-04 13:17:05','2025-08-04 13:17:05'),(142,74,1,'ขวดน้ำ','359',1,NULL,'approved','2025-08-04 14:42:28','2025-08-04 14:43:17'),(143,74,5,'Pluck','299',1,NULL,NULL,'2025-08-04 14:42:28','2025-08-04 14:42:28'),(144,74,6,'Fabric bag','199',1,NULL,NULL,'2025-08-04 14:42:28','2025-08-04 14:42:28'),(145,75,9,'Craftsman key chain','129',1,NULL,NULL,'2025-08-04 14:59:59','2025-08-04 14:59:59');

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `order_id` int NOT NULL AUTO_INCREMENT,
  `order_user_id` int DEFAULT NULL,
  `order_code` varchar(20) DEFAULT NULL,
  `order_customer_name` varchar(255) DEFAULT NULL,
  `order_division` varchar(255) DEFAULT NULL,
  `order_email` varchar(255) DEFAULT NULL,
  `order_purpose` text,
  `order_request_date` datetime DEFAULT NULL,
  `order_use_date` datetime DEFAULT NULL,
  `order_receive_date` datetime DEFAULT NULL,
  `order_approved_date` datetime DEFAULT NULL,
  `order_address` text,
  `order_total_price` varchar(255) DEFAULT NULL,
  `order_status_for_admin` varchar(255) DEFAULT NULL,
  `order_status_for_supervisor` varchar(255) DEFAULT NULL,
  `order_status_for_authorize` varchar(255) DEFAULT NULL,
  `order_status` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` VALUES (54,1,'2025/0001','admin',NULL,NULL,NULL,'2025-07-23 14:32:31',NULL,NULL,'2025-07-24 10:23:52',NULL,'628','approved',NULL,NULL,'approved','2025-07-23 14:32:31','2025-07-24 10:23:52'),(55,76,'2025/0002','ทดสอบชื่อนามสกุล','1','nalinee.phumpra@gmail.com','ทดสอบวัตถุประสงค์การเบิก','2025-07-23 00:00:00','2025-07-25 00:00:00','2025-07-25 00:00:00','2025-07-24 11:22:06','ตึก SIIT ชั้น 3 ห้อง Consulting','1128','approved','approved','approved','delivered','2025-07-23 14:37:16','2025-07-24 11:22:06'),(56,1,'2025/0003','admin',NULL,NULL,NULL,'2025-07-24 13:09:55',NULL,NULL,NULL,NULL,'368','pending',NULL,NULL,'pending','2025-07-24 13:09:55','2025-07-24 13:09:55'),(58,76,'2025/0005','ทดสอบชื่อนามสกุล','26','nalinee.phumpra@gmail.com','ทดสอบวัตถุประสงค์การเบิก','2025-07-30 00:00:00','2025-08-05 00:00:00','2025-08-04 00:00:00',NULL,'ทดสอบที่อยู่่','1175','approved',NULL,NULL,'pending','2025-07-30 10:34:49','2025-08-04 14:46:13'),(59,76,'2025/0006','Requester',NULL,NULL,NULL,'2025-07-30 11:10:13',NULL,NULL,NULL,NULL,'1175','pending',NULL,NULL,'pending','2025-07-30 11:10:13','2025-07-30 11:10:13'),(60,76,'2025/0007','Requester',NULL,NULL,NULL,'2025-07-30 11:11:13',NULL,NULL,NULL,NULL,'1526','pending',NULL,NULL,'pending','2025-07-30 11:11:13','2025-07-30 11:11:13'),(61,78,'2025/0008','Authorize',NULL,NULL,NULL,'2025-07-30 13:23:18',NULL,NULL,NULL,NULL,'1395','approved',NULL,NULL,'pending','2025-07-30 13:23:18','2025-07-30 13:28:35'),(62,1,'2025/0009','admin',NULL,NULL,NULL,'2025-07-30 14:49:04',NULL,NULL,NULL,NULL,'228','pending',NULL,NULL,'pending','2025-07-30 14:49:04','2025-07-30 14:49:04'),(63,1,'2025/0010','admin',NULL,NULL,NULL,'2025-07-30 14:54:51',NULL,NULL,NULL,NULL,'497','approved','approved',NULL,'pending','2025-07-30 14:54:51','2025-08-04 14:47:46'),(64,1,'2025/0011','admin',NULL,NULL,NULL,'2025-07-30 15:45:49',NULL,NULL,NULL,NULL,'359','pending',NULL,NULL,'pending','2025-07-30 15:45:49','2025-07-30 15:45:49'),(65,1,'2025/0012','admin',NULL,NULL,NULL,'2025-07-30 15:49:35',NULL,NULL,NULL,NULL,'359','approved',NULL,NULL,'pending','2025-07-30 15:49:35','2025-07-30 16:18:29'),(66,76,'2025/0013','Requester','1','nalinee.phumpra@gmail.com','ทดสอบวัตถุประสงค์การเบิก','2025-07-30 00:00:00','2025-08-01 00:00:00','2025-08-01 00:00:00',NULL,'ศูนย์ใหเคำปรึกษา','228','pending',NULL,NULL,'pending','2025-07-30 15:59:54','2025-07-30 16:01:00'),(67,76,'2025/0014','Requester','1','nalinee.phumpra@gmail.com','ทดสอบวัตถุประสงค์การเบิก','2025-07-30 00:00:00',NULL,NULL,'2025-07-30 16:10:24','ศูนย์ให้คำปรึกษา','1266','approved','approved','approved','delivered','2025-07-30 16:03:15','2025-07-30 16:10:24'),(68,1,'2025/0015','admin',NULL,NULL,NULL,'2025-07-31 13:33:32',NULL,NULL,NULL,NULL,'228','pending',NULL,NULL,'pending','2025-07-31 13:33:32','2025-07-31 13:33:32'),(69,76,'2025/0016','ทดสอบชื่อนามสกุล','17','nalinee.phumpra@gmail.com','ทดสอบวัตถุประสงค์การเบิก','2025-08-04 00:00:00',NULL,NULL,NULL,'ชั้น 1','129','pending',NULL,NULL,'pending','2025-08-04 10:59:16','2025-08-04 10:59:42'),(70,76,'2025/0017','Requester',NULL,NULL,NULL,'2025-08-04 11:01:55',NULL,NULL,NULL,NULL,'696','pending',NULL,NULL,'pending','2025-08-04 11:01:55','2025-08-04 11:01:55'),(71,76,'2025/0018','Requester',NULL,NULL,NULL,'2025-08-04 11:04:03',NULL,NULL,NULL,NULL,'387','pending',NULL,NULL,'pending','2025-08-04 11:04:03','2025-08-04 11:04:03'),(72,76,'2025/0019','Requester',NULL,NULL,NULL,'2025-08-04 11:05:21',NULL,NULL,NULL,NULL,'667','pending',NULL,NULL,'pending','2025-08-04 11:05:21','2025-08-04 11:05:21'),(73,76,'2025/0020','Requester','10','nalinee.phumpra@gmail.com','ทดสอบวัตถุประสงค์การเบิก','2025-08-04 00:00:00','2025-08-07 00:00:00','2025-08-06 00:00:00',NULL,'รังสิตตึก SIIT ชั้น 4','618','approved',NULL,NULL,'pending','2025-08-04 13:17:05','2025-08-04 14:53:22'),(74,77,'2025/0021','Supervisor',NULL,NULL,NULL,'2025-08-04 14:42:28',NULL,NULL,NULL,NULL,'857','approved',NULL,NULL,'pending','2025-08-04 14:42:28','2025-08-04 14:43:17'),(75,1,'2025/0022','admin',NULL,NULL,NULL,'2025-08-04 14:59:59',NULL,NULL,NULL,NULL,'129','pending',NULL,NULL,'pending','2025-08-04 14:59:59','2025-08-04 14:59:59');

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (7,'Nullper','web','2024-11-06 16:00:30','2024-11-06 16:00:30');

--
-- Table structure for table `product_type`
--

CREATE TABLE `product_type` (
  `product_type_id` int NOT NULL AUTO_INCREMENT,
  `product_type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`product_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `product_type`
--

INSERT INTO `product_type` VALUES (1,'Accessories','2025-06-13 10:45:44','2025-06-13 10:45:44'),(2,'Books & Stationery','2025-06-13 10:51:15','2025-06-13 10:51:15'),(3,'Collectibles','2025-06-13 10:52:50','2025-06-13 10:52:50'),(4,'Electronics','2025-06-13 10:53:09','2025-06-13 10:53:09'),(5,'Gift Sets','2025-06-13 10:53:19','2025-06-13 10:53:19'),(6,'Limited Edition Items','2025-06-13 10:53:44','2025-06-13 10:53:44'),(7,'Premium Souvenirs','2025-06-17 11:02:33','2025-06-17 11:02:33'),(8,'Office Supplies','2025-07-07 10:02:34','2025-07-07 10:02:34'),(9,'Portable Accessories','2025-07-07 10:03:01','2025-07-07 10:03:01'),(10,'Travel Accessories','2025-07-07 10:13:29','2025-07-07 10:13:29'),(11,'Electronics Accessories','2025-07-07 10:14:15','2025-07-07 10:14:15');

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `product_id` int NOT NULL AUTO_INCREMENT,
  `product_code` varchar(255) DEFAULT NULL,
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `product_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `product_price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `product_quantity` int DEFAULT NULL,
  `product_type` varchar(255) DEFAULT NULL,
  `product_stock` int DEFAULT NULL,
  `product_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `product_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES (1,'0001','ขวดน้ำ','ขวดน้ำ 3 สี','359',7,'7',NULL,'1','1749723562_ขวดน้ำ.jpg','2025-06-12 15:57:47','2025-07-31 15:41:13'),(3,'2','Fan',NULL,'500',4,'4',NULL,'1','1749723657_พัดลม.jpg','2025-06-12 16:48:45','2025-08-04 10:13:53'),(4,'3','Post-It',NULL,'39',5,'2',NULL,'1','1752483885_โพสอิท.jpg','2025-07-14 16:04:45','2025-07-14 16:04:45'),(5,'4','Pluck',NULL,'299',2,'11',NULL,'1','1752483937_ไอปลั๊ก.jpg','2025-07-14 16:05:37','2025-07-14 16:05:37'),(6,'6','Fabric bag',NULL,'199',3,'10',NULL,'1','1752483993_กระเป๋าผ้า.jpg','2025-07-14 16:06:33','2025-07-14 16:06:33'),(7,'7','Charging cable',NULL,'149',14,'11',NULL,'1','1752484041_กล่องเคเบิ้ล.jpg','2025-07-14 16:07:21','2025-07-14 16:07:21'),(8,'8','Business card box',NULL,'99',2,'8',NULL,'1','1752484092_กล่องใส่นามบัตร.jpg','2025-07-14 16:08:12','2025-07-14 16:08:12'),(9,'9','Craftsman key chain',NULL,'129',0,'8',NULL,'1','1752484324_พวงกุญแจช่าง.jpg','2025-07-14 16:12:04','2025-07-14 16:12:04'),(10,'10','Passport Case',NULL,'269',25,'7',NULL,'1','1752484357_พาส2.jpg','2025-07-14 16:12:37','2025-07-16 10:32:06'),(11,'0002','ทดสอบ','สีดำ','250',4,'7',NULL,'1','1753951247_user-icon-person-icon-client-symbol-login-head-sign-icon-design-vector-Photoroom (1).png','2025-07-31 15:40:47','2025-07-31 15:40:47');

--
-- Table structure for table `return_orders`
--

CREATE TABLE `return_orders` (
  `return_orders_id` int NOT NULL AUTO_INCREMENT,
  `return_orders_item_id` int DEFAULT NULL,
  `return_orders_quantity` int DEFAULT NULL,
  `return_orders_reason` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`return_orders_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `return_orders`
--


--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` int unsigned NOT NULL,
  `role_id` int unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (7,1),(7,2),(7,3),(7,20),(7,21);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Admin','web','2019-11-27 03:25:57','2019-11-27 03:25:57'),(2,'Requester','web','2023-06-08 00:00:00','2023-06-08 00:00:00'),(3,'Supervisor','web','2025-02-27 15:26:10','2025-02-27 15:26:10'),(20,'Authorize','web','2025-06-11 16:43:51','2025-06-11 16:43:51'),(21,'AdminConsult','web','2025-07-08 14:47:12','2025-07-08 14:47:12');

--
-- Table structure for table `school_division`
--

CREATE TABLE `school_division` (
  `school_division_id` int NOT NULL AUTO_INCREMENT,
  `school_division_name_en` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `school_division_name_th` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `school_division_shortname` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `school_division_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`school_division_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `school_division`
--

INSERT INTO `school_division` VALUES (1,'SIIT Consulting Center','ศูนย์ให้คำปรึกษา','Consulting','Center','2022-05-10 11:07:55','2022-05-24 11:27:32'),(2,'Accounting Division','ฝ่ายบัญชี','ACC','Division','2022-05-10 11:20:20','2022-05-24 11:38:03'),(3,'Admission and Public Relations Division','ฝ่ายรับเข้าศึกษาและประชาสัมพันธ์','AD&PR','Division','2022-05-10 11:20:28','2024-08-29 11:34:37'),(4,'Academic Services and Registration Division','ฝ่ายบริการวิชาการและทะเบียน','AS&R','Division','2022-05-10 11:20:38','2022-06-07 10:54:46'),(5,'School of Bio-Chemical Engineering and Technology','ภาควิชาวิศวกรรมและเทคโนโลยีเคมีชีวภาพ','BCET','School','2022-05-10 11:20:52','2022-05-24 11:15:30'),(6,'Building and Ground Division','ฝ่ายอาคารและสถานที่','BG','Division','2022-05-10 11:21:01','2022-05-24 11:31:41'),(7,'Central Coordinating Division','ฝ่ายประสานงานกลาง','CCO','Division','2022-05-10 11:21:10','2022-05-24 11:37:26'),(8,'School of Civil Engineering and Technology','ภาควิชาวิศวกรรมและเทคโนโลยีโยธา','CET','School','2022-05-10 11:21:17','2022-05-24 11:13:01'),(9,'School of Integrated Science and Innovation','ภาควิชาวิทยาศาสตร์บูรณาการและนวัตกรรม','ISI','School','2022-05-10 11:24:28','2023-02-15 09:11:25'),(10,'Computer and Audiovisual Center','ศูนย์คอมพิวเตอร์และโสตทัศนศึกษา','COM&AV','Division','2022-05-10 11:24:36','2022-05-24 11:30:52'),(11,'Construction and Maintenance Technology Research Center','ศูนย์วิจัยเทคโนโลยีการก่อสร้างและบำรุงรักษา','CONTEC','Center','2022-05-10 11:24:45','2022-05-24 11:28:33'),(12,'Functional Advanced Materials Engineering','ศูนย์วิจัยวิศวกรรมวัสดุสมบัติพิเศษขั้นสูง','FAME','School','2022-05-10 11:24:56','2022-05-24 11:39:51'),(13,'Finance and Budget Division','ฝ่ายการเงินและงบประมาณ','FIN','Division','2022-05-10 11:25:02','2022-05-24 11:38:56'),(14,'International Affairs and Corporate Relations Division','ฝ่ายวิเทศและองค์กรสัมพันธ์','IA&CR','Division','2022-05-10 11:25:10','2022-05-24 11:32:38'),(15,'School of Information, Computer, and Communication Technology','ภาควิชาเทคโนโลยีสารสนเทศ คอมพิวเตอร์ และการสื่อสาร','ICT','School','2022-05-10 11:25:17','2022-05-24 11:18:39'),(16,'Library and Information Services Center','ห้องสมุดและศูนย์บริการข้อมูล','LIB&ISC','Division','2022-05-10 11:25:23','2022-05-24 11:29:46'),(17,'School of Manufacturing Systems and Mechanical Engineering','ภาควิชาวิศวกรรมเครื่องกลและระบบการผลิต','MSME','School','2022-05-10 11:25:32','2022-05-24 11:17:11'),(18,'School of Management Technology','ภาควิชาเทคโนโลยีการจัดการ','MT','School','2022-05-10 11:25:45','2022-05-24 11:26:41'),(19,'Office of the Director','สำนักผู้อำนวยการ','OD','Division','2022-05-10 11:25:53','2022-05-24 11:30:08'),(20,'Property Management Division','ฝ่ายจัดการทรัพย์สิน','PM','Division','2022-05-10 11:26:00','2022-05-24 11:31:19'),(21,'Research and Academic Quality Assurance Division','ฝ่ายวิจัยและประกันคุณภาพการศึกษา','R&QA','Division','2022-05-10 11:26:10','2022-05-24 11:29:29'),(22,'Student Affairs and Alumni Relations Division','ฝ่ายกิจการนักศึกษาและศิษย์เก่าสัมพันธ์','SA&AR','Division','2022-05-10 11:26:54','2022-05-24 11:38:39'),(23,'SIIT Academy','SIIT Academy','SIIT Academy','Center','2022-05-10 11:27:04','2022-05-24 11:28:07'),(24,'Supplies and Procurement Division','ฝ่ายพัสดุและจัดซื้อ','SP','Division','2022-05-10 11:27:15','2022-05-24 11:36:57'),(25,'Ground and Properties (Rangsit)','-','G&P-RS','Division','2024-08-29 00:00:00','2024-08-29 00:00:00'),(26,'Ground and Properties (Bangkadi)','-','G&P-BKD','Division','2024-08-29 00:00:00','2024-08-29 00:00:00'),(27,'Department of Common and Graduate Studies','-','CGS','School','2024-08-29 00:00:00','2024-08-29 00:00:00'),(28,'Academic Services Division (Bangkadi)','-','AS-BKD','Division','2024-08-29 00:00:00','2024-08-29 00:00:00'),(29,'Academic Services Division (Rangsit)','-','AS-RS','Division','2024-08-29 00:00:00','2024-08-29 00:00:00');

--
-- Table structure for table `sendemail`
--

CREATE TABLE `sendemail` (
  `sendemail_id` int NOT NULL AUTO_INCREMENT,
  `sendemail_userid` int NOT NULL,
  `sendemail_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `sendemail_type` varchar(255) NOT NULL,
  `sendemail_key` varchar(255) NOT NULL,
  `sendemail_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`sendemail_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sendemail`
--


--
-- Table structure for table `souvenir_logs`
--

CREATE TABLE `souvenir_logs` (
  `souvenir_log_id` int NOT NULL AUTO_INCREMENT,
  `souvenir_id` int DEFAULT NULL,
  `action_type` varchar(255) DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `note` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`souvenir_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `souvenir_logs`
--


--
-- Table structure for table `souvenir_request_items`
--

CREATE TABLE `souvenir_request_items` (
  `souvenir_request_items_id` int NOT NULL AUTO_INCREMENT,
  `request_id` int DEFAULT NULL,
  `souvenir_id` int DEFAULT NULL,
  `quantity` int DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`souvenir_request_items_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `souvenir_request_items`
--


--
-- Table structure for table `souvenir_requests`
--

CREATE TABLE `souvenir_requests` (
  `request_id` int NOT NULL AUTO_INCREMENT,
  `request_code` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `request_date` date DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `note` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `souvenir_requests`
--



