zw_tx.sql

来自「该系统为酒店日常管理提供了很大的方便」· SQL 代码 · 共 19 行

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
	)
);