/****** object: table [dbo].[provider_info] script date: 2004-9-11
create table [dbo].[provider_info] (
[pname] [char] (20) collate chinese_prc_ci_as not null ,
[pphone] [char] (20) collate chinese_prc_ci_as not null ,
[pcount] [int] not null ,
[ptype] [char] (10) collate chinese_prc_ci_as not null
) on [primary]
go
/****** object: table [dbo].[reserve_info] script date: 2004-9-11
create table [dbo].[reserve_info] (
[cid] [int] not null ,
[csn] [int] not null ,
[bdate] [datetime] not null ,
[rdate] [datetime] not null
) on [primary]
go
alter table [dbo].[car_info] with nocheck add
constraint [pk_car_info] primary key clustered
(
[csn]
) on [primary]
go
alter table [dbo].[client_info] with nocheck add
constraint [pk_client_info] primary key clustered
(
[cid]
