) on [primary]
go
alter table [dbo].[reserve_info] with nocheck add
constraint [pk_reserve_info] primary key clustered
(
[csn]
) on [primary]
go
alter table [dbo].[price_info] with nocheck add
constraint [ix_price_info] unique nonclustered
(
[type],
[state]
) on [primary]
go
create index [ix_car_info] on [dbo].[car_info]([type], [state]) on [primary]
go
alter table [dbo].[reserve_info] add
constraint [fk_reserve_info_car_info] foreign key
(
[csn]
) references [dbo].[car_info] (
[csn]
),
constraint [fk_reserve_info_client_info] foreign key
(
[cid]
