景區(qū)門票銷售管理系統(tǒng)(文件)
【正文】 MAXSIZE = 30MB, FILEGROWTH = 5MB ) GO 數(shù)據(jù)表創(chuàng)建語句營業(yè)員數(shù)據(jù)表創(chuàng)建語句：CREATE TABLE YYY ( YYY_NO CHAR(15) PRIMARY KEY 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,
電大資料相關(guān)推薦
鄂ICP備17016276號-1