plane.sql

来自「本系统本系统采用VB6.0+SQL2000,紧扣旅游的关键要素,进述如何对这些旅」· SQL 代码 · 共 14 行

CREATE TABLE Plane
  (Pid		Int Primary Key IDENTITY,
   AirCom	Varchar(50) Not Null,
   Pno		Varchar(20) Not Null,
   Sairport	Varchar(40),
   Eairport	Varchar(40),
   Stime	Varchar(40),
   Etime	Varchar(40),
   Price1	Decimal(7, 2),
   Price2	Decimal(7, 2),
   Cycle	Char(7),
   Input_time	Char(17)
  )