Viewing file:  managedb.sql (87.42 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- http://www.phpmyadmin.net
--
-- โฮสต์: localhost
-- เวลาในการสร้าง: 08 เม.ย. 2008 10:12น.
-- รุ่นของเซิร์ฟเวอร์: 4.1.20
-- รุ่นของ PHP: 4.3.9
--
-- ฐานข้อมูล: `managedb`
--
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `Status`
--
CREATE TABLE `Status` (
`StatusId` int(2) NOT NULL default '0',
`StatusTh` varchar(20) NOT NULL default '',
`StatusEng` varchar(20) NOT NULL default '',
PRIMARY KEY (`StatusId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `accessories_tb`
--
CREATE TABLE `accessories_tb` (
`code` int(11) unsigned NOT NULL auto_increment,
`Acc_code` varchar(100) NOT NULL default '',
`Acc_name` varchar(255) NOT NULL default '',
`Acc_type_code` int(5) unsigned zerofill NOT NULL default '00000',
`Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
`Store` text NOT NULL,
`Img1` varchar(255) NOT NULL default '',
`Fix_History` text NOT NULL,
`Contact` text NOT NULL,
`Date_buy` date NOT NULL default '0000-00-00',
`Price` float(9,2) NOT NULL default '0.00',
`Fix_budget` float(9,2) NOT NULL default '0.00',
`Status` varchar(255) NOT NULL default '',
`Statistic` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=407 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `accessories_type_tb`
--
CREATE TABLE `accessories_type_tb` (
`Acc_type_code` int(5) unsigned zerofill NOT NULL auto_increment,
`Acc_type` varchar(255) NOT NULL default '',
`Acc_Etype` varchar(255) NOT NULL default '',
PRIMARY KEY (`Acc_type_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=18 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `account`
--
CREATE TABLE `account` (
`Teach_id` int(4) unsigned NOT NULL auto_increment,
`Teacher_code` int(5) unsigned zerofill NOT NULL default '00000',
`HN_code` varchar(10) NOT NULL default '0',
`No_code` int(7) NOT NULL default '0',
`Person_code` int(5) unsigned zerofill NOT NULL default '00000',
`Tooth_code` varchar(8) NOT NULL default '',
`Code` int(3) NOT NULL default '0',
`Date` date NOT NULL default '0000-00-00',
`Time_in` time NOT NULL default '00:00:00',
`Time_out` time NOT NULL default '00:00:00',
`Price` float(8,2) NOT NULL default '0.00',
`Teach_code` int(3) unsigned zerofill NOT NULL default '000',
`Dentis_code` int(2) unsigned NOT NULL default '0',
`Mount` varchar(5) NOT NULL default '',
`Cost_total` float(8,2) NOT NULL default '0.00',
`Roug` tinyint(1) unsigned NOT NULL default '0',
`Hostpital` int(1) unsigned zerofill NOT NULL default '0',
`Percen` int(2) unsigned NOT NULL default '0',
PRIMARY KEY (`Teach_id`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=42 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `accounts`
--
CREATE TABLE `accounts` (
`id` varchar(20) NOT NULL default '',
`Paydate` varchar(15) NOT NULL default '',
`code` varchar(10) NOT NULL default '',
`code_1` varchar(10) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`Mainjob` varchar(100) NOT NULL default '',
`TypeM` varchar(50) NOT NULL default '',
`GPyear` varchar(80) NOT NULL default '',
`year` varchar(50) NOT NULL default '',
`prince_1` varchar(50) NOT NULL default '',
`prince` varchar(20) NOT NULL default '',
`Budget` varchar(200) NOT NULL default '',
`BUDSUM` varchar(20) NOT NULL default '',
`Percent` varchar(10) NOT NULL default '',
`Discrition` varchar(200) NOT NULL default '',
`Sdate` varchar(20) NOT NULL default '',
`Fdate` varchar(20) NOT NULL default '',
`question` varchar(200) NOT NULL default '',
`Discrition_1` varchar(200) NOT NULL default '',
`Discrition_2` varchar(200) NOT NULL default '',
`Discrition_3` varchar(200) NOT NULL default '',
`Subject` varchar(200) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `advice_problem_tb`
--
CREATE TABLE `advice_problem_tb` (
`Prob_code` int(10) unsigned zerofill NOT NULL auto_increment,
`Problem` tinyint(1) NOT NULL default '0',
`Student_id` varchar(10) NOT NULL default '',
`Prob1` varchar(100) NOT NULL default '',
`Prob2` varchar(100) NOT NULL default '',
`Prob3` varchar(100) NOT NULL default '',
`Prob4` varchar(100) NOT NULL default '',
`Prob_detail1` text NOT NULL,
`Prob_detail2` text NOT NULL,
`Prob_detail3` text NOT NULL,
`Prob_detail4` text NOT NULL,
`Recom` text NOT NULL,
`Date_meet` date NOT NULL default '0000-00-00',
`Unit_meet` int(11) NOT NULL default '0',
PRIMARY KEY (`Prob_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `bookmant_tb`
--
CREATE TABLE `bookmant_tb` (
`code` int(6) unsigned zerofill NOT NULL auto_increment,
`Book_code` tinyint(1) unsigned NOT NULL default '0',
`Year` int(4) NOT NULL default '0',
`No` varchar(10) NOT NULL default '0',
`No_in` varchar(50) NOT NULL default '',
`No_out` varchar(50) NOT NULL default '',
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Faculty_code` tinyint(2) unsigned zerofill NOT NULL default '00',
`Store_1` varchar(200) NOT NULL default '',
`Store_2` varchar(200) NOT NULL default '',
`Img1` varchar(50) NOT NULL default '',
`Date_buy` date NOT NULL default '0000-00-00',
`Date_year` date NOT NULL default '0000-00-00',
`Status` text NOT NULL,
`Statistic` varchar(200) NOT NULL default '',
`Description` text NOT NULL,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=3861 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `building_tb`
--
CREATE TABLE `building_tb` (
`BuildD_No` int(5) NOT NULL auto_increment,
`BuildD_ID` varchar(10) NOT NULL default '',
`Build_name` varchar(100) NOT NULL default '',
`Build_type` varchar(100) NOT NULL default '',
`Img1` varchar(155) NOT NULL default '',
`Short_name` varchar(50) NOT NULL default '',
`Class_unit` int(11) NOT NULL default '0',
`Room_unit` int(11) NOT NULL default '0',
`BuildD_Yr` date NOT NULL default '0000-00-00',
`BuildD_Pr` varchar(20) NOT NULL default '',
`MoneyS_C` int(5) NOT NULL default '0',
`Description` text NOT NULL,
PRIMARY KEY (`BuildD_No`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=20 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `building_type_tb`
--
CREATE TABLE `building_type_tb` (
`code` tinyint(5) NOT NULL auto_increment,
`Type_name` varchar(100) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `college`
--
CREATE TABLE `college` (
`collegeCode` char(3) NOT NULL default '',
`collegeLogo` varchar(255) NOT NULL default '',
`collegeName` text NOT NULL,
`collegeNameEng` text NOT NULL,
`collegeAbbr` varchar(50) NOT NULL default '',
`collegeAbbrEng` varchar(50) NOT NULL default '',
`collegeAddress` text NOT NULL,
`collegePhone` text NOT NULL,
PRIMARY KEY (`collegeCode`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `comment_tb`
--
CREATE TABLE `comment_tb` (
`Info_code` int(5) unsigned zerofill NOT NULL auto_increment,
`Info_name` varchar(100) NOT NULL default '',
`Date` date NOT NULL default '0000-00-00',
`Info_detail` text NOT NULL,
`Organiz` varchar(100) NOT NULL default '',
`Supervisor` varchar(100) NOT NULL default '',
`Flag` char(2) NOT NULL default '',
PRIMARY KEY (`Info_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=3937 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `committee_tb`
--
CREATE TABLE `committee_tb` (
`code` int(11) NOT NULL auto_increment,
`Teacher_code` int(5) unsigned zerofill NOT NULL default '00000',
`Title` varchar(255) NOT NULL default '',
`Year_com` varchar(10) NOT NULL default '',
`Edu` varchar(100) NOT NULL default '',
`Edu_job` varchar(100) NOT NULL default '',
`Tsis` varchar(100) NOT NULL default '',
`Check_tool` varchar(150) NOT NULL default '00:00:00',
`Scp10` varchar(100) NOT NULL default '',
`Club_bcnlp` varchar(100) NOT NULL default '',
`North_network` varchar(100) NOT NULL default '0',
`Else_commit` varchar(100) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `course_tb`
--
CREATE TABLE `course_tb` (
`Course_code` tinyint(5) unsigned zerofill NOT NULL auto_increment,
`Course_id` varchar(5) NOT NULL default '',
`Course_name` varchar(255) NOT NULL default '',
`Course_nameE` varchar(255) NOT NULL default '',
`Degree_Thai` varchar(255) NOT NULL default '',
`Short_Thai` varchar(255) NOT NULL default '',
`Degree_Eng` varchar(255) NOT NULL default '',
`Short_Eng` varchar(255) NOT NULL default '',
`Course_type` varchar(50) NOT NULL default '',
`TotalUnit` varchar(30) NOT NULL default '',
`Term` varchar(30) NOT NULL default '',
`Spec` text NOT NULL,
`Affect_class` text NOT NULL,
`Course_desc` text NOT NULL,
PRIMARY KEY (`Course_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `cul_activity_tb`
--
CREATE TABLE `cul_activity_tb` (
`code` int(5) unsigned zerofill NOT NULL auto_increment,
`Activity_name` varchar(255) NOT NULL default '',
`Activity_type` varchar(255) NOT NULL default '',
`Perform` varchar(50) NOT NULL default '',
`Activity` varchar(255) NOT NULL default '',
`Period` varchar(255) NOT NULL default '0000-00-00',
`Fund` float(8,2) NOT NULL default '0.00',
`Source` text NOT NULL,
`Target` varchar(255) NOT NULL default '',
`Amount` varchar(255) NOT NULL default '',
`Supervisor` text NOT NULL,
`Duty` varchar(100) NOT NULL default '',
`Objective` text NOT NULL,
`Index_mature` text NOT NULL,
`Spec` text NOT NULL,
`Affect_class` text NOT NULL,
`Asses` text NOT NULL,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `degree_tb`
--
CREATE TABLE `degree_tb` (
`Degree_code` int(5) NOT NULL auto_increment,
`Degree_name` varchar(60) NOT NULL default '',
`Rate` bigint(20) NOT NULL default '0',
PRIMARY KEY (`Degree_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `degree_type_tb`
--
CREATE TABLE `degree_type_tb` (
`Type_Degree` tinyint(3) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
PRIMARY KEY (`Type_Degree`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `dentis_tb`
--
CREATE TABLE `dentis_tb` (
`Dentis_code` int(2) NOT NULL auto_increment,
`Person_code` tinyint(5) NOT NULL default '0',
`Class` varchar(100) NOT NULL default '',
`Orderlist` varchar(5) NOT NULL default '0',
`Dental_code` tinyint(6) NOT NULL default '0',
`First_name` varchar(30) NOT NULL default '',
`Name` varchar(100) NOT NULL default '',
`Lastname` varchar(100) NOT NULL default '',
`Sex` varchar(10) NOT NULL default '',
`DateBirth` date NOT NULL default '0000-00-00',
`Religion` varchar(30) NOT NULL default '',
`Address` text NOT NULL,
`Img1` varchar(255) NOT NULL default '',
`Name_eng` varchar(155) NOT NULL default '',
`Lastname_eng` varchar(155) NOT NULL default '',
`ProvinceId` int(2) unsigned NOT NULL default '0',
`Phone_1` varchar(10) NOT NULL default '',
`Phone_2` varchar(10) NOT NULL default '',
`Email` varchar(155) NOT NULL default '',
`Description_1` text NOT NULL,
`Description_2` text NOT NULL,
`Datetype` date NOT NULL default '0000-00-00',
`Panal_code` tinyint(5) NOT NULL default '0',
`Year_1` varchar(5) NOT NULL default '00000',
`Flag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`Dentis_code`,`Dental_code`),
UNIQUE KEY `code` (`Dentis_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=38 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `descriptionplan_tb`
--
CREATE TABLE `descriptionplan_tb` (
`Code` int(6) NOT NULL auto_increment,
`Code_id` varchar(10) NOT NULL default '',
`Description_1` text NOT NULL,
`Description_2` text NOT NULL,
`Description_3` text NOT NULL,
PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=54 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `diagnosis_tb`
--
CREATE TABLE `diagnosis_tb` (
`Code` int(6) NOT NULL auto_increment,
`Code_id` varchar(10) NOT NULL default '',
`Description_1` text NOT NULL,
`Description_2` text NOT NULL,
`Description_3` text NOT NULL,
PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=66 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `edu_product_tb`
--
CREATE TABLE `edu_product_tb` (
`Prod_code` int(10) unsigned zerofill NOT NULL auto_increment,
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Product_name` varchar(255) NOT NULL default '',
`Date_start` date NOT NULL default '0000-00-00',
`Date_finish` date NOT NULL default '0000-00-00',
`Term` varchar(4) NOT NULL default '',
`Product_type` varchar(100) NOT NULL default '00000',
`Fund_resource` varchar(100) NOT NULL default '',
`Fund` varchar(100) NOT NULL default '',
`Propagate` varchar(100) NOT NULL default '',
`Benefit` text NOT NULL,
`Use_ref` text NOT NULL,
PRIMARY KEY (`Prod_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=9 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `edu_project_tb`
--
CREATE TABLE `edu_project_tb` (
`Project_code` tinyint(3) unsigned zerofill NOT NULL auto_increment,
`Faculty_code` tinyint(2) unsigned zerofill NOT NULL default '00',
`Project_name` text NOT NULL,
`Addwork` text NOT NULL,
`Project_desc` text NOT NULL,
`Period` varchar(255) NOT NULL default '',
`Start_Date` varchar(255) NOT NULL default '',
`Super` text NOT NULL,
`Supervisor` text NOT NULL,
`Term` varchar(4) NOT NULL default '',
`Budget_Year` varchar(4) NOT NULL default '',
`Budget` float(9,2) NOT NULL default '0.00',
`Budget_use` float(9,2) NOT NULL default '0.00',
`Percent_ans` int(11) NOT NULL default '0',
`Result_oper` char(1) NOT NULL default '',
`Dif_result` float(9,2) NOT NULL default '0.00',
`Flag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`Project_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=17 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `edu_service_tb`
--
CREATE TABLE `edu_service_tb` (
`Project_code` int(3) unsigned zerofill NOT NULL auto_increment,
`Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
`Project_name` varchar(255) NOT NULL default '',
`Period` varchar(150) NOT NULL default '00:00:00',
`Date_start` date NOT NULL default '0000-00-00',
`Term` varchar(4) NOT NULL default '',
`Res` char(2) NOT NULL default '',
`Detail` varchar(100) NOT NULL default '',
`Year_budget` varchar(4) NOT NULL default '',
`Budget` float(10,2) NOT NULL default '0.00',
`Budget_use` float(10,2) NOT NULL default '0.00',
`Target_group` int(10) NOT NULL default '0',
`Objective` text NOT NULL,
`Fund_support` varchar(200) NOT NULL default '',
`Fee` float(10,2) NOT NULL default '0.00',
`Response` varchar(100) NOT NULL default '',
`Total_time_project` int(11) NOT NULL default '0',
`Total_time_insi` int(11) NOT NULL default '0',
`Total_time_inso` int(11) NOT NULL default '0',
`Dif_result` float(8,2) NOT NULL default '0.00',
`Result_oper` char(1) NOT NULL default '0',
`Img1` varchar(100) NOT NULL default '',
PRIMARY KEY (`Project_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=61 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `faculty_tb`
--
CREATE TABLE `faculty_tb` (
`Faculty_code` tinyint(2) unsigned zerofill NOT NULL auto_increment,
`Faculty_name` varchar(255) NOT NULL default '',
`Faculty_nameE` varchar(255) NOT NULL default '',
PRIMARY KEY (`Faculty_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=17 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `finance3_tb`
--
CREATE TABLE `finance3_tb` (
`code` int(10) unsigned zerofill NOT NULL auto_increment,
`Year_budget` varchar(4) NOT NULL default '0',
`Date_note` date NOT NULL default '0000-00-00',
`Cost1` float(8,2) NOT NULL default '0.00',
`Cost2` float(8,2) NOT NULL default '0.00',
`Cost3` float(8,2) NOT NULL default '0.00',
`Cost4` float(8,2) NOT NULL default '0.00',
`Cost5` float(8,2) NOT NULL default '0.00',
`Cost6` float(8,2) NOT NULL default '0.00',
`Cost7` float(8,2) NOT NULL default '0.00',
PRIMARY KEY (`code`,`Year_budget`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=46 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `finance4_tb`
--
CREATE TABLE `finance4_tb` (
`code` int(10) unsigned zerofill NOT NULL auto_increment,
`Year_budget` varchar(4) NOT NULL default '0',
`Date_note` date NOT NULL default '0000-00-00',
`Cost1` float(8,2) NOT NULL default '0.00',
`Cost2` float(8,2) NOT NULL default '0.00',
`Cost3` float(8,2) NOT NULL default '0.00',
`Cost4` float(8,2) NOT NULL default '0.00',
`Cost5` float(8,2) NOT NULL default '0.00',
`Cost6` float(8,2) NOT NULL default '0.00',
`Cost7` float(8,2) NOT NULL default '0.00',
`Cost8` float(8,2) NOT NULL default '0.00',
PRIMARY KEY (`code`,`Year_budget`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=18 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `foreign_relation_tb`
--
CREATE TABLE `foreign_relation_tb` (
`code` int(10) NOT NULL auto_increment,
`Project_name` varchar(200) NOT NULL default '',
`Term` varchar(4) NOT NULL default '',
`Budget_Year` varchar(4) NOT NULL default '',
`Objective` text NOT NULL,
`Target` varchar(200) NOT NULL default '',
`Period` varchar(200) NOT NULL default '',
`Start_Date` varchar(255) NOT NULL default '',
`Budget` float(8,2) NOT NULL default '0.00',
`Budget_use` float(8,2) NOT NULL default '0.00',
`Dif_result` float(8,2) NOT NULL default '0.00',
`Fund_resource` varchar(200) NOT NULL default '',
`Director` varchar(100) NOT NULL default '',
`Join_co` varchar(100) NOT NULL default '',
`Join_type` varchar(100) NOT NULL default '',
`Result_oper` char(1) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `formation_tb`
--
CREATE TABLE `formation_tb` (
`Code` int(5) unsigned zerofill NOT NULL auto_increment,
`InforName` varchar(50) NOT NULL default '',
`Date` date NOT NULL default '0000-00-00',
`InforDetail` text NOT NULL,
`Teacher_code` int(5) unsigned zerofill NOT NULL default '00000',
`Flage` char(2) NOT NULL default '',
PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=18 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `grade_tb`
--
CREATE TABLE `grade_tb` (
`code` int(5) unsigned zerofill NOT NULL auto_increment,
`Student_id` varchar(10) NOT NULL default '00000',
`Class` char(2) NOT NULL default '',
`Term` tinyint(5) NOT NULL default '0',
`Tb` int(11) NOT NULL default '0',
`Tp` int(11) NOT NULL default '0',
`Total` int(11) NOT NULL default '0',
`Gpa` float(8,2) NOT NULL default '0.00',
`Total_Unit` float(8,2) NOT NULL default '0.00',
`Total_Gpa` float(8,2) NOT NULL default '0.00',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `history_absent`
--
CREATE TABLE `history_absent` (
`code` tinyint(2) unsigned zerofill NOT NULL auto_increment,
`Teacher_code` int(5) unsigned zerofill NOT NULL default '00000',
`Absent_code` int(2) unsigned zerofill NOT NULL default '00',
`Absent_times` int(2) unsigned zerofill NOT NULL default '00',
`Year` int(4) NOT NULL default '0',
PRIMARY KEY (`code`,`Teacher_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=25 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `history_absent01_tb`
--
CREATE TABLE `history_absent01_tb` (
`Absent_code` tinyint(2) unsigned zerofill NOT NULL auto_increment,
`Absent_type` varchar(100) NOT NULL default '',
`Teacher_code` varchar(5) NOT NULL default '',
`Absent_01` int(2) unsigned NOT NULL default '0',
`Absent_02` int(2) unsigned NOT NULL default '0',
`Absent_03` int(2) unsigned NOT NULL default '0',
`Absent_04` int(2) unsigned NOT NULL default '0',
`Absent_05` int(2) unsigned NOT NULL default '0',
`Absent_06` int(2) unsigned NOT NULL default '0',
`Absent_times` int(10) NOT NULL default '0',
`Date_start` date NOT NULL default '0000-00-00',
`Date_finish` date NOT NULL default '0000-00-00',
`Unit_count` varchar(100) NOT NULL default '0',
PRIMARY KEY (`Absent_code`,`Teacher_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `history_absent_tb`
--
CREATE TABLE `history_absent_tb` (
`code` int(6) NOT NULL auto_increment,
`Absent_code` tinyint(2) unsigned zerofill NOT NULL default '00',
`Year` int(4) NOT NULL default '0',
`Absent_type` varchar(100) NOT NULL default '',
`Teacher_code` varchar(5) NOT NULL default '',
`Absent_times` int(10) NOT NULL default '0',
`Date_start` date NOT NULL default '0000-00-00',
`Date_finish` date NOT NULL default '0000-00-00',
`Unit_count` varchar(100) NOT NULL default '0',
PRIMARY KEY (`code`,`Teacher_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=605 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `history_decoration_tb`
--
CREATE TABLE `history_decoration_tb` (
`Code` int(10) NOT NULL auto_increment,
`Decoration_name` varchar(100) NOT NULL default '',
`Teacher_code` varchar(5) NOT NULL default '',
`Year_receive` int(4) NOT NULL default '0',
`Volumn` varchar(100) NOT NULL default '',
`Col` varchar(100) NOT NULL default '',
`Page` varchar(10) NOT NULL default '',
`Orderlist` varchar(100) NOT NULL default '',
PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `history_position_tb`
--
CREATE TABLE `history_position_tb` (
`code` int(5) NOT NULL auto_increment,
`Teacher_code` int(5) unsigned zerofill NOT NULL default '00000',
`Position_id` varchar(20) NOT NULL default '',
`Date_post` date NOT NULL default '0000-00-00',
`Gover_pos` varchar(100) NOT NULL default '',
`Manage_pos` varchar(100) NOT NULL default '',
`Level` varchar(10) NOT NULL default '',
`Salary` int(10) NOT NULL default '0',
`Skill` text NOT NULL,
`Order_id` varchar(30) NOT NULL default '',
`Ref_doc` varchar(100) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1459 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `hospital`
--
CREATE TABLE `hospital` (
`Hostpital` int(1) unsigned zerofill NOT NULL auto_increment,
`Hostpital_name` varchar(50) NOT NULL default '',
`picture` varchar(50) NOT NULL default '',
PRIMARY KEY (`Hostpital`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `information_tb`
--
CREATE TABLE `information_tb` (
`Info_code` int(5) unsigned zerofill NOT NULL auto_increment,
`Info_name` varchar(100) NOT NULL default '',
`Date` date NOT NULL default '0000-00-00',
`Info_detail` text NOT NULL,
`Organiz` varchar(100) NOT NULL default '',
`Supervisor` varchar(100) NOT NULL default '',
`Flag` char(2) NOT NULL default '',
PRIMARY KEY (`Info_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 COMMENT='ҧЪѹ' AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `instructor_tb`
--
CREATE TABLE `instructor_tb` (
`code` int(5) unsigned zerofill NOT NULL auto_increment,
`First_name` varchar(20) NOT NULL default '',
`Name` varchar(100) NOT NULL default '',
`Lastname` varchar(100) NOT NULL default '',
`Sex` varchar(100) NOT NULL default '',
`Status` char(1) NOT NULL default '',
`Degree` varchar(200) character set tis620 collate tis620_bin NOT NULL default '',
`Exper` varchar(100) NOT NULL default '',
`Skill` text NOT NULL,
`Img1` varchar(255) NOT NULL default '',
`Addr_work` text NOT NULL,
`Addr_home` text NOT NULL,
`Tel` varchar(15) NOT NULL default '',
`Email` varchar(100) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=48 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `labtype_tb`
--
CREATE TABLE `labtype_tb` (
`Code` int(6) NOT NULL auto_increment,
`Code_id` varchar(10) NOT NULL default '',
`Lab` text NOT NULL,
`Description` text NOT NULL,
`Description_3` text NOT NULL,
PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=33 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `magazine_tb`
--
CREATE TABLE `magazine_tb` (
`code_mag` int(10) NOT NULL auto_increment,
`Magazine_name` varchar(100) NOT NULL default '',
`Magazine_type` varchar(100) NOT NULL default '',
`Ex_article` text NOT NULL,
`Author` varchar(255) NOT NULL default '',
`Vol` varchar(100) NOT NULL default '',
`Year` varchar(4) NOT NULL default '',
`Month` varchar(100) NOT NULL default '',
PRIMARY KEY (`code_mag`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `manage_tb`
--
CREATE TABLE `manage_tb` (
`code` int(11) unsigned zerofill NOT NULL auto_increment,
`Acc_code` varchar(100) NOT NULL default '',
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Student_id` varchar(10) NOT NULL default '',
`Acc_name` varchar(255) NOT NULL default '',
`Store` text NOT NULL,
`Img1` varchar(255) NOT NULL default '',
`Fix_History` text NOT NULL,
`Contact` text NOT NULL,
`Date_buy` date NOT NULL default '0000-00-00',
`Date_year` date NOT NULL default '0000-00-00',
`Price` float(8,2) NOT NULL default '0.00',
`Fix_budget` float(8,2) NOT NULL default '0.00',
`Status` varchar(255) NOT NULL default '',
`Status_1` varchar(150) NOT NULL default '',
`Statistic` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `manament_tb`
--
CREATE TABLE `manament_tb` (
`code` int(11) unsigned zerofill NOT NULL auto_increment,
`Acc_code` varchar(100) NOT NULL default '',
`Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Student_id` varchar(10) NOT NULL default '',
`Acc_name` varchar(255) NOT NULL default '',
`Store` text NOT NULL,
`Img1` varchar(255) NOT NULL default '',
`Fix_History` text NOT NULL,
`Contact` text NOT NULL,
`Date_buy` date NOT NULL default '0000-00-00',
`Date_year` date NOT NULL default '0000-00-00',
`Price` float(8,2) NOT NULL default '0.00',
`Fix_budget` float(8,2) NOT NULL default '0.00',
`Status` varchar(255) NOT NULL default '',
`Status_1` varchar(150) NOT NULL default '',
`Statistic` text NOT NULL,
`Description` text NOT NULL,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=348 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `method_tb`
--
CREATE TABLE `method_tb` (
`Method_code` tinyint(5) unsigned zerofill NOT NULL auto_increment,
`Method_name` varchar(50) NOT NULL default '',
PRIMARY KEY (`Method_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 COMMENT='ҧԸա' AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `money_source_tb`
--
CREATE TABLE `money_source_tb` (
`MoneyS_C` int(5) NOT NULL auto_increment,
`MoneyS_M` varchar(30) NOT NULL default '',
PRIMARY KEY (`MoneyS_C`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `permission_tb`
--
CREATE TABLE `permission_tb` (
`Number` tinyint(5) unsigned zerofill NOT NULL auto_increment,
`permision` int(11) NOT NULL default '0',
`url` varchar(100) NOT NULL default '',
`description` varchar(100) NOT NULL default '',
PRIMARY KEY (`Number`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 COMMENT='permissin Table' AUTO_INCREMENT=17 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `persnal_project_tb`
--
CREATE TABLE `persnal_project_tb` (
`Persnal_code` int(5) NOT NULL auto_increment,
`Project_code` tinyint(3) unsigned zerofill NOT NULL default '000',
`Code_no` varchar(8) NOT NULL default '0',
`Project_name` varchar(150) NOT NULL default '',
`First_name` varchar(20) NOT NULL default '',
`Name` varchar(50) NOT NULL default '',
`Last_name` varchar(50) NOT NULL default '',
`citizenId` varchar(13) NOT NULL default '',
`Program` int(2) unsigned zerofill NOT NULL default '00',
`Program_1` char(2) NOT NULL default '0',
`Program_2` char(2) NOT NULL default '',
`Program_3` char(2) NOT NULL default '',
`Program_4` char(2) NOT NULL default '',
`Program_5` char(2) NOT NULL default '',
`Teacher_code` int(5) unsigned zerofill NOT NULL default '00000',
`Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
`Code` int(3) unsigned NOT NULL default '0',
`Age` int(2) NOT NULL default '0',
`Sex` varchar(10) NOT NULL default '',
`Address` varchar(255) NOT NULL default '',
`Amper` varchar(50) NOT NULL default '0.00',
`ProvinceId` int(2) NOT NULL default '0',
`Img1` varchar(100) NOT NULL default '',
`Date_buy` date NOT NULL default '0000-00-00',
`Date_year` date NOT NULL default '0000-00-00',
`Zipcode` int(5) NOT NULL default '0',
`Email` varchar(50) NOT NULL default '',
`Phone` varchar(10) NOT NULL default '',
`Education` text NOT NULL,
`Education_1` text NOT NULL,
`Education_2` text NOT NULL,
`Addwork` text NOT NULL,
`Amount` float NOT NULL default '0',
`Flag` int(1) unsigned zerofill NOT NULL default '0',
`Work` text NOT NULL,
`Room` varchar(100) NOT NULL default '',
`Foot` varchar(50) NOT NULL default '',
`programId` int(2) unsigned zerofill NOT NULL default '00',
`collegeCode` int(2) unsigned zerofill NOT NULL default '00',
`Detail` varchar(100) NOT NULL default '',
`Bank` varchar(50) NOT NULL default '',
`Class` varchar(10) NOT NULL default '',
`Addname` varchar(50) NOT NULL default '',
PRIMARY KEY (`Persnal_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=407 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `person_type_tb`
--
CREATE TABLE `person_type_tb` (
`Ptype_code` tinyint(5) NOT NULL auto_increment,
`Ptype_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`Ptype_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `personal_den_tb`
--
CREATE TABLE `personal_den_tb` (
`Person_code` int(5) unsigned zerofill NOT NULL auto_increment,
`Teacher_code` int(5) unsigned zerofill NOT NULL default '00000',
`HN_code` varchar(10) NOT NULL default '',
`Teach_code` int(3) unsigned zerofill NOT NULL default '000',
`First_name` varchar(30) NOT NULL default '',
`Name` varchar(60) NOT NULL default '',
`Lastname` varchar(60) NOT NULL default '',
`DateBirth` date NOT NULL default '0000-00-00',
`Datetype` date NOT NULL default '0000-00-00',
`Sex` varchar(10) NOT NULL default '',
`Age` varchar(10) NOT NULL default '',
`Nationality` varchar(50) NOT NULL default '',
`Hostpital` int(1) unsigned zerofill NOT NULL default '0',
`Nation` varchar(50) NOT NULL default '',
`Religion` varchar(50) NOT NULL default '',
`Citizen_id` varchar(13) NOT NULL default '',
`Father_name` varchar(100) NOT NULL default '',
`Mother_name` varchar(100) NOT NULL default '',
`ProvinceId` int(2) unsigned NOT NULL default '0',
`Zipcode` varchar(10) NOT NULL default '',
`Phone` varchar(20) NOT NULL default '',
`Mobile` varchar(15) NOT NULL default '',
`Work` varchar(155) NOT NULL default '',
`Status2` varchar(50) NOT NULL default '',
`Status3` varchar(50) NOT NULL default '',
`Education` varchar(150) NOT NULL default '',
`Email_name` varchar(50) NOT NULL default '',
`Email_1` varchar(50) NOT NULL default '',
`Address` text NOT NULL,
`Img1` varchar(255) NOT NULL default '',
`Phone_1` varchar(20) NOT NULL default '',
`Mobile_1` varchar(15) NOT NULL default '0',
`Degree_code` varchar(50) NOT NULL default '0',
`Group_1` varchar(200) NOT NULL default '',
`Group_2` varchar(200) NOT NULL default '',
`Group_3` varchar(200) NOT NULL default '',
`Group_4` varchar(50) NOT NULL default '',
`Person_type` tinyint(1) NOT NULL default '0',
`Dental_code` tinyint(6) NOT NULL default '0',
`Club_nid` varchar(15) NOT NULL default '',
`Dentis_code` tinyint(5) NOT NULL default '0',
`Username` varchar(100) NOT NULL default '',
`Password` varchar(100) NOT NULL default '',
`Flag_del` tinyint(1) NOT NULL default '0',
`Permision` char(2) NOT NULL default '',
PRIMARY KEY (`Person_code`),
KEY `Teacher_code` (`Person_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 COMMENT='µ҃ҧ¢鍁م͒¨҃¬' AUTO_INCREMENT=66 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `personal_tb`
--
CREATE TABLE `personal_tb` (
`Teacher_code` int(5) unsigned zerofill NOT NULL auto_increment,
`officerId1` int(3) NOT NULL default '0',
`Teacher_id` varchar(6) default NULL,
`First_name` varchar(30) NOT NULL default '',
`Teacher_name` varchar(60) NOT NULL default '',
`Teacher_lastname` varchar(60) NOT NULL default '',
`DateBirth` date NOT NULL default '0000-00-00',
`Sex` varchar(10) NOT NULL default '',
`Nationality` varchar(50) NOT NULL default '',
`Nation` varchar(100) NOT NULL default '',
`Religion` varchar(50) NOT NULL default '',
`Citizen_id` varchar(13) NOT NULL default '0',
`Father_name` varchar(100) NOT NULL default '',
`Mother_name` varchar(100) NOT NULL default '',
`StatusId` int(1) NOT NULL default '0',
`Status` varchar(50) NOT NULL default '',
`Status2` varchar(50) NOT NULL default '',
`Status3` varchar(50) NOT NULL default '',
`Soulmate` varchar(100) NOT NULL default '',
`Total_child` varchar(10) NOT NULL default '',
`Address` text NOT NULL,
`Img1` varchar(255) NOT NULL default '',
`Skill` text NOT NULL,
`Type_Degree` tinyint(3) NOT NULL default '0',
`Degree_code` tinyint(5) NOT NULL default '0',
`Degree_else` varchar(50) NOT NULL default '',
`Degree_His1` varchar(200) NOT NULL default '',
`Degree_His2` varchar(200) NOT NULL default '',
`Degree_His3` varchar(200) NOT NULL default '',
`Type_degree1` varchar(50) NOT NULL default '',
`Type_degree2` varchar(50) NOT NULL default '',
`Type_degree3` varchar(50) NOT NULL default '',
`Year_1` varchar(4) NOT NULL default '',
`Year_2` varchar(4) NOT NULL default '',
`Year_3` varchar(4) NOT NULL default '',
`Person_type` tinyint(1) NOT NULL default '0',
`Teacher_type` char(2) NOT NULL default '',
`Gover_id` varchar(20) NOT NULL default '',
`Forum_nid` varchar(15) NOT NULL default '',
`Club_nid` varchar(15) NOT NULL default '',
`Year_gov` int(11) NOT NULL default '0',
`Year_coll` int(11) NOT NULL default '0',
`Year_fac` int(11) NOT NULL default '0',
`Gover_pos` varchar(30) NOT NULL default '',
`Salary_1` float(8,2) NOT NULL default '0.00',
`Salary_2` float(8,2) NOT NULL default '0.00',
`Salary_3` float(8,2) NOT NULL default '0.00',
`Absent_01` int(2) unsigned zerofill NOT NULL default '00',
`Absent_02` int(2) unsigned zerofill NOT NULL default '00',
`Absent_03` int(2) unsigned zerofill NOT NULL default '00',
`Absent_04` int(2) unsigned zerofill NOT NULL default '00',
`Absent_05` int(2) unsigned zerofill NOT NULL default '00',
`Absent_06` int(2) unsigned zerofill NOT NULL default '00',
`Manage_pos` varchar(50) NOT NULL default '',
`Faculty_code` tinyint(2) unsigned zerofill NOT NULL default '00',
`Dentis_code` int(2) unsigned zerofill NOT NULL default '00',
`Depart` varchar(60) NOT NULL default '',
`Username` varchar(100) NOT NULL default '',
`Password` varchar(100) NOT NULL default '',
`Flag_del` tinyint(1) NOT NULL default '0',
`Permision` char(2) NOT NULL default '',
PRIMARY KEY (`Teacher_code`),
KEY `Teacher_code` (`Teacher_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=163 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `planteach_tb`
--
CREATE TABLE `planteach_tb` (
`Teach_id` int(4) unsigned NOT NULL auto_increment,
`HN_code` varchar(10) NOT NULL default '0',
`No_code` int(7) NOT NULL default '0',
`Person_code` int(5) unsigned zerofill NOT NULL default '00000',
`Tooth_code` int(2) unsigned NOT NULL default '0',
`Img1` varchar(100) NOT NULL default '',
`Img2` varchar(100) NOT NULL default '',
`Code` int(3) unsigned zerofill NOT NULL default '000',
`Date` date NOT NULL default '0000-00-00',
`Time_in` time NOT NULL default '00:00:00',
`Time_out` time NOT NULL default '00:00:00',
`Price` float(8,2) NOT NULL default '0.00',
`Teach_code` int(3) unsigned zerofill NOT NULL default '000',
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Religion` varchar(50) NOT NULL default '',
`Discrition` varchar(50) NOT NULL default '',
`Flag` tinyint(1) unsigned NOT NULL default '0',
`Percen` int(2) unsigned NOT NULL default '0',
PRIMARY KEY (`Teach_id`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=6 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `program`
--
CREATE TABLE `program` (
`programId` int(12) NOT NULL default '0',
`programCode` varchar(8) NOT NULL default '',
`programYear` int(4) NOT NULL default '0',
`degreeId` int(2) NOT NULL default '0',
`levelId` int(2) NOT NULL default '0',
`programName` varchar(100) NOT NULL default '',
`programNameEng` varchar(100) NOT NULL default '',
`programAbbr` varchar(20) NOT NULL default '',
`programAbbrEng` varchar(20) NOT NULL default '',
`creditTotal` float NOT NULL default '0',
`description` text,
`descriptionEng` text,
`studyYearMax` int(2) NOT NULL default '0',
`gradePointMin` float NOT NULL default '0',
`createDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
`createUserId` varchar(20) NOT NULL default '',
`updateDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
`updateUserId` varchar(20) NOT NULL default '',
`semesterPerYear` int(1) NOT NULL default '0',
`programStatus` char(1) NOT NULL default 'Y',
`studyYear` int(1) NOT NULL default '0',
`programConfId` int(11) NOT NULL default '0',
PRIMARY KEY (`programId`),
KEY `degreeId` (`degreeId`),
KEY `levelId` (`levelId`),
KEY `programConfId` (`programConfId`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `project_tb`
--
CREATE TABLE `project_tb` (
`Code` int(10) NOT NULL auto_increment,
`Project_code` int(5) unsigned zerofill NOT NULL default '00000',
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Orderlist` varchar(10) NOT NULL default '',
`Faculty_code` tinyint(2) unsigned zerofill NOT NULL default '00',
`Orderlist_2` varchar(5) NOT NULL default '0',
`Project_name` varchar(255) NOT NULL default '',
`Project_plan` varchar(200) NOT NULL default '',
`Course_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Fee` int(5) NOT NULL default '0',
`Period` varchar(255) NOT NULL default '',
`Start_Date` date NOT NULL default '0000-00-00',
`Term` varchar(4) NOT NULL default '',
`Budget_Year` varchar(4) NOT NULL default '',
`Budget` float(9,2) NOT NULL default '0.00',
`Budget_use` float(9,2) NOT NULL default '0.00',
`Percent_ans` varchar(25) NOT NULL default '0',
`Result_oper` char(1) NOT NULL default '',
`Dif_result` float(9,2) NOT NULL default '0.00',
`Flag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=192 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `project_type_tb`
--
CREATE TABLE `project_type_tb` (
`Project_code` int(5) unsigned zerofill NOT NULL auto_increment,
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Orderlist` varchar(10) NOT NULL default '',
`Faculty_name` varchar(158) NOT NULL default '',
`Orderlist_2` varchar(15) NOT NULL default '',
`Project_name` varchar(255) NOT NULL default '',
`Project_plan` varchar(200) NOT NULL default '',
`Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
`Fee` float(9,2) NOT NULL default '0.00',
`Period` varchar(255) NOT NULL default '',
`Date_start` date NOT NULL default '0000-00-00',
`Date_finish` date NOT NULL default '0000-00-00',
`Term` varchar(4) NOT NULL default '',
`Budget_Year` varchar(4) NOT NULL default '',
`Budget` float(9,2) NOT NULL default '0.00',
`Budget_use` float(9,2) NOT NULL default '0.00',
`Percent_ans` varchar(25) NOT NULL default '0',
`Dif_result` float(9,2) NOT NULL default '0.00',
`January` float(9,2) NOT NULL default '0.00',
`February` float(8,2) NOT NULL default '0.00',
`March` float(9,2) NOT NULL default '0.00',
`April` float(9,2) NOT NULL default '0.00',
`May` float(9,2) NOT NULL default '0.00',
`June` float(9,2) NOT NULL default '0.00',
`July` float(9,2) NOT NULL default '0.00',
`Augus` float(9,2) NOT NULL default '0.00',
`September` float(9,2) NOT NULL default '0.00',
`October` float(9,2) NOT NULL default '0.00',
`November` float(9,2) NOT NULL default '0.00',
`December` float(9,2) NOT NULL default '0.00',
`Flag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`Project_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=809 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `province`
--
CREATE TABLE `province` (
`ProvinceId` int(2) NOT NULL default '0',
`ProvinceName` varchar(30) NOT NULL default '',
`ProvinceNameEng` varchar(30) NOT NULL default '',
PRIMARY KEY (`ProvinceId`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `punishment_tb`
--
CREATE TABLE `punishment_tb` (
`Punish_code` int(5) unsigned zerofill NOT NULL auto_increment,
`Student_id` varchar(10) NOT NULL default '',
`Perform` varchar(100) NOT NULL default '',
`Result` varchar(255) NOT NULL default '',
`Healthy_card` varchar(255) NOT NULL default '',
`Sick_in_learn` text NOT NULL,
`Insurrance` varchar(255) NOT NULL default '',
PRIMARY KEY (`Punish_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `qa_pi_cri_tb`
--
CREATE TABLE `qa_pi_cri_tb` (
`code` int(5) NOT NULL auto_increment,
`Stand_code` int(5) NOT NULL default '0',
`Ind_code` varchar(5) NOT NULL default '',
`Indicate` varchar(255) NOT NULL default '',
`Source` varchar(255) NOT NULL default '',
`IncFor` text NOT NULL,
`Awa` text NOT NULL,
`Att` text NOT NULL,
`Ach1` text NOT NULL,
`Ach2` text NOT NULL,
`E_awa` text NOT NULL,
`E_att` text NOT NULL,
`E_ach1` text NOT NULL,
`E_ach2` text NOT NULL,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `qa_project_tb`
--
CREATE TABLE `qa_project_tb` (
`Project_code` int(10) unsigned zerofill NOT NULL auto_increment,
`Orderlist` varchar(10) NOT NULL default '',
`Project_name` varchar(150) NOT NULL default '',
`Objective` text NOT NULL,
`Fee` float(8,2) NOT NULL default '0.00',
`Period` varchar(255) NOT NULL default '',
`Start_Date` varchar(255) NOT NULL default '',
`Term` varchar(4) NOT NULL default '',
`Budget_Year` varchar(4) NOT NULL default '',
`Budget` float(8,2) NOT NULL default '0.00',
`Budget_use` float(8,2) NOT NULL default '0.00',
`Participant` text NOT NULL,
`Percent_ans` int(11) NOT NULL default '0',
`Result_oper` char(1) NOT NULL default '',
`Dif_result` float(8,2) NOT NULL default '0.00',
`Flag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`Project_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `qa_result_tb`
--
CREATE TABLE `qa_result_tb` (
`code` int(5) NOT NULL auto_increment,
`Stand_code` varchar(5) NOT NULL default '',
`Term` varchar(4) NOT NULL default '',
`Times` char(2) NOT NULL default '',
`Assessor` text NOT NULL,
`S11` int(11) NOT NULL default '0',
`S12` int(11) NOT NULL default '0',
`S13` int(11) NOT NULL default '0',
`S14` int(11) NOT NULL default '0',
`S15` int(11) NOT NULL default '0',
`S16` int(11) NOT NULL default '0',
`S17` int(11) NOT NULL default '0',
`S18` int(11) NOT NULL default '0',
`S19` int(11) NOT NULL default '0',
`S21` int(11) NOT NULL default '0',
`S22` int(11) NOT NULL default '0',
`S23` int(11) NOT NULL default '0',
`S24` int(11) NOT NULL default '0',
`S25` int(11) NOT NULL default '0',
`S26` int(11) NOT NULL default '0',
`S27` int(11) NOT NULL default '0',
`S28` int(11) NOT NULL default '0',
`S29` int(11) NOT NULL default '0',
`S210` int(11) NOT NULL default '0',
`S31` int(11) NOT NULL default '0',
`S32` int(11) NOT NULL default '0',
`S33` int(11) NOT NULL default '0',
`S34` int(11) NOT NULL default '0',
`S35` int(11) NOT NULL default '0',
`S36` int(11) NOT NULL default '0',
`S41` int(11) NOT NULL default '0',
`S42` int(11) NOT NULL default '0',
`S43` int(11) NOT NULL default '0',
`S44` int(11) NOT NULL default '0',
`S45` int(11) NOT NULL default '0',
`S46` int(11) NOT NULL default '0',
`S51` int(11) NOT NULL default '0',
`S52` int(11) NOT NULL default '0',
`S53` int(11) NOT NULL default '0',
`S54` int(11) NOT NULL default '0',
`S55` int(11) NOT NULL default '0',
`S61` int(11) NOT NULL default '0',
`S62` int(11) NOT NULL default '0',
`S71` int(11) NOT NULL default '0',
`S72` int(11) NOT NULL default '0',
`S73` int(11) NOT NULL default '0',
`S74` int(11) NOT NULL default '0',
`S75` int(11) NOT NULL default '0',
`S76` int(11) NOT NULL default '0',
`S77` int(11) NOT NULL default '0',
`S78` int(11) NOT NULL default '0',
`S79` int(11) NOT NULL default '0',
`S710` int(11) NOT NULL default '0',
`S711` int(11) NOT NULL default '0',
`S712` int(11) NOT NULL default '0',
`S81` int(11) NOT NULL default '0',
`S82` int(11) NOT NULL default '0',
`S91` int(11) NOT NULL default '0',
`S92` int(11) NOT NULL default '0',
`S93` int(11) NOT NULL default '0',
`S94` int(11) NOT NULL default '0',
`S95` int(11) NOT NULL default '0',
`S96` int(11) NOT NULL default '0',
`S97` int(11) NOT NULL default '0',
`S98` int(11) NOT NULL default '0',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=9 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `qa_standard_tb`
--
CREATE TABLE `qa_standard_tb` (
`code` int(5) NOT NULL auto_increment,
`Stand_code` varchar(5) NOT NULL default '0.0',
`Topic` text NOT NULL,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=10 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `relation_tb`
--
CREATE TABLE `relation_tb` (
`code` int(11) NOT NULL auto_increment,
`Project_name` varchar(255) NOT NULL default '',
`Organize` varchar(255) NOT NULL default '',
`Objective` text NOT NULL,
`Contact` varchar(255) NOT NULL default '',
`Address` text NOT NULL,
`Email` varchar(255) NOT NULL default '',
`Website` varchar(255) NOT NULL default '',
`Country` varchar(255) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `res_project_tb`
--
CREATE TABLE `res_project_tb` (
`Resp_code` tinyint(5) unsigned zerofill NOT NULL auto_increment,
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Project_name` varchar(255) NOT NULL default '',
`Year_res` varchar(4) NOT NULL default '0000',
`Duty` varchar(100) NOT NULL default '',
`Duty_else` varchar(100) NOT NULL default '',
`Apply` varchar(100) NOT NULL default '',
PRIMARY KEY (`Resp_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=6 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `research_char_tb`
--
CREATE TABLE `research_char_tb` (
`code` tinyint(5) unsigned zerofill NOT NULL auto_increment,
`Rchar_name` varchar(255) NOT NULL default '',
`Rchar_desc` text NOT NULL,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `research_tb`
--
CREATE TABLE `research_tb` (
`Research_code` int(11) unsigned zerofill NOT NULL auto_increment,
`Teacher_code` varchar(5) NOT NULL default '',
`Branch` varchar(50) NOT NULL default '0',
`Research_name` varchar(100) NOT NULL default '',
`Research_type` varchar(100) NOT NULL default '',
`Research_char` varchar(100) NOT NULL default '',
`Research_char_else` varchar(100) NOT NULL default '',
`R_position` varchar(50) NOT NULL default '',
`name1` tinyint(5) unsigned zerofill NOT NULL default '00000',
`name2` tinyint(5) unsigned zerofill NOT NULL default '00000',
`name3` tinyint(5) unsigned zerofill NOT NULL default '00000',
`name4` tinyint(5) unsigned zerofill NOT NULL default '00000',
`name5` tinyint(5) unsigned zerofill NOT NULL default '00000',
`name6` tinyint(5) unsigned zerofill NOT NULL default '00000',
`name7` tinyint(5) unsigned zerofill NOT NULL default '00000',
`name8` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Year_start` date NOT NULL default '0000-00-00',
`Year_finish` date NOT NULL default '0000-00-00',
`Fund` varchar(10) NOT NULL default '0',
`Fund_resource` text NOT NULL,
`Resource_des` varchar(100) NOT NULL default '',
`Propagate` varchar(100) NOT NULL default '',
`Propagate_des` varchar(255) NOT NULL default '',
`Prop_type` varchar(100) NOT NULL default '',
`Prop_type1` varchar(100) NOT NULL default '',
`Prop_type2` varchar(100) NOT NULL default '',
`Prop_type3` varchar(100) NOT NULL default '',
`Apply1` varchar(100) NOT NULL default '',
`Apply2` varchar(100) NOT NULL default '',
`Apply3` varchar(100) NOT NULL default '',
`Apply4` varchar(100) NOT NULL default '',
`Apply_des` varchar(255) NOT NULL default '',
`Year_prop` varchar(4) NOT NULL default '',
PRIMARY KEY (`Research_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 COMMENT='ҧҹԨ¢ͧҨ' AUTO_INCREMENT=43 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `room_tb`
--
CREATE TABLE `room_tb` (
`code` int(5) NOT NULL auto_increment,
`Room_code` varchar(50) NOT NULL default '',
`BuildD_No` int(5) NOT NULL default '0',
`Room_type` varchar(50) NOT NULL default '',
`Img1` varchar(155) NOT NULL default '',
`Room_name` varchar(50) NOT NULL default '',
`Size` varchar(50) NOT NULL default '',
`Area` varchar(30) NOT NULL default '',
`Eletric_meter` int(5) NOT NULL default '0',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=37 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `salary_repot_tb`
--
CREATE TABLE `salary_repot_tb` (
`Code` int(5) unsigned zerofill NOT NULL auto_increment,
`Teacher_id` varchar(6) NOT NULL default '',
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Start_mont` varchar(15) NOT NULL default '',
`Start_year` varchar(20) NOT NULL default '',
`Salary_1` float(8,2) NOT NULL default '0.00',
`Salary_2` float(8,2) NOT NULL default '0.00',
`Salary_3` float(8,2) NOT NULL default '0.00',
`Costt_1` float(8,2) NOT NULL default '0.00',
`Costt_2` float(8,2) NOT NULL default '0.00',
`Costt_3` float(8,2) NOT NULL default '0.00',
`Costt_4` float(8,2) NOT NULL default '0.00',
`Costt_5` float(8,2) NOT NULL default '0.00',
`Costt_6` float(8,2) NOT NULL default '0.00',
`Costt_7` float(8,2) NOT NULL default '0.00',
`Costt_8` float(8,2) NOT NULL default '0.00',
`Costt_9` float(8,2) NOT NULL default '0.00',
`Costt_10` float(8,2) NOT NULL default '0.00',
`Costt_11` float(8,2) NOT NULL default '0.00',
`Costt_12` float(8,2) NOT NULL default '0.00',
`Costt_13` float(8,2) NOT NULL default '0.00',
`Costt_14` float(8,2) NOT NULL default '0.00',
`Costt_15` float(8,2) NOT NULL default '0.00',
`Costt_16` float(8,2) NOT NULL default '0.00',
`Costt_17` float(8,2) NOT NULL default '0.00',
`Costt_18` float(8,2) NOT NULL default '0.00',
`Costt_19` float(8,2) NOT NULL default '0.00',
`Costt_salary` float(8,2) NOT NULL default '0.00',
`Costt_to` float(8,2) NOT NULL default '0.00',
`Costt_total` float(8,2) NOT NULL default '0.00',
`Flag` int(1) NOT NULL default '0',
PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=499 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `salary_tb`
--
CREATE TABLE `salary_tb` (
`Code` tinyint(5) unsigned zerofill NOT NULL auto_increment,
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Start_mont` varchar(15) NOT NULL default '',
`Start_year` varchar(5) NOT NULL default '',
`Salary` float(8,2) NOT NULL default '0.00',
`Cost_1` float(8,2) NOT NULL default '0.00',
`Cost_2` float(8,2) NOT NULL default '0.00',
`Cost_3` float(8,2) NOT NULL default '0.00',
`Cost_4` float(8,2) NOT NULL default '0.00',
`Cost_5` float(8,2) NOT NULL default '0.00',
`Cost_6` int(5) NOT NULL default '0',
`Flag` int(1) NOT NULL default '0',
PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=116 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `scholarship_tb`
--
CREATE TABLE `scholarship_tb` (
`Scholarship_code` int(5) unsigned zerofill NOT NULL auto_increment,
`Scholarship_name` varchar(255) NOT NULL default '',
`Scholarship_type` varchar(255) NOT NULL default '',
`Source` varchar(255) NOT NULL default '',
`Fund` float(8,2) NOT NULL default '0.00',
`Period` varchar(255) NOT NULL default '',
PRIMARY KEY (`Scholarship_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `state_tb`
--
CREATE TABLE `state_tb` (
`stateId` int(10) NOT NULL auto_increment,
`State` int(3) NOT NULL default '0',
`Year_State` varchar(4) NOT NULL default '0',
`Date_note` date NOT NULL default '0000-00-00',
`No` varchar(100) NOT NULL default '',
`Disciption` varchar(100) NOT NULL default '',
`Cost1` float(10,2) NOT NULL default '0.00',
`Cost2` float(10,2) NOT NULL default '0.00',
`Cost3` float(10,2) NOT NULL default '0.00',
`Cost4` float(10,2) NOT NULL default '0.00',
`Cost5` float(10,2) NOT NULL default '0.00',
`CostSum` float(15,2) NOT NULL default '0.00',
PRIMARY KEY (`stateId`,`Year_State`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=40 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `std_absent_tb`
--
CREATE TABLE `std_absent_tb` (
`code` int(11) NOT NULL auto_increment,
`Student_id` varchar(10) NOT NULL default '',
`Date_note` date NOT NULL default '0000-00-00',
`Case_ab` text NOT NULL,
`Unit` int(11) NOT NULL default '0',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `std_activity_tb`
--
CREATE TABLE `std_activity_tb` (
`code` int(5) unsigned zerofill NOT NULL auto_increment,
`Activity_name` varchar(255) NOT NULL default '',
`Activity_type` varchar(255) NOT NULL default '',
`Perform` varchar(50) NOT NULL default '',
`Activity` varchar(255) NOT NULL default '',
`Period` varchar(255) NOT NULL default '0000-00-00',
`Budget` float(8,2) NOT NULL default '0.00',
`Budget_use` float(8,2) NOT NULL default '0.00',
`Dif_result` float(8,2) NOT NULL default '0.00',
`Source` text NOT NULL,
`Target` varchar(255) NOT NULL default '',
`Amount` varchar(255) NOT NULL default '',
`Supervisor` text NOT NULL,
`Duty` varchar(100) NOT NULL default '',
`Objective` text NOT NULL,
`Index_mature` text NOT NULL,
`Affect_class` text NOT NULL,
`Ec41_1` varchar(255) NOT NULL default '',
`Ec41_2` varchar(255) NOT NULL default '',
`Ec41_3` varchar(255) NOT NULL default '',
`Ec41_4` varchar(255) NOT NULL default '',
`Ec41_5` varchar(255) NOT NULL default '',
`Ec41_6` varchar(255) NOT NULL default '',
`Ec41_7` varchar(255) NOT NULL default '',
`Ec41_8` varchar(255) NOT NULL default '',
`Ec41_9` varchar(255) NOT NULL default '',
`Ec41_10` varchar(255) NOT NULL default '',
`Ec41_11` varchar(255) NOT NULL default '',
`Ec42_1` varchar(255) NOT NULL default '',
`Ec42_2` varchar(255) NOT NULL default '',
`Ec42_3` varchar(255) NOT NULL default '',
`Ec42_4` varchar(255) NOT NULL default '',
`Ec42_5` varchar(255) NOT NULL default '',
`Ec42_6` varchar(255) NOT NULL default '',
`Ec42_7` varchar(255) NOT NULL default '',
`Ec42_8` varchar(255) NOT NULL default '',
`Ec42_9` varchar(255) NOT NULL default '',
`Ec42_10` varchar(255) NOT NULL default '',
`Ec42_11` varchar(255) NOT NULL default '',
`Ec42_12` varchar(255) NOT NULL default '',
`Ec42_13` varchar(255) NOT NULL default '',
`Ec42_14` varchar(255) NOT NULL default '',
`Ec42_15` varchar(255) NOT NULL default '',
`Ec43_1` varchar(255) NOT NULL default '',
`Ec43_2` varchar(255) NOT NULL default '',
`Ec43_3` varchar(255) NOT NULL default '',
`Ec43_4` varchar(255) NOT NULL default '',
`Ec43_5` varchar(255) NOT NULL default '',
`Ec43_6` varchar(255) NOT NULL default '',
`Ec43_7` varchar(255) NOT NULL default '',
`Ec43_8` varchar(255) NOT NULL default '',
`Ec43_9` varchar(255) NOT NULL default '',
`Ec43_10` varchar(255) NOT NULL default '',
`Ec44_1` varchar(255) NOT NULL default '',
`Ec44_2` varchar(255) NOT NULL default '',
`Ec44_3` varchar(255) NOT NULL default '',
`Ec44_4` varchar(255) NOT NULL default '',
`Ec44_5` varchar(255) NOT NULL default '',
`Ec44_6` varchar(255) NOT NULL default '',
`Ec44_7` varchar(255) NOT NULL default '',
`Ec44_8` varchar(255) NOT NULL default '',
`Ec44_9` varchar(255) NOT NULL default '',
`Ec44_10` varchar(255) NOT NULL default '',
`Ec44_11` varchar(255) NOT NULL default '',
`Ec44_12` varchar(255) NOT NULL default '',
`Ec44_13` varchar(255) NOT NULL default '',
`Ec44_14` varchar(255) NOT NULL default '',
`Ec44_15` varchar(255) NOT NULL default '',
`Result_oper` char(1) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `std_ass14_tb`
--
CREATE TABLE `std_ass14_tb` (
`code` int(11) NOT NULL auto_increment,
`Term` varchar(4) NOT NULL default '',
`Course_code` varchar(5) NOT NULL default '',
`Level` varchar(5) NOT NULL default '',
`Total_pass1` int(11) NOT NULL default '0',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `std_ec_tb`
--
CREATE TABLE `std_ec_tb` (
`Es_code` int(11) NOT NULL auto_increment,
`code` varchar(100) NOT NULL default '',
`Ec41_1` char(2) NOT NULL default '',
`Ec41_2` char(2) NOT NULL default '',
`Ec41_3` char(2) NOT NULL default '',
`Ec41_4` char(2) NOT NULL default '',
`Ec41_5` char(2) NOT NULL default '',
`Ec41_6` char(2) NOT NULL default '',
`Ec41_7` char(2) NOT NULL default '',
`Ec41_8` char(2) NOT NULL default '',
PRIMARY KEY (`Es_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `std_employer_tb`
--
CREATE TABLE `std_employer_tb` (
`Code` int(11) NOT NULL auto_increment,
`Term` varchar(4) NOT NULL default '',
`Course_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Series` int(11) NOT NULL default '0',
`x1` float(8,2) NOT NULL default '0.00',
`x2` float(8,2) NOT NULL default '0.00',
`x3` float(8,2) NOT NULL default '0.00',
`x4` float(8,2) NOT NULL default '0.00',
`x5` float(8,2) NOT NULL default '0.00',
`x6` float(8,2) NOT NULL default '0.00',
`x7` float(8,2) NOT NULL default '0.00',
`x8` float(8,2) NOT NULL default '0.00',
`x9` float(8,2) NOT NULL default '0.00',
`x10` float(8,2) NOT NULL default '0.00',
`x11` float(8,2) NOT NULL default '0.00',
`x12` float(8,2) NOT NULL default '0.00',
`x13` float(8,2) NOT NULL default '0.00',
`sd1` float(8,2) NOT NULL default '0.00',
`sd2` float(8,2) NOT NULL default '0.00',
`sd3` float(8,2) NOT NULL default '0.00',
`sd4` float(8,2) NOT NULL default '0.00',
`sd5` float(8,2) NOT NULL default '0.00',
`sd6` float(8,2) NOT NULL default '0.00',
`sd7` float(8,2) NOT NULL default '0.00',
`sd8` float(8,2) NOT NULL default '0.00',
`sd9` float(8,2) NOT NULL default '0.00',
`sd10` float(8,2) NOT NULL default '0.00',
`sd11` float(8,2) NOT NULL default '0.00',
`sd12` float(8,2) NOT NULL default '0.00',
`sd13` float(8,2) NOT NULL default '0.00',
`rate1` tinyint(1) NOT NULL default '0',
`rate2` tinyint(1) NOT NULL default '0',
`rate3` tinyint(1) NOT NULL default '0',
`rate4` tinyint(1) NOT NULL default '0',
`rate5` tinyint(1) NOT NULL default '0',
`rate6` tinyint(1) NOT NULL default '0',
`rate7` tinyint(1) NOT NULL default '0',
`rate8` tinyint(1) NOT NULL default '0',
`rate9` tinyint(1) NOT NULL default '0',
`rate10` tinyint(1) NOT NULL default '0',
`rate11` tinyint(1) NOT NULL default '0',
`rate12` tinyint(1) NOT NULL default '0',
`rate13` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `std_health_tb`
--
CREATE TABLE `std_health_tb` (
`code` int(10) unsigned zerofill NOT NULL auto_increment,
`Student_id` varchar(10) NOT NULL default '',
`Weight` float NOT NULL default '0',
`Height` int(11) NOT NULL default '0',
`Date_note` date NOT NULL default '0000-00-00',
`B_group` varchar(50) NOT NULL default '',
`Presure` varchar(100) NOT NULL default '',
`Symptom` text NOT NULL,
`Disease` text NOT NULL,
`Treat` text NOT NULL,
`Place_Treat` varchar(255) NOT NULL default '',
`Medicine` varchar(255) NOT NULL default '',
`Bad_Medic` varchar(255) NOT NULL default '',
`Bad_Food` varchar(255) NOT NULL default '',
PRIMARY KEY (`code`,`Student_id`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `std_punish_tb`
--
CREATE TABLE `std_punish_tb` (
`code` int(11) NOT NULL auto_increment,
`Student_id` varchar(10) NOT NULL default '',
`Date_note` date NOT NULL default '0000-00-00',
`Punish_type` varchar(255) NOT NULL default '',
`Perform` text NOT NULL,
`Consider` text NOT NULL,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `std_scholarship_tb`
--
CREATE TABLE `std_scholarship_tb` (
`code` int(11) NOT NULL auto_increment,
`Scholarship_code` int(5) NOT NULL default '0',
`Date_rec` date NOT NULL default '0000-00-00',
`Student_id` varchar(10) NOT NULL default '',
`Consider` text NOT NULL,
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `std_success_tb`
--
CREATE TABLE `std_success_tb` (
`code` int(11) NOT NULL auto_increment,
`Student_id` varchar(10) NOT NULL default '',
`Year_grad` varchar(4) NOT NULL default '',
`Pass_test` char(2) NOT NULL default '',
`Times` tinyint(5) NOT NULL default '0',
`Past_test` char(2) NOT NULL default '',
`Place` char(1) NOT NULL default '',
`Work_addr` varchar(255) NOT NULL default '',
`Work_place` varchar(100) NOT NULL default '',
`Contact_addr` text NOT NULL,
`Work_status` char(1) NOT NULL default '',
`Position` varchar(255) NOT NULL default '',
`Level` varchar(5) NOT NULL default '',
`Depart_name` varchar(100) NOT NULL default '',
`Depart` varchar(100) NOT NULL default '',
`Date_w1` varchar(100) NOT NULL default '',
`Date_w11` varchar(100) NOT NULL default '',
`Date_w2` varchar(100) NOT NULL default '',
`Date_w22` varchar(100) NOT NULL default '',
`Date_w3` varchar(100) NOT NULL default '',
`Date_w33` varchar(100) NOT NULL default '',
`Work_change` varchar(100) NOT NULL default '',
`Income_m` float(8,2) NOT NULL default '0.00',
`Income_y` float(8,2) NOT NULL default '0.00',
`Status` char(1) NOT NULL default '',
`Learn_flag` char(1) NOT NULL default '',
`Degree1` varchar(255) NOT NULL default '',
`Degree2` varchar(255) NOT NULL default '',
`Award_in` varchar(255) NOT NULL default '',
`Award_out` varchar(255) NOT NULL default '',
PRIMARY KEY (`code`,`Student_id`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `student_tb`
--
CREATE TABLE `student_tb` (
`code` int(4) unsigned NOT NULL auto_increment,
`Course_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`ProvinceId` char(2) NOT NULL default '',
`Class` varchar(100) NOT NULL default '',
`Orderlist` tinyint(5) NOT NULL default '0',
`Student_id` varchar(10) NOT NULL default '0',
`First_name` varchar(30) NOT NULL default '',
`Name` varchar(100) NOT NULL default '',
`Lastname` varchar(100) NOT NULL default '',
`Sex` varchar(10) NOT NULL default '',
`DateBirth` date NOT NULL default '0000-00-00',
`Religion` varchar(30) NOT NULL default '',
`Address` text NOT NULL,
`Img1` varchar(255) NOT NULL default '',
`Father_name` varchar(255) NOT NULL default '',
`Mother_name` varchar(255) NOT NULL default '',
`Address2` text NOT NULL,
`Telno` varchar(10) NOT NULL default '',
`Pre_inst` varchar(50) NOT NULL default '',
`Pre_gpa` varchar(5) NOT NULL default '',
`Select_Method` varchar(60) NOT NULL default '',
`Term` varchar(4) NOT NULL default '',
`Date_in` date NOT NULL default '0000-00-00',
`Institute` varchar(100) NOT NULL default '',
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Affect_class` text NOT NULL,
`Scholarship_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Address_cur` varchar(50) NOT NULL default '',
`Coll_in` varchar(100) NOT NULL default '',
`Coll_out` varchar(100) NOT NULL default '',
`Circle_duty` varchar(100) NOT NULL default '',
`Circle` varchar(255) NOT NULL default '',
`Succ_Status` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`code`,`Student_id`),
UNIQUE KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=712 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `subject_category_tb`
--
CREATE TABLE `subject_category_tb` (
`SubCate_code` int(5) unsigned zerofill NOT NULL auto_increment,
`Cate_name` varchar(100) NOT NULL default '',
`Cate_nameE` varchar(100) NOT NULL default '',
PRIMARY KEY (`SubCate_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `subject_group_tb`
--
CREATE TABLE `subject_group_tb` (
`Subject_group` tinyint(5) unsigned zerofill NOT NULL auto_increment,
`SubCate_code` int(5) unsigned zerofill NOT NULL default '00000',
`Eng_name` varchar(255) NOT NULL default '',
`Short_name` varchar(255) NOT NULL default '',
`Thai_name` varchar(255) NOT NULL default '',
`Description` text NOT NULL,
PRIMARY KEY (`Subject_group`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=25 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `subject_tb`
--
CREATE TABLE `subject_tb` (
`Subject_no` int(5) unsigned zerofill NOT NULL auto_increment,
`Course_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`SubCate_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Subject_group` varchar(100) NOT NULL default '00000',
`Subject_code` varchar(50) NOT NULL default '',
`Subject_name` varchar(255) NOT NULL default '',
`Unit` varchar(20) NOT NULL default '0',
`Term` char(1) NOT NULL default '',
`Class_level` varchar(20) NOT NULL default '',
`Total_hour` int(5) NOT NULL default '0',
`Objective` text NOT NULL,
`Detail` text NOT NULL,
`Class_Affect` text NOT NULL,
`Affect_sub` text NOT NULL,
PRIMARY KEY (`Subject_no`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 COMMENT='ҧѹҧѡٵԪ' AUTO_INCREMENT=60 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `teacher_type_tb`
--
CREATE TABLE `teacher_type_tb` (
`Ttype_code` tinyint(5) NOT NULL auto_increment,
`Ttype_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`Ttype_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `teachplan_tb`
--
CREATE TABLE `teachplan_tb` (
`Teach_id` int(4) unsigned NOT NULL auto_increment,
`HN_code` varchar(10) NOT NULL default '0',
`No_code` int(7) NOT NULL default '0',
`Person_code` int(5) unsigned zerofill NOT NULL default '00000',
`Tooth_code` int(2) NOT NULL default '0',
`Teach1` varchar(50) NOT NULL default '',
`Teach2` varchar(50) NOT NULL default '',
`Teach3` varchar(50) NOT NULL default '',
`Teach4` varchar(50) NOT NULL default '',
`Teach5` varchar(50) NOT NULL default '',
`Teach6` varchar(50) NOT NULL default '',
`Teach7` varchar(50) NOT NULL default '',
`Teach8` varchar(50) NOT NULL default '',
`Teach9` varchar(50) NOT NULL default '',
`Teach10` varchar(50) NOT NULL default '',
`Teach11` varchar(50) NOT NULL default '',
`Teach12` varchar(50) NOT NULL default '',
`Teach13` varchar(50) NOT NULL default '',
`Teach_13` varchar(255) NOT NULL default '',
`Tooth_code1` int(2) unsigned NOT NULL default '0',
`Tooth_code3` int(2) unsigned NOT NULL default '0',
`Tooth_code4` int(2) unsigned NOT NULL default '0',
`Tooth_code5` int(2) unsigned NOT NULL default '0',
`Tooth_code6` int(2) unsigned NOT NULL default '0',
`Tooth_code7` int(2) unsigned NOT NULL default '0',
`Tooth_code8` int(2) unsigned NOT NULL default '0',
`Tooth_code11` int(2) unsigned NOT NULL default '0',
`Tooth_code12` int(2) unsigned NOT NULL default '0',
`Religion` varchar(50) NOT NULL default '',
`Code` int(3) NOT NULL default '0',
`Date_1` date NOT NULL default '0000-00-00',
`Date` date NOT NULL default '0000-00-00',
`Time_in` time NOT NULL default '00:00:00',
`Time_out` time NOT NULL default '00:00:00',
`Time` time NOT NULL default '00:00:00',
`Teach_code` int(3) unsigned zerofill NOT NULL default '000',
`Teacher_code` int(5) unsigned zerofill NOT NULL default '00000',
`Flag` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`Teach_id`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=9 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `tech_plan_tb`
--
CREATE TABLE `tech_plan_tb` (
`Plan_code` int(5) unsigned zerofill NOT NULL auto_increment,
`Teacher_code` int(5) unsigned zerofill NOT NULL default '00000',
`Course_code` int(5) unsigned zerofill NOT NULL default '00000',
`Status` tinyint(5) NOT NULL default '0',
`Subject_group` int(5) unsigned zerofill NOT NULL default '00000',
`Subject_no` varchar(50) character set tis620 collate tis620_bin NOT NULL default '0',
`Start_date` date NOT NULL default '0000-00-00',
`Objective` text NOT NULL,
`Mainidea` text NOT NULL,
`Title_name` text NOT NULL,
`Total_hour` int(5) unsigned default NULL,
`Total_std` int(5) unsigned default NULL,
`Assess_code` tinyint(5) unsigned NOT NULL default '0',
`Method_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Place` varchar(255) NOT NULL default '',
`Media` text NOT NULL,
`Appendix` text NOT NULL,
`Res_unit` varchar(5) NOT NULL default '',
`Apply` varchar(5) NOT NULL default '',
`Asses1` float(8,2) NOT NULL default '0.00',
`Asses2` float(8,2) NOT NULL default '0.00',
`Asses3` float(8,2) NOT NULL default '0.00',
`Asses4` float(8,2) NOT NULL default '0.00',
PRIMARY KEY (`Plan_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 COMMENT='ҧἹ' AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `tech_spec_tb`
--
CREATE TABLE `tech_spec_tb` (
`Sptcode` int(11) NOT NULL auto_increment,
`Plan_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Teacher_code` varchar(5) NOT NULL default '',
`Subject_no` varchar(5) NOT NULL default '',
`Sp1` varchar(255) NOT NULL default '',
`Sp2` varchar(255) NOT NULL default '',
`Sp3` varchar(255) NOT NULL default '',
`Sp4` varchar(255) NOT NULL default '',
`Sp5` varchar(255) NOT NULL default '',
`Sp6` varchar(255) NOT NULL default '',
`Sp7` varchar(255) NOT NULL default '',
`Sp8` varchar(255) NOT NULL default '',
`Sp9` varchar(255) NOT NULL default '',
`Sp10` varchar(255) NOT NULL default '',
`Sp11` varchar(255) NOT NULL default '',
`Else_desc` varchar(255) NOT NULL default '',
PRIMARY KEY (`Sptcode`,`Plan_code`,`Teacher_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `techplan_method_tb`
--
CREATE TABLE `techplan_method_tb` (
`code` int(11) NOT NULL auto_increment,
`Plan_code` int(5) unsigned zerofill NOT NULL default '00000',
`Teacher_code` int(5) unsigned zerofill NOT NULL default '00000',
`Subject_no` varchar(255) NOT NULL default '',
`M1` varchar(255) NOT NULL default '',
`M2` varchar(255) NOT NULL default '',
`M3` varchar(255) NOT NULL default '',
`M4` varchar(255) NOT NULL default '',
`M5` varchar(255) NOT NULL default '',
`M6` varchar(255) NOT NULL default '',
`M7` varchar(255) NOT NULL default '',
`M8` varchar(255) NOT NULL default '',
`M9` varchar(255) NOT NULL default '',
`M10` varchar(255) NOT NULL default '',
`M11` varchar(255) NOT NULL default '',
`M12` varchar(255) NOT NULL default '',
`M13` varchar(255) NOT NULL default '',
`M14` varchar(255) NOT NULL default '',
`M15` varchar(255) NOT NULL default '',
`M16` varchar(255) NOT NULL default '',
`M17` varchar(255) NOT NULL default '',
`M18` varchar(255) NOT NULL default '',
`M19` varchar(255) NOT NULL default '',
`M20` varchar(255) NOT NULL default '',
`M21` varchar(255) NOT NULL default '',
`M_else` varchar(255) NOT NULL default '',
`Else_desc` varchar(255) NOT NULL default '',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `tooth_tb`
--
CREATE TABLE `tooth_tb` (
`Tooth_code` int(2) unsigned NOT NULL auto_increment,
`Code_id` varchar(10) NOT NULL default '',
`Description_1` varchar(10) NOT NULL default '',
`Description_2` text NOT NULL,
PRIMARY KEY (`Tooth_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=93 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `training_tb`
--
CREATE TABLE `training_tb` (
`Training_code` int(5) unsigned zerofill NOT NULL auto_increment,
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Training_name` varchar(255) NOT NULL default '',
`Period_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Training_type` int(1) NOT NULL default '0',
`Level` varchar(50) NOT NULL default '',
`Major` varchar(50) NOT NULL default '',
`Year_std` varchar(10) NOT NULL default '',
`Place` varchar(255) NOT NULL default '',
`Place_des` varchar(200) NOT NULL default '',
`Date_start` date NOT NULL default '0000-00-00',
`Date_finish` date NOT NULL default '0000-00-00',
`CNEU` varchar(100) NOT NULL default '',
`Total_hour` int(11) NOT NULL default '0',
`Fund` varchar(100) NOT NULL default '',
`Fund_resource` varchar(100) NOT NULL default '',
`Organiz` varchar(100) NOT NULL default '',
`Date_send` date NOT NULL default '0000-00-00',
`Period_prop` char(1) NOT NULL default '',
`Apply` varchar(100) NOT NULL default '',
PRIMARY KEY (`Training_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 COMMENT='ҧý֡ͺд٧ҹ' AUTO_INCREMENT=268 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `training_type_tb`
--
CREATE TABLE `training_type_tb` (
`Training_type` tinyint(5) unsigned zerofill NOT NULL auto_increment,
`Detail` varchar(100) NOT NULL default '',
PRIMARY KEY (`Training_type`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 COMMENT='ª¹Ô´¡ÒÃÍ&or' AUTO_INCREMENT=6 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `treatcat_tb`
--
CREATE TABLE `treatcat_tb` (
`Code` int(3) unsigned zerofill NOT NULL auto_increment,
`Code_id` varchar(10) NOT NULL default '',
`Description_1` text NOT NULL,
`Description_2` text NOT NULL,
`Description_3` text NOT NULL,
PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=67 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `treatment_tb`
--
CREATE TABLE `treatment_tb` (
`Teach_code` int(3) unsigned zerofill NOT NULL auto_increment,
`Code_1` varchar(10) NOT NULL default '',
`Name` varchar(30) NOT NULL default '',
`Price` float(8,2) NOT NULL default '0.00',
`Description_1` text NOT NULL,
`Description_2` text NOT NULL,
`Description_3` text NOT NULL,
PRIMARY KEY (`Teach_code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=151 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `user_tb`
--
CREATE TABLE `user_tb` (
`code` int(5) NOT NULL auto_increment,
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Username` varchar(30) NOT NULL default '',
`Password` varchar(50) NOT NULL default '',
`PasswordR` varchar(100) NOT NULL default '',
`Priority` varchar(10) NOT NULL default '',
`Flag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=270 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `webboard_ans`
--
CREATE TABLE `webboard_ans` (
`No` int(5) NOT NULL auto_increment,
`QuestionNo` int(5) NOT NULL default '0',
`Name` varchar(50) NOT NULL default '',
`Namer` varchar(50) NOT NULL default '',
`Member` tinyint(1) NOT NULL default '0',
`IP` varchar(15) NOT NULL default '',
`Email` varchar(50) NOT NULL default '',
`Msg` text NOT NULL,
`Date` datetime default NULL,
`nphoto` text,
PRIMARY KEY (`No`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=1299 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `webboard_data`
--
CREATE TABLE `webboard_data` (
`No` int(5) NOT NULL auto_increment,
`Category` varchar(50) NOT NULL default '',
`Question` varchar(100) NOT NULL default '',
`Note` text NOT NULL,
`Name` varchar(50) NOT NULL default '',
`Namer` varchar(50) NOT NULL default '',
`Member` tinyint(1) NOT NULL default '0',
`Memberr` varchar(50) NOT NULL default '',
`IP` varchar(15) NOT NULL default '',
`Email` varchar(50) NOT NULL default '',
`Reply` int(5) NOT NULL default '0',
`ReplyDate` varchar(20) NOT NULL default '',
`Date` datetime default NULL,
`nphoto` varchar(50) default NULL,
`pageview` char(3) default '0',
PRIMARY KEY (`No`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=71 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `webboard_member`
--
CREATE TABLE `webboard_member` (
`id` int(6) NOT NULL auto_increment,
`User` varchar(10) NOT NULL default '',
`Password` varchar(10) NOT NULL default '',
`Email` varchar(30) default NULL,
`ICQ` varchar(15) default NULL,
`WebName` varchar(80) default NULL,
`URL` varchar(80) default NULL,
`Date` datetime default NULL,
`BDdate` varchar(20) NOT NULL default '',
`Profile` text,
`memphoto` varchar(50) default NULL,
`IP` varchar(16) default NULL,
`icon` varchar(8) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=10 ;
-- --------------------------------------------------------
--
-- โครงสร้างตาราง `webboard_online`
--
CREATE TABLE `webboard_online` (
`SID` varchar(100) NOT NULL default '',
`time` varchar(15) NOT NULL default '',
`day` char(3) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=tis620;
DROP TABLE IF EXISTS `user_tb`;
CREATE TABLE `user_tb` (
`code` int(5) NOT NULL auto_increment,
`Teacher_code` tinyint(5) unsigned zerofill NOT NULL default '00000',
`Username` varchar(30) NOT NULL default '',
`Password` varchar(50) NOT NULL default '',
`PasswordR` varchar(100) NOT NULL default '',
`Priority` varchar(10) NOT NULL default '',
`Flag` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 AUTO_INCREMENT=270 ;
--
-- dump ҧ `user_tb`
--
INSERT INTO `user_tb` (`code`, `Teacher_code`, `Username`, `Password`, `PasswordR`, `Priority`, `Flag`) VALUES (1, 00000, 'admin', '0b22ee6a8ec8156a0b22706b22df4795', '288490', '1', 0),
(2, 00000, 'manage', '208f565794201e6812b9140d4c383ccf', '275664', '3', 0),
(3, 00000, 'research', '208f565794201e6812b9140d4c383ccf', '275664', '4', 0),
(49, 00000, 'stdac', '208f565794201e6812b9140d4c383ccf', '275664', '7', 0),
(5, 00000, 'develop', '6770bca5914eda8b9565e3aac1dccd51', '275663', '5', 0),
(48, 00000, 'guest', '084e0343a0486ff05530df6c705c8bb4', 'guest', '9', 0),
(47, 00000, 'edu', '208f565794201e6812b9140d4c383ccf', '275664', '6', 0),
(51, 00000, 'qa', '8264ee52f589f4c0191aa94f87aa1aeb', 'qa', '8', 0),
(72, 00003, '041056', '876ce4e8869a62fd8f5b544aa1a7f03b', '041056', '2', 1),
(63, 00000, 'director', '4e29c8b74cbd4f0ddea9899dd2e03ee8', '275665', '10', 0),
(260, 00153, '041104', '2f565b5115e2d49f27d8b24d83fe5e54', '041104', '2', 1),
(69, 00000, 'wirat', 'ac73001b1d44f4925449ce09d9f5d5ca', '3266', '9', 0),
(73, 00000, 'dental', '4e29c8b74cbd4f0ddea9899dd2e03ee8', '275665', '15', 0),
--
-- çҧҧ `permission_tb`
--
DROP TABLE IF EXISTS `permission_tb`;
CREATE TABLE `permission_tb` (
`Number` tinyint(5) unsigned zerofill NOT NULL auto_increment,
`permision` int(11) NOT NULL default '0',
`url` varchar(100) NOT NULL default '',
`description` varchar(100) NOT NULL default '',
PRIMARY KEY (`Number`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 COMMENT='permissin Table' AUTO_INCREMENT=17 ;
--
-- dump ҧ `permission_tb`
--
INSERT INTO `permission_tb` (`Number`, `permision`, `url`, `description`) VALUES (00001, 1, 'Location:admin/adminmenu.php', 'к administrator'),
(00002, 2, 'Location:teacher/menu_teacher.php', 'Ҩ Teacher'),
(00003, 3, 'Location:manage_depart/menu_manage.php', 'º Management Officer'),
(00004, 4, 'Location:Research_depart/Menu_Research.php', 'Ԩ Research Department'),
(00005, 5, 'Location:Develop_person_depart/Menu_Develop.php', '¾ѲҺؤҡ Develop person Department'),
(00006, 6, 'Location:edu_depart/Edu_Menu.php', 'Ԫҡ Education Department'),
(00007, 7, 'Location:Std_Acc_depart/Menu_Std_Acc.php', '¡Ԩùѡ֡'),
(00008, 8, 'Location:Qa_depart/Qa_menu.php', '»СѹسҾ֡'),
(00009, 9, 'Location:register/Condition.php', ' guest'),
(00010, 10, 'Location:Director/Director_menu.php', ' ӹ¡'),
(00011, 11, 'Location:comment/index.php', 'Ъѹ'),
(00012, 12, 'Location:Plan_dura/menu_teacher.php', 'Ἱҹоʴ'),
(00013, 13, 'Location:Book_depart/menu_teacher.php', 'ҹúó'),
(00014, 14, 'Location:Monny_depart/menu_teacher.php', 'ҹԹкؤҡ'),
(00015, 15, 'Location:Den/index.php', 'кҹѹ'),
(00016, 16, 'Location:State/index.php', 'кǺԹҳ');
|