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


--
-- Table structure for table `user_meta`
--

CREATE TABLE `user_meta` (
  `user_id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_userid` int NOT NULL,
  `user_title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `user_username` varchar(255) DEFAULT NULL,
  `user_fullname` varchar(255) NOT NULL,
  `user_firstname` varchar(255) NOT NULL,
  `user_lastname` varchar(255) NOT NULL,
  `user_position` varchar(255) DEFAULT NULL,
  `user_division_id` int DEFAULT NULL,
  `user_email` varchar(255) NOT NULL,
  `user_phone` varchar(50) DEFAULT NULL,
  `user_address` text,
  `user_picture` varchar(255) DEFAULT NULL,
  `user_status` varchar(255) DEFAULT NULL,
  `user_role` varchar(255) NOT NULL,
  `user_pass_update` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `user_meta`
--

INSERT INTO `user_meta` VALUES (1,1,NULL,NULL,'Consult Admin','Consult','Admin',NULL,1,'consulting@siit.tu.ac.th',NULL,NULL,NULL,NULL,'AdminConsult',NULL,'2023-07-21 11:05:32','2025-07-18 16:20:20'),(59,75,NULL,'Nongtest','นลินี พุ่มประจำ','นลินี','พุ่มประจำ',NULL,1,'nalinee@siit.tu.ac.th',NULL,NULL,NULL,NULL,'Admin',NULL,'2025-07-18 16:27:10','2025-07-18 16:27:10'),(60,76,NULL,'Requester','ทดสอบ ทดสอบ','ทดสอบ','ทดสอบ',NULL,1,'nalinee.phumpra@gmail.com',NULL,NULL,NULL,NULL,'Requester','2025-07-23','2025-07-18 16:28:24','2025-07-18 16:28:24'),(61,77,NULL,'Supervisor','ทดสอบ ทดสอบ','ทดสอบ','ทดสอบ',NULL,1,'nalinee.phumprajam@gmail.com',NULL,NULL,NULL,NULL,'Supervisor',NULL,'2025-07-18 16:29:56','2025-07-18 16:29:56'),(62,78,NULL,'Authorize','ทดสอบ ทดสอบ','ทดสอบ','ทดสอบ',NULL,1,'morefinn.nvm@gmail.com',NULL,NULL,NULL,NULL,'Authorize',NULL,'2025-07-18 16:30:55','2025-07-18 16:30:55'),(63,79,NULL,'Admin','ทดสอบ ทดสอบ','ทดสอบ','ทดสอบ',NULL,1,'kriettipoom@siit.tu.ac.th',NULL,NULL,NULL,NULL,'Admin',NULL,'2025-07-18 16:32:41','2025-07-18 16:34:59');


