book.sql

旅游在线报名的系统包括地域管理

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