景區(qū)門票銷售管理系統(tǒng)(完整版)
【正文】 NOT NULL , XM CHAR(10)NULL, XB CHAR(4)NULL, XL CHAR(10) NULL, NL INT NULL, ZW CHAR(15) NULL, LXFS CHAR(15) NULL,)門票數(shù)據(jù)表創(chuàng)建語句：CREATE TABLE MP ( PH CHAR(15) PRIMARY KEY NOT NULL , PZ CHAR(10)NULL, PS INT NULL, JQ DECIMAL(6,2) NULL)游客數(shù)據(jù)表創(chuàng)建語句：CREATE TABLE YK ( DI CHAR(18) PRIMARY KEY NOT NULL , XM CHAR(10)NULL, XB INT NULL, LXFS CHAR(20) NULL, GZFS CHAR(10) NULL)銷售數(shù)據(jù)表創(chuàng)建語句：CREATE TABLE XS ( YYY_NO CHAR(15)NULL , PH CHAR(15)NULL, XSSL INT NULL, XSSJ DATE NULL, FOREIGN KEY(YYY_NO) REFERENCES YYY(YYY_NO), FOREIGN KEY(PH) REFERENCES MP(PH) FOREIGN KEY(DI) REFERENCES YK(DI))退票數(shù)據(jù)表創(chuàng)建語句：CREATE TABLE TP ( DI CHAR(18)NULL , PH CHAR(15)NULL, TPSJ DATE NULL, TPSL INT NULL, TPYY VARCHAR(40) NULL, YYY_NO CHAR(15) NULL, FOREIGN KEY(DI) references YK(DI),
電大資料相關推薦
鄂ICP備17016276號-1