-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jun 20, 2025 at 03:00 PM
-- Server version: 5.7.17-log
-- PHP Version: 5.6.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `project_service50per`
--
CREATE DATABASE IF NOT EXISTS `project_service50per` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `project_service50per`;

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

--
-- Table structure for table `tbl_building`
--

CREATE TABLE IF NOT EXISTS `tbl_building` (
  `bid` int(11) NOT NULL AUTO_INCREMENT,
  `bname` varchar(100) NOT NULL,
  PRIMARY KEY (`bid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_building`
--

INSERT INTO `tbl_building` (`bid`, `bname`) VALUES
(1, 'อาคาร 1'),
(2, 'อาคาร 2');

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

--
-- Table structure for table `tbl_case`
--

CREATE TABLE IF NOT EXISTS `tbl_case` (
  `c_id` int(11) NOT NULL AUTO_INCREMENT,
  `ref_m_id` int(11) NOT NULL COMMENT 'tbl_member',
  `ref_p_id` int(11) NOT NULL COMMENT 'tbl_position',
  `ref_d_id` int(11) NOT NULL COMMENT 'tbl_department',
  `ref_de_id` int(11) NOT NULL COMMENT 'tbl_device',
  `ref_s_id` int(11) NOT NULL DEFAULT '1' COMMENT 'tbl_status',
  `ref_bid` int(11) NOT NULL COMMENT 'รหัสตึก',
  `b_floor` varchar(10) NOT NULL COMMENT 'ชั้น',
  `b_room` varchar(10) NOT NULL COMMENT 'ห้อง',
  `c_detail` text NOT NULL,
  `c_img` varchar(100) NOT NULL,
  `c_datesave` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`c_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tbl_department`
--

CREATE TABLE IF NOT EXISTS `tbl_department` (
  `d_id` int(11) NOT NULL AUTO_INCREMENT,
  `d_name` varchar(100) NOT NULL,
  PRIMARY KEY (`d_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_department`
--

INSERT INTO `tbl_department` (`d_id`, `d_name`) VALUES
(1, 'บัญชี'),
(2, 'การตลาด'),
(3, 'การจัดการทั่วไป'),
(4, 'การเงิน'),
(5, 'IT');

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

--
-- Table structure for table `tbl_device`
--

CREATE TABLE IF NOT EXISTS `tbl_device` (
  `de_id` int(11) NOT NULL AUTO_INCREMENT,
  `de_name` varchar(100) NOT NULL,
  PRIMARY KEY (`de_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_device`
--

INSERT INTO `tbl_device` (`de_id`, `de_name`) VALUES
(1, 'pc'),
(2, 'notebook'),
(3, 'projector'),
(4, 'Keyboard'),
(5, 'Mouse');

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

--
-- Table structure for table `tbl_member`
--

CREATE TABLE IF NOT EXISTS `tbl_member` (
  `m_id` int(11) NOT NULL AUTO_INCREMENT,
  `ref_d_id` int(11) NOT NULL COMMENT 'tbl_department',
  `ref_p_id` int(11) NOT NULL COMMENT 'tbl_position',
  `m_username` varchar(50) NOT NULL,
  `m_password` varchar(50) NOT NULL,
  `m_fname` varchar(50) NOT NULL,
  `m_name` varchar(100) NOT NULL,
  `m_lname` varchar(100) NOT NULL,
  `m_phone` varchar(20) NOT NULL,
  `m_email` varchar(50) NOT NULL,
  `m_level` varchar(20) NOT NULL,
  `m_img` varchar(100) NOT NULL,
  `m_datesave` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`m_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_member`
--

INSERT INTO `tbl_member` (`m_id`, `ref_d_id`, `ref_p_id`, `m_username`, `m_password`, `m_fname`, `m_name`, `m_lname`, `m_phone`, `m_email`, `m_level`, `m_img`, `m_datesave`) VALUES
(1, 1, 1, 'admin', 'admin', 'นาย', 'admin', 'นะเทอ', '09999999', '[email protected]', 'admin', '180952619120190228_141331.png', '2019-02-17 08:41:29'),
(2, 4, 2, 'member', 'member', 'นาย', 'พนง.', 'นะครับ', '09999999', '[email protected]', 'member', '105468984220190222_151507.png', '2019-02-17 08:42:59'),
(3, 2, 1, 'boss', 'boss', 'นาย', 'หัวหน้า', 'จ้า', '09999999', '[email protected]', 'manager', '213488081520190228_141814.png', '2019-02-17 08:43:58'),
(4, 5, 5, 'tech', 'tech', 'นาย', 'ช่าง', 'ครับ', '09999999', '[email protected]', 'technician', '98545466220190228_142345.png', '2019-02-28 07:23:45');

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

--
-- Table structure for table `tbl_position`
--

CREATE TABLE IF NOT EXISTS `tbl_position` (
  `p_id` int(11) NOT NULL AUTO_INCREMENT,
  `p_name` varchar(100) NOT NULL,
  PRIMARY KEY (`p_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_position`
--

INSERT INTO `tbl_position` (`p_id`, `p_name`) VALUES
(1, 'ผู้จัดการ'),
(2, 'พนักงานบัญชี'),
(3, 'พนักงานการตลาด'),
(4, 'พนักงานประชาสัมพันธ์'),
(5, 'ช่างคอมพิวเตอร์');

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

--
-- Table structure for table `tbl_status`
--

CREATE TABLE IF NOT EXISTS `tbl_status` (
  `s_id` int(11) NOT NULL AUTO_INCREMENT,
  `s_name` varchar(100) NOT NULL,
  PRIMARY KEY (`s_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tbl_status`
--

INSERT INTO `tbl_status` (`s_id`, `s_name`) VALUES
(1, 'รอดำเนินการ'),
(2, 'กำลังซ่อม'),
(3, 'ซ่อมเสร็จ/<br>รอประเมิน'),
(4, 'ปิดงาน'),
(5, 'ยกเลิก');

/*!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 */;