ls.sql

一个简单的酒店管理系统 用VB.net+SQL2000实现

CONNECT TO S_HDXT;
CREATE TABLE hsc_cbdj (
	cbid char (9) NOT NULL ,
	sfkh char (14) NOT NULL ,
	cbdjh char(10) ,
	gsbm char (4) NOT NULL ,
	cblx char (2) NOT NULL ,
	cjbm char (4) NOT NULL ,
	cmch char (16) NOT NULL ,
	syr char (8) NOT NULL ,
        syrz char (18) NOT NULL ,
	jyr char (8) NOT NULL ,
        jyrz char (18) NOT NULL ,
	sxw char (10) NOT NULL ,
	zd numeric (5,0) NOT NULL ,
	jdw numeric (5,0) NOT NULL ,
	zzda numeric (5,0) NOT NULL ,
	zzdb numeric (5,0) NOT NULL ,
	zzdc numeric (5,0) NOT NULL ,
	gl numeric  (4,0) NOT NULL ,
	xc numeric  (5,1) NOT NULL ,
	xk numeric  (5,1) NOT NULL ,
	xs numeric  (5,1) NOT NULL ,
	djrq date NOT NULL,
        djsj time NOT NULL ,
	djcj char (4) NOT NULL ,
	djdw char (4) NOT NULL ,
	djzd char (2) NOT NULL ,
	djczy char (2) NOT NULL ,
	yhrq date NOT NULL ,
	CONSTRAINT PK___4__14 PRIMARY KEY
	(
		cbid
	)
);