suifang.sql

来自「Delphi 控件源码」· SQL 代码 · 共 404 行 · 第 1/2 页

  `ZYYSXM` varchar(32) NOT NULL,
  `HSZGH` varchar(16) default NULL,
  `HSZXM` varchar(32) default NULL,
  `BAZL` char(1) NOT NULL,
  `BLH` varchar(32) default NULL,
  `ZMZCYZD` char(1) default NULL,
  `ZRYCYZD` char(1) default NULL,
  `SWGBYY` text,
  `SWSJ` datetime default NULL,
  `MZYSGH` varchar(16) default NULL,
  `MZYSXM` varchar(32) default NULL,
  `SYFY` char(1) default NULL,
  `SFKYBA` char(1) default NULL,
  `JSF` double(15,3) default NULL,
  `YEF` double(15,3) default NULL,
  `FSF` double(15,3) default NULL,
  `MZF` double(15,3) default NULL,
  `PCF` double(15,3) default NULL,
  `ZILIF` double(15,3) default NULL,
  `MJ` varchar(16) default NULL,
  `XGBZ` char(1) NOT NULL,
  `BFSJ` datetime NOT NULL,
  `BASYLX` varchar(2) default NULL,
  `SZBQ` varchar(128) default NULL,
  `BMYXM` varchar(32) default NULL,
  `ZLZXM` varchar(32) default NULL,
  `YLYL1` varchar(128) default NULL,
  `YLYL2` varchar(128) default NULL,
  PRIMARY KEY  (`JZLSH`,`YLJGDM`,`BFSJ`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for tb_cis_operation_detail
-- ----------------------------
DROP TABLE IF EXISTS `tb_cis_operation_detail`;
CREATE TABLE `tb_cis_operation_detail` (
  `SSMXLSH` varchar(32) NOT NULL,
  `YLJGDM` varchar(11) NOT NULL,
  `JZLSH` varchar(32) NOT NULL,
  `SSCZBM` varchar(10) NOT NULL,
  `SSQZD` varchar(10) default NULL,
  `SSHZD` varchar(10) default NULL,
  `SSSJ` datetime NOT NULL,
  `SSYSGH` varchar(16) NOT NULL,
  `SSYSXM` varchar(32) NOT NULL,
  `SSYSZ1GH` varchar(16) default NULL,
  `SSYSZ1XM` varchar(32) NOT NULL,
  `SSYSZ2GH` varchar(16) default NULL,
  `SSYSZ2XM` varchar(32) default NULL,
  `MZYSGH` varchar(16) default NULL,
  `MZYSXM` varchar(32) NOT NULL,
  `MZFS` char(1) NOT NULL,
  `QKYHDJ` varchar(3) NOT NULL,
  `MJ` varchar(16) default NULL,
  `XGBZ` char(1) NOT NULL,
  `BFSJ` datetime NOT NULL,
  `SSCZMC` varchar(64) default NULL,
  `YLYL1` varchar(128) default NULL,
  PRIMARY KEY  (`SSMXLSH`,`YLJGDM`,`BFSJ`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for tb_directed_attendance
-- ----------------------------
DROP TABLE IF EXISTS `tb_directed_attendance`;
CREATE TABLE `tb_directed_attendance` (
  `KH` varchar(64) NOT NULL default '0',
  `tb_issued_id` varchar(11) NOT NULL,
  `tb_implementation_id` varchar(11) NOT NULL,
  `tb_dir_att_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tb_follow_target
-- ----------------------------
DROP TABLE IF EXISTS `tb_follow_target`;
CREATE TABLE `tb_follow_target` (
  `tb_target_id` int(11) NOT NULL,
  `tb_target_nm` varchar(50) default NULL,
  `tb_target_emark` varchar(50) default NULL,
  PRIMARY KEY  (`tb_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tb_follow_target_grouping
-- ----------------------------
DROP TABLE IF EXISTS `tb_follow_target_grouping`;
CREATE TABLE `tb_follow_target_grouping` (
  `follow_target_group_id` int(11) NOT NULL auto_increment,
  `follow_target_nm` varchar(50) NOT NULL,
  `follow_target_remark` varchar(100) default NULL,
  PRIMARY KEY  (`follow_target_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for tb_follow_up_data
-- ----------------------------
DROP TABLE IF EXISTS `tb_follow_up_data`;
CREATE TABLE `tb_follow_up_data` (
  `Follow_up_id` int(11) NOT NULL auto_increment,
  `KH` varchar(64) NOT NULL,
  `Follow_up_content` varchar(2000) default NULL,
  `Follow_up_date` date default NULL,
  `follow_up_state` char(255) default NULL,
  `tb_issued_id` varchar(11) NOT NULL,
  `follow_up_input_nm` varchar(32) default NULL,
  `follow_up_input_date` date default NULL,
  `follow_up_input_remark` varchar(100) default NULL,
  PRIMARY KEY  (`Follow_up_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for tb_medical_staff
-- ----------------------------
DROP TABLE IF EXISTS `tb_medical_staff`;
CREATE TABLE `tb_medical_staff` (
  `tb_issued_id` varchar(11) NOT NULL,
  `password` varchar(255) default NULL,
  `tb_med_sta_nm` varchar(32) NOT NULL,
  `tb_med_sta_type` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tb_yl_medical_record
-- ----------------------------
DROP TABLE IF EXISTS `tb_yl_medical_record`;
CREATE TABLE `tb_yl_medical_record` (
  `JZLSH` varchar(32) NOT NULL,
  `YLJGDM` varchar(11) NOT NULL,
  `KH` varchar(64) NOT NULL,
  `KLX` varchar(16) NOT NULL,
  `HZXM` varchar(32) NOT NULL,
  `HZSX` varchar(20) NOT NULL,
  `JZLX` varchar(3) NOT NULL,
  `JZKSBM` varchar(15) NOT NULL,
  `JZKSMC` varchar(30) NOT NULL,
  `JZKSRQ` varchar(8) NOT NULL,
  `JZZDBM` varchar(10) default NULL,
  `BMLX` varchar(2) default NULL,
  `JZZDSM` text,
  `JZBZ` varchar(16) NOT NULL,
  `ZYJSSJ` datetime default NULL,
  `XGBZ` char(1) NOT NULL,
  `MJ` varchar(16) default NULL,
  `BFSJ` datetime NOT NULL,
  `YXSCBZ` varchar(16) default NULL,
  `YLYL1` varchar(128) default NULL,
  `YLYL2` varchar(128) default NULL,
  PRIMARY KEY  (`JZLSH`,`YLJGDM`,`BFSJ`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for tb_yl_patient_information
-- ----------------------------
DROP TABLE IF EXISTS `tb_yl_patient_information`;
CREATE TABLE `tb_yl_patient_information` (
  `p_id` int(11) NOT NULL auto_increment,
  `XM` varchar(32) character set utf8 NOT NULL default '',
  `KH` varchar(64) NOT NULL default '',
  `Follow_up_id` int(11) default NULL,
  `XB` char(1) default NULL,
  PRIMARY KEY  (`KH`),
  UNIQUE KEY `tb_yl_patient_information` (`p_id`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for usr_role
-- ----------------------------
DROP TABLE IF EXISTS `usr_role`;
CREATE TABLE `usr_role` (
  `h_gh` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `usr_role_id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`usr_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `cap_role` VALUES ('3', '1', '28'), ('3', '4', '29'), ('3', '5', '30'), ('3', '6', '31'), ('2', '3', '32'), ('2', '5', '33'), ('2', '6', '34'), ('1', '2', '35'), ('1', '5', '36'), ('1', '6', '37'), ('4', '5', '38'), ('4', '6', '39'), ('4', '7', '40'), ('5', '8', '41'), ('3', '9', '42'), ('1', '9', '43'), ('2', '9', '44'), ('4', '9', '45'), ('5', '9', '46'), ('3', '10', '47');
INSERT INTO `caption` VALUES ('1', 'N1', '系统'), ('2', 'N2', '医生工具'), ('3', 'N3', '研究人员'), ('4', 'N4', '管理员'), ('5', 'N5', '设置'), ('6', 'N6', '联系我们'), ('7', 'N21', '护士'), ('8', 'N11', '数据库管理'), ('9', 'N13', '帮助'), ('10', 'N24', '系统设置');
INSERT INTO `health_care_workers` VALUES ('1', '123', 'ban', 'ban', '42500982800', null, null, null), ('2', '163', '范秀兰', '111', '42500982800', '', '', ''), ('3', '244', '陈俊', '111111', '42500982800', '', '', ''), ('4', '293', '杜美玲', '111111', '42500982800', '', '', ''), ('5', '368', '周桂玲', '111111', '42500982800', '', '', ''), ('6', '449', '朱丽萍', '111111', '42500982800', '', '', ''), ('7', '475', '顾占敏', '111111', '42500982800', '', '', ''), ('8', '48', '李雪峰', '111111', '42500982800', '', '', ''), ('9', '60', '汤黎明', '111111', '42500982800', '', '', ''), ('10', '624', '吕瑾', '111111', '42500982800', '', '', ''), ('11', '70', '史伟锋', '111111', '42500982800', '', '', '');
INSERT INTO `role` VALUES ('1', 'doctors', '医生'), ('2', 'Researchers', '研究人员'), ('3', 'system', '系统'), ('4', 'nurse', '护士'), ('5', 'DbManager', '数据库管理');
INSERT INTO `tb_directed_attendance` VALUES ('00007962', '130', '', '2007-10-22');
INSERT INTO `tb_directed_attendance` VALUES ('00007962', '130', '', '2007-10-22');
INSERT INTO `tb_directed_attendance` VALUES ('00013093', '130', '', '2007-10-22');
INSERT INTO `tb_directed_attendance` VALUES ('00013093', '130', '', '2007-10-22');
INSERT INTO `tb_directed_attendance` VALUES ('00021384', '130', '', '2007-10-22');
INSERT INTO `tb_directed_attendance` VALUES ('00021384', '130', '', '2007-10-22');
INSERT INTO `tb_directed_attendance` VALUES ('00021384', '130', '', '2007-10-22');
INSERT INTO `tb_directed_attendance` VALUES ('00021384', '130', '', '2007-10-22');
INSERT INTO `tb_directed_attendance` VALUES ('00021384', '130', '', '2007-10-22');
INSERT INTO `tb_directed_attendance` VALUES ('00021384', '130', '', '2007-10-22');
INSERT INTO `tb_directed_attendance` VALUES ('00021384', '130', '', '2007-10-22');
INSERT INTO `tb_directed_attendance` VALUES ('00021384', '130', '', '2007-10-22');
INSERT INTO `tb_follow_target` VALUES ('1', '住院病例记录', null), ('2', '住院病例手术明细', null), ('3', '就诊记录', null), ('4', '检验报告', null), ('5', '个人缴费记录', null), ('6', '随访登记日期', null);
INSERT INTO `tb_follow_up_data` VALUES ('1', '范秀兰', 'dfadsfadf\r\n', '2008-03-20', null, '12', '范秀兰', '2008-03-20', 'eqtretretertwertewtrtewt\r\n');
INSERT INTO `tb_medical_staff` VALUES ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', ''), ('130', null, '王美华', '');
INSERT INTO `tb_yl_medical_record` VALUES ('7894', '42500982800', 'J06199573', '1', '陈奇', '10000000000000000000', '400', '41', '中医科', '20070917', 'K74.602', '01', '肝硬变', '1', '1900-01-01 00:00:00', '1', '0', '2007-10-24 00:27:01', '', '', ''), ('7915', '42500982800', 'S01122206', '1', '吴品祥', '10000000000000000000', '400', '41', '中医科', '20070918', 'K74.602', '01', '肝硬变', '1', '1900-01-01 00:00:00', '1', '0', '2007-10-24 00:27:01', '', '', '');
INSERT INTO `tb_yl_patient_information` VALUES ('21', '蔡文琴', '00007111', null, null), ('22', '蔡正宝', '00008112', null, null), ('23', '陈彬', 'Q01101400', null, null), ('24', '陈桂香', 'Q01690583', null, null), ('25', '陈进泉', '00008191', null, null), ('26', '陈锋', '00008109', null, null), ('27', '陈雪君', '00007218', null, null), ('28', '陈琛', '00008108', null, null), ('29', '池小琴', '00007702', null, null), ('30', '高红英', '00008133', null, null), ('31', '顾柏林', 'Q00020350', null, null), ('32', '顾水生', 'R03866076', null, null), ('33', '顾忠耀', '00008120', null, null), ('34', '何海红', 'Q05616380', null, null), ('35', '胡斌', '00008136', null, null), ('36', '胡承宇', '00007203', null, null), ('37', '胡细才', '00006247', null, null), ('38', '贺军', '00008015', null, null), ('39', '姜锡明', 'K00196336', null, null), ('40', '姜雅宝', '00008134', null, null);
INSERT INTO `usr_role` VALUES ('449', '1', '29'), ('368', '1', '34'), ('244', '1', '35'), ('293', '1', '36'), ('475', '1', '37'), ('48', '1', '38'), ('60', '1', '42'), ('624', '1', '45'), ('70', '1', '48'), ('163', '1', '51'), ('123', '3', '52'), ('123', '5', '53');