book.sql

来自「旅游在线报名的系统包括地域管理」· SQL 代码 · 共 23 行

USE travel
GO
CREATE TABLE Book
 (
  BookId	Int identity(1,1) NOT NULL,
  LineId	Int,
  StartDate	DateTime,
  TraNum	Int,
  BookPerson	Varchar(100),
  WorkPlace	Varchar(200),
  Email	Varchar(100),
  Address	Varchar(400),
  Zip	Varchar(10),
  Telephone	Varchar(100),
  Mobile	Varchar(100),
  Fax	Varchar(100),
  IdCard	Varchar(50),
  Comment	Varchar(2000),
  PostDate	Smalldatetime,
  Flag	Bit
)
GO