table.sql

来自「jsp+oracle书记的源代码」· SQL 代码 · 共 109 行

# MySQL-Front Dump 2.5
#
# Host: localhost   Database: kjc
# --------------------------------------------------------
# Server version 4.0.5-beta-max-nt


#
# Table structure for table 'kjc2_bookstatistic'
#

CREATE TABLE kjc2_bookstatistic (
  
	id number(10) NOT NULL,
  
	bh varchar2(20) default NULL,
  
	xy varchar2(50) default NULL,
 
	zz varchar2(100) default NULL,
  
	cbs varchar2(50) default NULL,
  
	zs varchar2(5) default NULL,
  
	bz varchar2(200) default NULL

);



#
# Dumping data for table 'kjc2_bookstatistic'
#

INSERT INTO kjc2_bookstatistic VALUES('1', 'JSP技术', 'new', 'Tom', 'CCW', '20000', 'OK');
INSERT INTO kjc2_bookstatistic VALUES('2', '00001', '信息学院', '张三', '计算机', '50000', '');
INSERT INTO kjc2_bookstatistic VALUES('4', '专著编号', '学院', '作者', '出版社', '22222', '备注');


#
# Table structure for table 'kjc2_code'
#

CREATE TABLE kjc2_code (
  
	id number(10) NOT NULL,
  
	codeid varchar2(20) default NULL,
  
	code_type varchar2(20) default NULL,
  
	code_name varchar2(20) default NULL,
  
	code_value varchar2(100) default NULL

);



#
# Dumping data for table 'kjc2_code'
#

INSERT INTO kjc2_code VALUES('15', 'LW_SLQK', '论文', '收录情况', '在馆');
INSERT INTO kjc2_code VALUES('16', 'LW_SLQK', '论文', '收录情况', '军博');
INSERT INTO kjc2_code VALUES('17', 'LW_SLQK', '论文', '收录情况', '不在馆');


#
# Table structure for table 'kjc2_paper'
#

CREATE TABLE kjc2_paper (
  
	id number(3) NOT NULL,
  
	bh varchar2(20) default NULL,
  
	xy varchar2(50) default NULL,
  
	zz varchar2(100) default NULL,
  
	kwmc varchar2(50) default NULL,
  
	lwmc varchar2(100) default NULL,
  
	slqk number(10) default NULL,
  
	slqk_name varchar2(100) default NULL,
  
	yxl varchar2(10) default NULL,
  
	yxyz varchar2(5) default NULL,
  
	yycs number(5) default NULL,
  
	djzz number(5) default NULL,
  
	bz varchar2(200) default NULL
);



#
# Dumping data for table 'kjc2_paper'
#

INSERT INTO kjc2_paper VALUES('8', '论文编号', '学院', '作者', '刊物名称', '论文名称', '15', '在馆', '全国性', '影响