-- phpMyAdmin SQL Dump
-- version 5.1.1deb5ubuntu1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jul 17, 2024 at 07:01 AM
-- Server version: 8.0.37-0ubuntu0.22.04.3
-- PHP Version: 8.2.17

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


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

--
-- Database: `consult`
--

-- --------------------------------------------------------

--
-- Table structure for table `report_activity`
--

CREATE TABLE `report_activity` (
  `activity_id` int NOT NULL,
  `activity_code` varchar(255) DEFAULT NULL,
  `activity_code_number` varchar(255) DEFAULT NULL,
  `activity_academic_year` int DEFAULT NULL,
  `activity_name_en` varchar(255) DEFAULT NULL,
  `activity_name_th` varchar(255) DEFAULT NULL,
  `activity_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `activity_type1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `activity_type_code` int DEFAULT NULL,
  `activity_organized` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `activity_date_begin` date DEFAULT NULL,
  `activity_date_end` date DEFAULT NULL,
  `activity_time` time DEFAULT NULL,
  `activity_place` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `activity_detail_en` varchar(255) DEFAULT NULL,
  `activity_detail_th` varchar(255) DEFAULT NULL,
  `activity_participants` int DEFAULT NULL,
  `activity_status` int DEFAULT NULL,
  `activity_open_close` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `report_activity`
--

INSERT INTO `report_activity` (`activity_id`, `activity_code`, `activity_code_number`, `activity_academic_year`, `activity_name_en`, `activity_name_th`, `activity_name`, `activity_type1`, `activity_type_code`, `activity_organized`, `activity_date_begin`, `activity_date_end`, `activity_time`, `activity_place`, `activity_detail_en`, `activity_detail_th`, `activity_participants`, `activity_status`, `activity_open_close`, `created_at`, `updated_at`) VALUES
(14, 'AP4522002', NULL, 1, 'SIIT Football cup 2022', 'SIIT ฟุตบอลคัพ 2565', NULL, '1', NULL, '1', '2022-09-08', '2022-09-10', '21:06:00', 'TU Football', 'Football competition between SIIT student, year 2022', 'การแข่งขันฟุตบอลระหว่างนักศึกษา SIIT ประจำปี 2565', NULL, 2, 'close', '2024-06-20 12:06:47', '2024-06-20 12:06:47'),
(15, 'AP4523001', NULL, 2, 'SIIT Leadership camp2022', 'SIIT Leadership camp2022', NULL, '2', NULL, '1', '2024-06-01', '2024-06-08', '13:17:00', 'TU Football', 'Student Committee', NULL, NULL, 1, 'open', '2024-06-20 13:17:33', '2024-06-20 13:17:33'),
(17, 'AP4524002', NULL, 3, 'Test', 'ทดสอบ', NULL, '3', NULL, '3', '2024-05-26', '2024-06-01', '15:45:00', 'TU Football', 'en', 'th', NULL, 1, NULL, '2024-06-20 15:45:33', '2024-06-20 15:45:33'),
(22, 'AP4524004', NULL, 3, NULL, 'asfasf', NULL, '3', NULL, '1', '2024-06-12', '2024-08-30', '15:39:00', 'ffff', 'en', 'th', NULL, 1, NULL, '2024-07-08 15:39:34', '2024-07-08 15:39:34'),
(23, 'AP4523002', NULL, 2, 'Test', 'ทดสอบ', NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 'close', '2024-07-11 11:05:41', '2024-07-11 11:05:41'),
(25, 'AP4524010', NULL, 3, 'Tamiya', 'ทามิยา', NULL, '1', NULL, '2', '2022-08-09', '2024-08-09', '11:00:00', 'Fortune Town', 'rama 9', 'พระราม 9', NULL, 1, NULL, '2024-07-17 11:27:24', '2024-07-17 11:27:24'),
(27, 'AP4525001', NULL, 7, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2024-07-17 13:42:41', '2024-07-17 13:42:41');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `report_activity`
--
ALTER TABLE `report_activity`
  ADD PRIMARY KEY (`activity_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `report_activity`
--
ALTER TABLE `report_activity`
  MODIFY `activity_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
COMMIT;

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