I_AS NULL ,
[canDiscount] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[serviceMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
3.3 创建客机信息表
CREATE TABLE [dbo].[planeInfo] (
[planeNO] [char] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[planeType] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[buyDate] [datetime] NULL ,
[serveDate] [datetime] NULL ,
[isCommon] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[isCommercial] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[isFirst] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[planeMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
3.4 创建航线信息表
CREATE TABLE [dbo].[airlineInfo] (
[airlineNO] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[departCity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[arrivalCity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[departDate] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[departTime] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[arrivalTime] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[planeNO] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
[commonPrice] [numeric](18, 2) NULL ,
[commercialPrice] [numeric](18, 2) NULL ,
[firstPrice] [numeric](18, 2) NULL ,
[airlineMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
3.5 创建客户类型信息表
CREATE TABLE [dbo].[customerType] (
[ctypeNO] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ctypeName] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[discount] [numeric](2, 0) NULL ,
[ctypeMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
3.6 创建客户信息表
CREATE TABLE [dbo].[customerInfo] (
[customerNO] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[customerName] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[customerSex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[customerID] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
[customerTele] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[customerType] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
[customerMemo] [text] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
3.7 创建订票信息表
CREATE TABLE [dbo].[ticketInfo] (
[ticketNO] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[customerNO] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
[customerName] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[customerType] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
[discount] [numeric](18, 0) NULL ,
[airlineNO] [char] (14) COLLATE Chinese_PRC_CI_AS NULL ,
[departCity] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[a
相关热词:java 航空 公司 管理 信息 系统 论文 java