健康系統資料表規畫
-- 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='學生健康管理綜合紀錄';
