zw_tx.sql

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

connect to S_HDXT;

CREATE TABLE zw_tx (
        cwdwbm char (4) NOT NULL ,
	txbm char (4) NOT NULL ,
	txmc char (30) NOT NULL ,
	ssnf char (4) NOT NULL ,
	xzbj char (1) NOT NULL ,
        cwdwmc char (10) NOT NULL ,
        scrq char (10) ,
        scsj char (8) ,
	CONSTRAINT PK___2__10 PRIMARY KEY
	(
		txbm,
		ssnf,
                cwdwbm
	)
);