-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
-- 
-- 主機: localhost
-- 建立日期: Nov 23, 2007, 08:21 AM
-- 伺服器版本: 5.0.45
-- PHP 版本: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- 資料庫: `sfs4_develop`
-- 

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

-- 
-- 資料表格式： `health_addon`
-- 

CREATE TABLE `health_addon` (
  `sn` int(10) unsigned NOT NULL auto_increment COMMENT '流水號',
  `student_sn` int(10) unsigned NOT NULL COMMENT '學生流水號',
  `year` tinyint(2) unsigned default NULL COMMENT '學年',
  `semester` tinyint(2) unsigned default NULL COMMENT '學期',
  `grade` tinyint(2) unsigned default NULL COMMENT '就讀年級',
  `date` date default NULL COMMENT '檢查日期',
  `item_id` tinyint(3) unsigned default NULL COMMENT '檢查項目代號',
  `result_id` tinyint(3) unsigned default NULL COMMENT '總評建議',
  `track` varchar(60) default NULL COMMENT '複查追蹤',
  `hospital` varchar(30) default NULL COMMENT '醫事人員',
  `teacher_sn` int(10) unsigned default NULL COMMENT '紀錄教師流水號',
  `update_time` timestamp NULL default CURRENT_TIMESTAMP COMMENT '更新時間',
  PRIMARY KEY  (`sn`),
  KEY `student_sn` (`student_sn`),
  KEY `year` (`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='學生臨時性檢查紀錄' AUTO_INCREMENT=1 ;

-- 
-- 列出以下資料庫的數據： `health_addon`
-- 


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

-- 
-- 資料表格式： `health_disease_familial`
-- 

CREATE TABLE `health_disease_familial` (
  `sn` int(10) unsigned NOT NULL auto_increment COMMENT '流水號',
  `student_sn` int(10) unsigned NOT NULL COMMENT '學生流水號',
  `appellation` varchar(20) NOT NULL COMMENT '親屬稱謂',
  `disease_id` tinyint(2) unsigned NOT NULL COMMENT '遺傳性疾病代號',
  `update_sn` int(11) NOT NULL COMMENT '更新者流水號',
  `update_time` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '更新時間',
  PRIMARY KEY  (`sn`),
  KEY `student_sn` (`student_sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='學生家族遺傳性疾病' AUTO_INCREMENT=1 ;

-- 
-- 列出以下資料庫的數據： `health_disease_familial`
-- 


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

-- 
-- 資料表格式： `health_disease_personal`
-- 

CREATE TABLE `health_disease_personal` (
  `sn` int(10) unsigned NOT NULL auto_increment COMMENT '流水號',
  `student_sn` int(10) unsigned NOT NULL COMMENT '學生流水號',
  `disease_id` tinyint(4) unsigned NOT NULL COMMENT '疾病代號',
  `description` text NOT NULL COMMENT '病況描述',
  `care` text NOT NULL COMMENT '照顧描述',
  `update_sn` int(10) unsigned NOT NULL COMMENT '教師流水號',
  `update_time` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '更新時間',
  PRIMARY KEY  (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='個人疾病史' AUTO_INCREMENT=1 ;

-- 
-- 列出以下資料庫的數據： `health_disease_personal`
-- 


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

-- 
-- 資料表格式： `health_disease_serious`
-- 

CREATE TABLE `health_disease_serious` (
  `sn` int(10) unsigned NOT NULL auto_increment COMMENT '流水號',
  `student_sn` int(10) unsigned NOT NULL COMMENT '學生流水號',
  `year` tinyint(2) unsigned NOT NULL COMMENT '學年',
  `semester` tinyint(2) unsigned NOT NULL COMMENT '學期',
  `grade` tinyint(2) unsigned NOT NULL COMMENT '年級',
  `ill_certification` enum('Y','N') NOT NULL COMMENT '領有重大傷病證明卡',
  `disability_certification` enum('Y','N') NOT NULL COMMENT '領有身心障礙手冊',
  `disability_grade` tinyint(2) NOT NULL COMMENT '傷殘等級',
  `insurance` tinyint(2) NOT NULL COMMENT '參加保險',
  `update_sn` int(10) unsigned NOT NULL COMMENT '更新者流水號',
  `update_time` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '更新日期',
  PRIMARY KEY  (`sn`),
  KEY `year` (`year`),
  KEY `student_sn` (`student_sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='學生重大傷病資料' AUTO_INCREMENT=1 ;

-- 
-- 列出以下資料庫的數據： `health_disease_serious`
-- 


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

-- 
-- 資料表格式： `health_harm&sickness`
-- 

CREATE TABLE `health_harm&sickness` (
  `sn` int(10) unsigned NOT NULL auto_increment COMMENT '流水號',
  `student_sn` int(10) unsigned NOT NULL COMMENT '學生流水號',
  `year` tinyint(2) unsigned default NULL COMMENT '學年',
  `semester` tinyint(2) unsigned default NULL COMMENT '學期',
  `grade` tinyint(2) unsigned default NULL COMMENT '就讀年級',
  `place` varchar(30) default NULL COMMENT '發生地點',
  `datetime` datetime default NULL COMMENT '發生日期時間',
  `description_condiction` text COMMENT '學生狀況描述',
  `description_disposal` text COMMENT '處理情形',
  `teacher_sn` int(10) unsigned default NULL COMMENT '紀錄教師流水號',
  `update_time` timestamp NULL default CURRENT_TIMESTAMP COMMENT '更新時間',
  PRIMARY KEY  (`sn`),
  KEY `student_sn` (`student_sn`),
  KEY `year` (`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='學生在學期間重大傷病事故' AUTO_INCREMENT=1 ;

-- 
-- 列出以下資料庫的數據： `health_harm&sickness`
-- 


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

-- 
-- 資料表格式： `health_inoculation`
-- 

CREATE TABLE `health_inoculation` (
  `sn` int(10) unsigned NOT NULL auto_increment COMMENT '流水號',
  `student_sn` int(10) unsigned NOT NULL COMMENT '學生流水號',
  `year` tinyint(2) unsigned default NULL COMMENT '學年',
  `semester` tinyint(2) unsigned default NULL COMMENT '學期',
  `grade` tinyint(2) unsigned default NULL COMMENT '就讀年級',
  `date` date default NULL COMMENT '檢查日期',
  `hospital` varchar(30) default NULL COMMENT '接種單位',
  `bacterin_id` tinyint(2) unsigned default NULL COMMENT '疫苗代號',
  `kind_id` tinyint(2) unsigned NOT NULL COMMENT '劑別',
  `teacher_sn` int(10) unsigned default NULL COMMENT '紀錄教師流水號',
  `update_time` timestamp NULL default CURRENT_TIMESTAMP COMMENT '更新時間',
  PRIMARY KEY  (`sn`),
  KEY `student_sn` (`student_sn`),
  KEY `year` (`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='學生預防接種紀錄' AUTO_INCREMENT=1 ;

-- 
-- 列出以下資料庫的數據： `health_inoculation`
-- 


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

-- 
-- 資料表格式： `health_lab_enterobiasis`
-- 

CREATE TABLE `health_lab_enterobiasis` (
  `sn` int(10) unsigned NOT NULL auto_increment COMMENT '流水號',
  `student_sn` int(10) unsigned NOT NULL COMMENT '學生流水號',
  `year` tinyint(2) unsigned NOT NULL COMMENT '學年',
  `semester` tinyint(2) unsigned NOT NULL COMMENT '學期',
  `grade` tinyint(2) unsigned NOT NULL COMMENT '年級',
  `date` date default NULL COMMENT '初查日期',
  `result_id` tinyint(4) default NULL COMMENT '初查結果',
  `teacher_sn` int(10) unsigned default NULL COMMENT '紀錄教師流水號',
  `update_time` timestamp NULL default CURRENT_TIMESTAMP COMMENT '更新時間',
  PRIMARY KEY  (`sn`),
  KEY `year` (`year`),
  KEY `student_sn` (`student_sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='學生蟯蟲檢查紀錄' AUTO_INCREMENT=1 ;

-- 
-- 列出以下資料庫的數據： `health_lab_enterobiasis`
-- 


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

-- 
-- 資料表格式： `health_lab_urine`
-- 

CREATE TABLE `health_lab_urine` (
  `sn` int(10) unsigned NOT NULL auto_increment COMMENT '流水號',
  `student_sn` int(10) unsigned NOT NULL COMMENT '學生流水號',
  `year` tinyint(2) unsigned default NULL COMMENT '學年',
  `semester` tinyint(2) unsigned default NULL COMMENT '學期',
  `grade` tinyint(2) unsigned default NULL COMMENT '就讀年級',
  `date` date default NULL COMMENT '初查日期',
  `albuminuria` float unsigned default NULL COMMENT '初查-尿蛋白',
  `occult_blood` float default NULL COMMENT '初查-潛血',
  `glucosuria` float default NULL COMMENT '初查-尿糖',
  `PH` float default NULL COMMENT '初查-酸鹼度',
  `result_id` tinyint(4) default NULL COMMENT '初查結果',
  `date_reexamine` date default NULL COMMENT '複查日期',
  `albuminuria_reexamine` float default NULL COMMENT '複查-尿蛋白',
  `occult_blood _reexamine` float default NULL COMMENT '複查-潛血',
  `glucosuria_reexamine` float default NULL COMMENT '複查-尿糖',
  `PH_reexamine` float default NULL COMMENT '複查-酸鹼度',
  `result_id_reexamine` tinyint(2) unsigned default NULL COMMENT '複查結果',
  `teacher_sn` int(10) unsigned default NULL COMMENT '紀錄教師流水號',
  `update_time` timestamp NULL default CURRENT_TIMESTAMP COMMENT '更新時間',
  PRIMARY KEY  (`sn`),
  KEY `student_sn` (`student_sn`),
  KEY `year` (`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='學生尿液檢查紀錄' AUTO_INCREMENT=1 ;

-- 
-- 列出以下資料庫的數據： `health_lab_urine`
-- 


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

-- 
-- 資料表格式： `health_modeling`
-- 

CREATE TABLE `health_modeling` (
  `sn` int(10) unsigned NOT NULL auto_increment COMMENT '流水號',
  `student_sn` int(10) unsigned NOT NULL COMMENT '學生流水號',
  `year` tinyint(2) unsigned default NULL COMMENT '學年',
  `semester` tinyint(2) unsigned default NULL COMMENT '學期',
  `grade` tinyint(2) unsigned default NULL COMMENT '就讀年級',
  `date` date default NULL COMMENT '檢查日期',
  `result` varchar(30) default NULL COMMENT '處理情形',
  `teacher_sn` int(10) unsigned default NULL COMMENT '紀錄教師流水號',
  `update_time` timestamp NULL default CURRENT_TIMESTAMP COMMENT '更新時間',
  PRIMARY KEY  (`sn`),
  KEY `student_sn` (`student_sn`),
  KEY `year` (`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='學生新生立體感檢查結果' AUTO_INCREMENT=1 ;

-- 
-- 列出以下資料庫的數據： `health_modeling`
-- 


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

-- 
-- 資料表格式： `health_physic`
-- 

CREATE TABLE `health_physic` (
  `student_sn` int(10) unsigned NOT NULL COMMENT '學生流水號',
  `year` tinyint(2) unsigned default NULL COMMENT '學年',
  `semester` tinyint(2) unsigned default NULL COMMENT '學期',
  `grade` tinyint(2) unsigned default NULL COMMENT '就讀年級',
  `date` date default NULL COMMENT '檢查日期',
  `color` tinyint(2) unsigned default NULL COMMENT '辨色力異常',
  `strabismus` tinyint(2) unsigned default NULL COMMENT '斜視',
  `eyelashes` tinyint(2) unsigned default NULL COMMENT '睫毛倒插',
  `nystagmus` tinyint(2) unsigned default NULL COMMENT '眼球震顫',
  `eyelid` tinyint(2) unsigned default NULL COMMENT '眼瞼下垂',
  `eye_others` varchar(20) default NULL COMMENT '眼其它',
  `eye_others_result` tinyint(2) unsigned default NULL COMMENT '結果_眼其它',
  `hearing_right` tinyint(2) unsigned default NULL COMMENT '右耳聽力',
  `hearing_left` tinyint(2) unsigned default NULL COMMENT '左耳聽力',
  `tympanitis` tinyint(2) unsigned default NULL COMMENT '中耳炎',
  `abnormity` tinyint(2) unsigned default NULL COMMENT '耳道畸型',
  `harelip` tinyint(2) unsigned default NULL COMMENT '唇額裂',
  `audition` tinyint(2) unsigned default NULL COMMENT '構音異常',
  `irritation` tinyint(2) unsigned default NULL COMMENT '耳前?管',
  `embolism` tinyint(2) unsigned default NULL COMMENT '耵聹栓塞',
  `rhinitis_chronic` tinyint(2) unsigned default NULL COMMENT '慢性鼻炎',
  `rhinitis_allergic` tinyint(2) unsigned default NULL COMMENT '過敏性鼻炎',
  `tonsil` tinyint(2) unsigned default NULL COMMENT '扁桃腺腫大',
  `ent_others` varchar(20) default NULL COMMENT '耳鼻喉其它',
  `ent_others_result` tinyint(2) unsigned default NULL COMMENT '結果_耳鼻喉其它',
  `torticollis` tinyint(2) unsigned default NULL COMMENT '斜頸',
  `goiter` tinyint(2) unsigned default NULL COMMENT '甲狀腺腫',
  `lymphadenoma` tinyint(2) unsigned default NULL COMMENT '淋巴腺腫大',
  `neck_others` varchar(20) default NULL COMMENT '頭頸其它',
  `neck_others_result` tinyint(2) unsigned default NULL COMMENT '結果_頭頸其它',
  `ribcage` tinyint(2) unsigned default NULL COMMENT '胸廓異常',
  `murmur` tinyint(2) unsigned default NULL COMMENT '心雜音',
  `arrhythmia` tinyint(2) unsigned default NULL COMMENT '心律不整',
  `breathing` tinyint(2) unsigned default NULL COMMENT '呼吸聲異常',
  `chest_others` varchar(20) default NULL COMMENT '胸部其它',
  `chest_others_result` tinyint(2) unsigned default NULL COMMENT '結果_胸部其它',
  `hepatomegaly` tinyint(2) unsigned default NULL COMMENT '肝脾腫大',
  `hernia` tinyint(2) unsigned default NULL COMMENT '疝氣',
  `abdomen_others` varchar(20) default NULL COMMENT '腹部其它',
  `abdomen_others_result` tinyint(2) unsigned default NULL COMMENT '結果_腹部其它',
  `scoliosis` tinyint(2) unsigned default NULL COMMENT '脊柱側彎',
  `surplus` tinyint(2) unsigned default NULL COMMENT '多併指',
  `frog` tinyint(2) unsigned default NULL COMMENT '青蛙肢',
  `joints` tinyint(2) unsigned default NULL COMMENT '關節變形',
  `edema` tinyint(2) unsigned default NULL COMMENT '水腫',
  `procreation_others` varchar(20) default NULL COMMENT '泌尿生殖其它',
  `procreation_others_result` tinyint(2) unsigned default NULL COMMENT '結果_泌尿生殖其它',
  `testis` tinyint(2) unsigned default NULL COMMENT '隱睪',
  `hematocele` tinyint(2) unsigned default NULL COMMENT '陰囊腫大',
  `foreskin` tinyint(2) unsigned default NULL COMMENT '包皮異常',
  `varicocele` tinyint(3) unsigned NOT NULL COMMENT '精索靜脈曲張',
  `spine_others` varchar(20) default NULL COMMENT '其它',
  `spine_others_result` tinyint(2) unsigned default NULL COMMENT '結果_其它',
  `tinea` tinyint(2) unsigned default NULL COMMENT '癬',
  `wart` tinyint(2) unsigned default NULL COMMENT '疣',
  `scabies` tinyint(2) unsigned default NULL COMMENT '疥瘡',
  `spots` tinyint(2) unsigned default NULL COMMENT '紫斑',
  `eczema` tinyint(3) unsigned NOT NULL COMMENT '濕疹',
  `dermatitis` tinyint(3) unsigned default NULL COMMENT '異位性皮膚炎',
  `skin_others` varchar(20) default NULL COMMENT '皮膚其它',
  `skin_others_result` tinyint(2) unsigned default NULL COMMENT '結果_皮膚其它',
  `caries` tinyint(2) unsigned default NULL COMMENT '齲齒',
  `snag` tinyint(2) unsigned default NULL COMMENT '缺牙',
  `insalutary` tinyint(2) unsigned default NULL COMMENT '口腔衛生不良',
  `concretion` tinyint(2) unsigned default NULL COMMENT '牙結石',
  `periodontitis` tinyint(2) unsigned NOT NULL COMMENT '牙周炎',
  `occlude` tinyint(2) unsigned default NULL COMMENT '齒列咬合',
  `gingivitis` tinyint(2) unsigned default NULL COMMENT '牙齦炎',
  `roupy` tinyint(2) unsigned default NULL COMMENT '口腔黏膜異常',
  `oral_others` varchar(20) default NULL COMMENT '口腔其它',
  `oral_others_result` tinyint(2) unsigned default NULL COMMENT '結果_口腔其它',
  `tooth11` tinyint(2) unsigned default NULL COMMENT '牙齒11',
  `tooth12` tinyint(2) unsigned default NULL COMMENT '牙齒12',
  `tooth13` tinyint(2) unsigned default NULL COMMENT '牙齒13',
  `tooth14` tinyint(2) unsigned default NULL COMMENT '牙齒14',
  `tooth15` tinyint(2) unsigned default NULL COMMENT '牙齒15',
  `tooth16` tinyint(2) unsigned default NULL COMMENT '牙齒16',
  `tooth17` tinyint(2) unsigned default NULL COMMENT '牙齒17',
  `tooth18` tinyint(2) unsigned default NULL COMMENT '牙齒18',
  `tooth21` tinyint(2) unsigned default NULL COMMENT '牙齒21',
  `tooth22` tinyint(2) unsigned default NULL COMMENT '牙齒22',
  `tooth23` tinyint(2) unsigned default NULL COMMENT '牙齒23',
  `tooth24` tinyint(2) unsigned default NULL COMMENT '牙齒24',
  `tooth25` tinyint(2) unsigned default NULL COMMENT '牙齒25',
  `tooth26` tinyint(2) unsigned default NULL COMMENT '牙齒26',
  `tooth27` tinyint(2) unsigned default NULL COMMENT '牙齒27',
  `tooth28` tinyint(2) unsigned default NULL COMMENT '牙齒28',
  `tooth31` tinyint(2) unsigned default NULL COMMENT '牙齒31',
  `tooth32` tinyint(2) unsigned default NULL COMMENT '牙齒32',
  `tooth33` tinyint(2) unsigned default NULL COMMENT '牙齒33',
  `tooth34` tinyint(2) unsigned default NULL COMMENT '牙齒34',
  `tooth35` tinyint(2) unsigned default NULL COMMENT '牙齒35',
  `tooth36` tinyint(2) unsigned default NULL COMMENT '牙齒36',
  `tooth37` tinyint(2) unsigned default NULL COMMENT '牙齒37',
  `tooth38` tinyint(2) unsigned default NULL COMMENT '牙齒38',
  `tooth41` tinyint(2) unsigned default NULL COMMENT '牙齒41',
  `tooth42` tinyint(2) unsigned default NULL COMMENT '牙齒42',
  `tooth43` tinyint(2) unsigned default NULL COMMENT '牙齒43',
  `tooth44` tinyint(2) unsigned default NULL COMMENT '牙齒44',
  `tooth45` tinyint(2) unsigned default NULL COMMENT '牙齒45',
  `tooth46` tinyint(2) unsigned default NULL COMMENT '牙齒46',
  `tooth47` tinyint(2) unsigned default NULL COMMENT '牙齒47',
  `tooth48` tinyint(2) unsigned default NULL COMMENT '牙齒48',
  `tooth51` tinyint(2) unsigned default NULL COMMENT '牙齒51',
  `tooth52` tinyint(2) unsigned default NULL COMMENT '牙齒52',
  `tooth53` tinyint(2) unsigned default NULL COMMENT '牙齒53',
  `tooth54` tinyint(2) unsigned default NULL COMMENT '牙齒54',
  `tooth55` tinyint(2) unsigned default NULL COMMENT '牙齒55',
  `tooth61` tinyint(2) unsigned default NULL COMMENT '牙齒61',
  `tooth62` tinyint(2) unsigned default NULL COMMENT '牙齒62',
  `tooth63` tinyint(2) unsigned default NULL COMMENT '牙齒63',
  `tooth64` tinyint(2) unsigned default NULL COMMENT '牙齒64',
  `tooth65` tinyint(2) unsigned default NULL COMMENT '牙齒65',
  `tooth71` tinyint(2) unsigned default NULL COMMENT '牙齒71',
  `tooth72` tinyint(2) unsigned default NULL COMMENT '牙齒72',
  `tooth73` tinyint(2) unsigned default NULL COMMENT '牙齒73',
  `tooth74` tinyint(2) unsigned default NULL COMMENT '牙齒74',
  `tooth75` tinyint(2) unsigned default NULL COMMENT '牙齒75',
  `tooth81` tinyint(2) unsigned default NULL COMMENT '牙齒81',
  `tooth82` tinyint(2) unsigned default NULL COMMENT '牙齒82',
  `tooth83` tinyint(2) unsigned default NULL COMMENT '牙齒83',
  `tooth84` tinyint(2) unsigned default NULL COMMENT '牙齒84',
  `tooth85` tinyint(2) unsigned default NULL COMMENT '牙齒85',
  `physician` varchar(30) default NULL COMMENT '醫事人員',
  `hospital` varchar(30) default NULL COMMENT '醫療單位',
  `teacher_sn` int(10) unsigned NOT NULL COMMENT '教師流水號',
  `update_time` timestamp NOT NULL default CURRENT_TIMESTAMP COMMENT '更新時間',
  PRIMARY KEY  (`student_sn`),
  KEY `year` (`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='學生體檢紀錄';

-- 
-- 列出以下資料庫的數據： `health_physic`
-- 


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

-- 
-- 資料表格式： `health_regular_growth`
-- 

CREATE TABLE `health_regular_growth` (
  `sn` int(10) unsigned NOT NULL auto_increment COMMENT '流水號',
  `student_sn` int(10) unsigned NOT NULL COMMENT '學生流水號',
  `year` tinyint(3) unsigned NOT NULL COMMENT '學年',
  `semester` tinyint(3) unsigned NOT NULL COMMENT '學期',
  `grade` tinyint(3) unsigned NOT NULL COMMENT '年級',
  `height` float unsigned default NULL COMMENT '身高',
  `weight` float unsigned default NULL COMMENT '體重',
  `indicator` text COMMENT '評值',
  `diagnostic_id` tinyint(4) unsigned default NULL COMMENT '診斷代碼',
  `diagnostic_description` text NOT NULL COMMENT '診斷',
  `BMI` float unsigned NOT NULL COMMENT 'BMI指數',
  `constitution_id` tinyint(2) unsigned default NULL COMMENT '體位代號',
  `Ghd` float NOT NULL COMMENT 'Ghd指標',
  PRIMARY KEY  (`sn`),
  KEY `student_sn` (`student_sn`),
  KEY `year` (`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='學生生長發育紀錄' AUTO_INCREMENT=1 ;

-- 
-- 列出以下資料庫的數據： `health_regular_growth`
-- 


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

-- 
-- 資料表格式： `health_regular_sight`
-- 

CREATE TABLE `health_regular_sight` (
  `sn` int(10) unsigned NOT NULL auto_increment COMMENT '流水號',
  `student_sn` int(10) unsigned NOT NULL COMMENT '學生流水號',
  `year` tinyint(2) unsigned default NULL COMMENT '學年',
  `semester` tinyint(2) unsigned default NULL COMMENT '學期',
  `grade` tinyint(2) unsigned default NULL COMMENT '就讀年級',
  `right_original` float default NULL COMMENT '裸視-右眼',
  `left_original` float default NULL COMMENT '裸視-左眼',
  `right_corrected` float default NULL COMMENT '矯正-右眼',
  `left_corrected` float default NULL COMMENT '矯正-左眼',
  `myopic` enum('Y','N') default NULL COMMENT '近視',
  `hyperopic` enum('Y','N') default NULL COMMENT '遠視',
  `astigmatic` enum('Y','N') default NULL COMMENT '散光',
  `amblyopic` enum('Y','N') default NULL COMMENT '弱視',
  `others` varchar(30) default NULL COMMENT '視力_其它',
  `dispose_id` varchar(10) default NULL COMMENT '處置代號',
  PRIMARY KEY  (`sn`),
  KEY `student_sn` (`student_sn`),
  KEY `year` (`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='學生視力檢查紀錄' AUTO_INCREMENT=1 ;

-- 
-- 列出以下資料庫的數據： `health_regular_sight`
-- 


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

-- 
-- 資料表格式： `health_summary`
-- 

CREATE TABLE `health_summary` (
  `student_sn` int(10) unsigned NOT NULL COMMENT '學生流水號',
  `completed` varchar(50) default NULL COMMENT '完成複查',
  `tracked` varchar(50) default NULL COMMENT '持續追蹤',
  `summary` text COMMENT '個案管理摘要',
  `teacher_sn` int(10) unsigned default NULL COMMENT '紀錄教師流水號',
  `update_time` timestamp NULL default CURRENT_TIMESTAMP COMMENT '更新時間',
  PRIMARY KEY  (`student_sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='學生健康管理綜合紀錄';