crtabforsqlserver.sql

来自「java课程的资料以及实验的代码」· SQL 代码 · 共 43 行

create table employee (
	empno int primary key,
	ename varchar(40) not null,
	position varchar(40),
	remarks varchar(255));
	
create table category (
	cateid int,
	catename varchar(40),
	subcateid int,
	subcatename varchar(40),
	constraint cate primary key (cateid,subcateid));
	
create table operator (
	name varchar(10),
	pwd  varchar(20));
	
insert into operator values('admin','123456');
insert into operator values('admin1','123456');
insert into operator values('admin2','123456');
insert into operator values('admin3','123456');

create table asset (
	assetid int primary key,
	asset_name varchar(40) not null,
	cateid int not null,
	subcateid int not null,
	model varchar(40),
	price numeric(7,2) not null,
	purchase_date varchar(12) not null,
	status char(1) not null,
	useby varchar(10),
	remarks varchar(255));
	
create table lend (
	assetid int primary key,
	empno int ,
	usedate varchar(12),
	retdate varchar(12),
	isreturn varchar(4),
	lender varchar(10),
	remarks varchar(255));