suifang.sql

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

/*
MySQL Data Transfer
Source Host: localhost
Source Database: follow_up_data
Target Host: localhost
Target Database: follow_up_data
Date: 2008-5-5 14:17:11
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for cap_role
-- ----------------------------
DROP TABLE IF EXISTS `cap_role`;
CREATE TABLE `cap_role` (
  `role_id` int(11) NOT NULL,
  `cap_id` int(11) NOT NULL,
  `cap_role_id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`cap_role_id`),
  KEY `fk_cap_role_id` (`cap_id`),
  KEY `fk_role_id` (`role_id`),
  CONSTRAINT `fk_cap_role_id` FOREIGN KEY (`cap_id`) REFERENCES `caption` (`cap_id`),
  CONSTRAINT `fk_role_id` FOREIGN KEY (`role_id`) REFERENCES `role` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for caption
-- ----------------------------
DROP TABLE IF EXISTS `caption`;
CREATE TABLE `caption` (
  `cap_id` int(11) NOT NULL auto_increment,
  `cap_name` varchar(25) default NULL,
  `menuitem` varchar(25) default NULL,
  PRIMARY KEY  (`cap_id`),
  UNIQUE KEY `PrimaryKey` (`cap_id`),
  KEY `module_id` (`cap_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for health_care_workers
-- ----------------------------
DROP TABLE IF EXISTS `health_care_workers`;
CREATE TABLE `health_care_workers` (
  `h_id` int(11) NOT NULL auto_increment,
  `h_gh` varchar(16) NOT NULL,
  `h_xm` varchar(32) NOT NULL,
  `password` varchar(32) default '111111',
  `h_yljgdm` varchar(11) default NULL,
  `h_sfzh` varchar(32) default NULL,
  `h_zhiw` varchar(32) default NULL,
  `h_lb` varchar(4) default NULL,
  PRIMARY KEY  (`h_id`,`h_gh`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `role_id` int(11) NOT NULL auto_increment,
  `role_name` varchar(20) default NULL,
  `role_desc` varchar(20) default NULL,
  PRIMARY KEY  (`role_id`),
  UNIQUE KEY `PrimaryKey` (`role_id`),
  KEY `state_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tb_cis_dradvice_detail
-- ----------------------------
DROP TABLE IF EXISTS `tb_cis_dradvice_detail`;
CREATE TABLE `tb_cis_dradvice_detail` (
  `YZID` varchar(32) NOT NULL,
  `CXBZ` char(1) NOT NULL,
  `YLJGDM` varchar(11) NOT NULL,
  `JZLSH` varchar(32) NOT NULL,
  `YZSM` text,
  `KH` varchar(64) NOT NULL,
  `KLX` varchar(16) NOT NULL,
  `XDKSBM` varchar(15) NOT NULL,
  `BQ` varchar(32) default NULL,
  `ZXKSBM` varchar(15) default NULL,
  `XDRGH` varchar(16) NOT NULL,
  `XDRXM` varchar(32) NOT NULL,
  `ZXRGH` varchar(16) default NULL,
  `ZXRXM` varchar(32) default NULL,
  `YZZH` varchar(32) default NULL,
  `YZMXBM` varchar(32) NOT NULL,
  `YZMXMC` text NOT NULL,
  `YZLB` char(1) NOT NULL,
  `YZXDSJ` datetime NOT NULL,
  `YZZXSJ` datetime default NULL,
  `YZZZSJ` datetime default NULL,
  `YPGG` varchar(32) default NULL,
  `YPYF` varchar(32) default NULL,
  `YYJL` varchar(32) default NULL,
  `YYPD` varchar(32) default NULL,
  `FYJL` varchar(32) default NULL,
  `JCBW` varchar(32) default NULL,
  `BZ` text,
  `MJ` varchar(16) default NULL,
  `BFSJ` datetime NOT NULL,
  `YLYL1` varchar(128) default NULL,
  PRIMARY KEY  (`YZID`,`CXBZ`,`YLJGDM`,`BFSJ`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for tb_cis_main
-- ----------------------------
DROP TABLE IF EXISTS `tb_cis_main`;
CREATE TABLE `tb_cis_main` (
  `JZLSH` varchar(32) NOT NULL,
  `YLJGDM` varchar(11) NOT NULL,
  `RYSJ` datetime NOT NULL,
  `RYLX` varchar(2) NOT NULL,
  `YZBM` varchar(6) default NULL,
  `KH` varchar(64) NOT NULL,
  `KLX` varchar(16) NOT NULL,
  `YLFKFS` varchar(2) default NULL,
  `ZYCS` int(11) default NULL,
  `BAH` varchar(32) default NULL,
  `CH` varchar(16) NOT NULL,
  `RYBQ` varchar(32) NOT NULL,
  `CYBQ` varchar(32) NOT NULL,
  `XM` varchar(32) NOT NULL,
  `XB` char(1) NOT NULL,
  `CSNY` varchar(8) NOT NULL,
  `HYZK` char(1) NOT NULL,
  `MZ` varchar(2) default NULL,
  `GJ` varchar(32) default NULL,
  `CSD` varchar(32) default NULL,
  `SFZ` varchar(18) default NULL,
  `LXDH` varchar(20) default NULL,
  `GZDW` varchar(32) default NULL,
  `GZDWYB` varchar(6) default NULL,
  `ZYBM` varchar(16) default NULL,
  `JZD` varchar(50) default NULL,
  `HKDH` varchar(32) default NULL,
  `DQBM` varchar(32) default NULL,
  `QXBM` varchar(16) default NULL,
  `JDBM` varchar(16) default NULL,
  `LXRXM` varchar(32) default NULL,
  `LXRGX` varchar(4) default NULL,
  `LXRDH` varchar(20) default NULL,
  `LXRTXDZ` varchar(50) default NULL,
  `RYKSBM` varchar(20) default NULL,
  `ZKKSBM1` varchar(20) default NULL,
  `ZKKSBM2` varchar(20) default NULL,
  `ZKKSBM3` varchar(20) default NULL,
  `CYSJ` datetime NOT NULL,
  `CYKSBM` varchar(20) NOT NULL,
  `SJZYTS` decimal(18,0) NOT NULL,
  `CYFS` char(1) NOT NULL,
  `ZLLB` char(1) default NULL,
  `ZZZYZJ` char(1) default NULL,
  `RYQK` char(1) NOT NULL,
  `RYQWYZZ` char(1) default NULL,
  `QZRQ` varchar(8) default NULL,
  `YYGRMC` varchar(128) default NULL,
  `YYGRJG` varchar(1) default NULL,
  `MZCYZD` char(1) default NULL,
  `RYCYZD` char(1) default NULL,
  `SQSHZD` char(1) default NULL,
  `LCBLZD` char(1) default NULL,
  `FSBLZD` char(1) default NULL,
  `SSZD` text,
  `YWGM` text,
  `HBSAG_JG` char(1) default NULL,
  `HCVab_JG` char(1) default NULL,
  `HIVab_JG` char(1) default NULL,
  `QJCS` decimal(18,0) default NULL,
  `CGCS` decimal(18,0) default NULL,
  `QJFS` char(1) default NULL,
  `SFCXWJN` varchar(3) default NULL,
  `SSDYL` char(4) NOT NULL,
  `XX` varchar(2) default NULL,
  `HXBSXL` decimal(18,0) default NULL,
  `XXBSXL` decimal(18,0) default NULL,
  `XJSXL` decimal(18,0) default NULL,
  `QXSXL` decimal(18,0) default NULL,
  `QTSXL` decimal(18,0) default NULL,
  `SXFY` char(1) default NULL,
  `CRBBG` char(1) default NULL,
  `ZLBG` char(1) default NULL,
  `XSEBG` char(1) default NULL,
  `SWBG` char(1) default NULL,
  `QTBG` char(1) default NULL,
  `SZ` char(1) default NULL,
  `SZQX` decimal(18,0) default NULL,
  `SZQXDW` char(1) default NULL,
  `SJBL` char(1) default NULL,
  `SJ` char(1) default NULL,
  `RSMDSC` char(1) default NULL,
  `XSEJBSC` varchar(3) default NULL,
  `CHCYL` decimal(18,0) default NULL,
  `XSE_XB` char(1) default NULL,
  `XSE_TZ` decimal(18,0) default NULL,
  `ZRYSGH` varchar(16) default NULL,
  `ZRYSXM` varchar(32) NOT NULL,
  `ZZYSGH` varchar(16) default NULL,
  `ZZYSXM` varchar(32) NOT NULL,
  `ZYYSGH` varchar(16) default NULL,