line.sql

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

USE travel
GO
CREATE TABLE Line
(
  LineId	Int IDENTITY PRIMARY KEY ,
  LineName	Varchar(250) NOT NULL,
  AreaId	Int NOT NULL,
  Days  	Int NOT NULL,
  People	Varchar(50),
  Special	Varchar(250),
  Tips  	Varchar(500),
  SafeTip	Varchar(500),
  LineRef	Varchar(2000),
  Traffic	Varchar(500),
  Hotel 	Varchar(500),
  Dinner	Varchar(500),
  Entertainment	Varchar(500),
  Place 	Varchar(500),
  Shopping	Varchar(500),
  EcoPrice	Smallint,
  StdPrice	Smallint,
  ExpPrice	Smallint,
  CldPrice	Smallint,
  Posttime	Smalldatetime,
  Image1	Varchar(20),
  Image2	Varchar(20),
  Image3	Varchar(20),
  Image4	Varchar(20),
  ImageTitle1	Varchar(20),
  ImageTitle2	Varchar(20),
  ImageTitle3	Varchar(20),
  ImageTitle4	Varchar(20),
  CateId	Int
)