-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 23, 2020 at 01:57 PM
-- Server version: 10.4.13-MariaDB
-- PHP Version: 7.2.31

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: `internship`
--

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

--
-- Table structure for table `confirm_regis`
--

CREATE TABLE `confirm_regis` (
  `ID_stu` varchar(13) COLLATE utf8_unicode_ci NOT NULL,
  `cf_teacher_name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `datetime_tc` datetime NOT NULL,
  `comment_tc` varchar(80) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cf_dep_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `datetime_dep` datetime DEFAULT NULL,
  `comment_dep` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `confirm_regis`
--

INSERT INTO `confirm_regis` (`ID_stu`, `cf_teacher_name`, `datetime_tc`, `comment_tc`, `cf_dep_name`, `datetime_dep`, `comment_dep`) VALUES
('6203052412041', 'วสันต์ คล้ายทอง', '2020-11-23 18:57:40', 'แก้ไขด้วย', 'เกวลิน แววข้าว', '2020-11-23 19:49:35', 'แก้ไขข');

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

--
-- Table structure for table `register_attach`
--

CREATE TABLE `register_attach` (
  `id` int(11) NOT NULL,
  `ID_stu` varchar(13) COLLATE utf8_unicode_ci NOT NULL,
  `acot` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `acp_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `acs_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `other` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sig_n` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `sig_d` datetime NOT NULL,
  `status_regis` varchar(2) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `register_attach`
--

INSERT INTO `register_attach` (`id`, `ID_stu`, `acot`, `acp_id`, `acs_id`, `other`, `sig_n`, `sig_d`, `status_regis`) VALUES
(14, '6203052412041', 'a', 'a', 'a', 'จีน', 'ณัฐวิช', '2020-11-23 18:09:58', '98');

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

--
-- Table structure for table `register_edu_back`
--

CREATE TABLE `register_edu_back` (
  `id` int(11) NOT NULL,
  `ID_stu` varchar(13) COLLATE utf8_unicode_ci NOT NULL,
  `bac_u` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `bac_y` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `bac_cer` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `bac_mj` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `bac_gpa` float NOT NULL,
  `hv_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `hv_year` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `hv_cer` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `hv_mj` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `hv_gpa` float NOT NULL,
  `hs_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `hs_year` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
  `hs_cer` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `hs_mj` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `hs_gpa` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `register_edu_back`
--

INSERT INTO `register_edu_back` (`id`, `ID_stu`, `bac_u`, `bac_y`, `bac_cer`, `bac_mj`, `bac_gpa`, `hv_name`, `hv_year`, `hv_cer`, `hv_mj`, `hv_gpa`, `hs_name`, `hs_year`, `hs_cer`, `hs_mj`, `hs_gpa`) VALUES
(17, '6203052412041', 'asdasd', 'asdsadsa', 'asdsad', 'asdsad', 4, 'asd', '2222', 'asdasd', 'asdsa', 4, 'asd', '11111', 'asdsad', 'asdasdsad', 4);

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

--
-- Table structure for table `register_fam_det`
--

CREATE TABLE `register_fam_det` (
  `id` int(11) NOT NULL,
  `ID_stu` varchar(13) COLLATE utf8_unicode_ci NOT NULL,
  `father_fname` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `fat_age` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `fat_oc` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `fat_add` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `fat_tel` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `mother_fname` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `mot_age` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `mot_oc` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `mot_add` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `mot_tel` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `ec_fn` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `ec_age` int(11) NOT NULL,
  `ec_about` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `ec_oc` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `ec_pow` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `ec_add` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `ec_tel` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `ec_m` varchar(10) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `register_fam_det`
--

INSERT INTO `register_fam_det` (`id`, `ID_stu`, `father_fname`, `fat_age`, `fat_oc`, `fat_add`, `fat_tel`, `mother_fname`, `mot_age`, `mot_oc`, `mot_add`, `mot_tel`, `ec_fn`, `ec_age`, `ec_about`, `ec_oc`, `ec_pow`, `ec_add`, `ec_tel`, `ec_m`) VALUES
(14, '6203052412041', 'สมชาย โคตรชาย', '45', 'รับจ้าง', 'แพร่', '0454545', 'สมหญิง โคตรหญิง', '44', 'รับจ้าง', 'แพร่', '0124545458', 'สมชาย มาสาย', 32, 'น้า', 'รับจ้าง', 'กทม', 'กทม', '0111', '0124568879');

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

--
-- Table structure for table `register_job_his`
--

CREATE TABLE `register_job_his` (
  `id` int(11) NOT NULL,
  `ID_stu` varchar(13) COLLATE utf8_unicode_ci NOT NULL,
  `j_Course_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `j_Institute` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `j_Certi` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `j_Period` varchar(50) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `register_job_his`
--

INSERT INTO `register_job_his` (`id`, `ID_stu`, `j_Course_name`, `j_Institute`, `j_Certi`, `j_Period`) VALUES
(17, '6203052412041', 'sad', 'asd', 'asd', '2');

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

--
-- Table structure for table `register_sp_abil`
--

CREATE TABLE `register_sp_abil` (
  `id` int(11) NOT NULL,
  `ID_stu` varchar(13) COLLATE utf8_unicode_ci NOT NULL,
  `com_1` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skill_com_1` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `com_2` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skill_com_2` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `com_3` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skill_com_3` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `com_4` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skill_com_4` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skill_lth` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skill_leng` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `skill_other` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `register_sp_abil`
--

INSERT INTO `register_sp_abil` (`id`, `ID_stu`, `com_1`, `skill_com_1`, `com_2`, `skill_com_2`, `com_3`, `skill_com_3`, `com_4`, `skill_com_4`, `skill_lth`, `skill_leng`, `skill_other`) VALUES
(14, '6203052412041', 'c', 'ดีมาก', 'c#', 'ดีมาก', 'php', 'ดีมาก', 'linux', 'ดีมาก', 'ดีมาก', 'ดีมาก', 'ดีมาก');

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

--
-- Table structure for table `register_sp_data`
--

CREATE TABLE `register_sp_data` (
  `ID_stud` varchar(13) COLLATE utf8_unicode_ci NOT NULL,
  `th_fname` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `en_fname` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `th_lname` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `en_lname` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `dep` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `branch` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `fac` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `program` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `yic` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `teacher_ec` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `gpa` float DEFAULT NULL,
  `gpax` float DEFAULT NULL,
  `b_date` date DEFAULT NULL,
  `age` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `tp_start` date DEFAULT NULL,
  `tp_end` date DEFAULT NULL,
  `re_add` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `tel_no` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `se_add` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `tel_se` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `tel_m` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `militaly_status` varchar(20) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `register_sp_data`
--

INSERT INTO `register_sp_data` (`ID_stud`, `th_fname`, `en_fname`, `th_lname`, `en_lname`, `dep`, `branch`, `fac`, `program`, `yic`, `teacher_ec`, `gpa`, `gpax`, `b_date`, `age`, `tp_start`, `tp_end`, `re_add`, `tel_no`, `se_add`, `tel_se`, `tel_m`, `email`, `militaly_status`) VALUES
('6203052412041', 'ณัฐวิช', 'natthawit', 'โมลาดุก', 'moladuk', 'วิศวกรรมอิเล็คทรอนิค', 'อิเล็คคอ', 'วทอ', 'ECT', '2', 'DCK', 2.4, 2.7, '1998-06-07', '22', '2020-11-24', '2020-11-29', 'แพร่', '05405646', 'กทม', '0928600791', '0928600791', 'foy3000@hotmail.co.th', 'ได้รับการยกเว้น');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `confirm_regis`
--
ALTER TABLE `confirm_regis`
  ADD PRIMARY KEY (`ID_stu`);

--
-- Indexes for table `register_attach`
--
ALTER TABLE `register_attach`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ID_stu` (`ID_stu`);

--
-- Indexes for table `register_edu_back`
--
ALTER TABLE `register_edu_back`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ID_stu` (`ID_stu`);

--
-- Indexes for table `register_fam_det`
--
ALTER TABLE `register_fam_det`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ID_stu` (`ID_stu`);

--
-- Indexes for table `register_job_his`
--
ALTER TABLE `register_job_his`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ID_stu` (`ID_stu`);

--
-- Indexes for table `register_sp_abil`
--
ALTER TABLE `register_sp_abil`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ID_stu` (`ID_stu`);

--
-- Indexes for table `register_sp_data`
--
ALTER TABLE `register_sp_data`
  ADD PRIMARY KEY (`ID_stud`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `register_attach`
--
ALTER TABLE `register_attach`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `register_edu_back`
--
ALTER TABLE `register_edu_back`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `register_fam_det`
--
ALTER TABLE `register_fam_det`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `register_job_his`
--
ALTER TABLE `register_job_his`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `register_sp_abil`
--
ALTER TABLE `register_sp_abil`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `register_attach`
--
ALTER TABLE `register_attach`
  ADD CONSTRAINT `register_attach_ibfk_1` FOREIGN KEY (`ID_stu`) REFERENCES `register_sp_data` (`ID_stud`);

--
-- Constraints for table `register_edu_back`
--
ALTER TABLE `register_edu_back`
  ADD CONSTRAINT `register_edu_back_ibfk_1` FOREIGN KEY (`ID_stu`) REFERENCES `register_sp_data` (`ID_stud`);

--
-- Constraints for table `register_fam_det`
--
ALTER TABLE `register_fam_det`
  ADD CONSTRAINT `register_fam_det_ibfk_1` FOREIGN KEY (`ID_stu`) REFERENCES `register_sp_data` (`ID_stud`);

--
-- Constraints for table `register_job_his`
--
ALTER TABLE `register_job_his`
  ADD CONSTRAINT `register_job_his_ibfk_1` FOREIGN KEY (`ID_stu`) REFERENCES `register_sp_data` (`ID_stud`);

--
-- Constraints for table `register_sp_abil`
--
ALTER TABLE `register_sp_abil`
  ADD CONSTRAINT `register_sp_abil_ibfk_1` FOREIGN KEY (`ID_stu`) REFERENCES `register_sp_data` (`ID_stud`);
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 */;
