place.sql

采用VisualBasic和SQL Server 2000开发 功能比较全面的旅游资源管理系

CREATE TABLE Place
  (Pid		Int Primary Key IDENTITY,
   Pname	Varchar(200) Not Null,
   Contact	Varchar(100),
   Phone	Varchar(100),
   Address	Varchar(100),
   Postcode	Varchar(10),
   Adult_price	Decimal(10,2),
   Child_price	Decimal(10,2),
   AreaId	Int,
   Input_time	Char(17)
  )